Index Range Size (-indexrangesize)

Operating system and syntax UNIX / Windows
-indexrangesize n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 65536 1 50 50
n
The number of indexes for which you want to track access statistics.

Use Index Range Size (-indexrangesize) to specify the number of indexes for which you want to collect statistics from virtual system tables (VSTs).

The Index Range Size (-indexrangesize) parameter may be modified while your database is online using PROUTIL INCREASETO. The new value should be set greater than the current value. In the event there is insufficient shared memory for the new increased -indexrangesize value, an additional shared memory segment will be added. If there are existing connections, the utility will keep asking to retry until all the existing connections recognize the new segment.

See Virtual System Tables for more information on VSTs.

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