Cannot catalog db2 db in toad

Toad for IBM DB2
1

Hello guys,

I am new in Toad world. I have a database on an AIX server and I don’t know how to add it in toad interface. I tried to catalog the database but I keep receiving the same error:

ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: “TCP/IP”. Communication API being used: “SOCKETS”. Location where the error was detected: “9.51.102.135”. Communication function detecting the error: “recv”. Protocol specific error code(s): “", "”, “0”. SQLSTATE=08001

Thanks in advance for your help!!

2

AndraRadu,

Welcome to the Toad community! The following link should prove useful to you:

http://documents.quest.com/toad-for-db2/6.1/installation-guide/create-and-troubleshoot-connections/configure-db2-client-connections

If this does not help you may need to use to Fully Qualified Host name for your AIX server. Also make sure the Port number is correct. Check the SVCENAME DBM CFG parameter to see what it is set to.

Thanks,

Eric Sheridan

3

Go to (tools/options/database/timeouts/connection timeout) increasing this value might resolve the issue

4

You might also ensure you can connect from the IBM DB2 command line processor. If you cannot connect there (i.e. bad port number used during the cataloging of your database) , you will not be able to connect within Toad.

5

Hello,

see below the two main tipical reasons for this error

  1. the server isn’t recheable due to network problem, like firewall/router

problem

A1) use ping and/or tracert to check that you can reach server

A2) use telnet, specifing db2 server port, if telnet work network is

OK

  1. define db2 Node and db2 Remote Database using a syntax like the

followings:

from a CLP window/session

NODE:

catalog tcpip node MY_NODE_NAME (for example N+db_name)

remote IP_add or hostname of server

server DB2_port (check on server in /etc/services the port number)

ostype LINUX/AIX/WIN

with “MY Node to server X”

;

– The below TERMINATE is mandatory to Refresh CLP) Cache Directory

TERMINATE;

– If you want list the node directory (remove --)

–LIST NODE DIRECTORY SHOW DETAIL;

REMOTE DB:

catalog db DATA_BASE_NAME

as ALIAS_of_DATA_BASE_NAME (can be the same)

at node NODE_NAME (see previous Node definiton)

authentication SERVER (where user/pswd authantication will checked)

with “db remoto DATA_BASE_NAME”;

– The below TERMINATE is mandatory to Refresh CLP) Cache Directory

TERMINATE;

– If you want list the DB directory (remove --)

–LIST DB DIRECTORY

after try a: db2 connect to database_name user xxx using ppppp

if work you can also define Node and db in Toad

Save the trees, Please do not print this e-mail unless you really need to

Per cortesia non stampare questa e-mail se non per assoluta necessità.

Cordiali Saluti, Best Regards, Bonne Réception, Mit Freundlichen Gruessen,

Venlig Hilsen, Saludos, Atenciosamente, Pokà/Met Vriendelijke Groeten

Gianfranco Casati

Certified Senior IBM System Engineer

zOS, DB2 zOS, Vtam, TCPIP, RACF, CICS, MQ, TWS, ect.

Linux, DB2LUW

IT Security is a Smart Investment

The human mind is our fundamental resource.

John Fitzgerald Kennedy

USA President

Da: “AndraRadu”

Per: ,

Data: 22/08/2016 21:40

Oggetto: [Toad for IBM DB2 - Discussion Forum] Cannot catalog db2 db in

toad

Cannot catalog db2 db in toad

Thread created by AndraRadu

Hello guys,

I am new in Toad world. I have a database on an AIX server and I don’t know

how to add it in toad interface. I tried to catalog the database but I keep

receiving the same error:

ERROR [08001] [IBM] SQL30081N A communication error has been detected.

Communication protocol being used: “TCP/IP”. Communication API being used:

“SOCKETS”. Location where the error was detected: “9.51.102.135”.

Communication function detecting the error: “recv”. Protocol specific

error code(s): “", "”, “0”. SQLSTATE=08001

Thanks in advance for your help!!

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

Thank you so much for your help!! Now I learned how to catalog a database and I was able to connect to the database.

Again, thank you!

7

One more question: I cannot catalog 2 databases from different servers with the same name?

for example, I have rfs_it3 database on a test server and rfs_it3 database on a production server and I want to catalog both of them on toad, but I cannot because it says that the db is there. What should I do? I’m afraid that if I change the name of the prod db, then I cannot connect to it.

Thanks,

Andra

8

Andra,

You will need to use an Alias for your database name. The DB2 Catalog/Toad can only use one database name at a time. The Alias name can be anything you want. You could use “rfs_it3_a” as an Alias. For better housekeeping you could use a mixture of the database name and the AIX server name.

Ember Crooks has a good article on her blog explaining Aliases here: http://db2commerce.com/2014/07/29/db2-basics-aliases/

Hope this helps.

Thanks,
Eric Sheridan

9

NO, the only way to define db with same name is use “ALIAS” this means that

in “catalog db” is mandatory specify the AS keyword with two different

value,

for example:

catalog db rfs_it3 as T_rfs_it3 …

catalog db rfs_it3 as P-rfs_it3 …

Use alias name in db2 connect and ort java properties

Da: “AndraRadu”

Per: ,

Data: 23/08/2016 17:23

Oggetto: RE: [Toad for IBM DB2 - Discussion Forum] Cannot catalog db2 db

in toad

RE: Cannot catalog db2 db in toad

Reply by AndraRadu

One more question: I cannot catalog 2 databases from different servers with

the same name?

for example, I have rfs_it3 database on a test server and rfs_it3 database

on a production server and I want to catalog both of them on toad, but I

cannot because it says that the db is there. What should I do? I’m afraid

that if I change the name of the prod db, then I cannot connect to it.

Thanks,

Andra

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.

10

Hi Eric, thanks again! :slight_smile:

11

Thank you!!