RECORDS/CHECKPOINT field (CHKFREQ and CHKLOGR subsystem parameters)

The RECORDS/CHECKPOINT field determines the approximate number of log records that are to be created between scheduled log checkpoints.

Acceptable values:	Depending on the CHECKPOINT TYPE value: CHECKPOINT TYPE is LOGRECS: 1000–160 00 000 CHECKPOINT TYPE is MINUTES: NOT USED CHECKPOINT TYPE is BOTH: 1000–99 999 999
Default:	NOTUSED
Update:	option 43 on panel DSNTIPB
DSNZP`xxx`:	DSN6SYSP.CHKFREQ and DSN6SYSP.CHKLOGR

NOT USED (if CHECKPOINT TYPE is MINUTES): The value NOTUSED is assigned to the CHKLOGR parameter. (The CHECKFREQ parameter is assigned the value specified for the MINUTES/CHECKPOINT field. See MINUTES/CHECKPOINT field (CHKFREQ and CHKMINS subsystem parameters).)
1000–160 00 000 (if CHECKPOINT TYPE is LOGRECS): The number of log records that are created between checkpoints. The specified value is assigned to the CHKFREQ parameter, and the CHKLOGR parameter is set to NOT USED.
1000–99 999 999 (if CHECKPOINT TYPE is BOTH): The number of log records that are created between checkpoints. The specified value is assigned to the CHKLOGR parameter, and the CHEKFREQ parameter is set to NOT USED.
Db2 prevents log checkpoints from being taken too frequently and degrading performance. Log checkpoints are scheduled, but not necessarily immediately taken, when the number of minutes that passes reaches the value of CHKMINS.

The following table summarizes how the CHECKPOINT TYPE, MINUTES/CHECKPOINT, and RECORDS/CHECKPOINT fields on panel DSNTIPL1 set the related subsystem parameters to specify the Db2 checkpoint frequency. The following table shows panel DSNTIPL1 fields and related subsystem parameters for controlling the Db2 checkpoint frequency.

CHECKPOINT TYPE field	CHKTYPE subsystem parameter	CHKFREQ subsystem parameter	CHKMINS subsystem parameter	CHKLOGR subsystem parameter
MINUTES (default)	SINGLE	1–5 (default 3) Set in the MINUTES/CHECKPOINT field to specify the number of minutes between checkpoints.	NOT USED	NOT USED
LOGRECS	SINGLE	1000–16 000 000 Set in the RECORDS/CHECKPOINT field to specify the number of log records between checkpoints.	NOT USED	NOT USED
BOTH	BOTH	NOT USED	1–5 Set in the MINUTES/CHECKPOINT field to specify the number of minutes between checkpoints.	1000–99 999 999 Set in the RECORDS/CHECKPOINT field to specify the number of log records between checkpoints.