Accessing host or System i DB2 data using DB2 Connect Personal Edition

A direct connection without intermediate servers is a very convenient and desirable configuration. This is especially true for situations where the host or System i™ database server supports TCP/IP connectivity. In such situations, each DB2 Connect™ workstation establishes a direct connection with the host or System i database server.

TCP/IP connectivity requires that the host or System i database support TCP/IP. The following versions support native TCP/IP connections:

DB2^® Universal Database (UDB) for OS/390^® and z/OS Version 7.1 or later
DB2 UDB for iSeries Version 5 Release 1 or later, and
DB2 Server for VSE & VM Version 7 or later

To connect to an IBM^® host or System i database server you require a licensed DB2 Connect product. You cannot connect directly to an IBM host or System i Data Server using a IBM data server client.

Figure 1 shows a workstation, with DB2 Connect Personal Edition installed, directly connected to a host or System i database server.

Figure 1. Direct connection between DB2 Connect and a host or System i database server

Graphic showing a direct connection between DB2 Connect and a host or System i database server

Parent topic: DB2 Connect scenarios

Parent topic: DB2 Connect

Related concepts
Direct access to host databases