Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC63974 Status: Closed

TRAP IN Sqlak_CallbDrdaInput WHEN IMPORTING XML DATA AND USING THE
COMPOUND OPTION

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
During import of XML data, db2bp.exe crashes with a C000 0005 
exception in db2app.dll. Here is a portion of the Trap (from DB2 
v9.5 FP3a, but problem also occurs in V9.1): 
 
<Trap> 
<Header> 
DB2 build information: DB2 v9.5.301.436 s081210 SQL09053 
timestamp: 2009-03-17-10.29.10.229000 
uname: S:Windows 
comment: WR21427 
process id: 5500 
thread id: 5260 
</Header> 
<SystemInformation> 
Number of Processors: 2 
Processor Type: x86 Family 6 Model 15 Stepping 6 
OS Version: Microsoft Windows XP, Service Pack 2 (5.1) 
Current Build: 2600 
</SystemInformation> 
<MemoryInformation> 
<Usage> 
Physical Memory:    3326 total,    1809 free. 
Virtual Memory :    2047 total,    1953 free. 
Paging File    :    5210 total,    3380 free. 
Ext. Virtual   :       0 free. 
</Usage> 
</MemoryInformation> 
<SignalDetails> 
Exception C0000005 Occurred 
Exception Address = 6C012A33 
Other Unknown access fault 
</SignalDetails> 
<Registers> 
GS  : 0000     FS  : 003B     ES  : 0023     DS  : 0023 
EDI : 036F3410 ESI : 01C60370 EAX : DB2CAFE8 EBX : 01C6E484 
ECX : DB2CAFE8 EDX : 036F3CE0 
EBP : 0012DFBC EIP : 6C012A33 EFLG: 00010286 ESP : 0012DF18 
CS  : 001B     SS  : 0023 
</Registers> 
<POFDisassembly> 
<![CDATA[ 
Failing instruction at 6C012A33 offset: 000008A7 in 
<?sqlak_callbDrdaInput@@YAHPAUdb2UCinterface@@@Z> <NotFound:-1> 
0x6C012A13 ADD          EAX,EDI 
0x6C012A15 MOV          ECX,DWORD PTR [EBP-18H] 
0x6C012A18 IMUL         ECX,+2CH 
0x6C012A1B LEA          EAX,DWORD PTR [EAX+ECX+10H] 
0x6C012A1F MOV          ECX,DWORD PTR [EAX+8] 
0x6C012A22 TEST         ECX,ECX 
0x6C012A24 JZ           6C012B83H 
0x6C012A2A MOV          EDX,DWORD PTR [EDX+4] 
0x6C012A2D MOV          DWORD PTR [ESI+20H],EDX 
0x6C012A30 MOV          EAX,DWORD PTR [EAX+8] 
0x6C012A33 MOV          EAX,DWORD PTR [EAX] 
<<<< 
0x6C012A35 MOV          DWORD PTR [ESI+34H],EAX 
0x6C012A38 TEST         EAX,EAX 
0x6C012A3A JL           6C432FC2H 
0x6C012A40 MOV          DWORD PTR [EBP-58H],EAX 
0x6C012A43 TEST         EAX,EAX 
0x6C012A45 JZ           6C432FA6H 
0x6C012A4B MOV          EAX,DWORD PTR [ESI+8] 
0x6C012A4E MOV          EDX,DWORD PTR [ESI+1CH] 
0x6C012A51 MOV          DWORD PTR [EBP],EDI 
]]></POFDisassembly> 
<StackTrace> 
<![CDATA[ 
--EBP------EIP------ARGS----------------------------- 
0012DFBC 6C012A33 01C614B8 01C825A0 00002113 01C825A0 offset: 
000008A7 in <?sqlak_callbDrdaInput@@YAHPAUdb2UCinterface@@@Z> 
<NotFound:-1> 
0012E058 6C12567A 01C614B8 00000000 036F3420 00000009 offset: 
000003A6 in <?sqljrGenSqlDta@@YAHPAUdb2UCinterface@@I@Z> 
<sqljrbni.C:662> 
0012E090 6C109FCF 01C614B8 00000000 5C617461 6C697455 offset: 
000000D5 in 
<?sqljrDrdaArExecute@@YAHPAUdb2UCinterface@@PAUUCstpInfo@@@Z> 
<sqljrintrfc.C:2715> 
0012E46C 6C002C15 00000026 00000000 00000000 00000000 offset: 
000006E1 in <_sqlacall@20> <sqlakmain.C:4311> 
0012E51C 6C2D380A 0012F390 1C080007 00000004 0012FA18 offset: 
000039C2 in 
<?sqluimpm@@YAXPAHPAUsqluecb@@PAUsqlca@@EPAPAEPAUSQLO_MEM_POOL@@ 
000PAUdb2ImportOut@@@Z> <sqluimpm.SQC:5966> 
0012FB74 6C2D1F18 6C68D590 01C90060 0053C5DC 00000033 offset: 
000020D0 in 
<?sqluimpm@@YAXPAHPAUsqluecb@@PAUsqlca@@EPAPAEPAUSQLO_MEM_POOL@@ 
000PAUdb2ImportOut@@@Z> <sqluimpm.SQC:4320> 
0012FC80 6C2FB74C 00000000 0053E74C 0055E648 0053C7A8 offset: 
00000374 in 
<?sqluimpt@@YAXPAD0PAUsqlu_media_list@@PAUsqldcol@@PAUsqllob@@0P 
AUsqlchar@@0HPAUdb2ImportIn@@PAUdb2ImportOut@@PAH1PAXPAUsqlca@@@ 
Z> <sqluimpt.C:787> 
0012FD30 6C2D8D0D 008A18BC 0012FD4C 0053C5DC 0053C7A0 offset: 
00000247 in <_db2Import.@12> <sqluapi.C:1875> 
0012FD88 0041F3B2 00000000 0288DBCC 0012FDB0 6CFC012A offset: 
000000EA in <?clpbp_exe_sqluimpt@@YAHXZ> <clpbcmd1.C:19790> 
0012FF08 004764D6 0012FF68 0012FF7C 0012FF7C 00475FFF offset: 
0000049A in <?clp_bp_con@@YAHXZ> <clpbp.C:1071> 
0012FF68 00475FFF 005BC3B8 00000000 005BC3C8 00000000 offset: 
000001CF in <_main> <clpbp.C:413> 
0012FFC0 0052AC16 0000000D 3242445C 7FFD7000 8054A6ED offset: 
0000010F in <__tmainCRTStartup> 
<f:\qfe\vctools\crt_bld\self_x86\crt\src\crtexe.c:597> 
0012FFF0 7C816FD7 0052AD5F 00000000 78746341 00000020 
]]></StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of IMPORT on a table containing XML data               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 1                               * 
****************************************************************
Local Fix:
Work Around: Remove the COMPOUND option from the IMPORT 
statement
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem fixed in DB2 V9.7 Fix Pack 1
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.10.2009
23.02.2010
23.02.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP1
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList