DSNT408I SQLCODE = -sql-code, explanation

Explanation

This message contains an SQL return code and a brief explanation, with text inserted from the SQLERRM field. The SQL return code is negative, indicating that an error has occurred.

System programmer response

Determine the cause for the SQL error by using the information about the specific SQL code in Error (−) SQL codes . Then correct the error and rerun the application program or SQL statement.

Problem determination

Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
  • Dynamic dump, taken to SYS1.DUMPxx data set, by Db2 (04E and 04F abends).
  • A listing of the SYS1.LOGREC data set, obtained by executing IFCEREP1.
  • Listing of the results produced by the SQL statements.
  • Source listing of the failing application program.