DB2 - Problem description
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 | |
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 |