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