IBM Support

InfoSphere Warehouse 10.1 components, by edition

Preventive Service Planning


Abstract

InfoSphere Warehouse V10.1 offers different features depending on the edition that you purchase.

Content

Descriptions of key InfoSphere Warehouse components

The key components of InfoSphere Warehouse are described as follows.

InfoSphere Warehouse Design Studio

    The Design Studio provides a common design environment for creating physical data models, OLAP cubes, SQL data flows and control flows, and Blox® Builder analytic applications. The Design Studio is built on the Eclipse Workbench, which is a development environment that you can customize.

InfoSphere Warehouse Administration Console
    The InfoSphere Warehouse Administration Console is a Web application from which you can deploy and manage applications, control flows, database resources, and system resources. You can do the following types of tasks in the Administration Console:

Common configuration
    Create and manage database and system resources, including driver definitions, log files, and notifications.

SQL warehousing
    Run and monitor data warehousing applications and view deployment histories and execution statistics.
Cubing Services
    Manage cube servers, import and export cube models, explore cubes and cube models, and run the OLAP Metadata Optimization Advisor. Cubing Services works with business intelligence tools to provide OLAP access to data directly from InfoSphere Warehouse. Cubing Services includes tooling for multidimensional modeling to design OLAP metadata (cubes), an optimization advisor for recommending materialized query tables (MQTs) in DB2, and a cube server for providing multidimensional access to the data. Each of these Cubing Services components is integrated with the InfoSphere Warehouse user interfaces for design (Design Studio) and administration and maintenance (Administration Console).

Intelligent Miner
    InfoSphere Warehouse includes the following mining features:
    • Intelligent Miner Easy Mining
    • Intelligent Miner Modeling
    • Intelligent Miner Scoring
    • Intelligent Miner Visualization
    • Text Analysis
    These features provide rapid enablement of data mining analysis in Data Warehousing, eCommerce, or traditional Online Transaction Processing (OLTP) application programs. While previously available as separately priced products, they are now available as an integrated part of InfoSphere Warehouse.

Text Analysis
    With InfoSphere Warehouse, you can create business insight from unstructured information. You can extract information from text columns in your data warehouse then use the extracted information in reports, multidimensional analysis, or as input for data mining.

Components of InfoSphere Warehouse, by edition

    InfoSphere Warehouse offers different features depending on the edition that you purchase. The following table summarizes the components and features of each edition.
