Data Warehouse Center Administration Guide

Appendix G. Data Warehouse Center environment structure

The information in this appendix explains how the Data Warehouse Center is structured and how it interacts with the operating system.

Data Warehouse Center environment variables

In Table 34, the drive letter C indicates a local drive.

Table 34. Data Warehouse Center environment variable updates for Windows

The environment variable:	Is added to, or modified, to include:
PATH (used to access the Data Warehouse Center code)	C:\Program Files\SQLLIB\BIN and C:\Program Files\SQLLIB\ODBC32
LOCPATH (used by the Data Warehouse Center Host Adapter Client)	C:\Program Files\SQLLIB\ODBC32\LOCALE
VWS_TEMPLATES	C:\Program Files\SQLLIB\TEMPLATES
VWS_LOGGING	C:\Program Files\SQLLIB\LOGGING
VWSPATH	C:\Program Files\SQLLIB

Data Warehouse Center registry updates

The following values are added to HKEY_LOCAL_MACHINE\Software\IBM\DB2\DataWarehouseCenter\ServiceParms in the Windows NT or Windows 2000 registry:

Value name

Value data

Database name

<Control DB name>

Log Directory

<disk:\dir\>

Password

<password>

Qualifier

<table qualifier>

Userid

<DB2 user ID>

Data Warehouse Center configuration files

The following updates are made to TCP/IP configuration information:

TCP/IP SERVICES:
   vwkernel     11000/tcp
   vwlogger     11002/tcp