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.
If you specify a value for this parameter and then create a table, add rows to the table, and start to execute a CREATE INDEX ONLINE statement on a column, you can also perform other operations on the column, such as running UPDATE STATISTICS HIGH, without having memory problems.
The ONLIDX_MAXMEM configuration parameter can be changed using the onmode -wf option or superseded for a session with the onmode -wm option. For more information about onmode, see Dynamically Change Certain Connection, PDQ, and Memory Parameters.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]