Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Problem with DB2 DDF connection

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
senthilssg

Active User


Joined: 09 Dec 2005
Posts: 54
PostPosted: Thu Apr 12, 2007 3:40 pm    Post subject: Problem with DB2 DDF connection
 Reply with quote
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
View user's profile Send private message
References
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 3277
Location: italy
PostPosted: Thu Apr 12, 2007 6:50 pm    Post subject: Re: Problem with DB2 DDF connection
 Reply with quote
have the support people check Your TCP/IP configuration
Back to top
View user's profile Send private message
Rogerio Ferreira Coelho

New User


Joined: 13 Jun 2007
Posts: 5
Location: Sao Paulo - Brazil
PostPosted: Fri Jan 25, 2008 5:45 pm    Post subject: Problem with DB2 DDF connection
 Reply with quote
Hi Senthil,

I'm having the same problem, did you have a solution?

Thank you
Back to top
View user's profile Send private message
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 9183
Location: 221 B Baker St
PostPosted: Fri Jan 25, 2008 10:24 pm    Post subject:
Reply with quote
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
View user's profile Send private message
Rogerio Ferreira Coelho

New User


Joined: 13 Jun 2007
Posts: 5
Location: Sao Paulo - Brazil
PostPosted: Fri Jan 25, 2008 10:50 pm    Post subject: DB2 Connection
 Reply with quote
I`m network support... whem I ping I receive timeout

Thanks
Back to top
View user's profile Send private message
senthilssg

Active User


Joined: 09 Dec 2005
Posts: 54
PostPosted: Mon Jan 28, 2008 11:00 pm    Post subject: Reply to: Problem with DB2 DDF connection
 Reply with quote
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
View user's profile Send private message
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 9183
Location: 221 B Baker St
PostPosted: Mon Jan 28, 2008 11:07 pm    Post subject:
Reply with quote
Hello Rogerio,

Have you tried a tracert? How far does it go before failing (if it fails)?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1