Fixes are available
APAR status
Closed as fixed if next.
Error description
In a DPF environment, if a table resides in a tablespace that belongs to a single-dbpartition-dbpartitiongroup, and the table contains a Unique Index, and Load is invoked into this table and fails in the DELETE phase (ie. this might happen if log space is exhausted while the DELETE phase is removing duplicate records), and a Load-RESTART is invoked, then a seg-fault could occur and bring the instance down. Stack trace would contain sqlusCUserExitSubAgent::iRun() module at top <StackTrace> -------Frame------ ------Function + Offset------ 0x0900000005C88ED8 iRun__22sqlusCUserExitSubAgentFv + 0x570 0x090000000560E478 sqlusSubAgentRouter__FP20sqle_agent_privatecbi + 0x630 0x09000000056090B0 sqleSubRequestRouter__FP13sqle_agent_cbPUiT2 + 0x7E4 0x090000000569FBC4 sqleProcessSubRequest__FP13sqle_agent_cb + 0x22C 0x0900000004E9FBC0 sqleRunAgent__FPcUi + 0x920 0x09000000047B3E8C sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x25C 0x09000000047B0364 sqloSpawnEDU + 0x230
Local fix
Instead of using Load-RESTART, use Load-TERMINATE instead and then re-execute the original Load-INSERT/REPLACE
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * IN DPF, LOAD-RESTART FROM CURSOR WITH DATABASE CLAUSE INTO * * TABLE * * DEFINED IN SNNG MAY TRAP * **************************************************************** * RECOMMENDATION: * * Upgrade to fixpak that includes this APAR fix. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
LI75820
Reported component name
DB2 UDB ESE LIN
Reported component ID
5765F4106
Reported release
910
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-21
Closed date
2012-02-13
Last modified date
2012-02-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R910 PSY
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":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021