Limiting memory allocation while creating indexes online

The ONLIDX_MAXMEM configuration parameter limits the amount of memory that is allocated to a single preimage pool and a single updator log pool.

The preimage and updator log pools, pimage_<partnum> and ulog_<partnum>, are shared memory pools that are created when a CREATE INDEX ONLINE statement is executed. The pools are freed when the execution of the statement is completed.

The default value of the ONLIDX_MAXMEM configuration parameter is 5120 kilobytes. The minimum value that you can specify is 16 kilobytes; the maximum value is 4294967295 kilobytes.

You can set the ONLIDX_MAXMEM configuration parameter before starting the database server, or you can change it dynamically through the onmode -wf and onmode -wm commands.

Copyright© 2018 HCL Technologies Limited