Data Warehouse Center

| | |

Setting up the warehouse client environment on AIX and Solaris operating |systems

|

On AIX and Solaris operating systems, you must set your locale correctly |prior to running the warehouse client.

|

To set your locale, type the following command from a command line: export LC_ALL=<locale>

|

Note the following example: export LC_ALL=Ja_JP where Ja_JP is your local locale.

|

If this environment variable is not set, then GUI applications might not |run correctly and can result in Java errors.

Updating the database manager configuration before installing warehouse transformers

In the DB2 Warehouse Manager Standard Edition Installation Guide, Version 8.2, the topic "Updating the database manager configuration before installing warehouse transformers" incorrectly instructs you to update the SDK path parameter. You must update the JDK path parameter.

Use the DB2 Command Line Processor to update the database manager configuration for the target DB2 instance before you install warehouse transformers.

Procedure

To update the database manager configuration before installing warehouse transformers:

  1. Set the JDK path parameter (JDK_PATH) to the subdirectory where the JDK is installed: 
    UPDATE DATABASE MANAGER CONFIGURATION USING JDK_PATH path
    where path is the subdirectory where the JDK is installed.
    Note:
    Do not include the bin directory in JDK_path. If you are using a DB2 Universal Database Version 7.2 (or earlier) target that has transformers installed, you should update JDK11_PATH as opposed to JDK_PATH.
  2. Set the Java Virtual Machine heap size parameter (JAVA_HEAP_SZ) to 4096: 
    UPDATE DATABASE MANAGER CONFIGURATION USING JAVA_HEAP_SZ 4096

VW_NETRC environment variable added to the Data Warehouse Center (UNIX)

Starting with Version 8.2 FixPak 10 (equivalent to Version 8.1 FixPak 3) of the Data Warehouse Center, you can set the VW_NETRC environment variable on UNIX operating systems, except for on Linux. Setting the VW_NETRC environment variable to off allows you to manually maintain the .netrc file. Refer to your operating system's documentation for information about the correct format for the .netrc file.

Running concurrent FTP user-defined programs might corrupt the .netrc file. If you want to run concurrent FTP user-defined program steps, you can set the VW_NETRC environment variable to off (VW_NETRC=OFF). Add this environment variable to your agent daemon profile for remote agents and to the IWH.environment file for your default or local agent.

DB2 Data Warehouse Center requires Unicode format database

After installing DB2 Universal Database(TM) Version 8.1 FixPak 7 or later, you need to run the Warehouse Control Database Management tool to create a new warehouse control database that is in Unicode format.

Prerequisites

To create and store a copy of the existing warehouse control database, your workstation must have enough disk space to store this copy plus twice as much space as the warehouse control database requires to store temporary files. For example, if the existing warehouse control database is 10 MB, a total of 30 MB must be available in the same instance as the existing warehouse control database.

Procedure

Follow these steps to create a new warehouse control database in Unicode format:

  1. Run the Warehouse Control Database Management tool:
    • On Windows: Click Start and select Programs -> IBM(R) DB2(R)-> Set up Tools-> Warehouse Control Database Management.
    • On AIX: Run the db2wcdbm script.
  2. Enter the name of the existing warehouse control database. You are then prompted for a new warehouse control database name. This creates a new Unicode warehouse control database.

Defining DB2 warehouse sources and targets

The following update affects two Data Warehouse Center topics:

By default, when you define a warehouse source or a warehouse target, the number of tables that are returned is 250. However, you can use the new environment variable VWS_MAX_TABLELIST to set the number of tables that are returned. The maximum number of tables that can be returned is 40 000. This number might be less depending on the size of the table names in the list. It is recommended that you specify a number much smaller than 40 000.

Updates to the Business Intelligence tutorial

Verifying that the DWCTBC and TBC_MD databases are registered with ODBC

In Version 8, the control database, TBC_MD that is used in the tutorial, does not need to be a system ODBC data source. However, the target database or database source DWCTBC must be a system ODBC data source.

Opening the Define Warehouse Source notebook

The procedure for opening the Define Warehouse Source notebook for the Tutorial Relational Source has changed.

Procedure

To open the Define Warehouse Source notebook for the Tutorial Relational Source:

  1. From the Data Warehouse Center window, right-click the Warehouse Sources folder.
  2. Click Define --> ODBC --> DB2 --> DB2 Family.

The Define Warehouse Source notebook opens.

Opening the Define Warehouse Target notebook

The procedure for opening the Define Warehouse Target notebook has changed.

Procedure

To open the Define Warehouse Target notebook:

  1. From the Data Warehouse Center window, right-click the Warehouse Targets folder.
  2. Click Define --> ODBC --> DB2 --> DB2 Family.

The Define Warehouse Target notebook opens.

Setting the purge limit for warehouse log files

The log file holds records until a designated count limit is reached. The default count limit is 1000 records. Typically, each job that you run creates 12 to 15 log records. Set the purge limit to a number that meets your needs by updating the Purge log when total records equal field on the Server tab of the Warehouse Properties page.

Data Warehouse Center support for CURSOR load

The DB2 Universal Database Load step now allows a view or a table to be used as the source to the step, resulting in a LOAD FROM CURSOR.

In order to map columns in the wizard for CURSOR load, the Map columns based on column positions found in the input file radio button must be selected.

Unicode warehouse control database migration and limitations

Starting with Version 8.2 of the Data Warehouse Center, the warehouse control database must be a Unicode database. If you have a Unicode warehouse control database from a version of the Data Warehouse Center that is before Version 8.2, you still must create a new Unicode control database by using the Warehouse Control Database Management tool.

When you migrate a warehouse control database from a version of the Data Warehouse Center that is before Version 8.2, the Data Warehouse Center Control Database Management tool runs the db2move command to move the data to a new Unicode control database. During this process, windows appear that show the progress of the db2move command. This migration path only occurs once.

The Data Warehouse Center does not support Unicode on Sybase servers.

Change in date format for Modified column

In the details view of the main Data Warehouse Center window, the format of the date in the Modified column has been updated. The date in the Modified column is displayed in the format for your locale and includes the time. This change in the date format ensures that sorting objects on the Modified column functions properly. This update applies to most lists of Data Warehouse Center objects that are shown in the Navigator and Details views, such as:

Defining statistical transformers in the Data Warehouse Center

To perform a statistical transformation of your data, define the statistical transformer that you want to use.

Procedure

To define statistical transformers:

  1. Open the Process Model window.
  2. Click the transformer icon and select a transformer from the list of available transformers.
  3. Link the transformer that you selected to a warehouse source and warehouse target as required by the rules for that transformer.

Each transformer has specific rules for how it must be linked to a warehouse source and warehouse target. See the documentation for each transformer for more information.

| | |

Preparing to install warehouse agents

|

When installing DB2 Warehouse Manager, the warehouse server, warehouse |client, and all of the warehouse agents must be at the same version and fix |pack level.

Prerequisite for the iSeries warehouse agent

To use an iSeries(TM) warehouse agent for DB2 Warehouse Manager on V5R2 and V5R3 systems, the following PTF is required:

PTF SI13558

This database PTF enables the CLI on iSeries to handle Unicode data.

[ Top of Page |Previous Page | Next Page | Contents ]