Skip to Content

SQL Error Analysis report example

The following SYSIN statements are used to generate the SQL Error Analysis report, listing all negative SQL codes that are captured between 3/27/22 14:00:01 and 3/27/22 20:00:00.

   REPORT(NAME(SQMCERRC) -
   INTERVAL(START(03/27/22,14:00:01)  -  
              END(03/27/22,20:00:00)))

Related topic

Batch-reports-description-and-examples

Batch SQL Error Analysis report (SQMCERRC)

1 SQMCERRC: SQL ERROR ANALYSIS                                     03/23/22 13:49:41    PAGE     1             
                                   INTERVAL: 03/19/22 00:00:00  TO  03/20/22 00:00:00                                                

    ACTIONS FOR +:  S-SHOW LIST OF OCCURRENCES
                    T-SHOW ALL ERRORS IN CHRONOLOGICAL ORDER
                FOR *:  D-DETAIL ERROR ANALYSIS  F-FULL PROGRAM NAME (IF LONG)                                                           

                    CORRID:                PLAN:            CLNTAP:
  CONNID:          USER:           PROGRAM:          CLNTID:    APPGRP:                               STMTNO:            CLNTWS:

       SQL         ERROR   +------------- DATA FROM LAST SQL ERROR ------------+
      CODE  DB2    DETAILS DATE AND TIME              USER     PLAN     PROGRAM
 +    -104  DEDK         2  2022-03-19-18.49.24.99114 RDADAC4  AFDINST4 AINSQLIO
 +    -204  DEDK        64  2022-03-19-18.38.13.93862 RDADAC4  AFDINST5 AINSQLIO


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Apptune for Db2 13.1