Technote (troubleshooting)
Problem(Abstract)
An error occurs when queries are submitted from an Open Database Connectivity (ODBC) client to be processed by DB2 Analytics Accelerator for z/OS.
Symptom
The following error occurs when queries are submitted from an Open Database Connectivity (ODBC) client to a DB2 for z/OS database server for processing with IBM DB2 Analytics Accelerator for z/OS:
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [HY000:1248: on SQLHANDLE] [MicroStrategy][ODBC DB2 Wire Protocol driver]Unhandled CodePoint: 1C03 For more information, please consult DB2 document for error code SQL01248
IBM DB2 Analytics Accelerator for z/OS is enabled if the CURRENT QUERY ACCELERATION special register is set to one of the following values:
- ALL
- ELIGIBLE
- ENABLE
- ENABLE WITH FAILBACK
The same query runs without problems when query acceleration is disabled (the CURRENT QUERY ACCELERATION special register is set to NONE or not set at all).
Cause
Not all ODBC drivers support DB2 for z/OS as a gateway to IBM DB2 Analytics Accelerator.
For example the DataDirect ODBC driver, which is supplied with MicroStrategy Intelligence Server or SPSS, does not support this scenario.
See also: http://knowledgebase.progress.com/articles/Article/4404
Environment
DB2 for z/OS with IBM DB2 Analytics Accelerator for z/OS.
Database client connection established by use of third party ODBC driver.
Diagnosing the problem
SQL error for queries sent from ODBC clients to DB2 for z/OS. The problem disappears when you disable query acceleration.
Resolving the problem
Use the current version of the IBM-supplied ODBC driver for this purpose. For example, the ODBC driver that comes with IBM Data Server Driver does not have this problem.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.