The function provided by the Visual Warehouse product has been integrated into DB2 Universal Database. This function is accessed in DB2 Universal Database through the Data Warehouse Center.
When you install DB2 Universal Database on Windows, all previous versions of Visual Warehouse components on that system are uninstalled. To ensure that you continue to have a working environment after the installation, all warehouse components that interoperate in your environment must be at the Version 7 level. This includes:
A partial migration of Visual Warehouse is not allowed.
Note: | Any settings that you have customized for Visual Warehouse will be lost during the migration process. For example, you might have a customized setting in the IWH.environment file for an AIX or Solaris Operating Environment warehouse agent. Before you begin the installation process, make a backup copy of any Visual Warehouse settings that you have customized. |
The Visual Warehouse server and your active warehouse control database (the most recently used database) are migrated together during the installation process. After you install DB2 Universal Database, you must manually migrate any other warehouse control databases that you want to continue to use with the Data Warehouse Center.
Refer to Data Warehouse Center Administration Guide for:
When a warehouse server is installed, a default warehouse agent is also installed. However, you must migrate any remote warehouse agents that you want to continue to use after the installation completes. Warehouse agents are available with the DB2 Warehouse Manager product.
To migrate a warehouse agent:
For information on removing and installing Visual Warehouse agents, see the DB2 Warehouse Manager Installation Guide.
Warehouse transformers are available with the DB2 Warehouse Manager product. After installing the warehouse transformers on the warehouse agent system, you must enable the warehouse transformers so that they can be used with new warehouse targets. This is done using the Data Warehouse Center.
For more information on enabling warehouse transformers, see the DB2 Warehouse Manager Installation Guide.
Note: | DataGuide is known as the Information Catalog Manager in DB2 Universal Database Version 7. It is available with the DB2 Warehouse Manager product. |
When you install DB2 Universal Database Version 7, any DataGuide components that are on that system are uninstalled. If you then install the Information Catalog Manager as a component of the DB2 Warehouse Manager, the new Information Catalog Manager components will be installed and the DataGuide information catalog database can be upgraded. For information about upgrading DataGuide information catalog databases, refer to the Information Catalog Manager Administration Guide.
Note: | If you do not upgrade to the Information Catalog Manager at this time, you will not be able to use DataGuide with the Data Warehouse Center after the installation. DataGuide components on other systems will continue to work with the DataGuide information catalog database if it has not been upgraded by a DB2 Warehouse Manager installation. |