Collecting data for SQL data definition language statement errors

If an error occurs processing an SQL data definition language statement such as CREATE or ALTER, collect the job output and all data definition language statements that are needed to re-create the objects that are involved in your Db2 environment.

Before you begin

To diagnose data definition language statement errors, 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 data definition language statement errors:
  • A copy of the job output with the failing SQL statement, and service SQL information for the statement, as described in Collecting service SQL documentation.
  • A copy of the complete SQLCA returned to your application
  • Data definition language statements to re-create the query environment.
  • A DSN1COPY of the catalog data if requested by IBM® Support
  • Output of the REPAIR DBD TEST or REPAIR DBD DIAGNOSE utility if requested by IBM Support