Task output panels
The Db2 Admin Task SYSOUT panel shows the output from the task execution. If the task was a JCL job, the output display shows the contents of the job's SYSOUT data set if the data set is still available in SDSF. If the data set is not available, the panel displays the message "No rows to display." If the task was a stored procedure, the panel displays the output parameters and results sets from the stored procedure.
SYSOUT panel for JCL jobs
The following figure shows the Db2 Admin Task Status Detail window for a JCL job:AUTOXPRT V1R1 --------- Db2 Admin Task SYSOUT --------- 2023/10/21 21:08:57
Option ===> Scroll ===> CSR
-------------------------------------------------------------------------------
Task Name TEST EXECUTION JCL
Task Creator TWUSR Db2 Subsystem: SS1A
JobID J0211132 Row 1 of 58 +>
-------------------------------------------------------------------------------
J E S 2 J O B L O G -- S Y S T E M R S 2 2 -- N O D
13.11.43 J0211132 ---- MONDAY, 05 SEP 2023 ----
13.11.43 J0211132 IRR010I USERID TWUSR IS ASSIGNED TO THIS JOB.
13.11.45 J0211132 ICH70001I TWUSR LAST ACCESS AT 13:10:45 ON MONDAY, SEPTEM
13.11.45 J0211132 $HASP373 TWUSRAPF STARTED - INIT 7 - CLASS A - SYS RS25
13.11.45 J0211132 IEF403I TWUSRAPF - STARTED - TIME=13.11.45
13.11.45 J0211132 RKTSW01I ----------
13.11.45 J0211132 RKTSW01I JOBNAME STEPNAME PROCSTEP STEP RC CPU (Total
13.11.45 J0211132 RKTSW01I TWUSRAPF CSVAPF00 1 00 00:00:00.0
13.11.45 J0211132 IEF404I TWUSRAPF - ENDED - TIME=13.11.45
13.11.45 J0211132 RKTSW01I TWUSRAPF JOB TOTALS: 00:00:00.0
13.11.45 J0211132 $HASP395 TWUSRAPF ENDED
------ JES2 JOB STATISTICS ------
05 SEP 2023 JOB EXECUTION DATE
5 CARDS READ
58 SYSOUT PRINT RECORDS
0 SYSOUT PUNCH RECORDS
4 SYSOUT SPOOL KBYTES
0.00 MINUTES EXECUTION TIME
1 //TWUSRAPF JOB ,'TWUSR',CLASS=A,MSGCLASS=X,
// NOTIFY=&SYSUID,REGION=6M
/*JOBPARM SYSAFF=RS25
IEFC653I SUBSTITUTION JCL - ,'TWUSR',CLASS=A,MSGCLASS=X,NOTIFY=TWUSR,R
2 //CSVAPF00 EXEC PGM=CSVAPF00
3 //APFLIB DD DISP=SHR,DSN=DAJ.WRK0410.LOADLIB
ICH70001I TWUSR LAST ACCESS AT 13:10:45 ON MONDAY, SEPTEMBER 5, 2023
IEF236I ALLOC. FOR TWUSRAPF CSVAPF00
IGD103I SMS ALLOCATED TO DDNAME APFLIB
IEF142I TWUSRAPF CSVAPF00 - STEP WAS EXECUTED - COND CODE 0000
IGD104I DAJ.WRK0410.LOADLIB RETAINED, DDNAME=APFLIB
RKTSW01I-----------------------------------------------------------------------
- Step Termination Statistics
-
- Program Name CSVAPF00 HH:MM:SS.hh
- Step Name CSVAPF00 Elapsed Time 00:00:00.00
- Procedure Step
- Step Number 1 TCB CPU Time 00:00:00.00
- Substep Number 0 SRB CPU Time 00:00:00.00
- Return Code 00 Other CPU Time 00:00:00.01
- Tape Mounts 0 Total CPU Time 00:00:00.01
- Total I/O 0 Connect Time/ms 0
-
- Region Size 6144K
-
- --------Below 16Meg-------- --------Above 16Meg--------
- Private Area 9192K Private Area 1368064K
- Max Allocated 4K Max Allocated 8K
- LSQA And SWA 240K LSQA And SWA 10464K
-
-----------------------------------------------------------------------
IEF373I STEP/CSVAPF00/START 2023248.1311
IEF032I STEP/CSVAPF00/STOP 2023248.1311
CPU: 0 HR 00 MIN 00.00 SEC SRB: 0 HR 00 MIN 00.00 SEC
VIRT: 4K SYS: 240K EXT: 8K SYS: 10464K
IEF375I JOB/TWUSRAPF/START 2023248.1311
IEF033I JOB/TWUSRAPF/STOP 2023248.1311
CPU: 0 HR 00 MIN 00.00 SEC SRB: 0 HR 00 MIN 00.00 SEC
***************************** Bottom of Data **********************************
- Task Name
- The task name.
- Task Creator
- The task creator.
- Db2 Subsystem
- The Db2 SSID on which the task was run.
- JobID
- The job ID that was assigned to the job submitted by the administrative scheduler.
The remainder of the panel contains the contents of the job's SYSOUT data set.
SYSOUT panel for stored procedures
Note: The output command is not available for stored procedures on subsystems running Db2 versions prior to Db2 V9 NFM. If you attempt to use the O line command on such a task, message DAJM763 is displayed.
The following figure shows the Db2 Admin Task SYSOUT panel for stored procedures: AUTOXPRT V1R1 --------- Db2 Admin Task SYSOUT --------- 2023/10/21 21:08:57
Option ===> Scroll ===> CSR
------------------------------------------------------------------------------
Task Name AUTOSTATS TEST RUNSTATS #2
Task Creator PDUSRAA Db2 Subsystem: SS1A
JobID Row 1 of 3 >
------------------------------------------------------------------------------
Parm Type Value
000002 INTEGER 283
000003 INTEGER 0
000004 VARCHAR
***************************** Bottom of Data *********************************- Task Name
- The task name.
- Task Creator
- The task creator.
- Db2 Subsystem
- The Db2 SSID on which the task was run.
- JobID
- The job ID that was assigned to the job submitted by the administrative scheduler.
- Parm, Type, Value
- These columns display the output parameters, their types, and results (if any) from the stored procedure.