Release Notes (FixPak 3)
The following limitations exist for down-level server support for DB2
Universal Database 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 Universal Database 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 Universal Database 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 Universal Database 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.
[ Top of Page | Previous Page | Next Page | Table of Contents ]