-30005 EXECUTION FAILED BECAUSE FUNCTION NOT SUPPORTED BY THE SERVER: LOCATION location-name PRODUCT ID product-identifier REASON reason-code (sub-code)
Explanation
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.
- location-name
- The name of the server that could not support the required database protocols to perform the requested function.
- product-identifier
- An alphanumeric string that identifies the product.The product identifier (PRDID) value is an 8-byte character value in pppvvrrm format, where: ppp is a 3-letter product code; vv is the version;rr is the release; and m is the modification level. In Db2 12 for z/OS®, the modification level indicates a range of function levels:
- DSN12015 for V12R1M500 or higher.
- DSN12010 for V12R1M100.
- reason-code
- A numeric value that identifies the function. Possible values
are:
- 0010
- LONG_STMTS
- 0020
- LONG255_IDS
- 0030
- EXTENDED_DESCRIBE
- 0040
- EXTENDED_DIAGNOSTICS
- 0050
- KEEP_DYNAMIC
- 0060
- UNICODE_CONVERSION
- 0070
- ROWSET_CURSOR
- 0080
- DYNAMIC_SCROLLABLE_CURSOR
- 0090
- FLEX_BLOCKING
- 0100
- PACKAGE_PATH
- 0110
- REOPT_ONCE
- 0120
- REOPT_ALWAYS
- 0130
- REOPT_NONE
- 0140
- SCROLL_ORIENTATION
- 0150
- DIV_SCALE
- 0160
- QUERY_INSTANCE
- 0170
- MULTIROW_INPUT
- 0180
- SQL_ATTRIBUTES
- 0190
- SQL_GET
- 0200
- SET
- 0210
- BIND_DEPLOY
- 0220
- DUP_QUERY_SEMANTICS
- 0230
- BINARY_XML_FORMAT
- 0240
- BIND_DEPLOY_FUNCTION
- 0250
- REMOTE_QUERY_OFFLOAD
- 0260
- ORDINARY_ARRAY_PARM
- sub-code
- A single-byte value that indicates how the error was detected
in the network. If no additional information is available, this value
is 0.
- '01'x
- The local Db2 that is acting as the requester detected the error. The values that are provided for location-name and product-identifier identify the server in error.
- '02'x
- The server detected the error. The values that are provided for location-name and product-identifier identify the location and level of the local Db2 server.
- '03'x or '04'x
- An intermediate server (hop site) detected the error. The values that are provided for location-name and product-identifier identify the server in error.
System action
The statement cannot be processed. The SQLCA is formatted.
Programmer response
Notify the DBA for assistance in analyzing the SQL statement that prompted this SQLCODE.
Problem determination
Use the reason-code value that was specified in the code to determine which function was not supported. Use the sub-code value to further identify the problem.
SQLSTATE
56072