Operating system and syntax UNIX / Windows
-secsize n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 32768 0 - 512
n
The size, in number of cache entries, of the primary and secondary security caches.

For best performance, you should set Security cache size (-secsize) large enough that all your existing records fit in the primary cache. Pick the value for –secsize based on available shared memory and the size of the _sec-authentication-domain table. Each entry consumes approximately 450 bytes. For example, if –secsize is 512, roughly 512 * 450 = 0.25 Mb is allocated for the primary cache, and also the secondary cache, for a total of 0.5 Mb. If memory is not an issue, pick a value close the number of records in _sec-authentication-domain.

If you set the value between 1 and 12, it is automatically increased to 13.

You can set Security cache size (-secsize) to 0 (zero) if you never intend to enable use of the security cache on your database.

The Security Cache Size (-secsize) parameter may be modified while your database is online using PROUTIL INCREASETO.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.