|
Problem IC62753
|
Status: Geschlossen |
PERFORMANCE PROBLEMS WHEN VERY LONG RUNNING TRANSACTIONS CREATE GLOBAL TEMP TABLES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When a long running transaction issues many statements refering
to a declared global temporary table
that has been created in the current transaction - or for which
an index has been created in the current transaction, then the
statements are inserted in the package cache and are not able to
be removed from the package cache until the transaction ends.
This can cause the package cache to overflow and use up
additional memory on the system
This causes slow execution of queries. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users using GLOBAL TEMP TABLES. *
****************************************************************
* PROBLEM DESCRIPTION: *
* PERFORMANCE PROBLEMS WHEN VERY LONG RUNNING TRANSACTIONS *
* CREATE *
* GLOBAL TEMP TABLES. Commit DDL associated with declared *
* global temporary tables *
* before long running transactions *
****************************************************************
* RECOMMENDATION: *
* PERFORMANCE PROBLEMS WHEN VERY LONG RUNNING TRANSACTIONS *
* CREATE *
* GLOBAL TEMP TABLES. Commit DDL associated with declared *
* global temporary tables *
* before long running transactions *
**************************************************************** |
| Local-Fix: |
commit DDL associated with declared global temporary tables
before long running transactions |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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
|
| Lösung |
PERFORMANCE PROBLEMS WHEN VERY LONG RUNNING TRANSACTIONS CREATE
GLOBAL TEMP TABLES. Commit DDL associated with declared global
temporary tables
before long running transactions |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.08.2009
21.12.2009
21.12.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
