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