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. This information is reported by catalog administration tools as:
    • IBM® Data Studio, IBM Data Server Manager, or Optim™ Query Tuner
  • 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