|
Problem IC74294
|
Status: Closed |
SQL QUERY COULD HANG IF INSPECT AND ALTER TABLESPACE WERE RUNNING SIMULTANEOUSLY AGAINST THE SAME TABLE SPACE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was fixed in DB2 v9.7 FP5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.02.2011
19.12.2011
19.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
