home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT31955 Status: Closed

HADR REPLAY FAILS DUE TO "EMP MAP INFO END" RESULTING IN FORCED DB
SHUTDOWN

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
REDO of log record for columnar table creation fails due to "EMP
MAP INFO END" resulting in ForceDBShutdown with db2diag messages
like the following:

2017-04-04-17.01.18.725414-240 I47925774A738        LEVEL:
Severe
PID     : 13631586             TID : 8483           PROC :
db2sysc 0
INSTANCE:                      NODE : 000           DB   :

APPHDL  : 0-8                  APPID: *LOCAL.DB2.170404210059
HOSTNAME:
EDUID   : 8483                 EDUNAME: db2redow ( ) 0
FUNCTION: DB2 UDB, CDE Data, Recovery::processRedo, probe:427
MESSAGE : Log Record Component ID
DATA #1 : unsigned integer, 1 bytes
18
DATA #2 : String, 22 bytes
Log Record Function ID
DATA #3 : unsigned integer, 1 bytes
4
DATA #4 : String, 18 bytes
Log Record Pool ID
DATA #5 : unsigned integer, 2 bytes
19
DATA #6 : String, 20 bytes
Log Record Object ID
DATA #7 : unsigned integer, 2 bytes
11
.............................
2017-04-04-17.01.18.729077-240 I47929761A596        LEVEL:
Severe
PID     : 13631586             TID : 8483           PROC :
db2sysc 0
INSTANCE:                      NODE : 000           DB   :
APPHDL  : 0-8                  APPID: *LOCAL.DB2.170404210059
HOSTNAME:
EDUID   : 8483                 EDUNAME: db2redow (HADRDB) 0
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:1744
MESSAGE : ZRC=0x8402001A=-2080243686=SQLB_EMP_MAP_INFO_END ?EMP
MAP INFO END?
DATA #1 : String, 25 bytes
Error during REDO of LSN:
DATA #2 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes
0000000000341A8C
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 10.5 fp9                                      *
****************************************************************
Local Fix:


Solution




Workaround


****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 10.5 fp9                                      *
****************************************************************


Comment


Upgrade to Db2 10.5 fp9


Timestamps


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

23.02.2020
23.02.2020
23.02.2020


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)