DSNT416I SQLERRD = field-1, field-2, field-3, field-4, field-5, field-6 SQL DIAGNOSTIC INFORMATION
Explanation
One or more of the six diagnostic fields do not
have the expected value. The diagnostic fields should contain one
of the following expected sets of values:
- 00, 00, 00, 00, 00, 00
- 00, 00, 00, -1, 00, 00
- field-1
- DB2® unique internal relational data system code.
- field-2
- DB2 internal data manager error code.
- field-3
- One of the following conditions:
- Number of rows inserted, updated, or deleted following
an INSERT, UPDATE, MERGE or DELETE statement. Attention: A -1 in this field indicates that a mass delete of a table in a segmented table space was performed, wherein DB2 does not access nor count individual rows.
- For SQLCODE -911 or -913, a reason code that indicates whether
a deadlock or timeout occurred. Tip: The most common reason codes are:
- 00C90088 - deadlock
- 00C9009E - timeout
- Number of rows inserted, updated, or deleted following
an INSERT, UPDATE, MERGE or DELETE statement.
- field-4
- Reserved.
- field-5
- Position or column of a syntax error for PREPARE or EXECUTE IMMEDIATE.
- field-6
- DB2 internal buffer manager error code.
System action
Processing continues.
System programmer response
The SQL diagnostic information might help in diagnosing an error or in indicating the results of successful execution. If this error or warning should not occur, correct the error. Rerun the program or SQL statement.