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) |