DB2 - Problem description
Problem IT28979 | Status: Closed |
POOR PERFORMANCE WITH CLUSTER INDEX AND COMPRESSED TABLE. ( SQLDCHECKPAGEFORINSERT EXIT [RC = 0X00002712 = 10002] ) | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Problem conclusion * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.04.2019 18.06.2020 18.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |