| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IT28979 | Status: Geschlossen |
POOR PERFORMANCE WITH CLUSTER INDEX AND COMPRESSED TABLE. ( SQLDCHECKPAGEFORINSERT EXIT [RC = 0X00002712 = 10002] ) | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Problem conclusion * **************************************************************** | |
| Local-Fix: | |
| Lösung | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.04.2019 18.06.2020 18.06.2020 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
