View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 Location: delhi
|
|
|
|
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):
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 Location: delhi
|
|
|
|
TCPPORT is the one you need to use. |
|
Back to top |
|
|
|