Collecting data when an abend occurs for an SQL query
If an abend occurs during an SQL query, collect the SQL statement, EXPLAIN report, DDL, supervisor call (SVC) dump, LOGREC, and SYSLOG diagnostic data.
Before you begin
To diagnose query abend problems, you must have the appropriate authorization to collect data from different z/OS® components.
Procedure
Gather the following diagnostic data:
Collect the following data to diagnose an abend for an SQL query:
- A copy of the SQL statement to investigate
Service SQL documentation
that describes the environment for the SQL statement, as described in Collecting service SQL documentation
- The LOGREC, which might contain messages during the time of the error
- The SYSLOG data set messages from the ssnnMSTR address space
- Any supervisor call (SVC) dump that is generated by the abend