|
View previous topic :: View next topic
|
| Author |
Message |
senthilssg
New User
Joined: 09 Dec 2005
Posts: 64
Location: USA
|
|
|
|
Hi all ,
I am facing problem with DDF of DB2 . Message of log DB2 address space is given below .
I am continuously getting following message
| Code: |
14.31.22 STC04033 DSNL512I +DBY7 DSNLILNR TCP/IP 640
640 GETHOSTBYADDR(172.20.85.101) FAILED WITH
640 RETURN CODE=1 AND REASON CODE=00000000 |
Message log of DB2 MSTR address space
| Code: |
14.31.22 STC04033 DSNL004I +DBY7 DDF START COMPLETE 641
641 LOCATION SHOLY7
641 LU TCSM.LUY7SHOL
641 GENERICLU -NONE
641 DOMAIN -NONE
641 TCPPORT 1000
641 RESPORT 1001
14.31.22 STC04033 DSN9022I +DBY7 DSNYASCP 'START DB2' NORMAL COMPLETION
14.34.22 STC04033 DSNL512I +DBY7 DSNLILNR TCP/IP 689
689 GETHOSTBYADDR(172.20.85.101) FAILED WITH
689 RETURN CODE=1 AND REASON CODE=00000000
14.37.22 STC04033 DSNL512I +DBY7 DSNLILNR TCP/IP 729
729 GETHOSTBYADDR(172.20.85.101) FAILED WITH |
Due to the above issue , I am not able to connect to DB2 on z/OS through DB2 connect . I am getting following error message when connect to DB2
via DB2 connect .
| Code: |
DB2 => connect to sholy7 user userid using password1
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "172.20.85.101". Communication function
detecting the error: "connect". Protocol specific error code(s): "10061", "*
"*". SQLSTATE=08001 |
I have tried with refresh DDF ( ie stop and start the DDF ) and Refresh VTAM connection for DB2 . But no effect . Still problem persist .
Could anyone of you please pass some light on this and help me to resolve this issue .
Thanks In advance
Regards
SenthilKumar K |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| have the support people check Your TCP/IP configuration |
|
| Back to top |
|
|
Rogerio Ferreira Coelho
New User
Joined: 13 Jun 2007
Posts: 11
Location: Sao Paulo - Brazil
|
|
|
|
Hi Senthil,
I'm having the same problem, did you have a solution?
Thank you |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello Rogerio,
Have you had your network support people verify your tcp/ip configuration?
If you try to "ping" your db2 ip address, what happens? |
|
| Back to top |
|
|
Rogerio Ferreira Coelho
New User
Joined: 13 Jun 2007
Posts: 11
Location: Sao Paulo - Brazil
|
|
|
|
I`m network support... whem I ping I receive timeout
Thanks |
|
| Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005
Posts: 64
Location: USA
|
|
|
|
Hi ,
The above problem was due to IP address not getting resolved .
by DNS resolver .
We have added entry for this IP address in the /etc/host file in OMVS .
| Code: |
Format for adding the above entry :
hostname ip-address
xxxx 10.0.0.1
|
Thanks and Regards
senthil |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello Rogerio,
Have you tried a tracert? How far does it go before failing (if it fails)? |
|
| Back to top |
|
|
|
|
