|
Problem IC76782
|
Status: Closed |
DB2TOP DOES NOT SHOW ALL OF LOCK CHAIN. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
db2top does not show all of Lock Chain.
One. application is Lock holder
Two. applications are waiting for lock.
db2top showed only 1 LockChain.
Expected Lock Chain is 2.
A -> B
A -> C
For example.
Agent Appl Application Object Lock
Id(State) Name Status Name Mode
--------- ----- ---------------------- ------------------ ----
94(l) db2bp Lock Waiting Internal Plan S
94(l) db2bp Lock Waiting Internal Variation S
94(l) db2bp Lock Waiting E97Q3AA.TEST1(0) X (X)
94(l) db2bp Lock Waiting E97Q3AA.TEST1 IX
240(l) db2bp Lock Waiting E97Q3AA.TEST1(0) X (X)
240(l) db2bp Lock Waiting E97Q3AA.TEST1 IX
240(l) db2bp Lock Waiting Internal Variation S
240(l) db2bp Lock Waiting Internal Plan S
75(i) db2bp UOW Waiting in the app Internal Plan S
75(i) db2bp UOW Waiting in the app E97Q3AA.TEST1 X
75(i) db2bp UOW Waiting in the app E97Q3AA.TEST1 IX
db2top screen.
Blocked/Blocking Agent Chain
----------------------------------------------------------------
--------
75->240
75->94 is missing from db2top. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2top does not show all of Lock Chain. *
* *
* One. application is Lock holder *
* *
* Two. applications are waiting for lock. *
* *
* *
* db2top showed only 1 LockChain. *
* *
* Expected Lock Chain is 2. *
* *
* A -> B *
* A -> C *
* *
* For example. *
* *
* Agent Appl Application Object Lock *
* Id(State) Name Status Name *
* Mode *
* --------- ----- ---------------------- ------------------ *
* ---- *
* 94(l) db2bp Lock Waiting Internal Plan S *
* 94(l) db2bp Lock Waiting Internal Variation S *
* 94(l) db2bp Lock Waiting E97Q3AA.TEST1(0) X (X) *
* 94(l) db2bp Lock Waiting E97Q3AA.TEST1 IX *
* 240(l) db2bp Lock Waiting E97Q3AA.TEST1(0) X *
* (X) *
* 240(l) db2bp Lock Waiting E97Q3AA.TEST1 IX *
* 240(l) db2bp Lock Waiting Internal Variation S *
* 240(l) db2bp Lock Waiting Internal Plan S *
* 75(i) db2bp UOW Waiting in the app Internal Plan S *
* 75(i) db2bp UOW Waiting in the app E97Q3AA.TEST1 X *
* 75(i) db2bp UOW Waiting in the app E97Q3AA.TEST1 IX *
* *
* db2top screen. *
* Blocked/Blocking Agent Chain *
* ------------------------------------------------------------ *
* ---- *
* -------- *
* 75->240 *
* *
* 75->94 is missing from db2top. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 fixpack 5. *
**************************************************************** |
| Local Fix: |
|
| 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 first fixed in DB2 UDB Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.06.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
|
 |
