Warehouse Manager Installation Guide

Installing the OS/2 warehouse agent

Before you install the OS/2 warehouse agent, you must remove the Visual Warehouse Version 5.2 or earlier OS/2 agent that is located on that workstation.

Removing the Visual Warehouse OS/2 agent

To remove the Visual Warehouse OS/2 agent components from your workstation:

• For Visual Warehouse Version 3.1, start the Uninstall program icon in the Visual Warehouse Agent folder on the desktop.
• For Visual Warehouse Version 5.2, use the Installation Utility in the Visual Warehouse folder.

Installing the OS/2 warehouse agent

Installing a warehouse agent on OS/2 consists of installing the warehouse agent code and cataloging the databases that will be accessed by the agent as ODBC data sources. You can do this by using the ODBC Administrator. To access non-DB2 databases with the installed Data Warehouse Center ODBC drivers, you must install licensed clients for those database types, and the clients must be accessible by the warehouse agent, on the node where the warehouse agent runs.

Before you install the OS/2 warehouse agent:

1. Verify that the DB2 ODBC driver and driver manager (available from the DB2 Universal Database CD-ROM) are installed in the \OS2 directory of your boot drive.
2. To access databases with the installed Data Warehouse Center ODBC drivers, ensure that the correct client software is installed for the data sources that you plan to use. See the Data Warehouse Center Administration Guide for information on supported data sources.

To install the warehouse agent and executable versions of the sample programs:

1. Insert the Warehouse Manager CD-ROM into your CD-ROM drive.
2. Run f:\install.exe, where f is your CD-ROM drive.
3. If you are upgrading from Visual Warehouse, find the file ODBC.DLL in the \SQLLIB\BIN directory, and rename it to ODBC.BAK. Doing this will ensure that the ODBC driver manager in the \OS2 directory on your boot drive will be used.
4. Restart your workstation.

You must catalog the DB2 nodes and databases, and register each source and warehouse database that you want to use with the warehouse agent as a system DSN. See the Installation and Configuration Supplement for more information.

When you install the warehouse agent, the warehouse agent daemon is added to your OS/2 Startup folder. When the warehouse agent daemon starts from the OS/2 Startup folder, the daemon runs in a window in a foreground session. While the daemon is running, this window provides status information about the daemon. You can end this session by closing the window.

The warehouse agent creates log files in the directory that is specified by the VWS_LOGGING environment variable. The default value for this variable is C:\SQLLIB\LOGGING.