|
Problem IC66963
|
Status: Geschlossen |
FREQUENT SQLESETI() OR SETDB2CLIENT TYPE API CALLS IN APPL. CAUSING EXTENDED COMPILING STATE AND FILLING THE PKGCACHE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
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. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
LOCAL FIX:
Try to avoid submitting frequent SET CLIENT stmt if possible.
Fixed in DB2 V91Fp10 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66997 IC67000
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.03.2010
14.06.2011
14.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
