home‎ > ‎sysadmin‎ > ‎


Change the locking mode of a table, either page level or row level.


infx sysadmin func=lmode db tab [ owner lmode=page|row ]
     change table lock mode
         db - select database
         tab - the name of the table or enter owner.table
         lmode - the locking mode


Change the locking mode to row level locking.

demo1@bobii:/home/informix>infx sysadmin func=lmode db=monitor_jgh1 tab=objectdailydetail lmode=row

execute: alter table objectdailydetail lock mode (row);

Database selected.

Table altered.

Database closed.