DB2 FOR LUW / DB2FORLUW / B50 - DB2

SQL using a column organized table may fail with an assertion
failure and SQL0901N error as follows:

2020-05-22-18.24.11.432997+540 I11182521E4194        LEVEL:
Error
PID     : 18806                TID : 47035663247104  PROC :
db2sysc 10
INSTANCE: db2inst1             NODE : 010            DB   :
BLUDB
APPHDL  : 0-32837              APPID:
127.0.0.1.51554.200522092411
UOWID   : 1                    ACTID: 2
AUTHID  : BLUADMIN             HOSTNAME: hostname.ibm.com
EDUID   : 166222               EDUNAME: db2agntcol (BLUDB) 10
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:815
DATA #1 : String, 1023 bytes
AssertionFailedException: An assertion 'false' failed.
Additional info: Unable to access target page from page map:
  ...

DATA #2 : Function name in Library, 255 bytes
ibm_cde::data::Page
*ibm_cde::data::PageIteratorForTSNRange::readNextPageInternal(bool, unsigned int &,
ibm_cde::data::PageRequest *&, bool &, bool &, bool *, const
ibm_cde::data::PageDescriptor *) [with CheckAllCom
DATA #3 : File name, 27 bytes
PageIteratorForTSNRange.cpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
  [0] 0x00002AB9DF40BAB9
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0x369
  [1] 0x00002AB9DF377777
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x337
  [2] 0x00002AB9DF36DC4F
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x13F
  [3] 0x00002AB9DFF8F917
_ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE20readNextPag
eInternalILb0ELb0EEEPNS0_4PageEbRjRPNS0_11PageRequestERbSA_PbPK
+ 0x1B57
  [4] 0x00002AB9DFF903D8
_ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE12readNextPag
eERjRPNS0_11PageRequestE + 0x28
  [5] 0x00002AB9E0DEFAC0
_ZN7ibm_cde5query21LoadColValueEvaluator15processTSNRangeILNS0_3
OpTE305ENS_5types7IntegerIiEES6_EEvv + 0x8A0
  [6] 0x00002AB9E0CC54EE
_ZN7ibm_cde5query21LoadColValueEvaluator26processInputsSynchrono
uslyEv + 0x2CE
    ...

2020-05-22-18.24.11.470951+540 I11186716E5833        LEVEL:
Severe (Origin)
PID     : 18806                TID : 47035663247104  PROC :
db2sysc 10
INSTANCE: db2inst1             NODE : 010            DB   :
BLUDB
APPHDL  : 0-32837              APPID:
127.0.0.1.51554.200522092411
UOWID   : 1                    ACTID: 2
AUTHID  : BLUADMIN             HOSTNAME: hostname.ibm.com
EDUID   : 166222               EDUNAME: db2agntcol (BLUDB) 10
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:815
MESSAGE : SQL0901N  The SQL statement or command failed because
of a database
          system error. (Reason "".)
DATA #1 : 
'false' failed. Info: Unable to access target page from page
map:
  ...
----- Begin dump of Page object at 0x00002abb79198030 -----
  ...
------ End dump of Page object at 0x00002abb79198030 ------

   currentPageLSN:          428006938
   commitLSN:               434388247
   isPageLSNBelowReadLSN:   1
   currentTSN:              144115188075896650
(0x0200000000009f4a)

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to db2_v115m5fp0 or later                            *
****************************************************************

db2set -im DB2_EXTENDED_OPTIMIZATION="PARTSCAN 100" (plus any
existing settings)

not known / see Local fix

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

23.06.2020
19.11.2020
19.11.2020