IBM DB2 Warehouse Manager Version 7 Product Leaflet

About this manual

The IBM DB2 Warehouse Manager (Version 7) provides a comprehensive environment for building, managing, and analyzing data warehouses. It includes tools such as DB2 Control Center, Stored Procedure Builder, and Query Patroller to simplify data extraction, transformation, and reporting.

The solution integrates with a wide range of platforms and data sources, supporting Windows NT, Windows 2000, IBM OS/390, AS/400, AIX and OS/2, and can connect to Oracle, Sybase, Informix, Microsoft, ODBC and OLE DB sources. It also adheres to the Common Warehouse Metadata Interchange (CWMI) standard for metadata exchange across heterogeneous systems.

What's inside

• Features and Capabilities
• Supported Operating Systems
• Supported Data Sources
• Management Tools
• Metadata Interchange (CWMI)
• Integration with Other IBM Tools

Specifications

Frequently asked questions

Which operating systems can DB2 Warehouse Manager run on?

It can run on Windows NT, Windows 2000, IBM OS/390, AS/400, AIX and OS/2.

What data sources are supported for integration?

DB2 Warehouse Manager supports Oracle, Sybase, Informix, Microsoft, ODBC and OLE DB data sources.

What standard does DB2 Warehouse Manager use for metadata exchange?

It uses the Common Warehouse Metadata Interchange (CWMI) standard.

What is the purpose of the DB2 Control Center?

The DB2 Control Center provides a console for creating and managing data warehouses.