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.
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.
To update the database manager configuration before installing warehouse transformers:
UPDATE DATABASE MANAGER CONFIGURATION USING JDK_PATH pathwhere path is the subdirectory where the JDK is installed.
UPDATE DATABASE MANAGER CONFIGURATION USING JAVA_HEAP_SZ 4096
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.
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.
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.
Follow these steps to create a new warehouse control database in Unicode format:
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.
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.
The procedure for opening the Define Warehouse Source notebook for the Tutorial Relational Source has changed.
To open the Define Warehouse Source notebook for the Tutorial Relational Source:
The Define Warehouse Source notebook opens.
The procedure for opening the Define Warehouse Target notebook has changed.
To open the Define Warehouse Target notebook:
The Define Warehouse Target notebook opens.
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.
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.
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.
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:
To perform a statistical transformation of your data, define the statistical transformer that you want to use.
To define statistical transformers:
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.
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.
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 ]