The following tables show the supported databases for the Tivoli® Data Warehouse.
Table 1 shows the supported
databases for the Tivoli Data
Warehouse. If you run the database for the
Tivoli Enterprise Portal Server and
the database for the warehouse in the same instance of IBM®
DB2 for Linux, UNIX, and Windows,
you must follow the support requirements in
Table 1.
Note: IBM Tivoli Monitoring
V6.3 includes DB2® Enterprise
Server Edition 10.1 for use with the portal server and the Tivoli Data Warehouse.
Table 1. Supported databases for the Tivoli Data WarehouseTivoli Data Warehouse database ("WAREHOUS")1 |
IBM DB2 for Linux, UNIX, and Windows |
IBM DB2 on z/OS5 |
MS SQL Server |
Oracle |
Supported versions: - V9.7 and fix packs
- V10.1 and fix packs
|
Supported versions: version 9.1 or higher.
Support applies to any Windows, Linux, or UNIX platform that can run the Warehouse Proxy Agent. DB2 Connect™ Server Edition
is also required on the workstation. |
Supported versions: - MS SQL Server 2008
Enterprise Edition
- MS SQL Server 2008 R2 Enterprise Edition
- MS SQL Server 2012 Enterprise Edition
|
Supported versions: - 11g Release 1
- 11g Release 2
|
Note: - "WAREHOUS" is the default database name for the database
used by Tivoli Data Warehouse.
Support is for 32-bit or 64-bit databases. Your Tivoli Data Warehouse database can be located
on the same computer as your monitoring server or
on a remote computer.
- See the Oracle company support Web site (http://www.oracle.com/index.html)
for information about installing and configuring Oracle on Solaris
V10.
- DB2 on z/OS is
not supported for the Tivoli Enterprise Portal Server.
|
Table 2 shows
the supported databases for the Tivoli Data
Warehouse database compression feature.
Table 2. Supported databases for Tivoli Data
Warehouse database compressionTivoli Data Warehouse database compression |
IBM DB2 |
MS SQL Server |
Oracle |
V9.7 or higher, with the IBM DB2 Storage
Optimization feature. |
MS SQL Server 2008 Enterprise Edition or higher. |
11g Release 1 or higher, with the Oracle Advanced
Compression feature. |
Note: DB2 on z/OS® is not supported for this
feature.
Table 3 shows the supported
databases for the Tivoli Data
Warehouse database range partitioning feature.
Table 3. Supported databases for Tivoli Data Warehouse database range partitioningTivoli Data Warehouse range partitioning |
IBM DB2 |
IBM DB2 on z/OS |
Oracle |
Enterprise Edition 9.7 or higher. |
DB2 for z/OS 9.1 or higher. |
11g Release 1 or higher, with the partitioning
option. |