Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
Author Message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
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: 11
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

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

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: 11
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

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

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

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us