Displaying or managing batch checkpoint tables

The Db2® Admin Tool Batch Restart program, ADBTEP2, provides the ability to restart or resume the execution of an input stream of SQL statements, utilities, and Db2 commands in a batch job at an intermediate point, in the event that any one of the statements in that input stream should fail.

About this task

The information to monitor the execution of the input stream is stored in a Db2 table referred to as the checkpoint table.

You can use the Manage Batch Job Checkpoint Table (ADB2Z2B) panelto display and manage the checkpoint table for batch jobs running ADBTEP2. A row exists in the checkpoint table for each active and abnormally terminated job running ADBTEP2.

To display and manage the checkpoint table for the batch jobs that running ADBTEP2:

Procedure

On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
The System Administration (ADB2Z) panel is displayed.

Specify option 2B, and press Enter.

The Manage Batch Job Checkpoint Table (ADB2Z2B) panel is displayed, as shown in the following figure.

Figure 1. Manage Batch Job Checkpoint Table (ADB2Z2B) panel

 DB2 Admin ------------ DD1A Manage Batch Job Checkpoint Table ----------- 20:39
 Option ===>  																						   
 																												
 Batch Job Checkpoint Table :  ADB.ADBCHKPT               DB2 System: DD1A		
                                                          DB2 SQL ID: ADM001		
    1 - Display Checkpoint Records																
    2 - Display Checkpoint Table Status															
																												
  Enter Checkpoint Table Owner:  																	
																												
    Table Owner ===> ADB  																	   	
																												
  Enter display selection criteria for option 1:  											
																												
    Userid      ===>                   (default is '')                 
																												
    Worklist    ===>                   (default is '')

Select one of the following options and press Enter.

1 - Display Checkpoint Records

Displays all checkpoint records. Use option 1 to terminate an active ADBTEP2 job, update or delete a record of an abnormal terminated job, or insert a new checkpoint record.

2 - Display Checkpoint Table Status

Displays information about the checkpoint table. Use this option to issue any request against the checkpoint table that is supported by Db2 Admin Tool, such as GRANT or REVOKE.
The following figure shows the rows in the table you selected.
Figure 2. Display Batch Job Checkpoint Table panel (ADB2Z2B1)
```
 DB2 Admin ---------- DD1A Display Batch Job Checkpoint Table ------ Row 1 of 1	 
 Command ===>                                                                    
																												 
                                                          DB2 System: DD1A			 
                                                          DB2 SQL ID: ADM001		 
																												 
 Checkpoint Table:  ADB.ADBCHKPT  																	 
																												 
 Line commands:																				          
  D - Delete/Terminate  I - Insert  U - Update  N - Skip-Next							 
                                               Commit      Restart     Restart   
 S Userid   Worklist Suffix   Time             Number      Command     Action    
   *        *        *        *                            *           *         
 - -------- -------- -------- ---------------> ----------- ----------- ------    
   ISTJE    MYMIGR            2002-07-18-16.06           4 COPY        C         
   VNDBRON  RI03              2002-07-10-16.19           2                       
   VNDOJFK  OBJCMP            2002-06-26-16.54           1                       
   VNDROTH  AAA               2002-06-26-07.36           1 COPY        C         
 ******************************* END OF DB2 DATA ******************************* 
```
When data is unloaded in one job and is then reloaded in another job, the unload suffix has the following format: Uxxxx. The corresponding reload is Rxxxx. An additional suffix might also exist, in the format @xxxx. Never attempt to update or modify the @xxxx record. Delete this record only if you are abandoning a current run of a work statement list. The @xxxx record is deleted by the Rxxxx job.
Use the following line commands to change the content of the table:

D

To DELETE the row of an abnormally terminated job or to terminate an active job.

I

To INSERT a new row. Row values can be entered on the next panel displayed.

U

To UPDATE the row of an abnormally terminated job. If the job is executing, the request is rejected. Row values can be changed on the next panel.

N

To instruct ADBTEP2 to skip to the next commit instruction.

If you use the I or U line commands, the insert or update a checkpoint record panel (ADB2Z2BU) displays. The schema and sqlid values are used during a restart for setting the current sqlid and current schema special registers at the point of restart. When you update a checkpoint record that does not have a SCHEMA value (is null), the panel value displayed is blank . If you do not enter a new value, the SCHEMA value remains null. When you insert a new checkpoint record using the panels, if you do not enter a non-blank value, a null value will be stored.

Figure 3. Insert or update a checkpoint record panel (ADB2Z2BU)

ADB2Z2BU DTEST ----------------- INSERT an Entry ------------------------ 23:07
Command ===>                                                                   
                                                                               
                                                         DB2 System: DD1A      
Checkpoint table :  ADB72PAR.ADBCHKPT                    DB2 SQL ID: ADM001   
                                                                               
Enter/Verify:                                                                  
                                                                               
  Userid . . . . . . J148286                                                   
  Worklist . . . . . T14681                                                    
  Suffix . . . . . .                                                           
  Jobname  . . . . . J148286                                                   
  SQLID  . . . . . . J148286                                                   
  SCHEMA . . . . . .          >                                                
  Commit number  . . 2                                                         
  Restart cmd  . . . New Record                                                
  Restart Act  . . .                                                           
  Timestamp  . . . . 2010-05-10-23.05.45.31781                                 
  Server . . . . . . DSNA                                                      
  Path . . . . . . . "SYSIBM","SYSFUN","SYSPROC","J148286"                     
  Precision  . . . . . . . DEC15      (DEC15, DEC31 or Dpp.s)                  
  Rules  . . . . . . . . . DB2        (DB2 or STD)                             
  Decfloat Rounding Mode .                                                 >   
  Routine Version  . . . .                                                 >                                                                            
  Session Timezone . ?                                                         
  Explain Mode . . . YES                                                       
  Program Cntrl  . . NNNINNN                                                   
  Temporal Business Time .                                                 >   
  Temporal System Time . .                                                 >   
  Get Archive  . . . . . .            (Yes/No)                                 
  Move To Archive  . . . .            (Yes/No)                                 
  Temporal Logical                                                             
      Transaction Time . . 2016-02-10-16.21.36.274810                          
  Temporal Logical                                                             
      Transaction  . . . . 1          (1=Yes/0=No)
                                                                                                                                                          
Press ENTER to INSERT an entry, or press PF3 to cancel INSERT.