-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.

The 'reason-code' value is the two-byte hexadecimal code point for the DDM reply message that represents the error and is one of the following:
  • 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.

The 'sub-code' when nonzero, consists of two bytes such that the high-order byte indicates the site at which the error was detected. This is X'01' if the error was detected by the local DB2; it is X'02' if the error was detected by the remote server. The low-order byte is dependent on the 'reason-code' as follows:
  • 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