|
Problem IT22923
|
Status: Closed |
IMPORT REPLACE HOLDING X ROW LOCK AND IX TABLE LOCK ON SYSIBM.SYSTABLES FOR THE WHOLE DURATION
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
During the IMPORT REPLACE we holding X ROW LOCK AND IX TABLE
LOCK ON
SYSIBM.SYSTABLES for the whole duration operation
example:
db2 import from org1.ixf of ixf COMMITCOUNT 10000 replace into
org1
we can see that we all the time hold lock on SYSIBM.SYSTABLES
db2pd -db sample -locks showlocks | grep SYSTABLES
Locks:
Address TranHdl Lockname Type
Mode Sts Owner Dur HoldCount Att ReleaseFlg rrIID
TableNm SchemaNm
0x00007FFFB1BCEF80 3 000005000E000C000000000052 RowLock
..X G 3 8 0 0x00200000 0x4000004D 0
SYSTABLES SYSIBM 000005000E000C000000000052
SQLP_RECORD (obj={0;5}, rid=d(0;12;14), x0E000C0000000000)
0x00007FFFB1BCFB00 3 00000500000000000000000054
TableLock .IX G 3 38 0 0x00202000
0x4000007F 0 SYSTABLES SYSIBM
00000500000000000000000054 SQLP_TABLE (obj={0;5})
Operating system : ALL
Db2 9.7.11 and above |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to at least *
* Db2 v 10.5 FP 10 *
* or *
* Db2 v 111 m1FP 4 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.10.2017
13.07.2018
13.07.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
