IBM 000-8697 Manuale Utente

Operating OnLine

The maximum number of active tblspaces permitted by OnLine is specified
as

TBLSPACES

 in the configuration file.

You can make this change while OnLine is in online mode but the change
does not 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 a

DROP

DATABASE

 statement.)

Refer to

 for further information about this limit.

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 within

DB-M

onitor, select the Parameters menu, Shared-

Memory option to change the maximum number of dbspaces.
Change the value in the field,

Max # of Tblspaces

.

Reinitialize shared memory (take OnLine offline and then to
quiescent mode) for the change to take effect.

To change the value of

 TBLSPACES

 from the command line, use an

editor to edit the file specified by $

.

Change the value of

 TBLSPACES

. Reinitialize shared memory (take

OnLine offline and then to quiescent mode) for the change to take
effect.