STATSINT—RTS statistics timer interval


Use the Modify RTS Statistics Timer Interval panel or the STATSINT command to set the RTS Tables Time Interval value (the time that Db2 waits before attempting to write out page set statistics to the real-time statistics tables). The new value takes effect immediately.

Modify RTS Statistics Timer Interval panel

DDTG DEBD Modify RTS Statistics Timer Interval
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : RTS TABLES TIME INTERVAL

Type the new RTS Tables Time Interval that you wish to change to. Then Press Enter.

RTS Tables Time Interval
Timer Interval . . . . . . . (1-1440 or delta)

Command syntax and parameters

image2018-12-25_10-50-29.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

Real-time statistics timer interval (the time (in minutes) that Db2 waits before attempting to write out page set statistics to the real-time statistics tables). 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

Timer Interval

DSNTIP0

None

DSN6SPRM

STATSINT

 

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