DB2 graphic QMF Version 8

Understanding the generated JCL

The generated JCL is described in this section. This description assumes that all TSO and CICS log data sets are configured. If any data sets are omitted, the corresponding steps and DDs are automatically omitted from the generated JCL.

Step SORT1

This step sorts the TSO and CICS activity log files and merges them into the sorted activity log file.

Step Name SORT1
Program SORT
Input Data Sets (DD=SORTIN) Current TSO and CICS activity log files
Input Data Set Disposition OLD
Output Data Set (DD=SORTOUT) Sorted activity log file
Output Data Set Disposition OLD
IF JOB TERMINATES NOW: Restart at job start.

Step LOAD2

This step updates the HPO Activity Log table, loading the information from the sorted activity log file and the SQL text log files into DB2.

Step Name LOAD2
Program RAAOMLD
Input Data Set (DD=RAALOG) Sorted activity log file (SORTOUT from previous step)
Input Data Set (DD=RAALOG2) Current TSO and CICS SQL text log files
Input Data Set (DD=INCLUDE)
Note:
This DD is not generated automatically.
Optional DD; read only if remote location parm = Y. Sysin listing for all desired included locations.
Input Data Set (DD=EXCLUDE)
Note:
This DD is not generated automatically.
Optional DD; read only if remote location parm = Y. Sysin listing for all desired excluded locations.
DB2 Tables Updated Q.OBJ_ACTIVITY_SUMM and Q.OBJ_ACTIVITY_DTL
IF JOB TERMINATES NOW: Restart at LOAD2 step.

Step ARCH3

This step appends the sorted activity log file to the activity archive log file.

Step Name ARCH3
Program IEBGENER
Input Data Set (DD=SYSUT1) Sorted activity log file
Input Data Set Disposition OLD
Output Data Set (DD=SYSUT2) Archive activity log file
Output Data Set Disposition MOD (data will be appended to the archive log file)
IF JOB TERMINATES NOW: Restore the archive activity log file (SYSUT2 data set) to its state prior to executing this step then restart at the ARCH3 step.

Step ARCH4

This step appends the SQL text log files to the SQL text archive log file.

Step Name ARCH4
Program IEBGENER
Input Data Set (DD=SYSUT1) Current TSO and CICS SQL text log files
Input Data Set Disposition OLD
Output Data Set (DD=SYSUT2) Archive SQL text log file
Output Data Set Disposition MOD (data will be appended to the archive log file)
IF JOB TERMINATES NOW: Restore the archive SQL text log file (SYSUT2 data set) to its state prior to executing this step then restart at ARCH4 step.

Step INIT5

This step reinitializes the TSO activity log file.

Step Name INIT5
Program RAAMT
Input Data Set (DD=SYSUT1) Current TSO activity log file
Input Data Set Disposition OLD
IF JOB TERMINATES NOW: Restart at INIT5 step.

Step INIT6

This step reinitializes the CICS activity log file.

Step Name INIT6
Program RAAMT
Input Data Set (DD=SYSUT1) Current CICS activity log file
Input Data Set Disposition OLD
IF JOB TERMINATES NOW: Restart at INIT6 step.

Step INIT7

This step reinitializes the sorted activity log file.

Step Name INIT7
Program RAAMT
Input Data Set (DD=SYSUT1) Sorted activity log file
Input Data Set Disposition OLD
IF JOB TERMINATES NOW: Restart at INIT7 step.

Step INIT8

This step reinitializes the TSO SQL text log file.

Step Name INIT8
Program RAAMT
Input Data Set (DD=SYSUT1) TSO SQL text log file
Input Data Set Disposition OLD
IF JOB TERMINATES NOW: Restart at INIT8 step.

Step INIT9

This step reinitializes the CICS SQL text log file.

Step Name INIT8
Program RAAMT
Input Data Set (DD=SYSUT1) CICS SQL text log file
Input Data Set Disposition OLD
IF JOB TERMINATES NOW: Restart at INIT9 step.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004