DB2 CONNECT / DB2CONNCT / 970 - DB2

IBM.Data.DB2 can throw a System.IndexOutOfRangeException or 
System.InvalidOperationException when establishing a high # of 
connections at once with a high # of threads running in 
parallel. 
 
System.InvalidOperationException Stack: 
 
EX_1: Thread 26  Collection was modified; enumeration operation 
may not execute. 
 
   at 
System.Collections.ArrayList.ArrayListEnumeratorSimple.MoveNext( 
) 
   at 
System.Data.Common.DbConnectionStringBuilder.get_ConnectionStrin 
g() 
   at IBM.Data.DB2.DB2Permission.Add(String connectionString, 
String restrictions, KeyRestrictionBehavior behavior) 
   at IBM.Data.DB2.DB2Connection.Open() 
   at TransHang.SysSelect(Int32 threadn, String txtype) 
 
System.IndexOutOfRangeException Stack: 
 
EX_1: Thread 27  Index was outside the bounds of the array. 
   at 
System.Collections.ArrayList.ArrayListEnumeratorSimple.MoveNext( 
) 
   at 
System.Data.Common.DbConnectionStringBuilder.get_ConnectionStrin 
g() 
   at IBM.Data.DB2.DB2Permission.Add(String connectionString, 
String restrictions, KeyRestrictionBehavior behavior) 
   at IBM.Data.DB2.DB2Connection.Open() 
   at TransHang.SysSelect(Int32 threadn, String txtype)

**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows users using MSDTC                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.7 FP 7 or greater                               * 
****************************************************************

You may set "SkipSynonymProcessing" connection 
string/db2dsdriver.cfg keyword to "true". The same can be 
achieved by setting 
"DB2ConnectionStringBuilder.SkipSynonymProcessing=true", if you 
use DB2ConnectionStringBuilder class to build the connection 
string.

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 Version 9.7 Fix Pack 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC88622 IT00978 IT00979 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.04.2012
30.10.2012
30.10.2012

9.7.FP7