IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022