Toad World® Forums

Toad error to SQL Optimizer window.


#1

I use Toad for DB2 LUW 6.3. While I have SQL query on the SQL Edit and when I click on mouse over which says “Optimize the current statement” It give away the following error then a pop-up windows comes in with user id , password and Database Alias. The connect button is freeze and while I click on Close open up the “Quest SQL Optimizer for IBM DB2 LUW 4.3”

May I know what am I doing wrong here ?

[IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: “DBNAME”.


#2

Hi Glenn,

I can’t reproduce this error. Would you please download latest v4.3.1 version SQL Optimizer for DB2 LUW and try again?

Regards,

Ken


#3

Ok I wish to know how to connect to the database. The query optimizer from Toad 6.5 is opening the version – 4.3. However I’m not able to connect to the database.

The clicking on Connect I get the following error.

Failed to connect to database.

[IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: “CMSDB”.

Glenn

Gopalan Venkatramani | DB Administrator

Allegiant Travel Company

1201 N. Town Center Drive, Las Vegas, NV 89144

Direct # +1 702 830 8712 Cell # +1 908 205 7691

Glenn.Venkatramani@allegiantair.com
|www.allegiant.com

From: ken.tai@quest.com [mailto:bounce-kentaiquestcom@toadworld.com]

Sent: Monday, May 07, 2018 2:44 AM

To: toaddb2@toadworld.com

Subject: RE: [Toad for IBM DB2 - Discussion Forum] Toad error to SQL Optimizer window.

RE: Toad error to SQL Optimizer window.

Reply by ken.tai@quest.com

Hi Glenn,

I can’t reproduce this error. Would you please download latest v4.3.1 version SQL Optimizer for DB2 LUW and try again?

Regards,

Ken

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.


#4

Hi Glenn,

SQL Optimizer use system default DB2 client but Toad can define which DB2 client to use if you have more than one DB2 client installed in your system. SQL Optimizer will fail if “CMSDB” not defined in current default DB2 client. An easy way to check it is check is “CMSDB” in the “Database Alias” drop-down list.

If you still have problem, please contact support and create a support case.

Regards,
Ken


#5

So in other words TOAD for DB2 LUW uses the TYPE 4 driver with DBNAME / port number but SQL Optimizer is looking for TYPE 2 driver which can be connected only via DB2 client.

TOAD LUW – TYPE 4 driver

SQL Optimizer – TYPE 2 driver.

Glenn

Gopalan Venkatramani | DB Administrator

Allegiant Travel Company

1201 N. Town Center Drive, Las Vegas, NV 89144

Direct # +1 702 830 8712 Cell # +1 908 205 7691

Glenn.Venkatramani@allegiantair.com
|www.allegiant.com

From: ken.tai@quest.com [mailto:bounce-kentaiquestcom@toadworld.com]

Sent: Tuesday, May 08, 2018 7:59 PM

To: toaddb2@toadworld.com

Subject: RE: [Toad for IBM DB2 - Discussion Forum] Toad error to SQL Optimizer window.

RE: Toad error to SQL Optimizer window.

Reply by ken.tai@quest.com

Hi Glenn,

SQL Optimizer use system default DB2 client but Toad can define which DB2 client to use if you have more than one DB2 client installed in your system. SQL Optimizer will fail if “CMSDB” not defined in current default DB2 client. An easy way to check it is check is “CMSDB” in the “Database Alias” drop-down list.

If you still have problem, please contact support and create a support case.

Regards,

Ken

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.


#6

SQL Optimizer need you catalog database in DB2 client.


#7

You wrote:


TOAD LUW – TYPE 4 driver

SQL Optimizer – TYPE 2 driver.


Neither Toad for DB2 nor SQL Optimizer uses JDBC.

SQL Optimizer requires IBM Data Server Client. Toad for DB2 is able to work both with IBM Data Server Driver Package (DS Driver) and IBM Data Server Client client.

Regards

Ondrej