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/06 14:00:01 and 3/27/06 20:00:00.
REPORT(NAME(SQMCERRC) -
INTERVAL(START(03/27/06,14:00:01) -
END(03/27/06,20:00:00)))
INTERVAL(START(03/27/06,14:00:01) -
END(03/27/06,20:00:00)))
Batch SQL Error Analysis report (SQMCERRC)
1 SQMCERRC: SQL ERROR ANALYSIS 03/23/11 13:49:41 PAGE 1
INTERVAL: 03/19/11 00:00:00 TO 03/20/11 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 2011-03-19-18.49.24.99114 RDADAC4 AFDINST4 AINSQLIO
+ -204 DEDK 64 2011-03-19-18.38.13.93862 RDADAC4 AFDINST5 AINSQLIO
INTERVAL: 03/19/11 00:00:00 TO 03/20/11 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 2011-03-19-18.49.24.99114 RDADAC4 AFDINST4 AINSQLIO
+ -204 DEDK 64 2011-03-19-18.38.13.93862 RDADAC4 AFDINST5 AINSQLIO
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*