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