I was not able to connect to the db2 databases using Toad for DB2 6.0

Toad for IBM DB2
1

Hi Team,

I have installed Toad for DB2 Freeware 6.0 in one of our VM windows box and installed db2client and catalogued the databases.

I could see those catalogued databases in Toad for DB2 window but when I was trying to connect I am getting the following error.

Could anyone please help me to check and suggest me what could be the issue.

System.ArgumentOutOfRangeException
Length cannot be less than zero.
Parameter name: length
Stack Trace:
at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn)
at IBM.Data.DB2.DB2Connection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

Exception Information

Exception: System.ArgumentOutOfRangeException
Message : Length cannot be less than zero.
Parameter name: length
Stack Trace:
at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn)
at IBM.Data.DB2.DB2Connection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

NOTE: We are eliminating automatic support case creation by email. Before sending your Support Bundle, ensure your subject line includes an opened CaseID:### or a Service Request ID:###. Without the CaseID or Service Request ID your Support Bundle request will be declined.

The quickest way to open a new service request is through our online Support Portal support.quest.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit support.quest.com/…/contact-technical-support. Post case creation you will continue to have all communication options available including email, phone, or through the Support Portal to manage the lifecycle of your case.

Support Bundle: Toad for DB2 6.0.0.373 Freeware
11/14/2016 12:53:52 PM

System Information

Operating System
Microsoft Windows Server 2012 R2 Datacenter 6.3.9600 AMD64
Manufacturer: Microsoft Corporation
Computer Name: WHSE-WKSTN-DEV
Windows Directory: C:\Windows

Computer System
Computer Manufacturer Name: Microsoft Corporation
Computer Model: Virtual Machine
System Type: x64-based PC
Total Physical Memory: 7,339,572 KB
Domain: WORKGROUP
User Name:

System Processor
Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 63 Stepping 2
CPU Speed: 2.397 GHz

Connection Information

No open connections.

DB2 Client:
DB2 Client Type:

Loaded Assemblies

Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
ActiproSoftware.Docking.WinForms, Version=12.1.302.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.Docking.WinForms\12.1.302.0__c27e062d3c1a4763\ActiproSoftware.Docking.WinForms.dll
ActiproSoftware.Shared.WinForms, Version=12.1.302.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\12.1.302.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll
ActiproSoftware.SyntaxEditor.WinForms, Version=12.1.302.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\12.1.302.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
BouncyCastle.Crypto, Version=1.7.4114.6375, Culture=neutral, PublicKeyToken=0e99375e54769942 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\BouncyCastle.Crypto.dll
CustomMarshalers, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_32\CustomMarshalers\v4.0_4.0.0.0__b03f5f7f11d50a3a\CustomMarshalers.dll
Dell.FastETL, Version=7.2.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.FastETL.dll
Dell.NamedPipeRPC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.NamedPipeRPC.dll
Dell.SecTech, Version=4.3.0.448, Culture=neutral, PublicKeyToken=99d4728064788932 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Dell.SecTech\v4.0_4.3.0.448__99d4728064788932\Dell.SecTech.dll
Dell.ToadCommunication, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.ToadCommunication.dll
Dell.ToadGeneral, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.ToadGeneral.dll
DevExpress.BonusSkins.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.BonusSkins.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.BonusSkins.v13.1.dll
DevExpress.Charts.v13.1.Core, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Charts.v13.1.Core\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.Charts.v13.1.Core.dll
DevExpress.Data.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Data.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.Data.v13.1.dll
DevExpress.Utils.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Utils.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.Utils.v13.1.dll
DevExpress.XtraBars.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraBars.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraBars.v13.1.dll
DevExpress.XtraEditors.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraEditors.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraEditors.v13.1.dll
DevExpress.XtraGrid.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraGrid.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraGrid.v13.1.dll
DevExpress.XtraTreeList.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraTreeList.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraTreeList.v13.1.dll
FastData, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\FastData.dll
IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208 C:\Program Files\IBM\SQLLIB\BIN\netf40_32\IBM.Data.DB2.dll
IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\IBM.Data.DB2.dll
Interop.StdVCL, Version=4.0.0.0, Culture=neutral, PublicKeyToken=298428818506a441 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Interop.StdVCL.dll
ManagedQP5, Version=5.2.5.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\managedqp5.dll
Microsoft.Win32.TaskScheduler, Version=1.9.4.17032, Culture=neutral, PublicKeyToken=0d013ddd5178a2ae C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Microsoft.Win32.TaskScheduler.dll
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_32\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll
PresentationFramework.AeroLite, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.AeroLite\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.AeroLite.dll
Quest.Compare.General.Sys, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.General.Sys.dll
Quest.Compare.General.SysInterfaces, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.General.SysInterfaces.dll
Quest.Compare.Schema.Common.PlInterfaces, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.Schema.Common.PlInterfaces.dll
Quest.Compare.Schema.DB2.DBModel, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.Schema.DB2.DBModel.dll
Quest.Data.DB2.Admin, Version=5.5.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Data.DB2.Admin.dll
Quest.PersistentCache, Version=3.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Quest.PersistentCache.dll
Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Quest.Toad.Interop.AxSHDocVw.dll
Quest.VersionControl, Version=1.1.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Quest.VersionControl.dll
QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\QuestElevation.exe
SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\SHDocVw.dll
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll
System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Design\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Design.dll
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Management.dll
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll
System.Runtime.Remoting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Remoting\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Remoting.dll
System.Runtime.Serialization.Formatters.Soap, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll
System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll
Toad, Version=7.4.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\toad.exe
ToadBlue2014, Version=13.1.5.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadBlue2014.dll
ToadCore, Version=7.4.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadCore.dll
ToadDB2, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\ToadDB2.dll
ToadDB2Provider, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\ToadDB2Provider.dll
ToadDB2Wrapper, Version=5.2.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\ToadDB2Wrapper.dll
ToadGreen2014, Version=13.1.5.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadGreen2014.dll
ToadPlugin, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadPlugin.dll
ToadTan2014, Version=13.1.5.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadTan2014.dll
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationTypes.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35\WindowsBase.dll
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35\WindowsFormsIntegration.dll
QP5, Version=5.270.14245.40037, C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\qp5.dll

Licensing

Freeware

LUW Freeware

2

Hi Team,

Could any one please check and suggest on this error.

Thanks,

Sudheer

3

Sudheer,

What version is your DB2 Server and DB2 Client?

Have you tried connecting to your database through the DB2 Client instead of Toad? If so what message is returned there?

Thanks,
Eric Sheridan

4

As previous posts have asked - supplying additional information will assist in problem determination such as:

  • what version is your DB2 client?

  • do you have multiple DB2 clients installed, If so what is your default?

  • what is the bitness of your default DB2 client (32 or 64)?

  • does Toad see your cataloged connections?

  • can you catalog any additional connections in Toad?

  • can you export and post your windows registry at:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\DB2

and/or

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2

Thanks

5

Hi Jeff,

Please find the required information below.

  1. DB2 Client Version:- V10.1 FP1

  2. Only one db2 client copy was installed.

  3. 64bit client

  4. Toad can automatically see the catalogued connections

  5. can you catalog any additional connections in Toad? --> I haven't tried

  6. Please find the below screen shot for the reference.

On Mon, Nov 28, 2016 at 5:50 PM, Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com wrote:

RE: I was not able to connect to the db2 databases using Toad for DB2 6.0

Reply by Jeff Podlasek
As previous posts have asked - supplying additional information will assist in problem determination such as:

  • what version is your DB2 client?
  • do you have multiple DB2 clients installed, If so what is your default?
  • what is the bitness of your default DB2 client (32 or 64)?
  • does Toad see your cataloged connections?
  • can you catalog any additional connections in Toad?
  • can you export and post your windows registry at:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\DB2

and/or

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2

Thanks

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

--
Thanks & Regards
Sudheer Nadendla
+1 (848) 248-9466

6

Hi Jeff,

Please find the required information below.

  1. DB2 Client Version:- V10.1 FP1

  2. Only one db2 client copy was installed.

  3. 64bit client

  4. Toad can automatically see the catalogued connections

  5. can you catalog any additional connections in Toad? --> I haven’t tried

  6. Please find the below screen shot for the reference.

Inline image 1

7

Adding to the above

I was able to connect to the database through db2 client.

8

Adding to the above

I was able to connect to the database through db2 client.

Please find the latest screen shot for registry variables.

On Tue, Nov 29, 2016 at 11:21 AM, Sudheer Nadendla nadendla.sudheer@gmail.com wrote:

Hi Jeff,

Please find the required information below.

  1. DB2 Client Version:- V10.1 FP1
  1. Only one db2 client copy was installed.
  1. 64bit client
  1. Toad can automatically see the catalogued connections
  1. can you catalog any additional connections in Toad? --> I haven't tried
  1. Please find the below screen shot for the reference.

On Mon, Nov 28, 2016 at 5:50 PM, Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com wrote:

RE: I was not able to connect to the db2 databases using Toad for DB2 6.0

Reply by Jeff Podlasek
As previous posts have asked - supplying additional information will assist in problem determination such as:

  • what version is your DB2 client?
  • do you have multiple DB2 clients installed, If so what is your default?
  • what is the bitness of your default DB2 client (32 or 64)?
  • does Toad see your cataloged connections?
  • can you catalog any additional connections in Toad?
  • can you export and post your windows registry at:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\DB2

and/or

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2

Thanks

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

Thanks & Regards
Sudheer Nadendla
+1 (848) 248-9466

--

--
Thanks & Regards
Sudheer Nadendla
+1 (848) 248-9466

9

Hi Jeff,

If you find time , could you please check the attached information and assist me how to proceed further.

Thanks,

Sudheer

On Tue, Nov 29, 2016 at 11:30 AM, Sudheer Nadendla nadendla.sudheer@gmail.com wrote:

Adding to the above

I was able to connect to the database through db2 client.

Please find the latest screen shot for registry variables.

On Tue, Nov 29, 2016 at 11:21 AM, Sudheer Nadendla nadendla.sudheer@gmail.com wrote:

Hi Jeff,

Please find the required information below.

  1. DB2 Client Version:- V10.1 FP1
  1. Only one db2 client copy was installed.
  1. 64bit client
  1. Toad can automatically see the catalogued connections
  1. can you catalog any additional connections in Toad? --> I haven't tried
  1. Please find the below screen shot for the reference.

On Mon, Nov 28, 2016 at 5:50 PM, Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com wrote:

RE: I was not able to connect to the db2 databases using Toad for DB2 6.0

Reply by Jeff Podlasek
As previous posts have asked - supplying additional information will assist in problem determination such as:

  • what version is your DB2 client?
  • do you have multiple DB2 clients installed, If so what is your default?
  • what is the bitness of your default DB2 client (32 or 64)?
  • does Toad see your cataloged connections?
  • can you catalog any additional connections in Toad?
  • can you export and post your windows registry at:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\DB2

and/or

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2

Thanks

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

Thanks & Regards
Sudheer Nadendla
+1 (848) 248-9466

--

--
Thanks & Regards
Sudheer Nadendla
+1 (848) 248-9466

--
Thanks & Regards
Sudheer Nadendla
+1 (848) 248-9466

10

Can you extract your entire registry key hierarchy from the below point into a file and post it

from:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\DB2

and/or

HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2

11

Was this issue resolved? I pretty much have a similar issue.

I am able to connect to the zOS db2 via command line and not through the toad app.

12

Don't know why but IBM DB2 in recent years not responding as expected. A data base is suppose to be easy to configure and maintained and not no rocket science. Something smelling fishy around DB2

--Beresford

On Wed, Jun 14, 2017 at 10:59 AM dilip.rajamani@gmail.com bounce-diliprajamanigmailcom@toadworld.com wrote:

RE: I was not able to connect to the db2 databases using Toad for DB2 6.0

Reply by dilip.rajamani@gmail.com
Was this issue resolved? I pretty much have a similar issue.

I am able to connect to the zOS db2 via command line and not through the toad app.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

--

null

13

I know I am coming late to the game here, but which version of the db2 driver are you using?

I know that TOAD will only work with the "***I*BM Data Server Runtime Client" driver. I know this cause I spent A LOT of time researching this topic.

Here is the link to the driver download:

http://www-01.ibm.com/support/docview.wss?uid=swg21385217

It basically is because the IBM catalogs got changed in the latest version of the driver.

Give that driver a try instead and it should work!

14

I am using 11.1 etcetera running some test and comparing Oracle with variable Windows version on the fly. Hate to build a working database only to come and find it gone.

On Wed, Jun 14, 2017 at 12:05 PM Db2Developer bounce-Db2Developer@toadworld.com wrote:

RE: I was not able to connect to the db2 databases using Toad for DB2 6.0

Reply by Db2Developer
I know I am coming late to the game here, but which version of the db2 driver are you using?

I know that TOAD will only work with the "IBM Data Server Runtime Client*"* driver. I know this cause I spent A LOT of time researching this topic.

Here is the link to the driver download:

http://www-01.ibm.com/support/docview.wss?uid=swg21385217

It basically is because the IBM catalogs got changed in the latest version of the driver.

Give that driver a try instead and it should work!

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

--

null

15

I tried installing the latest runtime client and that shows licensing errors. It was working good until I installed a local express C and had to remove it because I was having issues (license errors).

16

We are in the same boat; a Java and windows 10 clash

On Wed, Jun 14, 2017 at 3:03 PM dilip.rajamani@gmail.com bounce-diliprajamanigmailcom@toadworld.com wrote:

RE: I was not able to connect to the db2 databases using Toad for DB2 6.0

Reply by dilip.rajamani@gmail.com
I tried installing the latest runtime client and that shows licensing errors. It was working good until I installed a local express C and had to remove it because I was having issues (license errors).

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

--

null