1.6. Host Connectivity
DB2 Connect is the software product containing the licensed files required to communicate from a DB2 distributed client, also known as the DRDA Application Requester , to a host DB2 server, a DRDA Application Server . (DRDADistributed Relational Database Architectureis the standard that defines formats and protocols for providing transparent access to remote data.) Host DB2 servers include DB2 UDB for z/OS and OS/390, DB2 UDB for VM/VSE, and DB2 UDB for iSeries. DB2 Connect also includes a DB2 runtime client.
As indicated earlier, if you install DB2 UDB ESE there is no need to install DB2 Connect since DB2 UDB ESE comes with a DB2 Connect component.
DB2 Connect software is only required when communicating from a workstation to a host; it is not required in the other direction (from a host to a workstation).
DB2 Connect comes in two main flavors.
1.7. Federated Support
allows you to query and manipulate data stored on other servers and in other RDBMSs. When you issue an SQL statement in a federated environment, you may actually be accessing information from multiple databases and
Figure 1.10. DB2 federation
Federated support is included in DB2 when the other databases being accessed are part of the IBM DB2 family, that is, another DB2 database or an Informix database. For accessing databases from other
1.8. Replication Support
lets you propagate data to different servers to keep different databases synchronized. Data changes captured at one server are later applied to another (target) server, as
Figure 1.11. DB2 replication environment
DB2 UDB has built-in support for replication when source and target databases are part of the IBM family, which includes Informix. For databases from other
1.9. IBM DB2 Information Integrator
The IBM DB2
) provides federated support by masking databases from IBM or different
The Replication Edition of IBM DB2 Information Integrator supports the propagation of data between DB2 UDB, Microsoft SQL Server, Oracle, and others.
1.10. Special Package Offerings for Developers
Two special offerings are available for application developers.
Both editions come at a reduced price, and are restricted to the development, evaluation, demonstration, and testing of application programs. Figure 1.12 shows most of the software provided with each offering. For a detailed listing of the features included with each offering, refer to the DB2 for Linux, UNIX, and Windows main Web page at http://www.ibm.com/software/data/db2/udb/.
Figure 1.12. Special package offerings for application developers