SQL error from ODBC driver when running a query in DB2 Analytics Accelerator for z/OS

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:

(0 users)Average rating

Document information


More support for:

DB2 Analytics Accelerator for z/OS

Software version:

2.1.0, 3.1.0

Operating system(s):

z/OS

Reference #:

1622424

Modified date:

2013-01-17

Translate my page

Machine Translation

Content navigation