triple-clicking on button execute explain-plan statement:


********************************************************************************

Exception Information
********************************************************************************

Exception: System.InvalidOperationException
Message : Collection was modified; enumeration operation may not execute.
Stack Trace:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate
method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.Control.Invoke(Delegate method)
at Quest.Toad.ExplainPlan.ExplainPlanControl.DoExplain()

********************************************************************************

Application Information
********************************************************************************

29.05.2006 16:39:03
Support Bundle for Toad for DB2 Beta 2.0
Toad, Version=2.0.0.465, Culture=neutral, PublicKeyToken=c862883b2ae69822
C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\Toad.exe
Referenced Assemblies:
DevExpress.BonusSkins.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=95fc6c5621878f0a
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
ToadCore, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822

Loaded Plugins:
ToadControls, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for
DB2 Beta 2.0\ToadControls.dll
Referenced Assemblies:
DevExpress.Utils.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Design, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089

ToadCore, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for
DB2 Beta 2.0\ToadCore.dll
Referenced Assemblies:
ActiproSoftware.Shared.Net20, Version=1.0.80.0, Culture=neutral,
PublicKeyToken=36ff2196ab5654b9
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral,
PublicKeyToken=0ecd8d0e8818ec9b
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.70.0, Culture=neutral,
PublicKeyToken=be939c973e8cb8a6
ActiproSoftware.WinUICore.Net20, Version=1.0.80.0, Culture=neutral,
PublicKeyToken=1eba893a2bc55de5
DevExpress.Data.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.Utils.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraBars.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraGrid.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraNavBar.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraPivotGrid.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraPrinting.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraReports.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraTreeList.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
FlexCel, Version=3.7.0.2, Culture=neutral,
PublicKeyToken=3b4004b85c62843e
ManagedQP5, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
Quest.Modeler.Drawing, Version=1.0.9.80, Culture=neutral,
PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.AxQExplain2, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral,
PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.FmtOptCom, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=c862883b2ae69822
Quest.Toad.Interop.KXpert, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=c862883b2ae69822
SharpZLib, Version=0.84.0.0, Culture=neutral,
PublicKeyToken=1b03e6acf1164f73
SHDocVw, Version=1.1.0.0, Culture=neutral,
PublicKeyToken=c862883b2ae69822
System, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Configuration, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Design, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Drawing, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Management, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Runtime.Serialization.Formatters.Soap, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.ServiceProcess, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Xml, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Xml, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
ToadControls, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822

ToadDB2, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for
DB2 Beta 2.0\Plugins\DB2\ToadDB2.dll
Referenced Assemblies:
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral,
PublicKeyToken=0ecd8d0e8818ec9b
DB2Classes, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
DevExpress.Data.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.Utils.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraBars.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraGrid.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraTreeList.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraVerticalGrid.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
IBM.Data.DB2.9.1.0, Version=9.1.0.2, Culture=neutral,
PublicKeyToken=7c307b91aa13d208
ManagedQP5, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
Quest.Compare.General.Sys, Version=2.0.12.30241, Culture=neutral,
PublicKeyToken=c862883b2ae69822
Quest.Compare.General.SysInterfaces, Version=2.0.11.30241,
Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Compare.Schema.Common.Pl, Version=2.0.37.30242, Culture=neutral,
PublicKeyToken=c862883b2ae69822
Quest.Compare.Schema.Common.PlInterfaces, Version=2.0.37.30242,
Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Compare.Schema.DB2.DBModel, Version=2.0.32.30243,
Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Compare.Schema.DB2.Scripter, Version=1.0.52.30248,
Culture=neutral, PublicKeyToken=c862883b2ae69822
Quest.Data.DB2.Admin, Version=1.0.0.25377, Culture=neutral,
PublicKeyToken=c862883b2ae69822
System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Xml, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
ToadControls, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
ToadCore, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
ToadDB2Provider, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822

ToadDB2Provider, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for
DB2 Beta 2.0\Plugins\DB2\ToadDB2Provider.dll
Referenced Assemblies:
DB2Classes, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
DevExpress.Utils.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors.v6.1, Version=6.1.3.0, Culture=neutral,
PublicKeyToken=79868b8147b5eae4
Interop.DB2ExplainComObjectPjt, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=c862883b2ae69822
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a
System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
System.Xml, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089
ToadControls, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822
ToadCore, Version=2.0.0.465, Culture=neutral,
PublicKeyToken=c862883b2ae69822

********************************************************************************

System Information
********************************************************************************

Operating System
Microsoft Windows XP Professional 5.1.2600
Manufacturer: Microsoft Corporation
Computer Name: CHR53455
Windows Directory: C:\WINNT
Serial Number: 55274-640-0456051-23821

Computer System
Computer Manufacturer Name: IBM
Computer Model: 81713FG
System Type: X86-based PC
Total Physical Memory: 514,540 KB
Domain: corp.gwpnet.com
User Name: CORP\srzsmy

System Processor
Manufacturer: GenuineIntel
Computer Processor: x86 Family 15 Model 4 Stepping 1
CPU Speed: 3.192 GHz
L2 Cache Size: Unknown
Manufacturer: GenuineIntel
Computer Processor: x86 Family 15 Model 4 Stepping 1
CPU Speed: 3.192 GHz
L2 Cache Size: Unknown

System Bios
BIOS: Phoenix FirstBios(tm) Desktop Pro Version 2.0 for IBM ThinkCentre.
BIOS Version: PTLTD - 60400d0

