CHKPTFRQ—Checkpoint frequency of element

Use the Modify Checkpoint Frequency panel or the CHKPTFRQ command to specify the value for the checkpoint frequency. This value specifies either the number of log records that Db2 writes or the number of minutes Db2 waits between the start of successive checkpoints. The new value is used immediately. If both values are specified, a checkpoint is taken when the first threshold is reached.

Modify Checkpoint Frequency panel

DDTG DBI1 Modify Checkpoint Frequency
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : CHECKPOINT FREQUENCY AMOUNT

Type the new checkpoint frequency value you wish to change to. Then press Enter.

Checkpoint Frequency Parameter
Log records/checkpoint . . . _________ (1-16000000 or delta)

Command syntax and parameters

image2018-12-20_15-40-31.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

Checkpoint frequency. Specify one of the following values:

  • A numerical value in the range 1–60 (represents the number of minutes between checkpoints)
  • A numerical value in the range 200–16000000 (represents the number of log records written between checkpoints)
  • 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 200–16000000

Note

Values between 60 and 200 are invalid.

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

Log records/checkpoint

DSNTIPN

OPCHKFRQ

DSN6SYSP

LOGLOAD


 

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