Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

220 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

4. Create the DB2 UDB for Multiplatforms user mappings.

5. Create the DB2 UDB for Multiplatforms nickname.

6. Test the DB2 UDB for Multiplatforms nickname.

We used the DB2 Control Center on the Windows platform to configure the DB2

UDB for Multiplatforms data source.

Catalog DB2 UDB for Multiplatforms

The remote database must first be cataloged using either the Client

Configuration Assistant (CCA) or through the command line.

The following steps catalog a database from the DB2 command line:

1. Log in with user administrator or db2admin to the Windows system.

2. Catalog the DB2 UDB for Multiplatforms node as follows:

db2 catalog tcpip node malmo remote 9.1.39.175 server DB2_db2loan

3. Catalog the database as follows:

db2 catalog database DB2LOANS as LOANS at node malmo

4. Test the connection to the database as follows:

db2 connect to LOANS user <user> using <password>

Create the DB2 UDB for Multiplatforms wrapper

Since we had already created a wrapper named DRDA for DB2 UDB for z/OS,

we can reuse the same wrapper definition for the DB2 UDB for Multiplatforms

data sources.

Create the DB2 UDB for Multiplatforms server definition

Select and expand the DRDA wrapper, right-click the Servers folder, and click

Create, similar to the actions taken for the NET8 wrapper from Figure B-3 on

page 170.

This action will display Figure B-55 on page 221.

Note: If there is an existing wrapper for DB2, it can be reused for DB2 UDB for

Multiplatforms, and a new wrapper is not necessary.

Appendix B. Configuring data sources in DB2 Information Integrator 221

Figure B-55 DB2 UDB for Multiplatforms - Create server

Choose LOANS for the Name field, select DB2/UDB for the Type field, select 8.1

for the Version field, and supply the User ID (db2loan) and Password values to

connect to this server as shown in Figure B-55.

Click the Settings tab to complete the server definition as shown in Figure B-56

on page 222.