IBM Support

IC99090: DB2 DRIVER/CLIENT MAY TRAP FOR APPLICATIONS USING THE WORKLOAD BALANCING (WLB) FEATURE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The workload balancing (WLB) feature is enabled by setting the
    enableWLB parameter to true in db2dsdriver.cfg, DB2
    Driver/Client may trap in function sqljCalcSdaCDTOverridesLen or
    sqljrDrdaArCommit.
    
    The call stack on window may look like as below:
    
    STACK_TEXT:
    00000000`2590d530 00000001`80838821 : 00000000`00000001
    00000000`00000003 00000000`00000004 00000000`2590d818 :
    db2app64!sqljCalcSdaCDTOverridesLen+0x512
    00000000`2590d6a0 00000001`8078a1ed : 00000000`00000000
    00000000`00000000 00000000`00000000 00000000`00000000 :
    db2app64!sqljCalcDscLen+0x179
    00000000`2590d700 00000001`807683d5 : 00000000`250ab9f8
    00000001`00000004 00010001`012322d0 00003728`1abc9a50 :
    db2app64!sqljrGenSqlDta+0x167
    00000000`2590d810 00000001`800e088a : 00000000`00000000
    00000001`800e2e5e 00000000`00000004 00000000`00000001 :
    db2app64!sqljrDrdaArArrayInput+0x2a3
    00000000`2590d8a0 00000001`8018462f : 00000000`1ef759e0
    00000000`250abd58 00000000`000000a0 00000000`250ab9f8 :
    db2app64!CLI_sqlExecute+0xff4
    00000000`2590d9a0 00000001`800a3a29 : 00000000`00151650
    000007fe`f1fb0c2f 00000000`000000f3 00000000`00000000 :
    db2app64!SQLExecute2+0xf03
    00000000`2590dac0 000007fe`92a29d08 : 000007fe`929a2d78
    00000000`00000000 00000000`00000000 00000000`00000000 :
    db2app64!SQLExecDirectADONET+0x1963
    
    .net application reports exception with the following call
    stack:
    Unhandled Exception: System.AccessViolationException: Attempted
    to read or write
     protected memory. This is often an indication that other memory
    is corrupt.
       at
    IBM.Data.DB2.UnsafeNativeMethods.DB232.SQLExecDirectADONET(DB2Ex
    ecDirectPa
    rameters* pParam)
       at IBM.Data.DB2.DB2Command.a(Boolean A_0)
       at IBM.Data.DB2.DB2Command.b()
       at IBM.Data.DB2.DB2Command.ExecuteNonQuery()
    
    OR
    
    STACK_TEXT:
    00000000`1f1bd2e0 00000001`800e5f8a : 000007fe`00000000
    00000000`1b898e9c 000007fe`00000003 00000000`1b898e9c :
    db2app64!sqljrDrdaArCommit+0x34e
    00000000`1f1bd3c0 00000001`801cb963 : 00000000`1ff73f40
    00000000`00000000 00000000`00000000 00000001`800817e5 :
    db2app64!CLI_sqlCommit+0x1da
    00000000`1f1bd480 00000001`801c918d : 0000a924`0a7e86a7
    00000004`00010001 00000000`00000004 00000000`1f1be5b8 :
    db2app64!SQLTransact2+0x181
    00000000`1f1bd540 000007fe`92918b96 : 00000000`028d0002
    00000000`00000017 00000000`00000000 00000000`00000000 :
    db2app64!SQLEndTran+0x367
    
    .net application reports exception with the following call
    stack:
    Unhandled Exception: System.AccessViolationException: Attempted
    to read or write
     protected memory. This is often an indication that other memory
    is corrupt.
       at IBM.Data.DB2.UnsafeNativeMethods.DB232.SQLEndTran(Int16
    HandleType, IntPtr
     Handle, Int16 CompletionType)
       at IBM.Data.DB2.DB2Transaction.Commit()
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Client/Driver                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7.10                                           *
    ****************************************************************
    

Problem conclusion

  • Upgrade to v9.7.10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC99090

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-30

  • Closed date

    2014-11-11

  • Last modified date

    2014-11-11

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

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

    IC99147 IC99151

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"9.7","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 June 2020