IBM 000-8697 Change the Maximum Number of Locks

3-112 IBM Informix OnLine Database Server Administrator’s Guide
Change the Maximum Number of Locks
From the Command Line
1. To change the value of DBSPACES from the command line, use an
editor to edit the file specified by$INFORMIXDIR /etc/$TBCONFIG.
2. Change the value of DBSPACES. Reinitialize shared memory (take
OnLine offline and then to quiescent mode) for the change to take
effect.
Change the Maximum Number of Locks
Themaximum number of available locks is specified as LOCKS in the config-
uration file.
You can make this change while OnLine is in online mode but the changes
willnot take effect until you reinitialize shared memory (take OnLine offline
and then to quiescent or online mode).
Themaximum number of locks is 256,000. The minimum is 20 locks per user
process (USERS).
Ifyou are logged in as user informix, you can make this change from within
DB-Monitoror from the command line. If you are logged in as root, you must
use the command-line option.
From DB-Monitor
1. From withinDB-Monitor, select the Parameters menu, Shared-
Memory option to change the maximum number of locks. Change
the value in the field,Max # of Locks.
2. Reinitialize shared memory (take OnLine offline and then to
quiescent mode) for the change to take effect.
From the Command Line
1. Tochange the value of LOCKS from the command line, use an editor
to edit the file specified by$ INFORMIXDIR/etc/$TBCONFIG.
2. Change the value of LOCKS. Reinitialize shared memory (take
OnLine offline and then to quiescent mode) for the change to take
effect.