You can view the error messages and output from a Db2 autonomic statistics procedure that was run by using the O line command.
Procedure
On the Automation Execution History panel, enter O in the line command area.
The Maintwindow Execution Output panel is displayed, as shown in the following figure: Figure 1. Maintwindow Execution Output panel
AUTOXPRT V1R1 ------ Maintwindow Execution Output ------ 2023/10/21 21:40:05
Option ===> Scroll ===> CSR
Db2 Subsystem: SS1A Row 1 of 29 +
-------------------------------------------------------------------------------
Error Messages
DSNA649I
DSNX7EXE RUNSTATS ALERTS COULD NOT BE RESOLVED BY PROCEDURE. REASON 1
Stored Procedure Output
2023-08-19 09:52:33.019090> Executing SYSPROC.ADMIN_UTL_EXECUTE
2023-08-19 09:52:33.019109> with options: STAND-ALONE=YES
2023-08-19 09:52:33.019121> stored procedure begins at 2023-08-19 09:52:33.0191
13
2023-08-19 09:52:33.024085> running in Db2 subsystem SS1A
2023-08-19 09:52:33.024096> ----------------------->>Used parameters<<---------
--------------
2023-08-19 09:52:33.024109> STAND-ALONE=YES
2023-08-19 09:52:33.035048> ----------------------->>Step 1: detect new alerts<
<-----------------------
2023-08-19 09:52:33.215914> 1 new alerts with action RUNSTATS detected
2023-08-19 09:52:33.216027> ----------------------->>Step 2: get maintenance wi
ndows<<-----------------------
2023-08-19 09:52:33.216674> DSNA649I DSNX7EXE RUNSTATS ALERTS COULD NOT BE RES
OLVED BY PROCEDURE. REASON 1
2023-08-19 09:52:33.217024> ----------------------->>Execution summary<<-------
----------------
2023-08-19 09:52:33.217037> RUNSTATS alerts solved: 0
2023-08-19 09:52:33.217046> RUNSTATS duplicated alerts completed: 0
This output report panel contains the following two sections:
Error Messages
Indicates the start of the error messages. If the return code was zero, there are no error messages and 'No Error Messages' is displayed.
Stored Procedure Output
Indicates the start of the output from the execution of the stored procedure.
For additional information about the error messages output from the stored procedures, refer to the Db2 autonomic procedures documentation for your version of Db2.