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
 

 

Has anyone here tried to connect DB2 on ZOS from windows

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Dec 15, 2008 6:51 pm    Post subject: Has anyone here tried to connect DB2 on ZOS from windows
Reply with quote

Hi,

Has anyone tried to connect DB2 z/OS from windows. I came across this website from google. If anybody has already tried this out or know how to do it. Can you give tell me "HOW 2 DO" in a stepwise, so that i can try it out AND also one more thing, before trying it out. I want to know is it safe to do something like this.
Try to get data from mainframe through windows.

As one of the inputs, its asking for IP address & port number of the DB2. How to find that ? G.K.

Definately tell me, Is It Safe ?

Sushanth
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7999
Location: Bellevue, IA

PostPosted: Mon Dec 15, 2008 7:15 pm    Post subject:
Reply with quote

The IP address will be the mainframe address; the port number will be whatever was set up for DB2. You'll need to talk to your systems support people about this since DB2 has to be listening on the given port before you can connect to it -- if it's not set up to listen, you're not going to connect no matter what you do. Port numbers while typically standardized don't have to be so this is very definitely a site specific issue.
Back to top
View user's profile Send private message
tarun_bhardwaj

New User


Joined: 18 Jul 2003
Posts: 39
Location: delhi

PostPosted: Mon Dec 15, 2008 7:49 pm    Post subject: Reply to: Has anyone here tried to connect DB2 on ZOS from w
Reply with quote

Quote:
The IP address will be the mainframe address

The IP address should be the IP address of the server on which DB2 is installed. This can be different from the IP address of your mainframe server. In case there are multiple DB2 servers to which your mainframe connects, then you would have to specify the IP of the server to which you want to connect.
I have used DB2 connect (from IBM) and it permits just one instance to be active at a time. Thus, if you have connections set up for multiple servers, you can connect to just one server at a time.

How to do:

Install DB2 connect on your machine. Using the configuration center, you would specify the IP address and port number of the server where your DB2 is installed. This can be found by issuing the DB2 command in DB2i panel(option 7):
Code:
-DIS DDF

and it will fetch you the IP address and port number of the server where DB2 is installed. You would also need to specify an alias name for this connection which would be used at the time of connecting to DB2.
After this, you need to open the command center and write the command:
CONNECT TO alias-name USER username USING password

Once this is successful, then you can issue regular SQL commands like
SELECT * FROM table WHERE .......

Please let me know incase you need any further elaboration on this.[/i]
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Dec 15, 2008 8:29 pm    Post subject:
Reply with quote

Tarun,

I use DB2 only in mainframe. I don't have DB2 Connect.

I have issued
-display ddf

Got the IP address.
Now there is TCPPORT & RESPORT which one is the port number


Sushanth
Back to top
View user's profile Send private message
tarun_bhardwaj

New User


Joined: 18 Jul 2003
Posts: 39
Location: delhi

PostPosted: Mon Dec 15, 2008 8:48 pm    Post subject: Reply to: Has anyone here tried to connect DB2 on ZOS from w
Reply with quote

TCPPORT is the one you need to use.
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 FTP from windows server into Mainfram... sathyajes All Other Mainframe Topics 24 Wed Jul 20, 2016 1:33 pm
No new posts DB2 CONNECT query mistah kurtz DB2 3 Fri Jul 15, 2016 6:37 pm
No new posts problem on data conversion from windo... hkalhor2 Java & MQSeries 3 Tue May 17, 2016 12:10 pm
No new posts Connect Direct details shankarm IBM Tools 2 Sat Feb 20, 2016 7:25 pm
No new posts force windows ftp client user to defa... meykh2014 All Other Mainframe Topics 0 Sun Feb 14, 2016 12:57 pm


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