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

[jeffhan]

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!

[The Boss]

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

[Dieter Stumpner]

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