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

DDTG DBI1 Modify Statistics Records Frequency
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

image2018-12-25_10-31-46.png

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:

  • A numerical value in the range 1–1440
  • A delta value
    Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 1–1440.

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*