Increase certain server startup parameters while the database remains online.

Syntax

proutil db-name -C increaseto [ -n n ] [ -B n ][ -B2 n ] [ -L n ]
                  [ -aibufs n ] [ -bibufs n ] [ -Mxs n ] [ -omsize n ] [ -mtpmsize n ] 
                  [ -cdcsize n ] [ -ecsize n ] [ -secsize n ] [ -indexrangesize n ]
                  [ -userindexrangesize n ] [ -tablerangesize n ] [ -usertablerangesize n ]
                  [ -pica n ]

Parameters

db-name

Specifies the name of the database to update.

-n

Use -n to increase the number of users.

-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.

-aibufs

Use -aibufs to specify the new number of after-image buffers.

-bibufs

Use -bibufs to specify the new number of before-image buffers.

-Mxs

Use -Mxs to specify the size of the shared-memory overflow in kilobytes.

-omsize

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.

-mtpmsize

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

Use -cdcsize to increase the size of the CDC Secondary cache.

-ecsize

Use -ecsize to increase the size of the encryption cache.

-secsize

Use -secsize to increase the size of the security cache.

-indexrangesize

Use -indexrangesize to increase the number of indexes for which you want to collect statistics.

-userindexrangesize

Use -userindexrangesize to increase the number of rows maintained in the_UserIndexStat VST.

-tablerangesize

Use -tablerangesize to increase the number of tables for which you want to collect statistics.

-usertablerangesize

Use -usertablerangesize to increase the number of rows maintained in the_UserTableStat VST.

-pica

Use -pica to increase the size of the database service communications area.

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:

  proutil db-name -C increaseto -B 10240 -L 20480 -bibufs 360 -aibufs 500

• 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 Database Startup 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 prompts you to disconnect the under-privileged users or abort the INCREASETO.