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
  • Start of changeService SQL documentation that describes the environment for the SQL statement, as described in Collecting service SQL documentationEnd of change
  • 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