|
Problem IT33354
|
Status: Closed |
RUNNING INSPECT ON A TABLE SPACE MAY HANG CAUSING OTHER QUERIES ON THE SAME TABLE SPACE TO HANG
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
The INSPECT hang is caused by INSPECT self-deadlatching on one
overflow page addressed to the original page.
It can be confirmed by db2pd -latches and db2trc
with USE_PAGELATCH_TRACKING registry variable as shown below.
db2set USE_PAGELATCH_TRACKING=ON;
db2stop; db2start
db2trc on
db2 inspect ...
db2trc dmp db2trc.dmp
db2trc off
db2pd -latches
The db2agent servicing the INSPECT command is the
latch holder and waiter and the trace will show
sqloSXULatch::convertUtoSX failing with SQLO_NOTAVAIL as below.
* db2pd -eve output
Database Member 0 -- Active -- Up 0 days 00:11:52 -- Date
2017-06-27-17.27.53.946535
Latches:
... Holder Waiter ... LatchType
HoldCount
... 48881 23180 ... SQLO_LT_SQLB_BPD__bpdLatch_SX S
... 48881 48881 ... SQLO_LT_SQLB_BPD__bpdLatch_SX S
* db2trc.flw
... dartInspect entry [eduid 48881 eduname db2agent]
... | dartScanTablespace entry [eduid 48881 eduname db2agent]
... | | dartScanTable entry [eduid 48881 eduname db2agent]
... | | | dartScanDAT entry [eduid 48881 eduname db2agent]
... | | | | dartScanPageOfDAT entry [eduid 48881 eduname
db2agent]
... | | | | | dartScanDataContentsOfDAT entry [eduid 48881
eduname db2agent]
... | | | | | | dartScanRowStructures entry [eduid 48881 eduname
db2agent]
... | | | | | | | sqlbfix entry [eduid 48881 eduname db2agent]
... | | | | | | | | sqlbgbGetP34892.999.760agePLock entry [eduid
48881 eduname db2agent]
... | | | | | | | | | sqloSXULatch::convertSXtoU entry [eduid
48881 eduname db2agent]
... | | | | | | | | | sqloSXULatch::convertSXtoU exit
... | | | | | | | | | sqloSXULatch::convertUtoSX entry [eduid
48881 eduname db2agent]
... | | | | | | | | | | SQLO_SLATCH_CAS64::convertConflict entry
[eduid 48881 eduname db2agent]
... | | | | | | | | | | SQLO_SLATCH_CAS64::convertConflict exit
[rc = 0x870F0035 = -2029060043 = SQLO_NOTAVAIL]
... | | | | | | | | | sqloSXULatch::convertUtoSX exit [rc =
0x870F0035 = -2029060043 = SQLO_NOTAVAIL]
... | | | | | | | | | SQLO_SLATCH_CAS64::getConflictComplex
entry [eduid 48881 eduname db2agent]
... | | | | | | | | | SQLO_SLATCH_CAS64::getConflictComplex mbt
[Marker:PD_LATCH_TRACE_WAIT_STARTING ] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* INSPECT Command users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1 Modification 4 FixPack 4 or *
* later *
**************************************************************** |
| Local Fix: |
The overflow pages will be cleaned up by "REORG TABLE". It
can be a work around to avoid this problem. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* INSPECT Command users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1 Modification 4 FixPack 4 or *
* later *
**************************************************************** |
| Comment |
Fixed in DB2 Version 11.1 Modification 4 FixPack 4 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.06.2020
05.07.2020
05.07.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
