|
Problem IC63522
|
Status: Closed |
DB2 CAN RETURN SQL0101N WHEN COMPILING A COMPLEX SQL QUERY THOUGH STMTHEAP IS AUTOMATIC |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When the database configuration parameter STMTHEAP is set to
AUTOMATIC and there is enough memory in APPL_MEMORY and
INSTANCE_MEMORY, DB2 can still return SQL0101N when compiling a
complex SQL query.
To assess if you are experiencing the problem, which typically
does not consistently return a -101, review the sqlcode returned
when a -101 is not received from statement compilation:
a) If you observe a +437 rc2 from sqlca.sqlerrp=SQLNO24F, then
it is the problem.
b) If you observe a +437 that is not case a, then it could be
the problem, but it can not be confirmed definitively.
c) If you observe no warnings, then it is not the problem. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 CAN RETURN SQL0101N WHEN COMPILING A COMPLEX SQL *
* QUERYTHOUGH STMTHEAP IS AUTOMATIC *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 9.7 FP2 *
**************************************************************** |
| Local Fix: |
Use optimization level 2 to compile the query |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
DB2 CAN RETURN SQL0101N WHEN COMPILING A COMPLEX SQL QUERY
THOUGH STMTHEAP IS AUTOMATIC |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.10.2009
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
