DB2 - Problem description
Problem IT24047 | Status: Closed |
SLOW INSERT PERFORMANCE IN PURESCALE BECAUSE UNCOMMITTED DELETED SLOTS AREN'T REUSED CORRECTLY | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Normally, if there are no other active transactions, deleted slots created by a transaction should be usable by the same transaction. However this doesn't always happen. Conditions for this APAR are the following: - pureScale - need to read a page from disk - the page needs to have a youngest_tid set (a delete by a different transaction occurred in the past) - deletes are not committed before an insert Here is a snippet of db2trc. db2 connect t test APPHNDL=`db2 -x "values MON_GET_APPLICATION_HANDLE()"` db2trc on -m "exit.*.*.sqldCheckPageForInsert.*" -f db2trc.dmp -apphdl ${APPHNDL} -t grep "sqldCheckPageForInsert exit" db2trc.flw | head -n 7 Good case, sqldCheckPageForInsert will return with rc = 0 1 sqldCheckPageForInsert exit 2 sqldCheckPageForInsert exit 3 sqldCheckPageForInsert exit 4 sqldCheckPageForInsert exit 5 sqldCheckPageForInsert exit 6 sqldCheckPageForInsert exit 7 sqldCheckPageForInsert exit ng.case sqldCheckPageForInsert was returned with rc = 10002. 1 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] 2 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] 3 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] 4 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] 5 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] 6 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] 7 sqldCheckPageForInsert exit [rc = 0x00002712 = 10002] | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * pureScale * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 UDB Version 10.5 FixPack 10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT24954 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.02.2018 16.07.2018 16.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |