Collecting data for an unexpected SQLCODE

If Db2 returns an unexpected SQLCODE, collect the SQLCA and DSN1SDMP dump data set that was triggered by the SQLCODE.

Before you begin

To diagnose unexpected SQLCODE problems, you must have the appropriate authorization to collect data from different z/OS® components.

Procedure

Gather the following diagnostic data:

Collect the following diagnostic data to diagnose unexpected SQLCODE problems:
  • Service SQL information for the SQL statement, as described in Collecting service SQL documentation.
  • A copy of the complete SQLCA that was returned to your application
  • The DSN1SDMP dump data set that was triggered by the SQLCODE. DSN1SDMP SDMPIN DD control statements are commonly supplied by IBM® Software Support