|
Problem IT38093
|
Status: Closed |
SQL0952N could be retuned for accessing tables having a LOB row.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
If the following conditions are met, SQL0952N could be returned
incorrectly while fetching rows for a select statement.
This problem could happen when the following conditions are met.
1.The Db2 server is configured for using DPF.
2.The table accessed by the SQL has a LOB (not inline-LOB) row.
3.Closing cursor before fetching all data from db2 server.
If the early close property is disabled for the connection, the
error could happen for closing cursor even after fetching all
data.
The early close property set enabled as default can be disabled
for connections.
- SQL_ATTR_EARLYCLOSE is set to SQL_EARLYCLOSE_OFF for CLI/ODBC.
- queryCloseImplicit is set to QUERY_CLOSE_IMPLICIT_NO fo
JDBC/SQLJ. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Comment |
Upgrade to 11.1.4.7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.08.2021
17.04.2022
17.04.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
