Change the locking mode of a table, either page level or row level. usageinfx sysadmin func=lmode db tab [ owner lmode=page|row ]
change table lock mode
required:
db - select database
tab - the name of the table or enter owner.table
optional:
lmode - the locking mode
exampleChange 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.
|