Operating system and syntax UNIX / Windows
-usertablerangesize n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 65536 50 -tablerangesize -tablerangesize
n
The number of user tables for which you want gather information in the _UserTableStat VST.

Use User Table Range (-usertablerangesize) to specify the number of rows maintained in the_UserTableStat VST.

Note: If the User table base and range are not specified, the _UserTableStat VST is dimensioned using the values specified for the _TableStat VST (-basetable and -tablerangesize).

The User Table Range (-usertablerangesize) 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 -usertablerangesize 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.

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