-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 format of product identifier values is pppvvrrm, where ppp is a 3-letter product code (such as DSN for DB2®), vv is the version, rr is the release, and m is the modification level. For example, DSN10015 identifies DB2 10 in new-function mode, the value is ‘DSN10015'. The product code (ppp) is one of the following values:
- AQT for IBM® DB2 Analytics Accelerator for z/OS®
- ARI for DB2 Server for VSE & VM
- DSN for DB2 for z/OS
- JCC for IBM Data Server Driver for JDBC and SQLJ
- QSQ for DB2 for i
- SQL for DB2 for Linux, UNIX, and Windows
- 0 - 1
- Modification levels in conversion and enabling-new-function mode from DB2 Version 8 (CM8, CM8*, ENFM8, and ENFM8*)
- 2 - 3
- Modification levels in conversion and enabling-new-function mode from DB2 9 (CM9, CM9*, ENFM9, and ENFM9*)
- 4
- Not used.
- 5 - 9
- Modification levels in new-function mode.
- 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
- 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
