Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL INCREASETO qualifier
 

PROUTIL INCREASETO qualifier

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.
-omsize n
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 n
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:
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 will prompt you to disconnect the under-privileged users or abort the INCREASETO.