IBM Support

IZ36683: DB2 CAN CRASH WHEN THIRD-PARTY DRDA CLIENT CONNECTS TO DB2 AND USES IPV6 ADDRESS FORMAT OF THE CORRELATION TOKEN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The DB2 can crash when third-party DRDA client connects to the
    DB2 and uses IPV6 address format of the correlation token.  The
    problem has been reported when DataDirect JDBC driver 3.7.32 was
    used.  The DB2 crashes due to memory corruption, callstack may
    look like this:
    
    ------Function + Offset------
    sqlpResetXidInTEntry__FP11SQLP_TENTRY + 0x40
    @62@setupForNextUOW__FP20sqle_agent_privatecbP8SQLP_ACBP11SQLP_T
    ENTRY+0x1
    sqlpEndUowRuntime__FP20sqle_agent_privatecbP9SQLP_DBCB + 0x90
    sqlpxcm1__FP20sqle_agent_privatecbP13sqlxaCallInfoi + 0x8C
    sqlrrcom_dps__FP8sqlrr_cbiT2P13sqlxaCallInfo + 0x114
    sqlrrcom__FP8sqlrr_cbiT2 + 0x328
    sqlrr_appl_init__FP20sqle_agent_privatecbP5sqlcai + 0x58
    sqlesrsu__FP7sqlebwaP13sqle_agent_cbcT3P5sqlcaPc + 0xA3C
    sqlelost__FP14db2UCinterface + 0x400
    sqleUCengnInit__FP14db2UCinterfaceUs + 0x1AC
    sqleUCagentConnect + 0x2C4
    ...
    
    
    The hint about hitting this APAR is in the db2diag.log. The
    trapping record contains APPID, which is 64 bytes long
    string starting with IPV6 address:
    ----------------------------------------------------------------
    2008-10-16-14.56.31.140290-300 I12585A565 LEVEL: Error
    PID     : 467196           TID  : 1   PROC : db2agent (INFDMN86)
    INSTANCE: db2inst1         NODE : 000 DB   : INFDMN86
    APPHDL  : 0-61             APPID:
    0000:0000:0000:0000:0000:FFFF:ac1c:26be.60418.224186.F9F9F1F0F3F
    AUTHID  : ZTRUCMPD
    FUNCTION: DB2 UDB, base sys utilities,sqleagnt_sigsegvh,probe:10
    MESSAGE : Error in agent servicing application with APPL. NAME:
    DATA #1 : Hexdump, 8 bytes
    0x07800000008ADAA6 : 4A44 4243 3444 4232                JDBC4DB2
    ----------------------------------------------------------------
    

Local fix

  • Use DB2 JDBC driver or older third-party JDBC driver, which
    does not use IPV6 address in the correlation token.
    

Problem summary

  • USERS AFFECTED:
    Users connecting to DB2 using third-party JDBC drivers.
    
    PROBLEM DESCRIPTION:
    The DB2 can crash when third-party DRDA client connects to the
    DB2 and uses IPV6 address format of the correlation token.  The
    problem has been reported when DataDirect JDBC driver 3.7.32 was
    used.  The DB2 crashes due to memory corruption, callstack may
    look like this:
    
    ------Function + Offset------
    sqlpResetXidInTEntry__FP11SQLP_TENTRY + 0x40
    @62@setupForNextUOW__FP20sqle_agent_privatecbP8SQLP_ACBP11SQLP_T
    ENTRY+0x1
    sqlpEndUowRuntime__FP20sqle_agent_privatecbP9SQLP_DBCB + 0x90
    sqlpxcm1__FP20sqle_agent_privatecbP13sqlxaCallInfoi + 0x8C
    sqlrrcom_dps__FP8sqlrr_cbiT2P13sqlxaCallInfo + 0x114
    sqlrrcom__FP8sqlrr_cbiT2 + 0x328
    sqlrr_appl_init__FP20sqle_agent_privatecbP5sqlcai + 0x58
    sqlesrsu__FP7sqlebwaP13sqle_agent_cbcT3P5sqlcaPc + 0xA3C
    sqlelost__FP14db2UCinterface + 0x400
    sqleUCengnInit__FP14db2UCinterfaceUs + 0x1AC
    sqleUCagentConnect + 0x2C4
    ...
    
    PROBLEM SUMMARY:
    As above.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9, FixPak 7 (s090308).
    

Temporary fix

  • Use DB2 JDBC driver or older third-party JDBC driver, which
    does not use IPV6 address in the correlation token.
    

Comments

APAR Information

  • APAR number

    IZ36683

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-05

  • Closed date

    2009-04-15

  • Last modified date

    2009-04-15

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

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

    IZ38874 IZ43290

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 910

Reference #: IZ36683

Modified date: 15 April 2009