88 DB2 for z/OS Administration Tools for Enhanced Change Management
Figure 3-59 Drop Impact analysis details panel
3.8 Restarting the monitor
When running the batch execution program ADBTEP2, a restart monitor registers the
execution process. This program inserts rows into the checkpoint table with restart
information in case the program terminates abnormally. These rows are identified by the user
ID that runs the job and the worklist name that has been chosen during the definition phase of
the batch execution (for example migrate).
How to create the checkpoint table is described in Chapter 2. “Activating DB2 Admin” in the
DB2 Administration Tool for z/OS User’s Guide and Reference Version 7 Release 2,
SC18-9552.
To see the contents of the checkpoint table, use option Z (DB2 system administration)
from the DB2 Administration Menu, and then select 2B (Display/manage batch checkpoint).
This brings you to the panel shown in Figure 3-60.
DB2 Admin ---------- DB8A DROP Impact Analysis Details ----- Row 1 to 10 of 10
Command ===> Scroll ===> CSR
SQL Statement: DROP TABLESPACE "DSG24D03"."GLWSPRJ"
Commands: RE-SORT DROP
Line commands: S - Show object DRD - DROP RESTRICT on DROP
Sel Type Object Name/Grantor>Grantee Owner Note
* * * *
--- ------ --------------------------- -------- -------------------------------
S DSG24D03.GLWSPRJ PAOLOR2 Segmented
T GLWTPRJ DSG24D03
UC GLWPPRJ PAOLOR2 Primary key
X GLWXPRJ1 DSG24D03
V WLPROJ DSG24D03 View of a Table
K DPTDEL,Collid=DSG24D03 PAOLOR2 Invalidated
K EMPDEL,Collid=DSG24D03 PAOLOR2 Invalidated
K PRJADD,Collid=DSG24D03 PAOLOR2 Invalidated
K PRJSEL,Collid=DSG24D03 PAOLOR2 Invalidated
K PRJUPD,Collid=DSG24D03 PAOLOR2 Invalidated
******************************* END OF DB2 DATA *******************************
Chapter 3. First steps with DB2 Admin 89
Figure 3-60 Manage Batch Job Checkpoint Table panel
This panel shows you the name of the checkpoint table and allows you to display the contents
of the checkpoint table. You can choose option 1 to display active checkpoint records. You can
select a Userid and/or Worklist to reduce the result list.
The Display Batch Job Checkpoint Table panel in Figure 3-61 shows the rows in the table you
have selected. In the records, you see from which statement and in which step a process can
be restarted.
Figure 3-61 Display Batch Job Checkpoint Table
The line commands, listed at the top of the panel, can be used to change the content of the
table.
You can for example, terminate, delete an active ADBTEP2 job, or update a record of an
abnormally terminated job. You can also insert a new checkpoint record.
DB2 Admin ------------ DB8A Manage Batch Job Checkpoint Table ----------- 13:25
Option ===> 1
Batch Job Checkpoint Table : A72.ADBCHKPT DB2 System: DB8A
DB2 SQL ID: PAOLOR3
1 - Display Checkpoint Records
2 - Display Checkpoint Table Status
Enter Checkpoint Table Owner:
Table Owner ===> A72
Enter display selection criteria for option 1:
Userid ===> (default is '')
Worklist ===> (default is '')
DB2 Admin ---------- DB8A Display Batch Job Checkpoint Table - Row 1 to 3 of 3
Command ===> Scroll ===> CSR
DB2 System: DB8A
DB2 SQL ID: PAOLOR3
Checkpoint Table: A72.ADBCHKPT
Line commands:
D - Delete/Terminate I - Insert U - Update N - Skip-Next
Commit Restart Restart
S Userid Worklist Suffix Time Number Command Action
* * * * * * *
- -------- -------- -------- ---------------> ----------- ----------- -------
PAOLOR3 A0000005 2007-02-28-19.04 1 RUN R
PAOLOR3 A0000007 2007-02-28-19.36 5 RUN R
PAOLOR3 A0000008 2007-02-28-20.06 1 UNLOAD C
******************************* END OF DB2 DATA *******************************

Get DB2 for z/OS Administration Tools for Enhanced Change Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.