You can view a list of the objects that were processed by Db2® Automation Expert-submitted jobs by using the Execution Reports Object Display. This panel contains details about the objects that were processed, and allows you to select the objects to view all the jobs that processed them.
Procedure
On the Db2 Automation Expert main menu, enter 6 in the Option field press Enter.
On the Execution Reports Job Display, enter O in the View Type field. You can also enter more selection criteria in the header fields. Press Enter.
The Execution Reports Object Display lists the objects that were processed by Db2 Automation Expert and that meet the specified selection criteria.
The following figure shows the Execution Reports Object Display: Figure 1. Execution Reports Object Display
AUTOXPRT V1R1 ---- Execution Reports Object Display ---- 2023/10/21 19:27:23
Option ===> Scroll ===> CSR
-------------------------------------------------------------------------------
Line Commands: S - Select
Profile Like * Db2 Subsystem: SS01
Creator Like PD* Database Like * Row 1 of 6
Space Type = A (I - Index, T - Tablespace, A - Any)
Space Like * Date From 01/01/2023 to 04/18/2023
Time From 00:01:00 to 23:00:00
Partition = 4 (0-4096, * - All, blank)
Jobname Like * View Type O (J - Jobs, O - Objects)
Jobnum Like *
-------------------------------------------------------------------------------
Cmd Type Database Name Space Name Partition
IX H7241DB H7241XB2 4
IX H7241DB H7241XC2 4
TS H7241DB H7241TSA 4
TS H7241DB H7241TSB 4
TS H7241DB H7241TSC 4
TS NMHACHNG TSCHNG01 4
***************************** Bottom of Data **********************************
To view job information for an object, enter S next to the object and press Enter.
The Object Job Display shows all the jobs that acted upon the object, including the completion and reason codes. The following figure shows the Object Job Display:
AUTOXPRT V1R1 ----------- Object Job Display ----------- 2023/10/21 19:28:22
Option ===> Scroll ===> CSR
-------------------------------------------------------------------------------
Line Commands: D - Delete O - Objects S - Steps
-------------------------------------------------------------------------------
Database Name H7241DB Db2 Subsystem: SS01
Space Name H7241XB2
Space Type IX Row 1 of 6 >
-------------------------------------------------------------------------------
Cmd Jobname Jobnum Completion Reason Code Creator Profile ID
PDUSERAZ J0681457 R0000 00000000 PDUSER CB1E9D32F528C5A0
PDUSERAZ J0681485 R0008 00000000 PDUSER CB1E9F78F7C433B0
PDUSERAZ J0681491 R0000 00000000 PDUSER CB1E9F78F7C433B0
PDUSERAZ J0681567 R0000 00000000 PDUSER CB1EA67A4D6E5C30
PDUSERAZ J0681571 R0000 00000000 PDUSER CB1EA6BE4E226427
PDUSERAZ J0681618 R0000 00000000 PDUSER CB1EA8AE88CD08A1
***************************** Bottom of Data **********************************
What to do next
On the Object Job Display, you can use the line commands that are described in the following table to process a job or to review related information about the job:
Table 1. Object job line command descriptions
Line command
Description
D
Delete a job from the Execution Reports repository.
Note: This does not delete the job from SDSF or other job handling facility.
O
Select a job to see all of the objects that were processed by that job.
S
Select a job to see the job steps in the job and the completion codes for each step.