DSNT271I THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM subsystem-id
- SQLCODE = sql-code
- SQLSTATE = sql-state
- SQLERRMT = sqlca-tokens
- SQLWARN warn_fields
- STATEMENT = statement_number
Explanation
A warning or error has been
received from a database server using Distributed
Relational Database Architecture (DRDA)
during remote program BIND processing.
- subsystem-id
- The database server.
- sql-code
- A numeric value that indicates why the SQL statement execution was unsuccessful.
- sql-state
- The corresponding SQLSTATE for the SQLCODE.
- sqlca-tokens
- Tokens that are passed in the message portion of the SQLCA for problem determination.
- warn_fields
- The warning information indicators.
- statement_number
- The statement number of the failing statement.
System action
See the System Action associated with the indicated SQLCODE.
System programmer response
Take note of the warning or error (as indicated in the SQLCODE, SQLSTATE, or one or more of the SQLWARN fields), and determine if a program change is necessary. Depending on the situation, a change to the application might be necessary or the system programmer might have to be consulted.
If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.
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.