The ADBTEP2 summary report
You might want a summary report of all activity at the end of or during large or complex work statement list (WLS) runs. This report will enable you to quickly spot any object or data availability issues. The ADBTEP2 summary report appears (and grows) while any ADBTEP2 job is running, not just WSLs.
The report can be examined in SDSF, under the ADBRPTSM DD. A sample report is shown in the following figure.
13:13.31 DB2 Administration Tool - 2009-09-17 Summary Report for L655527D
13:13.31
13:13.31 Ret Code Action Object
13:13.31 ======== ======== ====================================================
13:13.32 0 UNLOAD TABLESPACE DBADKK01.TSADKK01 FROM TABLE "VNDDHG"."TB
89740"
13:13.34 0 DROP TABLESPACE "DBADKK01"."TSADKK01"
13:13.37 562 GRANT USE OF STOGROUP SYSDEFLT TO USRT001
13:13.37 562 GRANT USE OF STOGROUP SYSDEFLT TO "PUBLIC"
13:13.39 0 CREATE TABLESPACE TSADKK01
13:13.39 0 CREATE TABLE VNDDHG.RN89740
13:13.39 562 GRANT USE OF STOGROUP SYSDEFLT TO "PUBLIC"
13:13.39 0 CREATE TABLESPACE TSADKK01
13:13.39 0 CREATE TABLE VNDDHG.RN89740
13:13.42 0 CREATE UNIQUE INDEX "VNDDHG"."D7762_INDEX" ON "VNDDHG"."RN8
9740"
13:13.42 0 CREATE UNIQUE INDEX VNDDHG.D7762_INDEX1 ON VNDDHG.RN89740
13:13.42 0 CREATE VIEW VNDDHG.VW_TEACHER
13:13.42 -204 DROP TRIGGER VNDDHG.INSOF_VIEW_TRIG01
13:13.42 0 CREATE TRIGGER VNDDHG.INSOF_VIEW_TRIG01
13:13.44 4 UTILFROM VNDDHG.L655527D.CNC.T001
13:13.45 0 ALTER TABLE "VNDDHG". "RN89740" ALTER COLUMN "TEACHER_ID"
SET GENERATED ALWAYS
13:13.45
13:13.45 End of Summary Report