Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun Solaris
This 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.
| Requirement | Data Source Database | Federated Database |
|---|---|---|
| Environment | OS/390 DB2 V6 | Sun Solaris 8 DB2 UDB Enterprise Server EditionV8.1 |
| Hostname | HOST390 | s4500db |
| IP Address | 210.100.100.210 | 192.168.10.100 |
| User ID (SYSADM) | tst1sys | dsnow |
| Instance Owner ID | dsnow | |
| Database | HDB1 | sample |
| Communication Port | 1300 | 50000 |
| User ID (DBADM) | tst1txp | tphan |
| User ID | user_n (where n is sequence start at 1, i.e., user_1) | |
| Data Source | DB2 OS/390 | DB2 UDB for Linux, UNIX, and Windows ... |
Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
