TBLSPACE_STATS

onconfig.std
value

1

if not present

1

units

Integer

takes effect

When shared memory is initialized

range of values

0 or 1

utilities

onutil

The TBLSPACE_STATS configuration parameter turns on and off collection of tblspace statistics that the database server performs.

To turn off collection of tblspace statistics, set TBLSPACE_STATS to 0. Turning off tablespace statistics might improve overall database server performance, but you cannot list tblspace statistics with onstat -g ppf. To turn on collection of tablespace statistics, set TBLSPACE_STATS to 1.

To modify the TBLSPACE_STATS parameter dynamically, use the onutil SET command. Example:

%onutil
SET TBLSPACE_STATS 0;