|
Problem IC73962
|
Status: Closed |
IN DPF, LOAD-RESTART FROM CURSOR WITH DATABASE CLAUSE INTO TABLE DEFINED IN SNNG MAY TRAP |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem 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 |
| Problem Summary: |
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 |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
Instead of using Load-RESTART, use Load-TERMINATE instead and
then re-execute the original Load-INSERT/REPLACE |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.01.2011
05.07.2011
05.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
