-30000 EXECUTION FAILED DUE TO A DISTRIBUTION PROTOCOL ERROR THAT WILL NOT AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR SQL STATEMENTS: REASON reason-code (sub-code)
Explanation
A DRDA protocol error has resulted which prevented successful execution of the current SQL statement. The error was such that it will not preclude the successful execution of further SQL statements.
System action
The statement cannot be processed. The SQLCA is formatted. Message DSNL031I or DSNL032I, which might contain additional diagnostic information, might be issued to the MVS™ console.
Programmer response
Notify the DBA for assistance in analysis of the SQL statement which yielded this SQLCODE.
Problem determination
The 'reason-code' identifies the DDM code point which represents the DDM reply message received from the remote server in response to the attempt to execute the SQL statement. These represent internal errors detected at the remote server or possibly, by the local DB2® functions.
- X'1254' - CMDCHKRM
- X'220A' - DSCINVRM
- X'220E' - DTAMCHRM
- X'1245' - PRCCNVRM
- X'2202' - QRYNOPRM
- X'220F' - QRYPOPRM
- X'2207' - RDBACCRM
- X'2204' - RDBNACRM
- X'124C' - SYNTAXRM
A two-byte 'sub-code' accompanies 'reason-codes' X'220A' (DSCINVRM), X'1245' (PRCCNVRM), and X'124C' (SYNTAXRM). In all other cases, the 'sub-code' is zero.
- Description Error Code (DSCERRCD) if 'reason-code' = X'220A' (DSCINVRM).
- Syntax Error Code (SYNERRCD) if 'reason-code' = X'124C' SYNTAXRM).
- Conversational Protocol Error Code (PRCCVNCD) if 'reason-code' = X'1245' (PRCCNVRM).
Refer to the Open Group Technical Standard, DRDA Version 3 Vol. 3: Distributed Data Management Architecture for a detailed discussion of the semantics of the DDM terms DSCERRCD, SYNERRCD, and PRCCNVCD.
SQLSTATE
58008