DB2 FOR LUW / DB2FORLUW / B10 - DB2

Lock exclusive MDC table with LockSize set to BlockInsert, then
inserting Rows with the same dimension value consecutively will
result in additional rows locks being acquired on this MDC
Table.

The folllowing is a simple reproduction of this issue:

----- Begin repro.ksh -----
#!/bin/ksh

export DB2OPTIONS="-ctv"
dbName="wsdb"

db2 "create db $dbName"
db2 "connect to $dbName"
db2 "create tablespace ts1"
db2 "create table t1 (i1 int) organize by (i1) in ts1"
db2 "alter table t1 locksize blockinsert"
db2 +c "lock table t1 in exclusive mode"
db2 +c "insert into t1 values
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0"
db2pd -db $dbName -locks
echo
db2 "commit"
db2 "drop tablespace ts1"
db2 "terminate"
----- End of repro.ksh -----

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************

A workaround to this problem is to set LockSize to either Table
or Row before the INSERT command and set it back afterwards.

I.e.
db2 +c "lock table t1 in exclusive mode"
db2 +c "alter table t1 locksize table"
db2 +c "insert into t1 values
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0"
db2 +c "alter table t1 locksize blockinsert"
db2pd -db $dbName -locks
echo
db2 "commit"

not known / see Local fix

forerunner  : IT24456 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

22.03.2018
27.11.2018
27.11.2018