DB2 FOR LUW / DB2FORLUW / A50 - DB2

In tables defined with both a clustering index as well as
adaptive compression, performance limitations during workloads
with very high insert operations may occur.

A db2 trace (db2trc) of the workload will show a significant
amount of time spent in function sqldCheckPageForInsert(), as
seen in this db2trc snippet:

sqlbfix entry    # accessMethod: SQLB_POOL_RELATIVE
sqlbfix exit      # SQLB_PAGE* , 0x0a0004037c5b0000 ,
Pagekey:{pool:44;obj:74;type:0} PPNum:44 ,
pageHead:{tbspSeed:44;obj:74;type:0} bphPPNum:44 bphOPNum:44
sqldCheckPageForInsert entry
sqldCheckPageForInsert exit [rc = 0x00002712 = 10002]
sqlbfix entry     # accessMethod: SQLB_OBJ_RELATIVE   LSN
=00000005A081F482  LOWTRANS=00000005A3019A50
sqlbfix exit      # SQLB_PAGE* , 0x0a0004037e4c8000 ,
Pagekey:{pool:44;obj:74;type:0} PPNum:47 ,
pageHead:{tbspSeed:44;obj:74;type:0} bphPPNum:47 bphOPNum:47
sqldCheckPageForInsert entry
sqldCheckPageForInsert exit [rc = 0x00002712 = 10002]
sqlbfix entry     # accessMethod: SQLB_OBJ_RELATIVE    LSN
=00000005A081F482  LOWTRANS=00000005A3019A50
sqlbfix exit      # SQLB_PAGE* , 0x0a00040359700000 ,
Pagekey:{pool:44;obj:74;type:0} PPNum:38 ,
pageHead:{tbspSeed:44;obj:74;type:0} bphPPNum:38 bphOPNum:38

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Problem conclusion                                           *
****************************************************************

not known / see Local fix

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

29.04.2019
18.06.2020
18.06.2020