DB2 - Problem description
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) |