Release Notes (version 8.1.2)

Data Warehouse Center down-level server support restrictions

The following limitations exist for down-level server support for DB2 Enterprise Server Edition Version 8 Data Warehouse Center:

Large Object (LOB) support

• If you are using a warehouse control database on a server that is older than DB2 Enterprise Server Edition Version 8 you will not be able to work with LOBs. You must upgrade the warehouse control database to the correct level, or move the control database to the system where the DB2 Enterprise Server Edition Version 8 warehouse server is installed and use it locally from that system.
• If you want to move LOBs back and forth between the Data Warehouse Center and DB2, you must upgrade to DB2 Enterprise Server Edition Version 8.

SNA support

If you use SNA to connect to your warehouse sources and targets, you must change the configuration to be TCP/IP over SNA, or use the Windows NT^(R) warehouse agent.

Support for EXPORT and LOAD utilities

When you upgrade your warehouse agent, you must also upgrade your source target databases, or replace the EXPORT and LOAD utilities in your warehouse processes with SQL Select and Insert steps. SQL Select and Insert steps use a DELETE* command followed by SELECT and INSERT commands. SQL Select and Insert steps require the database to log all transactions. As a result, the performance for SQL Select and Insert steps is not as efficient as it is for EXPORT and LOAD utilities.