DB2 SQL-Error: -30000
SQLState: 58008
Short Description: EXECUTION FAILED DUE TO A DISTRIBUTION PROTOCOL ERROR THAT WILL NOT AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR SQL STATEMENTS REASON C S E C SYNERRCD XC SYNTAXRM C P E C PRCCVNCD X PRCCNVRM R O G T S DRDA V V D D M A DDM DSCERRCD SYNERRCD PRCCNVCD
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 executed. 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: 1. Description Error Code (DSCERRCD) if 'reason-code' = X'220A' (DSCINVRM).