IBM Support

IT26773: DB2 TRAPS DUE TO DATASTAGE PASSES NON-NULL PIOUTPUTNODES BUT INUMNODES=0 WHEN CALLING DB2LOAD()

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Db2 generates FODC_Trap when Datstage job calls db2Load() API
    and Datastage passes non-NULL piOutputNodes but iNumNodes=0;
    The following is an example of stack dump for db2agent EDU:
    <StackTrace>
    -----Frame------ ------Address----- ------Function +
    Offset------
    0x0000100025BEB1A0 0x000010000F52C024
    _Z25sqluConvertTripletsToTextP8sqeAgentP12SQLE_DB2RA_T + 0x0a64
      ( = offset 0xF1FC024 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEB2C0 0x000010000F2523D0
    _Z17sqluvtld_route_inP12SQLE_DB2RA_T + 0x3b40
      ( = offset 0xEF223D0 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEB970 0x000010000AE54898
    _Z8sqlesrvrP14db2UCinterface + 0x1b98
      ( = offset 0xAB24898 in
    home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEBE90 0x000010000AED9DE8
    _Z19sqleMappingFnServerP5sqldaP5sqlca + 0x0688
      ( = offset 0xABA9DE8 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEC280 0x000010000B3AEADC
    _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent
    P5sqlca + 0x07bc
      ( = offset 0xB07EADC in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEC8D0 0x000010000B3B1994
    _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x0c64
      ( = offset 0xB081994 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BED280 0x000010000B8508D4
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
    0x0594
      ( = offset 0xB5208D4 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BED530 0x000010000B7F09C4
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x02f4
      ( = offset 0xB4C09C4 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BED650 0x000010000B7F1C44
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x0404
      ( = offset 0xB4C1C44 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BED940 0x000010000B7D2008
      ( = offset 0xB4A2008 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEDDD0 0x000010000B7CA698
      ( = offset 0xB49A698 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEDE50 0x000010000B7C8B80
      ( = offset 0xB498B80 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEE110 0x000010000B7C5F34
    _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x0254
      ( = offset 0xB495F34 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEE200 0x000010000AEEF300 _ZN8sqeAgent6RunEDUEv +
    0x0b60
      ( = offset 0xABBF300 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEE3D0 0x000010000FBE8B74 _ZN9sqzEDUObj9EDUDriverEv
    + 0x0344
      ( = offset 0xF8B8B74 in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEE440 0x000010000FBE880C _Z10sqlzRunEDUPcj + 0x001c
      ( = offset 0xF8B880C in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEE460 0x000010000D9CE35C sqloEDUEntry + 0x034c
      ( = offset 0xD69E35C in
    /home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100025BEE790 0x0000100000088AF4
      ( = offset 0x8AF4 in /lib64/libpthread.so.0)
    0x0000100025BEEA10 0x00001000161B4EF4 clone + 0x00e4
      ( = offset 0x124EF4 in /lib64/libc.so.6)
    </StackTrace>
    
    
    This APAR will add robust error handling in this scenario.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26773

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-28

  • Closed date

    2020-01-20

  • Last modified date

    2020-01-20

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       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":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2020