MAX_DBSPACES

onconfig.std
value

0

units

Number of dbspaces

range of values

0 through 32,767

takes effect

When shared memory is initialized

refer to

Chapter on managing disk space in the IBM Informix: Administrator's Guide

MAX_DBSPACES allows you to increase the maximum number of dbspaces. The safewrite area in the first chunk of the root dbspace grows to accommodate the new maximum number of dbspaces. If you use a CONFIGSIZE value of LARGE, the maximum number of dbspaces is 8192, but you can use MAX_DBSPACES to specify up to 32,767 dbspaces. For more information, see CONFIGSIZE.

If you set the MAX_DBSPACES value and later decrease it, the database server ignores the new value and uses the previously set value. However, you can increase the MAX_DBSPACES value at any time.

When you allocate the initial chunk for the root dbspace of any coserver, you must ensure that enough space is available for the safewrite area. If you create more than 8192 dbspaces, allow an extra 56 bytes per additional dbspace for the safewrite area. For example, if you set MAX_DBSPACES to 8200, allow an extra 448 bytes (56 bytes * 8 dbspaces).

If you do not provide enough space for the safewrite area, the database writes a message to the transaction log to report this situation. If insufficient space is available in the root dbspace, you might need to reinitialize the database server and reload your data.