DB2 FOR LUW / DB2FORLUW / A50 - DB2

Inserting in an MDC table may fail with the following 
db2diag.log message: 
 
2016-08-29-03.05.53.501342+120 I1151097E565          LEVEL: 
Severe 
PID     : 58787                TID : 140607448147712 PROC : 
db2sysc 0 
INSTANCE: db2jkl               NODE : 000            DB   : JKL 
APPHDL  : 0-23206              APPID: 
10.0.0.1.62596.160828212603 
AUTHID  : SAPJKL               HOSTNAME: server 
EDUID   : 8283                 EDUNAME: db2agent (JKL) 0 
FUNCTION: DB2 UDB, index manager, sqlilkey, probe:1430 
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program 
error" 
          DIA8575C An index manager programming error occurred. 
 
2016-08-29-03.05.53.501633+120 I1151663E753          LEVEL: 
Severe 
PID     : 58787                TID : 140607448147712 PROC : 
db2sysc 0 
INSTANCE: db2jkl               NODE : 000            DB   : JKL 
APPHDL  : 0-23206              APPID: 
10.0.0.1.62596.160828212603 
AUTHID  : SAPJKL               HOSTNAME: server 
EDUID   : 8283                 EDUNAME: db2agent (JKL) 0 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging function), probe:50 
MESSAGE : slotinfo 
DATA #1 : Hexdump, 40 bytes 
0x00007FE37FB27748 : 0100 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00007FE37FB27758 : 0100 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00007FE37FB27768 : FFFF FFFF FFFF FFFF 
........ 
 
APPHDL  : 0-23206              APPID: 
10.0.0.1.62596.160828212603 
AUTHID  : SAPJKL               HOSTNAME: server 
EDUID   : 8283                 EDUNAME: db2agent (JKL) 0 
FUNCTION: DB2 UDB, index manager, sqli_mdcProcessLeaf, 
probe:1214 
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program 
error" 
          DIA8575C An index manager programming error occurred. 
 
2016-08-29-03.05.58.099803+120 I1178886E758          LEVEL: 
Severe 
PID     : 58787                TID : 140607448147712 PROC : 
db2sysc 0 
INSTANCE: db2jkl               NODE : 000            DB   : JKL 
APPHDL  : 0-23206              APPID: 
10.0.0.1.62596.160828212603 
AUTHID  : SAPJKL               HOSTNAME: server 
EDUID   : 8283                 EDUNAME: db2agent (JKL) 0 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging function), probe:50 
MESSAGE : scan slotinfo 
DATA #1 : Hexdump, 40 bytes 
0x00007FE37FB27710 : 0000 0000 0000 0000 E134 0000 0000 0000 
.........4...... 
0x00007FE37FB27720 : 0800 0000 0000 0000 2200 0000 0000 0000 
........"....... 
0x00007FE37FB27730 : FFFF FFFF FFFF FFFF 
........ 
 
with the following stack: 
 
sqlilkey 
sqli_mdcProcessLeaf 
sqlirdk 
sqldb_insertRow 
sqldRowInsert 
sqlrinsr 
sqlriisr 
 
under very rare conditions: 
 
1. Index Page 1 (not actual index page number) contains only 1 
key, and all the BIDs are marked as full block. 
2. Index Page 2 (the next page of Page 1 ) contains 2 key, and 
the 1st key is the same as the key in Page 1, and all BIDs on 
first key is FULL BLOCK 
3. Index Page 3 (the next page of Page 2 ) is empty but not last 
leaf page.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

23.09.2016
29.09.2017
29.09.2017

9.0.