DB2 Connect's basic feature is providing a direct connection to a host database from desktop applications running on Windows or Linux workstations. DB2 Connect Personal Edition is the simplest way to provide this solution.

Each workstation that has DB2 Connect Personal Edition installed can establish a direct TCP/IP connection to...

• DB2 UDB for OS/390 and z/OS
• DB2 for z/OS
• DB2 UDB for iSeries
• DB2 for i5/OS
• DB2 Database for Linux, UNIX, and Windows servers

In addition, applications can connect to and update multiple DB2 family databases in the same transaction with the complete data integrity provided by the two-phase commit protocol.

Figure 1 shows a direct connection to a host or System i database server from a workstation with DB2 Connect Personal Edition installed.

Note:

1. You do not need to have DB2 installed on the DB2 Connect workstation. If you want a complete relational database management system on the DB2 Connect workstation, order DB2.

2. The IBM Data Server Client is now a part of the DB2 Connect package and can be installed if a customer wants to use it for application development. In addition, DB2 Connect now includes Stored Procedure Builder that can be used to build, test, and deploy stored procedures for DB2 for OS/390 and z/OS.

3. C programmers developing Windows applications that use Microsoft ODBC, OLE DB, or ActiveX Data Objects (ADO) should use the Microsoft Open Database Connectivity Software Development Kit. Programmers who want to develop applications using the Java™ programming language can use any Java development environment.

4. If a connection to a DB2 for z/OS database server with Sysplex exploitation enabled is lost, the client will automatically attempt to reestablish the connection.

Parent topic: DB2 Connect scenarios

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