DB2 - Problembeschreibung
Problem IC73962 | Status: Geschlossen |
IN DPF, LOAD-RESTART FROM CURSOR WITH DATABASE CLAUSE INTO TABLE DEFINED IN SNNG MAY TRAP | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
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 | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
Instead of using Load-RESTART, use Load-TERMINATE instead and then re-execute the original Load-INSERT/REPLACE | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.01.2011 05.07.2011 05.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |