DB2 FOR LUW / DB2FORLUW / B10 - DB2

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]

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

not known / see Local fix

forerunner  : IT24047 
follow-up : 

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

04.05.2018
27.11.2018
27.11.2018