STATFREQ—Statistics time interval
Use the Modify Statistics Records Frequency panel or the STATFREQ command to specify a new value for the statistics time interval. This action allows systems programmers and DBAs to dynamically control the frequency of statistics record generation. This value takes effect after the next set of statistics records is generated.
Modify Statistics Records Frequency panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : STATISTICS FREQUENCY AMOUNT
Type the new statistics value that you wish to change to. Then press Enter.
Statistics Parameter
Time interval (minutes) . . _____ (1-1440 or delta)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | Statistics interval (time interval (in minutes) at which statistics records are written). Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Time interval (minutes) | DSNTIPN | OPSTATIM | DSN6SYSP | STATIME |