Component
Advanced Enterprise Edition
Enterprise Edition²
Enterprise Base Edition ¹
Advanced Departmental Edition
Departmental Edition
Departmental Base Edition
Developer Edition
Table 1. Components of InfoSphere Warehouse, by edition
DB2 10.1 Enterprise Server Edition
Included
Included
Included
Included
Included
Included
Included
DB2 Database Partitioning
Included
Included
Included
Included
Included
Included
Included
Cubing Services
Included
Included
Included
Included
Included
Included
Included
SQL Warehousing (SQW) Tool
Included
Included
Included
Included
Included
Included
Included
InfoSphere Federation Server Relational Wrappers
Included
Included
Included
Included
Included
Included
Included
Design Studio
Included
Included
Included
Included
Included
Included
Included
IBM Data Studio Client
Included
Included
Included
Included
Included
Included
Included
IBM Data Studio Administration Client
Included
Included
Included
Included
Included
Included
Included
IBM Data Studio Web Console
Included
Included
Included
Included
Included
Included
Included
Warehouse Administration Console
Included
Included
Included
Included
Included
Included
Included
WebSphere Application Server
Included
Included
Included
Included
Included
Included
Included
Cognos 10 Business Intelligence For Reporting
Included
Included
Not applicable
Included
Included
Not applicable
Included
InfoSphere Replication Server
Included
Included
Included
Included
Included
Included
Included
DB2 Workload Management
Included
Included
Performance Optimization Feature
Included
Included
Not applicable
Included
Optim Performance Manager
Extended Edition included
Extended Edition included
Performance Optimization Feature
Included
Included
Not applicable
Extended Edition included
DB2 Query Patroller
Included
Included
Performance Optimization Feature
Not applicable
Not applicable
Not applicable
Included
DB2 Deep Compression
Included
Included
Storage Optimization Feature
Included
Included
Not applicable
Included
Label Based Access Control (LBAC)
Included
Included
Advanced Access Control Feature
Not applicable
Not applicable
Not applicable
Included
Intelligent Miner
Included
Included
Not applicable
Included
Included
Not applicable
Included
Text Analytics
Included
Included
Not applicable
Included
Included
Not applicable
Included
Mashup Center
Included
Included
Not applicable
Not applicable
Not applicable
Not applicable
Included
InfoSphere Data Architect
10 user license
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
InfoSphere Optim Query Workload Tuner
Included
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Optim High Performance Unload
Included
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
DB2 Recovery Expert
Included
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
DB2 Merge Backup
Included
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Not applicable
Warehouse Pack: Market and Campaign Insight
Included
Not applicable
Not applicable
Included
Not applicable
Not applicable
Not applicable
Warehouse Pack: Customer Insight
Included
Not applicable
Not applicable
Included
Not applicable
Not applicable
Not applicable
Warehouse Pack: Supply Chain Insight
Included
Not applicable
Not applicable
Included
Not applicable
Not applicable
Not applicable
Maximum DB2 Database Size
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Maximum DB2 instance memory
Unrestricted
Unrestricted
Unrestricted
32 GB, or 64 GB
32 GB, or 64 GB
32 GB, or 64 GB
Unrestricted
Maximum process cores used by DB2
Unrestricted
Unrestricted
Unrestricted
16
16
16
Unrestricted
Maximum terabytes of user data
Unrestricted
Unrestricted
Not applicable
15
15
Not applicable
Not applicable
Environments
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Unrestricted
Non-production only
  • ¹ Applies to customers with the Base Warehousing Feature for DB2.
  • ² Applies to customers with the Enterprise Warehousing Feature for DB2.

The following table lists the separately purchasable features that are available for each edition of InfoSphere Warehouse.

Component
Advanced Enterprise Edition ²
Enterprise Edition ²
Enterprise Base Edition ¹
Advanced Departmental Edition
Departmental Edition
Departmental Base Edition
Developer Edition
Table 2. Separately purchasable features forInfoSphere Warehouse, by edition
DB2 Advanced Access Control Feature
Included
Included
Available
Not applicable
Not applicable
Not applicable
Included
DB2 Geodetic Data Management Feature
Available
Available
Available
Not applicable
Not applicable
Not applicable
Included
Homogenous Replication Feature for DB2
Restricted use
Restricted use
Restricted use
Restricted use
Restricted use
Restricted use
Included
Performance Optimization Feature for DB2
Included
Included
Available
Not applicable
Not applicable
Not applicable
Included
Storage Optimization Feature for DB2
Included
Included
Available
Included
Included
Not applicable
Included
  • ¹ Applies to customers with the Base Warehousing Feature for DB2.
  • ² Applies to customers with the Enterprise Warehousing Feature for DB2.

InfoSphere Warehouse with Optim Data Retention software is a bundled solution that includes IBM InfoSphere Warehouse Enterprise Edition and IBM Optim Data Growth Solution. This combination of products provides a complete end-to-end data growth solution for IBM enterprise data warehouse customers.

The separately purchasable IBM Base Warehouse Feature for DB2 and IBM Enterprise Warehouse Feature for DB2 provide an upgrade path for existing DB2 for Linux, UNIX, and Windows customers. With these features, you can extend your DB2 Enterprise Server investment by adding the superior scalability and comprehensive tooling of InfoSphere Warehouse. IBM Base Warehouse Feature for DB2 adds the capabilities of InfoSphere Warehouse Enterprise Base Edition to an existing DB2 Enterprise Server deployment. Similarly, the IBM Enterprise Warehouse Feature for DB2 adds the capabilities of InfoSphere Warehouse Enterprise Edition to an existing DB2 Enterprise Server deployment.

All editions of InfoSphere Warehouse allow the use of Q replication in DB2, but the use is restricted to a single DB2 source and target.


Document information

More support for: InfoSphere Warehouse

Software version: 10.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Edition Independent

Reference #: 1585911

Modified date: 01 October 2012


Translate this page: