By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,133 Members | 1,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,133 IT Pros & Developers. It's quick & easy.

how to use db2 connect server as a gateway to connect to mainframe db2 database

P: n/a
we have os/400 db2 database at the backend.
i installed db2 v9 connect server on one windows server which is
locating the same network with database server.

now how to i configure the connect server and client, so client could
access the database through the connect server?

like that:

db2client <--db2 connect server <--db2 mainframe database

IBM keeps talking about this structure but never mention about the
configuration in all the manuals.:(

thanks for help!

Oct 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jeffhan wrote:
we have os/400 db2 database at the backend.
i installed db2 v9 connect server on one windows server which is
locating the same network with database server.

now how to i configure the connect server and client, so client could
access the database through the connect server?

like that:

db2client <--db2 connect server <--db2 mainframe database

IBM keeps talking about this structure but never mention about the
configuration in all the manuals.:(

thanks for help!
Info-center:
- "DB2 Connect server products: installation and configuration overview":
http://publib.boulder.ibm.com/infoce...c/c0008452.htm

- "Preparing DB2 Universal Database for iSeries for connections from DB2
Connect":
http://publib.boulder.ibm.com/infoce...c/t0008234.htm

- "Configuring a connection to host or iSeries database servers using the
CA (Linux and Windows)":
http://publib.boulder.ibm.com/infoce...c/t0023531.htm

- "Configuring a connection to host and iSeries database servers using the
CLP":
http://publib.boulder.ibm.com/infoce...c/t0022681.htm
Manuals:
- "Quick Beginnings for DB2 Connect Servers":
ftp://ftp.software.ibm.com/ps/produc...S/db2c6e90.pdf
(have a look at Chapter 2, Figure 1 seems to describe your situation)

- "Quick Beginnings for DB2 Clients":
ftp://ftp.software.ibm.com/ps/produc...S/db2ite90.pdf

HTH

--
Jeroen
Oct 17 '07 #2

P: n/a
jeffhan wrote:
we have os/400 db2 database at the backend.
i installed db2 v9 connect server on one windows server which is
locating the same network with database server.

now how to i configure the connect server and client, so client could
access the database through the connect server?

like that:

db2client <--db2 connect server <--db2 mainframe database

IBM keeps talking about this structure but never mention about the
configuration in all the manuals.:(

thanks for help!
Hi!

here the short way (didnt installed db2 on windows already, but it
should work this way):
at the server: catalog a node to the mainframe and catalog the mainframe
db on that node (remote db)
at the client: use your connect server as db server with user and
password of the os/400 db system.

Thats all. Nothing spezial.

with best regards
Dieter Stumpner
Oct 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.