DB2 SQL-Error: -30005
SQLState: 56072
Short Description: EXECUTION FAILED BECAUSE FUNCTION NOT SUPPORTED BY THE SERVER LOCATION PRODUCT ID REASON
The current SQL statement failed because the SQL statement was routed to a server that does not support the requested function. The error was such that it will not preclude the successful processing of further SQL statements. System action: The statement cannot be executed. The SQLCA is formatted. Programmer response: Notify the DBA for assistance in analyzing the SQL statement that prompted this SQL code. Problem determination: location identifies the name of the server that could not support hte required database protocals to perform the requested function. The product identifier is in the form pppvvrrm. It is an eight-byte field with alphanumeric characters, and identifies the product that could not support the function. ppp identifies the specific database product. vv identifies the product version. rr identifies the product release level. m identifies the product modification level. Possible values for pppvvrrm: ppp DSN for z/OS, ARI for VM/VSE, SQL for Unix/Windows/NT, QSQ for iSeries, and JCC for Java vv Version number rr Release level m Modification level To correct the problem, first identify the function that is not supported. To determine what function was not supported, and why, refer to the reason-code that was specified. Here are the possible values for reason-code, and the functions that they correspond to: 0010 LONG_STMTS 0010 LONG255_IDS 0030 EXTENDED_DESCRIBE 0040 EXTENDED_DIAGNOSTICS 0050 KEEP_DYNAMIC 0060 MULTI_ROW_FETCH 0070 MULTI_ROW_INSERT 0080 SQL_CANCEL 0090 SCROLLABLE_CURSORS 0100 CURSOR_ATTRIBUTES 0110 MONITORING 0120 SELECT_WITH_INSERT 0130 DATA_ENCRYPTION 0140 PACKAGE_PATH Lastly, you may use the sub-code value to further identify the problem. When non-zero, the sub-code consists of a one-byte code to indicate how the error was detected in the network: v If Â’01Â’x, then the local DB2 that is acting as the requester detected the error. The LOCATION and PRDID identify the server in error. v If Â’02Â’x, then the server detected the error. The LOCATION and PRDID identify the location and level of the local DB2 server. v If Â’03Â’x, then an intermediate server (hop site) detected the error. The error, the LOCATION, and PRDID identify the server in error. v If Â’04Â’x, then an intermediate server (hop site) detected the error. The error, the LOCATION, and PRDID identify the server in error.