Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT07703 Status: Closed

WHEN A DATABASE IS ORACLE COMPATIBLE, A STATEMENT HEAP CAN GROW ENORMOUSLY
WHEN A QUERY HAS A LOT OF REFERENCES TO DUAL TABLE.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
This can only happen when Oracle Compatibility is enabled. 
 
When one query uses a lot of DUAL (for instance, with UNION ALL 
clause), compiling that query can drive a statement heap to a 
enormous size.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 Fix Pack 11                               * 
****************************************************************
Local Fix:
The workaround is to replace DUAL with SYSIBM.SYSDUMMY1.
Solution
First fixed in DB2 9.7 Fix Pack 11
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.03.2015
03.05.2017
16.10.2017
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.