Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC66997 Status: Closed

FREQUENT SQLESETI() OR SETDB2CLIENT TYPE API CALLS IN APPL.
CAUSING EXTENDED COMPILING STATE AND FILLING THE PKGCACHE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
This APAR is similar to APAR IZ14287. However, APAR IZ14287 is 
not considering the "SET CLIENT ... <empty string>" as a 
reasonable valid SET request, hence not covering this case and 
causing the SET requests with empty string to fill the package 
cache and affecting the performance. 
 
With this APAR fix, caching SET stmt even its input is empty 
string will be bypassed.
Problem Summary:
FREQUENT SQLESETI() OR SETDB2CLIENT TYPE API CALLS IN 
APPL. CAUSING EXTENDED COMPILING STATE AND FILLING THE PKGCACHE
Local Fix:
Try to avoid submitting frequent SET CLIENT stmt if possible.
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Fixed in DB2 V95FP6
Workaround
See Local Fix.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.03.2010
14.09.2010
14.09.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
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.