To enable continous operations, you can modify many database parameters while your database is running.

Most parameters are changed using either PROMON or _DbParams VSTs, but those that require resources are changed using the PROUTIL INCREASETO command.

The following table lists database parameters that you can modify while the database is running and tells how to change them. Links to details about the change procedures follow the table.

Table 1. Database server continuous operation parameters
Parameter Update Method Notes
After-image File Management Archive Directory List (-aiarcdir) PROMON or _DbParams
After-image File Management Archive Directory Create (-aiarcdircreate) PROMON or _DbParams
After-image File Management Archive Interval (-aiarcinterval) PROMON or _DbParams
After-image Buffers (-aibufs) PROUTIL INCREASETO
After-image Stall (-aistall) PROMON or _DbParams
Blocks in Database Buffers -B) PROUTIL INCREASETO
Blocks in Alternate Buffer Pool (-B2) PROUTIL INCREASETO
Base Index (-baseindex) PROMON or _dbParams
Base LOB (-baselob) PROMON or _dbParams
Base Table (-basetable) PROMON or _dbParams
Base user index (-baseuserindex) PROMON or _dbParams
Base user LOB (-baseuserlob) PROMON or _dbParams
Base user table (-baseusertable) PROMON or _dbParams
Before-image Buffers (-bibufs) PROUTIL INCREASETO
Threshold Stall (-bistall) PROMON or _dbParams
Recovery Log Threshold (-bithold) PROMON or _dbParams
Maximum Private Buffers per Connection (-Bpmax) PROMON or _dbParams
CDC cache size (-cdcsize) PROUTIL INCREASETO
C stack print option (-cstackPrintopt) PROMON or _dbParams
Database consistency check (-DbCheck) PROMON or _dbParams
Database Notification Operations (-dbnotifyops) PROMON or _dbParams
Database Notification Time (-dbnotifytime) PROMON or _dbParams
Diagnostic directory (-diagDir) PROMON or _dbParams
Diagnostic events value (-diagEvent) PROMON or _dbParams
Diagnostic event level (-diagEvtLevel) PROMON or _dbParams
Diagnostic data format (-diagFormat) PROMON or _dbParams
Diagnostic field separator (-diagFS) PROMON or _dbParams
Diagnostic pause length (-diagPause) PROMON or _dbParams
Diagnostic prefix value (-diagPrefix) PROMON or _dbParams
Encryption cache size (-ecsize) PROUTIL INCREASETO
Group delay (-groupdelay) PROMON or _dbParams
Index consistency check (-IndexCheck) PROMON or _dbParams
Index Range Size (-indexrangesize) PROUTIL INCREASETO
Lock Table Entries (-L) PROUTIL INCREASETO
Lock Governor (-LGovernor) PROMON or _dbParams
Log file archive directory (-lgArchiveDir) PROMON or _dbParams
Log file archive enable (-lgArchiveEnable) PROMON or _dbParams
Log file truncate frequency (-lgTruncateFrequency) PROMON or _dbParams
Log file truncate size (-lgTruncateSize) PROMON or _dbParams
Log file truncate time (-lgTruncateTime) PROMON or _dbParams
Limit log file payload (-limitLgPayload) PROMON or _dbParams
LOB range (-lobrangesize) PROUTIL INCREASETO
LRU force skips (-lruskips) PROMON or _dbParams
Maximum Clients per Server (-Ma) PROMON or _dbParams
Maximum Dynamic Server (-maxport) PROMON or _dbParams You can only change this parameter for the primary broker.
Memory consistency check (-Memcheck) PROMON or _dbParams
Delayed BI File Write (-Mf) PROMON or _dbParams
Minimum Clients per Server (-Mi) PROMON or _dbParams
Minimum Dynamic Server (-minport) PROMON or _dbParams You can only change this parameter for the primary broker.
Message Buffer Size (-Mm) PROMON or _dbParams
Maximum Servers (-Mn) PROUTIL INCREASETO
Maximum Servers Per Broker (-Mpb) PROMON or _dbParams You can only change this parameter for the primary broker.
Multi-tenancy Partition Cache Size (-mtpmsize) (-mtpmsize) PROUTIL INCREASETO
Shared-memory Overflow Size (-Mxs) PROUTIL INCREASETO
Number of Users (-n) PROUTIL INCREASETO
Nap Time (-nap) PROMON or _dbParams
Nap Maximum (-napmax) PROMON or _dbParams
Nap Time Steps (-napstep) PROMON or _dbParams
Login Governor (-nGovernor) PROMON or _dbParams
Message Wait (-Nmsgwait) PROMON or _dbParams
No Host Verify (-nohostverify) PROMON or _dbParams You can only change this parameter for the primary broker.
No Session Cache (-nosessioncache) PROMON or _dbParams You can only change this parameter for the primary broker.
No Session Reuse (-nosessionreuse) PROMON or _dbParams You can only change this parameter for the primary broker.
Number of checkpoint statistics (-numCheckpointStats) PROMON or _dbParams
Omit Log Messages (-omitLgMsgs) PROMON or _dbParams
Storage Object Cache Size (-omsize) PROUTIL INCREASETO
Pending Connection Time (-PendConnTime) PROMON or _dbParams You can only change this parameter for the primary broker.
Database Service Communication Area Size (-pica) PROUTIL INCREASETO
Database PICA Queue Nap Time (-picanap) PROMON or _dbParams
Pin Shared Memory (-pinshm) PROMON or _dbParams
Prefetch delay (-prefetchDelay) PROMON or _dbParams
Prefetch Factor (-prefetchFactor) PROMON or _dbParams
Prefetch Num Recs (-prefetchNumRecs) PROMON or _dbParams
Prefetch Priority (-preFetchPriority) PROMON or _dbParams
Record free chain search depth factor (-recspacesearchdepth) PROMON or _dbParams
Schema Lock Wait Queue (-schlockwq) PROMON or _dbParams
Security cache size (-secsize) PROUTIL INCREASETO
Semaphore Sets (-semsets) PROMON or _dbParams
Type-of-Server-to-Start-ServerType.html PROMON or _dbParams You can only change this parameter for the primary broker.
Shared memory segment size (-shmsegsize) PROMON or _dbParams
Spin Lock Retries (-spin) PROMON or _dbParams
Autonomous Update Statistics (-SQLAutoStats) PROMON or _dbParams
SQL Open Cursors (-SQLCursors) PROMON or _dbParams You can only change this parameter for the primary broker.
Lock Wait Timeout(-SQLLockWaitTimeout) PROMON or _dbParams You can only change this parameter for the primary broker.
SQL rowid identifier (-SQLQuotedRowid) PROMON or _dbParams You can only change this parameter for the primary broker.
SQL Stack Size (-SQLStack) PROMON or _dbParams You can only change this parameter for the primary broker.
SQL Statement Cache Size (-SQLStmtCache) PROMON or _dbParams You can only change this parameter for the primary broker.
SQL Sorting Memory (-SQLTempBuff) PROMON or _dbParams You can only change this parameter for the primary broker.
SQL Sorting on Disk (-SQLTempDisk) PROMON or _dbParams You can only change this parameter for the primary broker.
SQL Temp Table Data Page (-SQLTempPageSize) PROMON or _dbParams You can only change this parameter for the primary broker.
Authorized Data Truncation (-SQLTruncateTooLarge) PROMON or _dbparams You can only change this parameter for the primary broker.
Autonomus Schema Update (-SQLWidthUpdate) PROMON or _dbParams You can only change this parameter for the primary broker.
Server-side join (-ssj) PROMON or _dbParams
TLS Encryption for TCP/IP Connections (-ssl) PROMON or _dbParams You can only change the -ssl parameter for new servers. the broker fins an appropriate server for mixed -ssl setting.
STS logging level (-stslogginglevel) PROMON or _dbParams You can only change this parameter for the primary broker.
Table consistency check (-TableCheck) PROMON or _dbParams
Table Range Size (-tablerangesize) PROUTIL INCREASETO
Transaction End (TXE) Lock Retry Limit (-TXERetryLimit) PROMON or _dbParams
User index range (-userindexrangesize) PROUTIL INCREASETO
User LOB range (-userlobrangesize) PROUTIL INCREASETO
Database Client Notification (-usernotifytime) PROMON or _dbParams
User Table Range (-usertablerangesize) PROUTIL INCREASETO

To change parameters using PROMON, see Modify database startup parameters online using PROMON.

To change parameters with the _Dbparams VST, you can use ABL code like the following:
Find _dbParams 
   where _dbParams-Name = "-lruskips".
   assign _dbParams-Value = 100.

For PROUTIL syntax and details, see PROUTIL INCREASETO qualifier.