468,514 Members | 1,611 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,514 developers. It's quick & easy.

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

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
2 9221
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
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.

Similar topics

4 posts views Thread by Wonderinguy | last post: by
5 posts views Thread by Kona | last post: by
6 posts views Thread by Jerry Orr | last post: by
2 posts views Thread by joejadick | last post: by
2 posts views Thread by vikas.bhatia | last post: by
2 posts views Thread by zgh1970 | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.