Monday, 15 June 2015

toad - Connecting to DB2 database -



toad - Connecting to DB2 database -

i next error when seek connect toad db2:

error [08001] [ibm] sql30081n communication error has been detected. communication protocol beingness used: "tcp/ip". communication api beingness used: "sockets". location error detected: "10.99.13.5". communication function detecting error: "recv". protocol specific error code(s): "", "", "0". sqlstate=08001

attached connection properties. help connecting great.

this tipical problem when client cannot reach database. there different reasons:

closed port in local (client) machine. (firewall outbound) if using local catalog, check if right (db2 catalog database, db2 catalog tcpip node). if using direct connection skip step. routing problem (iptables ou network firewall) database server closed port (inbonud) - netstat -nato check port. instance downwards (ps -ef or task center in windows) db2comm registry variable not set tcpip port number not correctly mapped service name (instance configuration, utilize number instead) database name not right (connect locally in database server)

you can telnet windows (client) machine server via telnet

telnet databaseserverip portnumber

even, if db2 server in same machine, can localhost telnet in order see instance can receive tcp connections

telnet localhost 50000

once can successfully, can connect database.

db2 toad

No comments:

Post a Comment