IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

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

Local fix

  • Work Around: Remove the COMPOUND option from the IMPORT
    statement
    

Problem summary

  • Users Affected: Users of DB2 v9.1 or 9.5 importing XML data
    using the COMPOUND option. The problem was seen in a Windows
    environment, but it may affect other Operating Systems.
    
    Problem Description: Exception C0000005 occurs -  an access
    fault in DB2APP.DLL
    

Problem conclusion

  • First fixed in FP5, defect wsdbu00547505
    

Temporary fix

  • Remove the COMPOUND option from the IMPORT statement
    

Comments

APAR Information

  • APAR number

    JR33088

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-20

  • Closed date

    2009-12-22

  • Last modified date

    2009-12-22

  • APAR is sysrouted FROM one or more of the following:

    JR33086

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 December 2009