|
Problem IT37448
|
Status: Closed |
AFTER TURNING ON CLI PREFETCHING FEATURE, SQL STATEMENT RECEIVESCLI0106E/CLI0108E OR SQL_ERROR WITHOUT DIAGNOSTIC INFO
|
| product: |
DB2 CONNECT / DB2CONNCT / B50 - DB2 |
| Problem description: |
This happens when application frees a statement handle before
all data for a SELECT statement is fetched.
Case 1: A statement handle has not fetched all data for a SELECT
statement but application tries to free another statement
handle. ODBC API may return CLI0106E or CLI0108E error as below:
SQLExecute: [IBM] [CLI Driver] CLI0108E Communication link
failure. SQLSTATE=40003
SQLEndTran: [IBM] [CLI Driver] CLI0106E Connection is closed.
SQLSTATE=08003
Case 2: A statement handle has not fetched all data for a SELECT
statement but application tries to free the same statement
handle. In such case, SQLFreeStmt() or SQLFreeHandle() may
return SQL_ERROR and next API call(Eg:SQLExecute or SQLPrepare)
also returns SQL_ERROR. When SQLGetDiagField() is called to get
SQL_DIAG_NUMBER, it returns 0. Hence, application is unable to
retrieve any diagnostic record. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* When QueryPrefetch feature is turned ON. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* When QueryPrefetch feature is turned ON. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5 FP7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5 FP7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.06.2021
21.11.2021
21.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
