Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun SolarisThis section describes the high-level design of the federated system. The environment requirements for accessing a host DB2 on OS/390 data from a DB2 UDB ESE on Sun Solaris are shown in Table 7.3. Table 7.3. Federated System Environment Requirements
Worksheet: For Windows Clients Connecting to DB2 for OS/390 Database via DB2 Connect GatewayTable 7.4 lists the communication information for the Windows clients accessing the federated system via a DB2 Connect Gateway.
Table 7.4. Windows Client Communication Information
Federated Database System Test ScenariosThe following describes different scenarios for a distributed join to be performed against DB2 tables or views on the OS/390 environment (remote) and DB2 UDB tables or views on the Sun Solaris environment (local).
Using DB2 Connect (Optional)DB2 Connect has several connection solutions. DB2 Connect Personal Edition provides direct connectivity to host and iSeries database series, whereas DB2 Connect Enterprise Edition provides indirect connectivity that allows clients to access host and iSeries database servers through the DB2 Connect server. DB2 Connect Unlimited Edition provides a unique packaging solution that makes product selection and licensing easier. DB2 Connect Enterprise Edition is a connectivity server that concentrates and manages connections from multiple desktop clients and Web applications to DB2 database servers running on host or iSeries systems. IBM's DB2 UDB for iSeries, DB2 for OS/390 and z/OS, and DB2 for VSE and VM databases continue to be the systems of choice for managing most critical data for the world's largest organizations. Although these host and iSeries databases manage the data, there is a great demand to integrate this data with applications running on Windows and UNIX workstations. DB2 Connect Enterprise Edition is most appropriate for environments where:
DB2 Connect Personal Edition provides access from a single workstation to DB2 databases residing on servers such as OS/390, z/OS, OS/400, VM, and VSE, as well as to DB2 UDB servers on UNIX and Windows operating systems. DB2 Connect Personal Edition provides the same rich set of APIs as DB2 Connect Enterprise Edition. DB2 Connect Personal Edition is used to connect a single Windows operating system or Linux workstation to a host or iSeries database. DB2 Connect Personal Edition is best suited for environments where native TCP/IP support is provided by the database servers, and the application being deployed is a traditional two-tier client-server application. DB2 Connect Unlimited Edition is a unique package offering that allows complete flexibility of DB2 Connect deployment and simplifies product selection and licensing. This product contains both DB2 Connect Personal Edition and DB2 Connect Enterprise Edition with license terms and conditions that allow the unlimited deployment of any DB2 Connect product. License charges are based on the size of the S/390 or zSeries server that DB2 Connect users will be working with. |