DB2 - Problem description
Problem IT35936 | Status: Closed |
DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Db2 can trap during an HPU (High Performance Unload) unload job, with the following stack in a trap file: 0x090000000C1173E0 InitializeOneDatapart__20sqluCStorageDatapartFiP8SQLD_TCB + 0x60 0x090000000C121CB8 zFixTCBs__10sqluCTableFP8sqeAgentUsT2PciT4N25 + 0x438 0x090000000C1216E0 zFixTCBwithName__10sqluCTableFP8sqeAgentiPcT2T3T2 + 0x60 0x090000000CF473DC sqluRegisterUnloadStart__FPUcT1P8sqeAgentP12SQLB_GLOBALSP22SQLU_ LOADAPI_UNLOAD_CBiT6PiP15sql_static_dataP5sqlca + 0x1EDC 0x090000000CF44954 sqlu_register_table_unload__FPUcT1iP15sqlu_media_listP13SQLUVLCB _TYPEP15sql_static_dataP5sqlca + 0x854 0x090000000C1626A4 sqluvtun_route_in__FP12SQLE_DB2RA_T + 0x424 0x090000000DC7D580 sqlesrvr__FP14db2UCinterface + 0x1D80 0x090000000DC7AFA8 sqleMappingFnServer__FP5sqldaP5sqlca + 0x6A8 (...) In almost every case, when the same HPU job is submitted again it succeeds. This APAR fix prevents Db2 from trapping, and causes the HPU operation to fail instead. It also records additional diagnostic information, which might aid in understanding the root cause shall the problem recurs again. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.5.5.1 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.02.2021 06.04.2021 06.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |