Changing Db2 system checkpoint frequency

You can change how frequently Db2® should perform a system checkpoint.

About this task

To change how frequently Db2 should perform a system checkpoint (in terms of number of Db2 log records):

Procedure

  1. On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
    The System Administration (ADB2Z) panel is displayed.
  2. Specify option LZ, and press Enter.
    The Change DB2 System Checkpoint Frequency (ADB2ZLZ) panel is displayed, as shown in the following figure.
    Figure 1. Change DB2 System Checkpoint Frequency (ADB2ZLZ) panel
     DB2 Admin -------- DB2X Change DB2 System Checkpoint Frequency ---------- 16:51 
 Command ===>                                                                    
                                                                                 
  -SET LOG                                                                       
   Mode  . . . . . . . . . .              (S-SINGLE, B-BOTH)                     
   LOGLOAD(                                                                      
   Checkpoint frequency  . .              (1000-16000000 when Mode=S,            
   )                                       0 or 1000-99999999 when Mode=B)       
                                                                                 
   CHKTIME(                                                                      
   Checkpoint frequency  . .              (1-60   when Mode=S,                   
   )                                       0-1439 when Mode=B)                   
                                                                                 
   SUSPEND . . . . . . . . .              (Yes/No)                               
   RESUME  . . . . . . . . .              (Yes/No)                               
   NEWLOG  . . . . . . . . .                                                     
   COPY  . . . . . . . . . .              (1/2)
  3. Enter the appropriate keywords and parameters on the panel and press Enter.
    Db2 Admin Tool issues the Db2 SET LOG command. The information Db2 Admin Tool returns to you from the command is in ISPF browse format.