|
Problem IC74294
|
Status: Geschlossen |
SQL QUERY COULD HANG IF INSPECT AND ALTER TABLESPACE WERE RUNNING SIMULTANEOUSLY AGAINST THE SAME TABLE SPACE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
If INSPECT and ALTER TABLESPACE commands were running
simultaneously against the same table space, access to the
tables within that table space may be locked. You can notice
that when trying to query any of such tables. This is because of
double latching approach in INSPECT. Although not a problem for
INSPECT itself, it could potentially cause dead latch issue in
some cases, and running ALTER TABLESPACE at the same time with
INSPECT is one of them. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users using DB2 v9.7 FP4 and earlier are affaected. *
****************************************************************
* PROBLEM DESCRIPTION: *
* If INSPECT and ALTER TABLESPACE commands were running *
* *
* simultaneously against the same table space, access to the *
* *
* tables within that table space may be locked. You can notice *
* *
* that when trying to query any of such tables. This is *
* because of *
* double latching approach in INSPECT. Although not a problem *
* for *
* INSPECT itself, it could potentially cause dead latch issue *
* in *
* some cases, and running ALTER TABLESPACE at the same time *
* with *
* INSPECT is one of them. *
****************************************************************
* RECOMMENDATION: *
* If possible, avoid running INSPECT and ALTER TABLESPACE *
* commands *
* against the same table space simultaneously and consider *
* upgrade to DB2 v9.7 FP5. *
**************************************************************** |
| Local-Fix: |
If possible, avoid running INSPECT and ALTER TABLESPACE commands
against the same table space simultaneously. |
| verfügbare FixPacks: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem was fixed in DB2 v9.7 FP5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.02.2011
19.12.2011
19.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
