Increase certain server startup parameters while the database remains online.
Syntax
proutil db-name -C increaseto [ -B n ][ -B2 n ][ -L n ][ -bibufs n ][ -aibufs n ] [ -Mxs n ][ -omsize n ][ -mtmpsize n ] [ -cdcsize n ]
Parameters
db-name
Specifies the name of the database to update.
-B
Use -B to specify the new value for the number of blocks in the primary buffer pool.
-B2
Use -B2 to specify the new value for the number of blocks in the Alternate Buffer Pool.
-L
Use -L to specify the new limit of the record locking table.
-bibufs
Use -bibufs to specify the new number of before-image buffers.
-aibufs
Use -aibufs to specify the new number of after-image buffers.
-Mxs
Use -Mxs to specify the size of the shared-memory overflow in kilobytes.
-omsizen
Use -omsize to specify the number entries in the secondary storage object cache. At startup, a primary and secondary storage object cache are allocated, each with the number of entries specified by the -omsize startup parameter; INCREASETO only modifies the size of the secondary cache.
-mtpmsizen
Use -mtpmsize to specify the number of entries in the multi-tenancy partition cache. At startup, a primary and secondary multi-tenancy partition cache are allocated, each with the number of entries specified by the -mtpmsize startup parameter; INCREASETO only modifies the size of the secondary cache.
-cdcsize n
Use -cdcsize to increase the size of the CDC Secondary cache.
INCREASETO enables the identified startup parameters to be increased while the database is online. This improves database resiliency by minimizing planned downtime exclusively for changes to startup parameters, providing a robust, high availability mechanism that allows you to modify commonly used database resources while the database is online.
Notes
You can execute any number of parameters in a single statement. For example:
If a value specified to increase to is less than the current setting, an error is reported and the value is not changed.
Only one instance of INCREASETO can connect to an online database at a time.
Parameters specified using INCREASETO are restricted by currently supported limits. For example, the maximum increase for the number of blocks in the database buffer is limited to 1,000,000,000 for 64-bit platforms. See DatabaseStartup Parameters for more information on range and limits of -B, -L, -bibufs, -aibufs, and -Mxs.
You must have security privileges on the directly connected database to use INCREASETO.
All users directly connected to the database must have privileges to read any new shared-memory segments created by INCREASETO. If a user does not have access, INCREASETO will prompt you to disconnect the under-privileged users or abort the INCREASETO.