Reviewing actions and symptoms
Once a job profile is built for automated actions, you can review the actions that were generated by the build and the exceptions or symptoms that triggered the actions.
Procedure
What to do next
- To change the type of action (active to passive or passive to active), enter T next to an open or active action and press Enter. Enter Y on the Confirm Action Type Change confirmation dialog to confirm the change.
- To delete an action, enter D next to the action and press Enter. Enter Y on the Confirm Action Delete confirmation dialog to confirm the change.
- To view the exceptions (symptoms) that triggered the action for an object, enter S next to an action and press Enter. The Symptoms panel is displayed, which shows the exception that was specified and that triggered the utility, along with the actual trigger value that was found.
- To view the output from the action or the control cards that were generated for the utility, follow these steps. Note: Some builds generate several individual actions as a group to run a utility. For example, a REORG might generate three individual actions: create a temporary mapping table, the REORG, and drop the temporary mapping table. When an action requires several individual actions, the Action Group panel is displayed first, with each action listed separately. For each of those individual actions, you can view the output or the options that were specified in control cards for each individual action from this panel.
- To view the output from the action, enter the letter O next to an action and press Enter. The Execution Output panel is displayed. This panel shows error messages that were generated during the action, and the output from the stored procedure. The following figure shows a portion of output from a CHECK DATA utility:
Figure 2. Execution Output panel AUTOXPRT V1R1 ---------- Execution Output ----------- 2023/10/21 16:21:35 Option ===> Scroll ===> CSR Db2 Subsystem: SS01 Row 1 of 22 + ------------------------------------------------------------------------------- Error Messages No Error Messages Stored Procedure Output 1DSNU000I 230 12:40:00.76 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = A114 5 DSNU1045I 230 12:40:00.86 DSNUGTIS - PROCESSING SYSIN AS UNICODE UTF-8 0DSNU050I 230 12:40:00.87 DSNUGUTC - CHECK DATA TABLESPACE NMHA7348.TS73480 2 PART 3 SHRLEVEL REFERENCE SCOPE PENDING AUXERROR REPORT LOBERROR REPORT XMLERROR REPORT EXCEPTIONS 0 DSNU737I !SS01 230 12:40:00.87 DSNUKINP - TABLESPACE 'NMHA7348.TS734802' PART ITION '3' IS NOT CHECK PENDING DSNU749I 230 12:40:00.87 DSNUK001 - CHECK DATA COMPLETE,ELAPSED TIME=00:00: 00 DSNU010I 230 12:40:00.87 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RET - To view the options that are specified on the control cards, enter P next to an action and press Enter. The Action Options panel shows the control cards that were generated to run the utility. The following figure shows the control cards from the same CHECK DATA utility:
Figure 3. Action Options panel AUTOXPRT V1R1 ------ Action Options ------ 2023/10/21 16:25:33 Option ===> Scroll ===> CSR Db2 Subsystem: SS01 Row 1 of 11 ------------------------------------------------------------------------------- Options CHECK DATA TABLESPACE NMHA7348.TS734802 PART 0003 SHRLEVEL REFERENCE SCOPE PENDING AUXERROR REPORT LOBERROR REPORT XMLERROR REPORT EXCEPTIONS 0 ***************************** Bottom of Data **********************************
- To view the output from the action, enter the letter O next to an action and press Enter. The Execution Output panel is displayed. This panel shows error messages that were generated during the action, and the output from the stored procedure. The following figure shows a portion of output from a CHECK DATA utility: