Toad World® Forums

Toad for IBM Db2 - z/OS can't connect to subsystem


#1

Using full trial version of software.

Unable to connect to Db2 subsystem. Connections imported on startup and can connect via CLP.

Go to Connection screen, select database, provide logon id and password, click “CONNECT”

  • screen flickers and nothing happens.

Found log entry -

New exception: 1/28/2019 3:34:53 PM

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()_

I have 2 Db2 clients installed - v10.1 and v10.5. Wondering if that is causing an issue.

Thanks in Advance


#2

What Windows OS version are you on?
IBM originally had some issues with their DB2 clients on Windows 10 - so if you are on that OS, I would suggest getting their latest v11.1 DB2 client.


#3

Thanks!!! v11.1 client works like a charm.