Release Notes

30.4 Accessing DB2 Version 5 Information Catalogs with the DB2 Version 7 Information Catalog Manager

The DB2 Version 7 Information Catalog Manager subcomponents, as configured by the DB2 Version 7 install process, support access to information catalogs stored in DB2 Version 6 and DB2 Version 7 databases. You can modify the configuration of the subcomponents to access information catalogs that are stored in DB2 Version 5 databases. The DB2 Version 7 Information Catalog Manager subcomponents do not support access to data from DB2 Version 2 or any other previous versions.

To set up the Information Catalog Administrator, the Information Catalog User, and the Information Catalog Initialization Utility to access information catalogs that are stored in DB2 Version 5 databases:

1. Install DB2 Connect Enterprise Edition Version 6 on a workstation other than where the DB2 Version 7 Information Catalog Manager is installed.

   DB2 Connect Enterprise Edition is included as part of DB2 Universal Database Enterprise Edition and DB2 Universal Database Enterprise - Extended Edition. If Version 6 of either of these DB2 products is installed, you do not need to install DB2 Connect separately.

   Restriction:

   You cannot install multiple versions of DB2 on the same Windows NT or OS/2 workstation. You can install DB2 Connect on another Windows NT workstation or on an OS/2 or UNIX workstation.

2. Configure the Information Catalog Manager and DB2 Connect Version 6 for access to the DB2 Version 5 data. For more information, see the DB2 Connect User's Guide. The following steps are an overview of the steps that are required:
   1. On the DB2 Version 5 system, use the DB2 Command Line Processor to catalog the Version 5 database that the Information Catalog Manager is to access.
   2. On the DB2 Connect system, use the DB2 Command Line Processor to catalog:
      • The TCP/IP node for the DB2 Version 5 system
      • The database for the DB2 Version 5 system
      • The DCS entry for the DB2 Version 5 system
   3. On the workstation with the Information Catalog Manager, use the DB2 Command Line Processor to catalog:
      • The TCP/IP node for the DB2 Connect system
      • The database for the DB2 Connect system

   For information about cataloging databases, see the DB2 Universal Database Installation and Configuration Supplement.

3. At the warehouse with the Information Catalog Manager, bind the DB2 CLI package to each database that is to be accessed through DB2 Connect.

   The following DB2 commands give an example of binding to v5database, a hypothetical DB2 version 5 database. Use the DB2 Command Line Processor to issue the following commands. db2cli.lst and db2ajgrt are located in the \sqllib\bnd directory.

   db2 connect to v5database user userid using password
   db2 bind db2ajgrt.bnd
   db2 bind @db2cli.lst blocking all grant public
   

   where userid is the user ID for v5database and password is the password for the user ID.

   An error occurs when db2cli.list is bound to the DB2 Version 5 database. This error occurs because large objects (LOBs) are not supported in this configuration. This error will not affect the warehouse agent's access to the DB2 Version 5 database.

   FixPak 14 for DB2 Universal Database Version 5, which is available in June, 2000, is required for accessing DB2 Version 5 data through DB2 Connect. Refer to APAR number JR14507 in that FixPak.