DSNT270I THE FOLLOWING SQLCA INFORMATION WAS RETURNED FROM subsystem-id
- SQLCODE = sql-code
- SQLSTATE = sql-state
- SQLERRMT = sqlca-tokens
- SQLWARN warn_fields
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.
System action
See the System Action associated with the indicated SQLCODE.
System programmer response
See the Programmer Response associated with the indicated SQLCODE and/or SQLSTATE. 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. A change to the application might be necessary or the system programmer might have to be consulted depending on the situation.
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).
- Listing of SYS1.LOGREC data set, obtained by executing IFCEREP1.