Operating OnLine 3-113

Change the Maximum Number of Tblspaces

Change the Maximum Number of Tblspaces
The maximum number of active tblspaces permitted by OnLine is specified
asTBLSPACES in the configuration file.
You can make this change while OnLine is in online mode but the change
doesnot take effect until you reinitialize shared memory (take OnLine offline
and then to quiescent or online mode).
The maximum number of tblspaces is 32,000. The minimum is 10 per user
process (USERS). This minimum also must be greater than the maximum
number of tables in any one database, including the system catalog tables,
plus 2. (This minimum is required to permit OnLine to execute aDROP
DATABASE statement.)
Refer topage 2-52 for further information about this limit.
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 dbspaces.
Change the value in the field,Max # of Tblspaces.
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 TBLSPACES from the command line, use an
editor to edit the file specified by$INFORMIXDIR /etc/$TBCONFIG.
2. Change the value of TBLSPACES. Reinitialize shared memory (take
OnLine offline and then to quiescent mode) for the change to take
effect.