System Time Zone
Time Zone: (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna

Logical Memory Configuration
Total Page File Space: 2,007,976 KB
Total Virtual Memory: 2,522,516 KB
Total Physical Memory: 514,540 KB

Video Controller
Name: Intel(R) 82915G/GV/910GL Express Chipset Family
Processor: Intel(R) 82915G/GV/910GL Express Chipset
Mode: 1280 x 1024 x 4294967296 colors
Video Ram: 131,072 KB
PNP Device ID:
PCI\VEN_8086&DEV_2582&SUBSYS_02D91014&REV_04\3&61AAA01&0&10
Status: OK

Environment Variables
HOMEPATH = \WINNT\Profiles\srzsmy
LSRV = CHRS0071
COMPUTERNAME = CHR53455
SystemRoot = C:\WINNT
USERDNSDOMAIN = CORP.GWPNET.COM
DB2INSTANCE = TOADDB2
DSRV = CHRS0062
PROCESSOR_IDENTIFIER = x86 Family 15 Model 4 Stepping 1, GenuineIntel
DB2PATH = C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client
TMP = C:\WINNT\Profiles\srzsmy\LOCALS~1\Temp
HOME = |HOME|
CLASSPATH = C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client\bin;C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client\bin.;C:\oracle\ora92\sqlj\lib\runtime12.jar;C:\oracle\ora92\sqlj\lib\tran\
slator.jar;C:\oracle\ora92\sqlj\lib\classes12.jar

IDate = 25.04.2006
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
ISHR = CID
SESSIONNAME = Console
Country = Switzerland
IVE_DIR = C:\Program Files\Visual Explain
CVS_HOME = C:\SRDEV\tool\cvs\cvs
PROCESSOR_REVISION = 0401
NAPW = NO
ComputerType = Desktop
include = C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client\INCLUDE;c:\cicscli\Include;c:\cicscli\Samples\Include
Office = R1051
JAVA_HOME = C:\SRDEV\sdk\j2sdk1.4.2_03
Company = Swiss Re
DECLIPSE_HOME = C:\SRDEV\ide\eclipse_2_1_0
Path = C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client\BIN;C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client\FUNCTION;c:\cicscli\BIN;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem\
;C:\Program
Files\SRAPPL;C:\oracle\ora92\bin\;C:\Program Files\Oracle\jre\1.1.8
\bin\;C:\oracle\ora92\sqlj\bin\;C:\Program Files\Oracle\jre\1.3.1
\bin\;C:\SRDEV\tool\cvs\cvs\;c:\Program
Files\F-Secure\Ssh\Program;C:\Program Files\IBM\Personal
Communications\;C:\Program Files\IBM\Trace
Facility\;C:\WINNT\system32;C:\WINNT\;C:\WINNT\System32\Wbem;C:\Program
Files\Quest Software\Toad for DB2 Beta 2.0\DB2 Client\REPL;C:\Program
Files\Visual Explain\lib
PROCESSOR_LEVEL = 15
NUMBER_OF_PROCESSORS = 2
lib = C:\Program Files\Quest Software\Toad for DB2 Beta 2.0\DB2
Client\LIB;c:\cicscli\Lib
PROMPT = $P$G
WF_RESOURCES = C:\oracle\ora92\wf\RES\WFUS.RES
CommonProgramFiles = C:\Program Files\Common Files
DECLIPSE_JDK = %DJDK141%
CERT = 0
DJDK14 = C:\SRDEV\sdk\j2sdk1.4.2_03
ProgramFiles = C:\Program Files
USERPROFILE = C:\WINNT\Profiles\srzsmy
FP_NO_HOST_CHECK = NO
DB2TEMPDIR = C:\SQLLIB\
ALLUSERSPROFILE = C:\WINNT\Profiles\All Users
IDOM = CORP.GWPNET.COM
Location = Zurich
SetupControl = 3
DCVS = C:\SRDEV\tool\cvs\
LOCPATH = V:\ALGCO\LOCALE
LOGONSERVER = \\CHRS0007
WSComment = R1051, srzmdl, IBM ThinkCentre S51
ComputerModel = IBM ThinkCentre S51
APPDATA = C:\WINNT\Profiles\srzsmy\Application Data
HOMEDRIVE = C:
DJDK142 = C:\SRDEV\sdk\j2sdk1.4.2_03
TEMP = C:\WINNT\Profiles\srzsmy\LOCALS~1\Temp
USERNAME = srzsmy
PCOMM_Root = C:\Program Files\IBM\Personal Communications\
PROCESSOR_ARCHITECTURE = x86
USERDOMAIN = CORP
OS = Windows_NT
ComSpec = C:\WINNT\system32\cmd.exe
SystemDrive = C:
windir = C:\WINNT
ISRV = CHRS0062
MSOffice = MS Office XP

********************************************************************************

Connection Information
********************************************************************************

Current Connection:
DSRZDB2I (srzsmy), DSRZDB2I
DB2 database
Server version 8.1.5
Connected since 29.05.2006 16:31:23
0 of 2 connections in pool active




Petr Smely



Global Infrastructure hotline: +41 43 285 94 84
(service hours)
Services
CCIIGZ/DS - GIS Data
Services
~ where your data feels @
home ~

website: Data Services Homepage

email: DB2 Admin
Oracle Admin
MSSQL Admin






(See attached file: ToadSupportBundle.zip)



This e-mail, including attachments, is intended for the person(s) or
company named and may contain confidential and/or legally privileged
information. Unauthorized disclosure, copying or use of this information
may be unlawful and is prohibited. If you are not the intended recipient,
please delete this message and notify the sender