A fix is available
APAR status
Closed as program error.
Error description
LOAD of small MDC table may fail during internal operation "purge object pages from bufferpool", in sqlbPurgeOrFlushAllPagesInSmallRange with error SQLB_EMP_MAP_INFO_NOT_FOUND. If this failure occurs during transaction commit time, it may cause DB shutdown and subsequent crash recovery failure. Errors in db2diag.log file point to: 2021-07-18-07.34.21.800184-240 I132233293E567 LEVEL: Error PID : 406232 TID : 46914707908352 PROC : db2sysc 3 INSTANCE: db2inst1 NODE : 003 DB : SAMPLE APPHDL : 1-28840 APPID: xx.xxx.xx.xx.52150.210718113415 AUTHID : DB2INST1 HOSTNAME: MYHOST1 EDUID : 6176 EDUNAME: db2agnta (SAMPLE) 3 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSMapObj2Pool, probe:840 MESSAGE : ZRC=0x8402001B=-2080243685=SQLB_EMP_MAP_INFO_NOT_FOUND "EMP MAP INFO NOT FOUND" 2021-07-18-07.34.21.801096-240 I132233293E567 LEVEL: Error PID : 406232 TID : 46914707908352 PROC : db2sysc 3 INSTANCE: db2inst1 NODE : 003 DB : SAMPLE APPHDL : 1-28840 APPID: xx.xxx.xx.xx.52150.210718113415 AUTHID : DB2INST1 HOSTNAME: MYHOST1 EDUID : 6176 EDUNAME: db2agnta (SAMPLE) 3 FUNCTION: DB2 UDB, buffer pool services, sqlbPurgeOrFlushAllPagesInSmallRange, probe:8940 MESSAGE : ZRC=0x8402001B=-2080243685=SQLB_EMP_MAP_INFO_NOT_FOUND "EMP MAP INFO NOT FOUND" DATA #1 : String, 38 bytes Error mapping object page to pool page ... CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002AAAAD281EA2 _Z36sqlbPurgeOrFlushAllPagesInSmallRangeP16SQLB_OBJECT_DESCP22SQ LB_OBJECT_PAGE_RANGEjjP12SQLB_GLOBALS + 0x18F2 [1] 0x00002AAAAD27FFDA _Z20sqlbPurgeObjectLocalP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSj + 0x62A [2] 0x00002AAAAD27EEBD _Z15sqlbPurgeObjectP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSjb + 0x41D [3] 0x00002AAAB3E4C4F2 _Z15sqluPurgeObjectP16SQLB_OBJECT_DESCjP10sqluCTableP16SQLU_GROU P_PURGEj + 0x242 [4] 0x00002AAAB3EC007D _Z22sqluCheckObjectForRedoP8sqeAgentP9SQLP_LSN8P11SQLB_OBJECTS2_ PiS5_PbS5_iiib + 0x3DD [5] 0x00002AAAB3EC61C5 /var/ibmdb2/nypxt150/sqllib/lib64/libdb2e.so.1 + 0x8A541C5 [6] 0x00002AAAB3EBE035 _Z30sqlu_process_pending_operationP8sqeAgentiPcP9SQLP_LSN8P12SQL P_PENLISTPjP15SQLD_RECOV_INFO + 0x545 [7] 0x00002AAAB2A12935 _Z8sqlptpplP8sqeAgentiPb + 0x425 [8] 0x00002AAAB29F7EB0 _Z8sqlpxcm2P8sqeAgentjP15SQLXA_CALL_INFOiP8SQLP_VTSP9SQLP_GXID + 0xA20 [9] 0x00002AAAB2FDCC27 _Z17sqlrr_tran_routerP8sqlrr_cb + 0x1327 [10] 0x00002AAAB2FAD572 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x962 [11] 0x00002AAAB0A87546 /var/ibmdb2/nypxt150/sqllib/lib64/libdb2e.so.1 + 0x5615546 [12] 0x00002AAAB0A85DE0 _Z21sqleProcessSubRequestP8sqeAgent + 0x3E0 [13] 0x00002AAAB0ABB057 _ZN8sqeAgent6RunEDUEv + 0x5D7 [14] 0x00002AAAB43F4F5E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [15] 0x00002AAAB2912A6A sqloEDUEntry + 0x57A [16] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1 [17] 0x00002AAABB469C4D clone + 0x6D the above example occurs during transaction commit time. If it occurs during crash recovery, we get similar message from db2redom, with call stack CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002AAAAD281EA2 _Z36sqlbPurgeOrFlushAllPagesInSmallRangeP16SQLB_OBJECT_DESCP22SQ LB_OBJECT_PAGE_RANGEjjP12SQLB_GLOBALS + 0x18F2 [1] 0x00002AAAAD27FFDA _Z20sqlbPurgeObjectLocalP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSj + 0x62A [2] 0x00002AAAAD27EEBD _Z15sqlbPurgeObjectP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSjb + 0x41D [3] 0x00002AAAB3E4C4F2 _Z15sqluPurgeObjectP16SQLB_OBJECT_DESCjP10sqluCTableP16SQLU_GROU P_PURGEj + 0x242 [4] 0x00002AAAB3EC007D _Z22sqluCheckObjectForRedoP8sqeAgentP9SQLP_LSN8P11SQLB_OBJECTS2_ PiS5_PbS5_iiib + 0x3DD [5] 0x00002AAAB3EC61C5 /var/ibmdb2/nypxt150/sqllib/lib64/libdb2e.so.1 + 0x8A541C5 [6] 0x00002AAAB3EBE035 _Z30sqlu_process_pending_operationP8sqeAgentiPcP9SQLP_LSN8P12SQL P_PENLISTPjP15SQLD_RECOV_INFO + 0x545 [7] 0x00002AAAB2A12935 _Z8sqlptpplP8sqeAgentiPb + 0x425 [8] 0x00002AAAB2C34F73 _Z10sqlpRFWpplP8sqeAgentP9SQLP_DBCBP11SQLP_TENTRYP10SQLP_FRAPPP1 0SQLP_FRSCBP9SQLP_LSN8 + 0x53 [9] 0x00002AAAB2C3118F _Z13sqlpRecDbRedoP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcbP10SQLP_FR APPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0xA1F [10] 0x00002AAAB2C263C1 _Z15sqlprProcDPSrecP10SQLPR_PRCBjP20SQLPR_PR_QUEUE_ENTRY + 0x271 [11] 0x00002AAAB2C1F233 _Z15sqlpPRecReadLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 0x773 [12] 0x00002AAAB2BECC76 _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca + 0xCA6 [13] 0x00002AAAB0A9E11C _Z26sqleSubCoordProcessRequestP8sqeAgent + 0x17C [14] 0x00002AAAB0ABB02E _ZN8sqeAgent6RunEDUEv + 0x5AE [15] 0x00002AAAB43F4F5E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [16] 0x00002AAAB2912A6A sqloEDUEntry + 0x57A [17] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1 [18] 0x00002AAABB469C4D clone + 0x6D
Local fix
db2set DB2_SQLU_DEBUG=1
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * ****************************************************************
Problem conclusion
Upgrade to 11.1.4.7
Temporary fix
Comments
APAR Information
APAR number
IT37720
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-21
Closed date
2022-04-16
Last modified date
2022-04-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022