Manualsbrain.com
  1. Manuali
  2. Marche
  3. IBM
  4. 000-8697
  5. Manuale Utente

IBM 000-8697 Manuale Utente

Scarica
Pagina di 702
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
The maximum 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
will not take effect until you reinitialize shared memory (take OnLine offline
and then to quiescent or online mode).
The maximum number of locks is 256,000. The minimum is 20 locks per user
process (
USERS
).
If you are logged in as user informix, you can make this change from within
DB-M
onitor or from the command line. If you are logged in as root, you must
use the command-line option.
From DB-Monitor
1.
From within
DB-M
onitor, 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.
To change 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.