Checkpoint Interval

The checkpoint interval is important for DB2 recovery processing. The longer amount of time between checkpoint intervals, the more your DB2 applications are exposed to a longer restart time in case of a system failure. The checkpoint interval is set with the LOGLOAD parameter in the DSNZPARMs. In addition, it can be changed dynamically with the -SET LOG LOGLOAD command. This parameter is based on the number of log records written. You may also specify the interval in terms of minutes with the -SET LOG CHKTIME command.

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.