The table below lists the startup parameters used to fine-tune memory allocation on the server system.

Table 1. Startup parameters that affect memory allocation
Startup parameter Suggested use
Blocks in Database Buffers (-B) Increasing the buffer size decreases the amount of database record I/O by increasing the number of buffers available in memory. This increases memory usage. Increase the -B parameter to use more memory to reduce I/O. Decrease the -B parameter if memory is limited or if database buffer I/O causes paging.
LRU Cold Area Percentage (-lrucoldpercent) Reduce scan pollution in the primary buffer pool by protecting frequently used pages from being displaced by pages loaded during large sequential scans.
LRU Cold Promotion Access Threshold (-lrucoldaccessthreshold) Refine the buffer hit ratio in the primary buffer pool by controlling when pages are eligible for promotion from the cold area to the hot area based on the number of times a page is accessed.
LRU Cold Promotion Time Threshold (-lrucoldtimethreshold) Refine the buffer hit ratio in the primary buffer pool by controlling when pages are eligible for promotion from the cold area to the hot area based on the amount of time a page has resided in the cold area.
Maximum Clients per Server (-Ma)1 If some number of remote clients overloads the server or exhausts the file descriptors on a system, set this parameter to limit the number of clients.
Maximum Servers (-Mn)1 If a server becomes overloaded with clients, set this parameter to limit the number of servers. If you significantly increase this parameter, you should also increase the Minimum Clients per Server (-Mi) parameter.
Number of Users (-n) Set this parameter large enough to include both local and remote users.
Pin Shared Memory (-pinshm) Use this parameter to prevent the database engine from swapping shared memory contents to disk.
1 Relevant only to database accessed using client/server.