DB2 - Problem description
Problem IC99147 | Status: Closed |
DB2 DRIVER/CLIENT MAY TRAP FOR APPLICATIONS USING THE WORKLOAD BALANCING (WLB) FEATURE. | |
product: | |
DB2 CONNECT / DB2CONNCT / A10 - DB2 | |
Problem 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() | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v10.1.4. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Upgrade to v10.1.4. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.02.2014 02.06.2014 02.06.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.4 |