IBM InfoSphere Warehouse 9.7 provides extended analytics and simplified warehousing for small, departmental, and enterprise businesses

IBM United States Software Announcement 209-129
May 19, 2009

 
 ENUS209-129.PDF (163KB)

Table of contents   Document options  
At a glance At a glance Publications Publications
Overview Overview Technical information Technical information
Key prerequisites Key prerequisites Software Services Software Services
Planned availability dates Planned availability dates Ordering information Ordering information
Description Description Terms and conditions Terms and conditions
Product positioning Product positioning  IBM  Electronic Services IBM Electronic Services
Program number Program number Prices Prices
Education support Education support Order now Order now
Offering Information Offering Information
 
Printable version Printable version

 
Top rule
At a glance
Bottom rule

IBM® InfoSphere Warehouse makes it easier to discover business opportunities hidden in your data. It provides a comprehensive platform to design, optimize, and grow departmental data marts and enterprise data warehouses.

IBM InfoSphere Warehouse 9.7 delivers:

  • Greater potential storage savings with enhanced deep compression
  • Simplified analytics that enable business users to discover revenue opportunities faster
  • Operational insight with end-to-end support for XML documents
  • Tools to help provide increased system availability, reduced administration, and fewer unplanned outages
  • Application compatibility that helps reduce the cost of data mart consolidation
  • Affordable departmental editions that helps reduce the expense of deploying and supporting warehousing and analytic solutions

To order, contact your IBM representative, an IBM Business Partner, or the Americas Call Centers at: 800-IBM-CALL

Reference:

IBM InfoSphere Warehouse                                   YE001
InfoSphere Warehouse with Optim Data Retention             YE001

 
Back to topBack to top
 
Top rule
Overview
Bottom rule

IBM InfoSphere Warehouse is IBM's comprehensive data warehousing platform. It provides a foundation that meets the warehousing solutions needs of small organizations as well as departmental and enterprise businesses. InfoSphere Warehouse delivers a solid return on investment by providing a complete set of capabilities that ensure simple or complex business problems can be solved effectively.

Underpinned by the powerful DB2® platform, InfoSphere Warehouse delivers a foundation for business solutions across a range of server platforms and operating systems. With industry-leading scalability, organizations can fulfill their warehousing vision whether they are starting small and growing or building an advanced enterprise-class warehouse. InfoSphere Warehouse extends the DB2 platform with integrated functionality and tooling that delivers superior scalability and availability, comprehensive design, build, and management tooling, and business analytics.

Innovations in InfoSphere Warehouse 9.7 can help reduce the time to value of warehouse implementations, improve the security, availability, and scalability of warehouses, and increase the ease of implementation and delivery of business analytics. These innovations can help organizations to build a cost-effective and energy-efficient platform that takes advantage of green technologies and cloud-based computing.

InfoSphere Warehouse was formerly known as IBM DB2 Warehouse.


 
Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

Refer to the Technical information section.


 
Back to topBack to top
 
Top rule
Planned availability dates
Bottom rule

June 19, 2009: Electronic software delivery

August 28, 2009: Media and documentation


 
Back to topBack to top
 
Top rule
Description
Bottom rule

Greater storage savings with enhanced deep compression

InfoSphere Warehouse 9.7 expands the scope of its advanced data row compression to more types of data. This can further reduce your storage requirements while improving the efficiency and performance of your disk and IO.

  • XML data in the XML storage object of a table can now be compressed using data row compression.
  • Temporary tables are now automatically compressed by the DB2 optimizer to maximize storage savings and performance.
  • Indexes can be compressed. If data row compression is enabled on a table, indexes on the compressed tables will be compressed by default.
  • Data replication source tables can be compressed.
  • In addition, because some inline large object (LOB) files can now be stored in base table rows, you can use data row compression to compress them as well. When a LOB is smaller than a specified size, the LOB is now stored in the row of the base table instead of in the separate LOB storage object, increasing performance.

Compression is included with InfoSphere Warehouse Enterprise Edition and is available through the Storage Optimization Feature license for InfoSphere Warehouse Enterprise Base Edition.

Analytics that enable business users to obtain deeper insight into their business and discover new opportunities to grow their business

InfoSphere Warehouse 9.7 introduces powerful, self-optimizing time series forecasting. Business users can easily create forecasts to model revenue growth, better predict seasonal sales, and anticipate out-of-stock situations. Visualization is done within a Web 2.0 based user interface. Like all InfoSphere Warehouse data mining functionality, the time series forecasting component resides inside the database allowing for large-scale data processing and easy integration into business processes for automatic forecasting.

New tools can significantly reduce the time and effort for the most time-consuming task of a data mining project, which is data preparation. Data preparation profiles allow people, who know the relevant data to express the necessary data transformations in a natural way - without the need for SQL knowledge or the help of a database administrator.

Easy-to-use solution wizards guide users through the whole process to create a "ready-to-run" mining flow. This significantly reduces the time from problem definition to business insight .

A new Radial Basis Function (RBF) algorithm complements the set of algorithms available for predictive analysis.

Support for virtual cubes and internal performance improvements in Cubing Services give business users more flexibility to perform multi-dimensional OLAP analysis in near real-time with large volumes of data. Fine grained security control in Cubing Services gives organizations the assurance to seamlessly deliver OLAP information across the enterprise wide.

Operational insight with end-to-end support for XML documents

For many organizations, the ability to more effectively integrate XML into their information management environment has become a business necessity. With InfoSphere Warehouse 9.7, organizations now have the ability to manage and analyze large volumes of XML data that were previously locked away in transactional systems.

DB2 pureXML™ technology has been enhanced to support XML data in range partitioned tables, multidimensional clustering (MDC) tables, declared temporary tables, user defined functions, and partitioned database environments. To populate warehouse systems, the SQL Warehousing Tool now supports the extraction, transformation, and publishing of XML data.

The performance of pureXML has also been improved. Multiple XML documents in a column can now be decomposed at the same time. In addition, write access is supported during creation or reorganization of indexes over XML data. Finally, all XML data can now be compressed (refer to the compression enhancements description).

Design Studio and Administration Console enhancements

The Administration Console has been completely redesigned in InfoSphere Warehouse 9.7 to make administration, deployment, and configuration easier. There is now a common interface for database connections and shared resources. The configuration tool has been simplified and relocated to the Administration Console. The new welcome page and launch pad provide links to useful resources and information.

A number of improvements have been made in the Design Studio to improve the overall user experience. The SQL Warehousing Tool now provides lightweight debugging of graphical data flows, automatic change propagation, and copy and paste support. Data can now also be extracted from DB2 for z/OS® and DB2 for i with the SQL Warehousing Tool without additional licenses. Quick start wizards aid in the creation of the Cubing Services cubes and hierarchies. The OLAP menu structure has been simplified and a dimension browser has been added.

In addition, Design Studio now shares the same graphical user interface shell with other IBM Optim and Data Studio tools. This reduces the overall installation footprint and provides a consistent look and feel.

Performance enhancements in DB2 9.7 for Linux®, UNIX®, and Windows®

InfoSphere Warehouse 9.7 is powered by DB2 for Linux, UNIX, and Windows. DB2 9.7 contains numerous performance enhancements benefiting a wide range of database installations.

Access plan reuse helps ensure consistent performance for applications not originally written for ideal database performance. By enabling static SQL access plan reuse, you can ensure that queries execute with predictable performance across version or fix pack upgrades, updates to statistics, and some configuration parameter changes. Access plan reuse keeps the access plan chosen for a static SQL statement the same as, or very similar to, the existing query execution plan across binds or rebinds.

Statement concentration reduces the need for compilation. The statement concentrator enables SQL statements, that are identical except for the values of literals, to share the same access plan.

Sampling RUNSTATS on statistical views run faster in DB2 9.7. The SYSTEM sampling style is now supported and overall sampling performance is better. Optimization guidelines for packages are also easier to apply.

Currently committed locking semantics help the cursor stability (CS) isolation level provide better concurrency and faster access to data. The new locking behavior offers significantly reduced lock wait and deadlock scenarios. The new behavior is beneficial in high-throughput transaction-processing database environments. This new behavior is particularly beneficial if your applications run against databases from multiple vendors. You can use CS instead of writing and maintaining code pertaining to locking semantics specifically for DB2 databases. This new CS behavior is the default for new databases, and can be enabled for existing databases that have upgraded from a previous release.

Scan sharing increases workload concurrency and performance. DB2 allows multiple scanners to coordinate the shared use of buffer pool pages and potentially reduce I/O through buffer pool page retention.

Partitioned indexes on partitioned tables improve performance. With DB2, you can use partitioned indexes to improve performance when you roll data into and out of a table. In addition, partition elimination for queries against a partitioned table that uses partitioned indexes can be more efficient.

Business-critical reliability and availability

You can now invoke a new stored procedure to move the data in a table to a new table object of the same name (but with possibly different storage characteristics) while the data remains online and available for access. You can also generate a new optimal compression dictionary when a table is moved. For systems that are leveraging data partitioning, a new node can be added online to minimize the impact on warehouse environments as the system grows.

It is important for your data warehouse to safeguard your data while maintaining availability. DB2 is now more resilient to critical errors or traps. If the data warehouse server determines that it can safely keep working in the event of a critical error or trap, it will try to isolate the problem and provide targeted diagnostic messages to help resolve the issue. If you need to restart the data warehouse server to fix the problem, you can now wait until after peak business hours.

Simplified administration

InfoSphere Warehouse 9.7 provides enhancements that make it easier to manage DB2 environments, help reduce the total cost of ownership (TCO), reduce the impact of performing system management tasks, and extend the capabilities of the autonomic features.

Automatic storage is even more efficient. Unused storage extents are easier to reclaim. Adding database partitions has been simplified. Finally, enhancements to installation, upgrade, and fix pack procedures make DB2 faster to deploy and easier to maintain.

InfoSphere Warehouse 9.7 accelerates problem solving through new point in time and event monitoring. You can now better understand what is happening inside your data warehouse server by using the new comprehensive monitoring information designed to address common diagnostic problems. Since the new monitoring is also more efficient, this new level of understanding doesn't come at a performance penalty. These enhancements include:

  • New monitor elements, available through SQL, that show where and how the DB2 database manager is spending its time.
  • Improved lock event reporting with a unified approach to monitoring all lock event types.
  • A clearer view into the package cache, including static and dynamic statements.
  • A new event monitor that collects section details when capturing an SQL activity event.

Adaptive workload management

InfoSphere Warehouse 9.7 enhances and simplifies DB2's integrated workload management. Application-level control and aggregate activity data collection, and the definition of workloads have been simplified. For Linux environments, the workload manager has been integrated with Linux workload management (WLM). DB2 9.7 supports priority aging of in-progress activities, I/O buffer pool priority control for service classes, new thresholds, and improved time granularity for time-based thresholds. These new controls will allow you to let DB2 react for them as workloads reach certain thresholds. DB2 can then either increase or decrease the priority of the workload ensuring that both runaway queries don't overwhelm a system and that key workloads under tight service level agreements get priority.

A new graphic user interface that streamlines the configuration of workload management has been added to InfoSphere Warehouse. Using the interface, you can define workloads, assign business priorities, and enable priority aging to ensure appropriate concurrency controls are applied.

Workload Management is included with InfoSphere Warehouse Departmental and Enterprise editions and is available through the Performance Optimization Feature license for InfoSphere Warehouse Enterprise Base Edition.

Security enhancements

With the number of both internal and external security threats growing, it is important that database security can be set up separately from a database administrator's (DBAs) control for critical systems. Advances in separation of duties are designed to let you allow DBAs full control over a database while preventing access to the data. You can also easily isolate all security and audit controls to a separate security administrator. Security has further been simplified with new groups making application development privileges as well as workload management simpler. Additionally, security functionality has been extended with AES encryption, Transport Layer Security (TLS), and additional Secure Sockets Layer (SSL) client support.

Application development flexibility

Significant application development enhancements have been added in InfoSphere Warehouse 9.7. These enhancements will accelerate the creation and modification of warehouse applications and allow developers with multiple SQL language skills to work easily with DB2.

Stored procedures and triggers can now be created in less time. The enhancements include more support for implicit casting, the creation of modules, new functions, and a range of new data types.

Module and package creation allows developers to bundle and deploy groups of procedures, functions, and variables. A large number of new, pre-written, system-defined functions and modules simplify the creation of custom administration scripts. Examples of some of the new modules are listed below.

  • Mail - Easily send e-mails and interact with an SMTP server or sockets.
  • Alert and output - The output package will give DBAs the ability to manipulate files as well as write to external files. This is very useful for administrative scripting, debugging, and application deployment. The alert package can be combined with the output module to build custom monitoring and batch scripts.
  • Job scheduling and utility - The job scheduling package can be used within existing scripts to automate job scheduling and tracking. Combine this with the new utility package for greater hands-free execution of a wide range of utilities, SQL statements, and commands.
  • File - Working with LOBs and files is now easier with the functions included in the file manipulation package.

DB2 9.7 introduces new data type support for NUMBER, VARCHAR2, and DATE with time component. To make data management more compatible with other database management systems, you can now use the NUMBER and VARCHAR2 data types. You can also have the database manager interpret the DATE data type (normally comprised of year, month, day) as a TIMESTAMP(0) data type (comprised of year, month, day, hour, minute, second). Improvements in string manipulation functions, such as TO_NUMBER, DATETIME and TO_VARCHAR, will make developing against the new data times easy.

Alternative SQL language syntax is supported including alternative SQL language syntax for DELETE statements, the RID_BIT scalar function, the FOR UPDATE clause for SELECT INTO statements, and alternative SQL programming language syntax for triggers and procedures. Alternative SQL syntax, such as varying outer join methods, is now supported.

DB2 9.7 has new application and administrative interfaces to simplify development.

  • A new scripting and command line development tool, CLPPlus, provides support for dynamically creating, editing, and running SQL statements and scripts.
  • Data dictionary views are now available that enhance the existing DB2 catalog and snapshot information. The data dictionary views are self-describing, so you can determine what information is available and how to access it.

Full-text searches with Net Search Extender are available in DB2 9.7 for range-partitioned tables and additional partitioned database environments.

Accessing IBM database management systems (DB2 and Informix®) is easier than ever. The common IBM data server clients and drivers have been enhanced and simplified, as have the IBM Database Add-Ins for Visual Studio and new Python extensions.

Autonomous transaction support and the ability to create global temporary tables expands DB2 capabilities. In addition to federating data from DB2 and IDS databases, DB2 9.7 now supports Web services through federation.

InfoSphere Warehouse Editions

The following table outlines the features of the core editions of InfoSphere Warehouse 9.7:

             Departmental Departmental Enterprise   Enterprise
             Base                      Base
 
DB2          Included     Included     Included     Included
 Enterprise
 Server
 Edition
DB2          Included     Included     Included     Included
 Database
 Partitioning
Unlimited    Included     Included     Included     Included
 Database
 Size
Design       Included     Included     Included     Included
 Studio
SQL          Included     Included     Included     Included
 Warehousing
 Tool
Administrati Included     Included     Included     Included
 on Console
Cubing       Included     Included     Included     Included
 Services
InfoSphere   Included     Included     Included     Included
 Federation
 Server
 Relational
 Wrappers
Intelligent  NA           Included     NA           Included
 Miner
 Modeling,
 Scoring,
 and
 MiningBlox
Text         NA           Included     NA           Included
 Analytics
DB2          NA           Included     NA           Included
 Alphablox
 including
 BloxBuilder
DB2          NA           NA           NA           Included
 Alphablox
 Connectors
DB2          NA           Included     DB2          Included
 Workload                               Performance
 Management                             Optimization
                                        Feature
DB2 Query    NA           NA           DB2          Included
 Patroller                              Performance
                                        Optimization
                                        Feature
DB2          NA           NA           DB2          Included
 Performance                            Performance
 Expert                                 Optimization
                                        Feature
Deep         NA           NA           DB2 Storage  Included
 Compression                            Optimization
                                        Feature
Maximum DB2  4 sockets    4 sockets    Unrestricted Unrestricted
 server CPU                                          
Maximum DB2  32 GB        32 GB        Unrestricted Unrestricted
 instance                                            
 memory

InfoSphere Warehouse Developer Edition is also available. The edition provides the same content and functionality as the InfoSphere Warehouse Enterprise Edition. It is licensed with terms and conditions for the purposes of evaluating, demonstrating, testing, and developing application programs.

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 customers. With these features, you can extend your DB2 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.

The separately purchasable IBM Homogeneous Replication Feature for DB2 Enterprise Server Edition is available for the following products:

  • InfoSphere Warehouse Enterprise Base Edition
  • InfoSphere Warehouse Enterprise Edition
  • InfoSphere Warehouse with Optim Data Retention
  • Base Warehouse Feature for DB2
  • Enterprise Warehouse Feature for DB2

The separately purchasable IBM DB2 Geodetic Data Management Feature is available for the following products:

  • InfoSphere Warehouse Enterprise Base Edition
  • InfoSphere Warehouse Enterprise Edition
  • InfoSphere Warehouse with Optim Data Retention
  • Base Warehouse Feature for DB2
  • Enterprise Warehouse Feature for DB2

The separately purchasable DB2 Advanced Access Control Feature is available for the following products:

  • InfoSphere Warehouse Enterprise Base Edition, and Enterprise Edition
  • InfoSphere Warehouse with Optim Data Retention
  • Base Warehouse Feature for DB2
  • Enterprise Warehouse Feature for DB2

The separately purchasable DB2 Performance Optimization Feature for Enterprise Server Edition and the DB2 Storage Optimization Feature remain available for the following products:

  • InfoSphere Warehouse Enterprise Base Edition
  • Base Warehouse Feature for DB2

For more detailed information about the benefits of InfoSphere Warehouse, visit

http://www.ibm.com/software/data/infosphere/warehouse/

Notes:

  1. The InfoSphere Warehouse Base Edition has been renamed InfoSphere Warehouse Enterprise Base Edition.
  2. Cognos 8 BI Starter Edition has been withdrawn and is not available in InfoSphere Warehouse 9.7.

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) can be requested via the IBM Web site

http://www.ibm.com/able/product_accessibility/index.html

Section 508 of the U.S. Rehabilitation Act

The products in this announcement are capable as of August 28, 2009 , when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. A U.S. Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested on the following Web site

http://www.ibm.com/able/product_accessibility/index.html

 
Back to topBack to top
 
Top rule
Product positioning
Bottom rule

Offerings for departmental systems

InfoSphere Warehouse 9.7 Departmental Base Edition is ideal for small and medium businesses or departments that require the ability to transform data into reliable and consistent business insights. It contains the foundation components of the enterprise editions of InfoSphere Warehouse at an affordable entry point. Departmental Base Edition supports business intelligence (BI) applications and analytic tools, and can scale from one to many database partitions.

Program charges: Departmental Base Edition can be deployed on Linux and Windows up to a maximum of four sockets. It is available in per authorized user and limited use socket pricing models. You must acquire a separate user license for each authorized user of this product with a minimum purchase of 20 users per socket.

InfoSphere Warehouse 9.7 Departmental Edition extends the capabilities of the Departmental Base Edition with mixed workload management capabilities and advanced analytics such as data mining, modeling, and scoring, text analytics, and Alphablox. It is ideal for organizations and departments that have moved beyond basic query and reporting, and need the necessary tools to discover new business opportunities.

Program charges: Departmental Edition can be deployed on Linux, UNIX, and Windows up to a maximum of four sockets. It is available in per authorized user and limited use socket pricing models. You must acquire a separate user license for each authorized user of this product with a minimum purchase of 30 users per socket.

Offerings for enterprise-class data warehouses

InfoSphere Warehouse 9.7 Enterprise Base Edition provides medium to large organizations with a scalable infrastructure for large data marts and enterprise-scale data warehouses. Unlike the departmental editions, deployment of Enterprise Base Edition is not limited to any number of processors. This edition was formerly called InfoSphere Warehouse Base Edition.

Program charges: Enterprise Base Edition can be deployed to any number of processors on Linux, UNIX, and Windows platforms. It is available through the Processor Value Unit and On/Off Capacity on Demand (OOCoD) pricing models.

InfoSphere Warehouse 9.7 Enterprise Edition is ideal for enterprise-scale data warehouses in medium to large organizations that need require scalability and manageability along with a complete range of analytic capabilities. By including all the options in this version, IBM provides a complete enterprise offering at a cost that is substantially less than the sum of its components, providing real value on price and completeness of solution.

With the benefit of advanced analytics such as data mining, modeling, and scoring, text analytics, and Alphablox, the InfoSphere Warehouse Enterprise Editions provides the perfect foundation for building enterprise real-time analytics, opening up sophisticated analysis to all warehouse users. Plus, the performance and storage optimization features can make building and managing a large data warehouse more affordable and can significantly reduce the cost of ownership.

Program charges: Enterprise Edition can be deployed to any number of processors on Linux, UNIX, and Windows platforms. It is available through the Processor Value Unit and On/Off Capacity on Demand (OOCoD) pricing models.

Specialty offerings

InfoSphere Warehouse 9.7 Developer Edition offers a package for a single application developer to design, build, test, and demonstrate applications for deployment on any InfoSphere Warehouse edition. The package has the same content and functionality as the InfoSphere Warehouse Enterprise Edition.

Program charges: The software in this package cannot be used for production systems. You must acquire a separate user license for each authorized user of this product.

InfoSphere Warehouse with Optim Data Retention 9.7 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.

Program charges: Enterprise Edition can be deployed to any number of processors on Linux, UNIX, and Windows platforms. It is available through the Processor Value Unit pricing model.

IBM Base Warehouse Feature for DB2 provides an upgrade path for existing DB2 customers. This optional feature adds all the capabilities of InfoSphere Warehouse Enterprise Base Edition, including database partitioning, to an existing DB2 Enterprise Server deployment.

Program charges: Base Warehouse Feature for DB2 can be deployed to any number of processors on Linux, UNIX, and Windows platforms. It is available through the Processor Value Unit and On/Off Capacity on Demand (OOCoD) pricing models.

IBM Enterprise Warehouse Feature for DB2 provides an upgrade path for existing DB2 customers. This optional feature adds all the capabilities of InfoSphere Warehouse Enterprise Edition, including database partitioning, storage and performance optimization, and advanced analytics, to an existing DB2 Enterprise Server deployment.

Program charges: Enterprise Warehouse Feature for DB2 can be deployed to any number of processors on Linux, UNIX, and Windows platforms. It is available through the Processor Value Unit and On/Off Capacity on Demand (OOCoD) pricing models.

Positioning with other IBM warehouse offerings

InfoSphere Warehouse continues to be IBM's flagship data warehouse platform for departmental data marts and enterprise data warehouses. In addition, IBM provides warehouse offerings for existing customers using DB2 for z/OS and Informix.

InfoSphere Warehouse on System z® is for existing DB2 for z/OS customers who need a highly scalable, highly resilient, lower cost infrastructure to optimize a data warehouse for business intelligence (BI) applications. Unlike competitors who do not offer an offering on System z, InfoSphere Warehouse on System z:

  • Provides a highly scalable, lower cost way to design, populate, and optimize a DB2 for z/OS data warehouse to support BI applications.
  • Simplifies operational complexity through deployment of both operational and warehouse data on a single platform.
  • Helps save money by potentially reducing costs associated with data movement and by providing more efficient access to DB2 data.
  • Significantly improves query performance through no-copy analytics and support for Multidimensional (MDX) queries to optimize BI applications such as Cognos.

Informix Warehouse is for Informix customers who want a single Informix platform for their operational and warehouse data. Informix Warehouse is an integrated warehouse solution that provides tools for design and modeling, embedded data movement and transformation, and administration and control. It leverages Informix enterprise replication capabilities to distribute operational data in real time for just in time analysis and time critical business decisions. It also leverages existing hardware and Informix software investments to build integrated warehouse solutions enabling you to unlock greater business value from your data at a potentially lower cost.

Availability of national languages

Product description            Language        GA date
 
Base Warehouse Feat DB2        Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)
Entpr Warehouse Feat DB2       Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)
IS Wh Dept Base Ed Sckt Opt    Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)
IS Whse Base Edition V9.7.0    Multilingual    August 28, 2009
                                (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whse Departmental Edition   Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whse Dept Base Edition      Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whse Dept Ed Socket Opt     Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)
IS Whse Developer Edition      Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whse Enterprise Edition     Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whse with Optim Data Ret    Multilingual    August 28, 2009
 V9.7.0                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)

 
Back to topBack to top
 
Top rule
Program number
Bottom rule

Program    VRM                          Program name
number
 
5724-E34   9.7.0                        IBM InfoSphere Warehouse
5724-U85   9.7.0                        IBM InfoSphere Warehouse
                                         with Optim Data Retention

 
Back to topBack to top
 
Top rule
Education support
Bottom rule

IBM training provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM training Web site

http://www.ibm.com/services/learning/

Call IBM training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.

The following InfoSphere Warehouse courses are currently available. Check with your country's Information Management Training and Education Web site or contact person to determine exactly when the new course material will be available.

Information Management Training is now offering some of our most popular courses in a new learning format, instructor-led online (ILO). With this new format, you get the benefits of being in a classroom with the convenience and cost savings of online training.

Courses

The following educational offerings are available:

Category         Course           Course title     Course type
                 code
 
Introduction     DW03             Changing         Classroom
 courses                           Business with
                                   Data Insight
                 3W03             Changing         Instructor Led
                                   Business with    Online
                                   Data Insight
                 DW11             Architecting     Classroom
                                   the Data
                                   Warehouse
Intermediate     DW31             IBM Alphablox    Classroom
 courses                           Essentials and
                                   Blox Builder
                 3W31             IBM Alphablox    Instructor Led
                                   Essentials and   Online
                                   Blox Builder
                 DW32             Managing         Classroom
                                   Workloads for
                                   DB2 LUW and
                                   InfoSphere
                                   Warehouse
                 3W32             Managing         Instructor Led
                                   Workloads for    Online
                                   DB2 LUW and
                                   InfoSphere
                                   Warehouse
Advanced         DW12             Advanced Data    Classroom
 courses                           Warehousing
                                   Workshop:
                                   Multi-Dimensiona
                                   l Modeling
                 DW35             InfoSphere       Classroom
                                   Warehouse 9
                                   Components
                 3WA51            InfoSphere       Instructor Led
                                   Warehouse 9 -    Online
                                   SQL Warehouse
                                   Tool and
                                   Administration
                                   Console
                 3WB51            InfoSphere       Instructor Led
                                   Warehouse 9 -    Online
                                   Cubing Service
                 3WC51            InfoSphere       Instructor Led
                                   Warehouse 9 -    Online
                                   Data Mining and
                                   Unstructured
                                   Text Analysis
                 3W35             InfoSphere       Instructor Led
                                   Warehouse 9      Online
                                   Components

IBM Redbooks®

IBM Redbooks offer extensive technical insight from IBM and industry experts. These books highlight real-time experiences, and include sample code, typical scenarios, and step-by-step, "how-to" guidelines.

IBM form no.                      Title
 
SG24-7418-00                      Dynamic Warehousing: Data
                                   Mining Made Easy
SG24-7138-00                      Dimensional Modeling: In a
                                   Business Intelligence
                                   Environment
SG24-7274-00                      Leveraging DB2 Data Warehouse
                                   Edition for Business
                                   Intelligence
SG24-7104-00                      Moving Forward with the On
                                   Demand Real-time Enterprise
SG24-2238-00                      Data Modeling Techniques for
                                   Data Warehousing
SG24-5174-00                      From Multiplatform Operational
                                   Data to Data Warehousing and
                                   Business Intelligence
SG24-7582-00                      InfoSphere Warehouse: Cubing
                                   Services and Client Access
                                   Interfaces

IBM training provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are available at

http://www.ibm.com/services/learning/ites.wss/tp/en?pageType=tp_search

 
Back to topBack to top
 
Top rule
Offering Information
Bottom rule

Product information is available via the Offering Information Web site

http://www.ibm.com/common/ssi

Also, visit the Passport Advantage® Web site

http://www.ibm.com/software/passportadvantage

 
Back to topBack to top
 
Top rule
Publications
Bottom rule

No hardcopy publications are shipped with these products.

The IBM Publications Center

http://www.ibm.com/shop/publications/order

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries.

The InfoSphere Warehouse Installation Guide is available in PDF format in the Publications Center.

The InfoSphere Warehouse 9.7 information is included in the DB2 9.7 Information Center.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

The following information is available for InfoSphere Warehouse:

  • Overview of InfoSphere Warehouse
  • Installing InfoSphere Warehouse
  • Migrating InfoSphere Warehouse
  • Configuring InfoSphere Warehouse
  • Tutorials
  • Transforming data
  • Data mining and analysis
  • OLAP and cubing
  • Analytics and reporting
  • Workload management
  • Reference
  • Messages

 
Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

System requirements

InfoSphere Warehouse has a component-based architecture that consists of three component groups: a data server, an application server, and a client. In a typical production environment, you install each of these component groups on different computers to form a complete warehousing solution.

The system requirements for InfoSphere Warehouse may be occasionally updated. To obtain the most current information visit

http://www.ibm.com/software/data/infosphere/warehouse/sysreqs.html

Requirements for the data server components

The data warehouse server components of InfoSphere Warehouse have requirements for hardware, software, disk space, and memory.

Operating system and hardware requirements

AIX®

  • AIX V5.3 (64-bit only)
  • AIX V6.1 (64-bit only)

HP-UX

  • HP-UX 11i v2 for 64-bit HP Integrity servers (Itanium-based systems)
  • HP-UX 11i v3 for 64-bit HP Integrity servers (Itanium-based systems)

Linux

  • Red Hat Enterprise Linux (RHEL) 5 on 64-bit AMD and Intel® x86-64 systems
  • SUSE Linux Enterprise Server (SLES) 10 on 64-bit AMD and Intel x86-64 systems

Solaris

  • Solaris 9 for UltraSPARC servers (64-bit only)
  • Solaris 10 for UltraSPARC servers (64-bit only)
  • Solaris 10 for x64 servers

Windows

  • Windows 2003 Standard, Enterprise, and Datacenter Editions (32 bit and 64 bit)
  • Windows 2008 Standard, Enterprise, and Datacenter Editions (32 bit and 64 bit)

Web browser requirements

Ensure that you have one of the following browsers on your computer:

  • Internet Explorer V7.0
  • Internet Explorer V6.0 with SP 1
  • Firefox V3.0
  • Firefox V2.0

Disk space requirements

Temporary space for installable images: If you are a Passport Advantage customer, before you can install the product, you must download the installation images to the target computer. These images contain the installation executable files for the components that you are installing. The temporary space that is required for these images is different from the space that is required to run the installation program. Approximately 1.2 GB of disk space is recommended for the installation images of the data server components. If you also download the installation images for the client components on the same computer, you need a total of 2.5 GB of disk space.

Temporary space for running the installation program: Approximately 1.5 GB of disk space is recommended.

Permanent space for the installed components:

  • On Windows, approximately 1 GB of disk space is recommended for the installation directory of the data server components.
  • On Linux and UNIX, approximately 1.4 GB of disk space is recommended for the installation directory of the data server components.

Memory requirements

Memory for installing the product: A minimum of 512 MB of memory is required to install the data server components.

Memory for running the product: A minimum of 1 GB of memory is the required to run the data server components. If you run the client components on the same computer, 2 GB of memory is recommended.

Requirements for the application server components

The application server components of InfoSphere Warehouse have requirements for hardware, software, disk space, and memory.

For detailed information about supported hardware and software for WebSphere®, visit

http://www.ibm.com/software/webservers/appserv/doc/latest/prereq.html

Operating system and hardware requirements

AIX

  • AIX V5.3 (64-bit only)
  • AIX V6.1 (64-bit only)

HP-UX

  • HP-UX 11i v2 for 64-bit HP Integrity servers (Itanium-based systems)
  • HP-UX 11i v3 for 64-bit HP Integrity servers (Itanium-based systems)

Linux

  • Red Hat Enterprise Linux (RHEL) 5 on 64-bit AMD and Intel x86-64 systems
  • SUSE Linux Enterprise Server (SLES) 10 on 64-bit AMD and Intel x86-64 systems

Solaris

  • Solaris 9 for UltraSPARC servers (64-bit only)
  • Solaris 10 for UltraSPARC servers (64-bit only)
  • Solaris 10 for x64 servers

Windows

  • Windows 2003 Standard, Enterprise, and Datacenter Editions (32 bit and 64 bit)
  • Windows 2008 Standard, Enterprise, and Datacenter Editions (32 bit and 64 bit)

Web browser requirements

Ensure that you have one of the following browsers on your computer:

  • Internet Explorer V7.0
  • Internet Explorer V6.0 with SP 1
  • Firefox V3.0
  • Firefox V2.0

Disk space requirements

Temporary space for installable images: If you are a Passport Advantage customer, before you can install the product, you must download the installation images to the target computer. These images contain the installation executable files for the components that you are installing. The temporary space that is required for these images is different from the space that is required to run the installation program. Approximately 1.2 GB of disk space is recommended for the installation images of the application server components. If you also download the installation images for the client components on the same computer, you need a total of 2.5 GB of disk space.

Temporary space for running the installation program: Approximately 1.5 GB of disk space is recommended.

Permanent space for the installed components:

  • On Windows, approximately 1 GB of disk space is recommended for the installation directory of the application server components. If you install the client components on the same computer, you need a total of 3 GB of disk space.
  • On Linux and UNIX, approximately 1.4 GB of disk space is recommended for the installation directory of the application server components. If you install the client components on the same computer, you need a total of 3.4 GB of disk space.

Memory requirements

Memory for installing the product: A minimum of 512 MB of memory is required to install the application server components.

Memory for running the product: A minimum of 1 GB of memory is the required to run the application server components. If you run the client components on the same computer, 2 GB of memory is recommended.

Requirements for the client components

The client components of InfoSphere Warehouse have requirements for hardware, software, disk space, and memory.

Operating system and hardware requirements

Linux

  • Red Hat Enterprise Linux (RHEL) 5 on 32-bit AMD and Intel x86 systems
  • SUSE Linux Enterprise Server (SLES) 10 on 32-bit AMD and Intel x86 systems

Windows

  • Windows XP Professional Edition 32 bit
  • Windows Vista Business, Enterprise, and Ultimate Editions 32 bit

Web browser requirements

Ensure that you have one of the following browsers on your computer:

  • Internet Explorer V7.0
  • Internet Explorer V6.0 with SP 1
  • Firefox V3.0
  • Firefox V2.0

Disk space requirements

Temporary space for installable images: If you are a Passport Advantage customer, before you can install the product, you must download the installation images to the target computer. These images contain the installation executable files for the components that you are installing. The temporary space that is required for these images is different from the space that is required to run the installation program. Approximately 1.5 GB of temporary disk space is recommended for the installation images of the client components.

Temporary space for running the installation program: Approximately 500 MB of disk space is recommended to run the installation program.

Permanent space for the installed components: Approximately 2 GB of disk space is recommended for the installed product.

Memory requirements

Memory for installing the product: Approximately 1 GB of memory is recommended to install the client components.

Memory for running the product: Approximately 1 GB of memory is recommended to run the client components.

Software information

For a current list of supported operating systems, refer to the IBM InfoSphere Warehouse Web site

http://www.ibm.com/software/data/infosphere/warehouse/sysreqs.html

The program's specifications and specified operating environment information may be found in documentation accompanying the program, if available, such as a README file, or other information published by IBM, such as an announcement letter. Documentation and other program content may be supplied only in the English language.

Planning information

Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support (also referred to as Software Maintenance) offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software, and technical support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Subscription and Support (also referred to as Software Maintenance) with each program license acquired. The initial period of Software Subscription and Support (also referred to as Software Maintenance) can be extended by the purchase of a renewal option, if available.

Packaging

Notes:

  • The InfoSphere Warehouse Server DVDs include Enterprise Server Edition, applicable DB2 Feature entitlements, InfoSphere Warehouse components, and WebSphere Application Server.
  • The InfoSphere Warehouse Client DVDs include IBM Data Server Client, InfoSphere Warehouse components, and samples.

IBM InfoSphere Warehouse 9.7, Departmental Base Edition - Authorized User and Socket options

  • IBM InfoSphere Warehouse Departmental Base Edition Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM Tivoli® System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD

IBM InfoSphere Warehouse 9.7, Departmental Edition - Authorized User and Socket options

  • IBM InfoSphere Warehouse Departmental Edition Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for AIX DVD
  • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM Alphablox DVD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD

IBM InfoSphere Warehouse 9.7, Enterprise Base Edition

  • IBM InfoSphere Warehouse Enterprise Base Edition Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for AIX DVD
  • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM Alphablox DVD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Enterprise Server Edition for Linux on POWER™ (System i® and System p®) systems DVD
  • IBM DB2 Enterprise Server Edition for Linux on System z DVD

IBM InfoSphere Warehouse 9.7, Enterprise Edition

  • IBM InfoSphere Warehouse Enterprise Edition Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for AIX DVD
  • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM Alphablox DVD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
  • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
  • IBM DB2 Performance Expert for Multiplatforms (Linux on System z, Linux on POWER (System i and System p) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD

IBM InfoSphere Warehouse 9.7, Developer Edition

  • IBM InfoSphere Warehouse Developer Edition Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for AIX DVD
  • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel Systems (x86) DVD
  • IBM Alphablox DVD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
  • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
  • IBM DB2 Performance Expert for Multiplatforms (Linux on System z, Linux on POWER (System i and System p) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD

IBM InfoSphere Warehouse 9.7, with Optim Data Retention

  • Overriding hardcopy license
  • IBM InfoSphere Warehouse 9.7, Enterprise Edition
    • IBM InfoSphere Warehouse Enterprise Edition Quick Start and Activation CD
    • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
    • IBM InfoSphere Warehouse Server for AIX DVD
    • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
    • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
    • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
    • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
    • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
    • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
    • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
    • IBM Alphablox DVD
    • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
    • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
    • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
    • IBM DB2 Performance Expert for Multiplatforms (Linux on System z, Linux on POWER (System i and System p) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD
  • Optim Data Growth Solution V7.1.1
    • IBM Optim Data Growth Solution V7.1.1 - Activation CD
    • IBM Optim Data Growth Solution V7.1.1 for Windows, for Multiplatforms CD
    • IBM Optim Data Growth Solution V7.1.1 for AIX CD
    • IBM Optim Data Growth Solution V7.1.1 for Solaris on UltraSPARC systems CD
    • IBM Optim Data Growth Solution V7.1.1 for Linux CD

IBM Base Warehouse Feature for DB2 9.7

  • IBM Base Warehouse Feature for DB2 Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for AIX DVD
  • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD

IBM Enterprise Warehouse Feature for DB2 9.7

  • IBM Enterprise Warehouse Feature for DB2 Quick Start and Activation CD
  • IBM InfoSphere Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM InfoSphere Warehouse Server for AIX DVD
  • IBM InfoSphere Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM InfoSphere Warehouse Server for Solaris on x64 systems DVD
  • IBM InfoSphere Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM InfoSphere Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM InfoSphere Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
  • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
  • IBM DB2 Performance Expert for Multiplatforms (Linux on System z, Linux on POWER (System i and System p) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD

Security, auditability, and control

The IBM products listed in this announcement use the security and auditability features of the host software.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.


 
Back to topBack to top
 
Top rule
Software Services
Bottom rule

IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an extensive portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support a wide range of critical business needs.

To learn more about IBM Software Services or to contact a Software Services sales specialist, visit

http://www.ibm.com/software/sw-services/

 
Back to topBack to top
 
Top rule
Ordering information
Bottom rule

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Product information

Licensed function title             Product group   Product
                                                    category
 
IBM Base Warehouse Feature for DB2 IBM Database    IBM InfoSphere
                                     Management      Warehouse
                                     Other
IBM Enterprise Warehouse Feature    IBM Database    IBM InfoSphere
 for DB2                             Management      Warehouse
                                     Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Departmental Base Edition           Management      Warehouse
 Authorized User Option              Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Departmental Base Edition Socket    Management      Warehouse
 Option                              Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Departmental Edition Authorized     Management      Warehouse
 User Option                         Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Departmental Edition Socket Option  Management      Warehouse
                                     Other
IBM InfoSphere Warehouse Developer  IBM Database    IBM InfoSphere
 Edition                             Management      Warehouse
                                     Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Enterprise Base Edition             Management      Warehouse
                                     Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Enterprise Edition                  Management      Warehouse
                                     Other
IBM InfoSphere Warehouse with       IBM Database 2™  DB2
 Optim Data Retention
Program name                          PID        Charge unit
                                      number     description
 
IBM Base Warehouse Feature for DB2    5724-E34   Processor-Days
IBM Base Warehouse Feature for DB2    5724-E34   Per Processor
                                                  Value Unit (PVU)
IBM Enterprise Warehouse Feature for  5724-E34   Per Processor
 DB2                                              Value Unit (PVU)
IBM Enterprise Warehouse Feature for  5724-E34   Processor-Days
 DB2
IBM InfoSphere Warehouse              5724-E34   PA Per
 Departmental Base Edition Authorized             Authorized User
 User Option
IBM InfoSphere Warehouse              5724-E34   Per Limited Use
 Departmental Base Edition Socket                 Socket
 Option
IBM InfoSphere Warehouse              5724-E34   PA Per
 Departmental Edition Authorized User             Authorized User
 Option
IBM InfoSphere Warehouse              5724-E34   Per Limited Use
 Departmental Edition Socket Option               Socket
IBM InfoSphere Warehouse Developer    5724-E34   PA Per
 Edition                                          Authorized User
IBM InfoSphere Warehouse Enterprise   5724-E34   Per Processor
 Base Edition                                     Value Unit (PVU)
IBM InfoSphere Warehouse Enterprise   5724-E34   Processor-Days
 Base Edition
IBM InfoSphere Warehouse Enterprise   5724-E34   Processor-Days
 Edition
IBM InfoSphere Warehouse Enterprise   5724-E34   Per Processor
 Edition                                          Value Unit (PVU)
IBM InfoSphere Warehouse with Optim   5724-U85   Per Processor
 Data Retention                                   Value Unit (PVU)

Charge metrics definitions

Processor Value Unit (PVU)

PVU is a unit of measure by which the program can be licensed. PVU entitlements are based on processor technology (defined within the PVU table* by processor vendor, brand, type, and model number). IBM defines a processor, for purposes of PVU-based licensing, to be each processor core on a chip. Each software product has a unique price per PVU. To determine the total cost of deploying an individual software product in a specific hardware environment, you must take the following steps:

  1. For each processor core in the hardware environment on which the software product is to be licensed, determine the PVU requirement based on its processor technology per the PVU table*.
  2. Add the PVU requirements for all processor cores in the hardware environment.
  3. Multiply the software product's price per PVU by the total number of PVUs required as determined in step 2 above.

PVU entitlements are specific to the program and may not be exchanged, interchanged, or aggregated with PVU entitlements of another software product.

Unless the program and your environment are each eligible for sub-capacity licensing according to the IBM International Passport Advantage Agreement Attachment for Sub-Capacity Licensing Terms (the "Attachment")**, You must obtain PVU Proofs of Entitlement (PoEs) for the maximum number of activated*** physical processor cores in the hardware environment made available to or managed by the program. This is also referred to as full capacity licensing.

*PVU licensing is subject to additional details and terms, including the latest PVU requirements table, described at

http://www.ibm.com/software/lotus/passportadvantage/pvu_licensing_for_customers.html

**Passport Advantage sub-capacity licensing terms, conditions and eligibility requirements are described at

http://www-01.ibm.com/software/lotus/passportadvantage/subcaplicensing.html

***Activated processor cores are physical processor cores that are available for use in a server. They include processor cores:

  1. That are activated (available for use) when the server is shipped by the manufacturer, and
  2. That are activated subsequently through activation codes purchased from the server manufacturer by the customer.

In each case regardless of whether the capacity of the processor cores can be or is limited by the customer through virtualization technologies, operating system commands, or BIOS settings.

This program is eligible for sub-capacity licensing. In order to take advantage of sub-capacity licensing, your virtualization environment must meet the eligibility requirements described in the IBM International Passport Advantage Agreement Attachment for Sub-Capacity Licensing Terms (the "Attachment"), and you must accept the terms of the Attachment. You must obtain PVU PoEs for the maximum processor core capacity available to the program when deployed in an eligible virtualization environment. This is also referred to as sub-capacity or virtualization capacity licensing.

Customers must use the IBM License Metric Tool unless they meet the exceptions described in the Attachment.

Additional details regarding Passport Advantage sub-capacity licensing terms, conditions, and eligibility requirements, including the Attachment and IBM License Metric Tool ordering information, are described at

http://www.ibm.com/software/lotus/passportadvantage/subcaplicensing.html

Authorized User

Authorized User is the unit of measure by which this program is licensed. An Authorized User is an individual (named or unnamed) within or outside of your enterprise. The program may be installed on one or more computers or servers and accessed by the number of users authorized by the PoE. You must have an entitlement for each Authorized User accessing the program or any program component in any manner directly or indirectly (for example, via a multiplexing program, device, or application server) through any means.

Processor Day

On/Off Capacity on Demand (OOCoD) extends the use of a perpetual license on a term basis when a peak situation occurs in a customer environment. OOCoD provides for daily temporary use of additional capacity when it is required by a customer. This is measured in Processor Days which is defined as the number of physical processor cores that are activated to increase temporary capacity on a server during a contiguous 24-hour period, beginning at the time when temporary capacity is initiated. Processor core usage is measured in day increments and is independent of the time of the day used. At initial activation, each processor core being used is charged for one day of use; software charges are incurred on a daily basis for each processor core that has been activated on a temporary basis for every IBM middleware program that is loaded on that server. An additional charge of a processor day is made for each 24 hours of continuous usage after the initial charge.

Limited Use Socket (LU Socket)

This program is licensed on a LU Socket basis, as follows. You must: (1) acquire a one LU Socket entitlement for each socket on the server on which the program is installed, and (2) comply with the resource use restrictions further defined below in this License Information. A server is a single physical computer that executes requested procedures, commands, or applications to one or more user or client devices. Where blade technology is employed, each blade is considered a separate server. A socket is electronic circuitry that accepts a processor chip. A processor chip is electronic circuitry containing one or more processor cores that plugs into a socket. A processor core is a functional unit within a computing device that interprets and executes program instructions, and consists of at least an instruction control unit and one or more arithmetic or logic units.

This program is eligible for sub-capacity licensing, and you may be permitted to license less than all sockets on the server. Sub-capacity licensing terms, conditions and eligibility requirements for LU Socket-charged products are described at

ftp://ftp.software.ibm.com/software/smb/pdfs/LicensingGuide.pdf

If your use of the program is not eligible for sub-capacity licensing based on these terms and conditions, You must acquire LU Socket entitlements for all sockets on the server on which the program is installed. The LU Socket entitlements are specific to the program and may not be exchanged, interchanged, or aggregated with LU Socket entitlements of another software program.

Passport Advantage program licenses

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Enterprise Base Edition
InfoSphere Whse Ent Base Ed Per Processor Value Unit     E02GULL
 (PVU) Annual SW S&S R
InfoSphere Whse Ent Base Ed Per Processor Value Unit     D57U9LL
 (PVU) Lic + SW S&S 12
InfoSphere Whse Ent Base Ed Per Processor Value Unit     D57UALL
 (PVU) SW S&S Reinstat

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Developer Edition
InfoSphere Whse Developer Ed Authorized Users   License  D59QFLL
 & SW Maintenance 1
InfoSphere Whse Developer Ed Authorized Users SW         D59QILL
 Maintenance Reinstateme
InfoSphere Whse Developer Ed Authorized Users SW         E033KLL
 Maintenance Rnwl

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM Base Warehouse Feature for DB2
Base Warehouse Feature DB2 Per Processor Value Unit      E047LLL
 (PVU) Annual SW S&S Rn
Base Warehouse Feature DB2 Per Processor Value Unit      D61VLLL
 (PVU) Lic + SW S&S 12
Base Warehouse Feature DB2 Per Processor Value Unit      D61VMLL
 (PVU) SW S&S Reinstate

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM Enterprise Warehouse Feature for DB2
IBM Entpris Whse Feature DB2 Per Processor Value Unit    E047MLL
 (PVU) Annual SW S&S
IBM Entpris Whse Feature DB2 Per Processor Value Unit    D61VNLL
 (PVU) Lic + SW S&S 1
IBM Entpris Whse Feature DB2 Per Processor Value Unit    D61VPLL
 (PVU) SW S&S Reinsta

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Departmental Edition Socket
 Option
IS Whse Dept Ed Skt Opt Limited Use Socket Lic + SW S&S  D09VALL
 12 Mo
IS Whse Dept Ed Skt Opt Limited Use Socket SW S&S        D09VBLL
 Reinstate 12 Mo
IS Whse Dept Ed Socket Opt Per Limited Use Socket        E07AILL
 Annual SW S&S Rnwl

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Enterprise Edition
InfoSphere Whse Enterp Ed Per Processor Value Unit       E02GVLL
 (PVU) Annual SW S&S Rnwl
InfoSphere Whse Enterp Ed Per Processor Value Unit       D57UBLL
 (PVU) Lic + SW S&S 12 Mo
InfoSphere Whse Enterp Ed Per Processor Value Unit       D57UCLL
 (PVU) SW S&S Reinstate

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Departmental Edition
 Authorized User Option
IS Whse Departmental Edition PA Per Authorized User      E07AJLL
 Annual SW S&S Rnwl
IS Whse Departmental Edition PA Per Authorized User Lic  D09VCLL
 + SW S&S 12 Mo
IS Whse Departmental Edition PA Per Authorized User SW   D09VDLL
 S&S Reinstate 12 Mo

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Departmental Base Edition
 Authorized User Option
IS Whse Departmental Base Ed PA Per Authorized User      E07ASLL
 Annual SW S&S Rnwl
IS Whse Departmental Base Ed PA Per Authorized User Lic  D09VTLL
 + SW S&S 12 Mo
IS Whse Departmental Base Ed PA Per Authorized User SW   D09VULL
 S&S Reinstate 12 Mo

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Departmental Base Edition
 Socket Option
IS Wh Dept Base Ed Skt Opt Per Limited Use Socket        E07BPLL
 Annual SW S&S Rnwl
IS Wh Dept Base Ed Skt Opt Per Limited Use Socket Lic +  D0A13LL
 SW S&S 12 Mo
IS Wh Dept Base Ed Skt Opt Per Limited Use Socket SW     D0A14LL
 S&S Reinstate 12 Mo

InfoSphere Warehouse with Optim Data Retention

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse with Optim Data Retention
IS Whse with Optim Data Ret Per Processor Value Unit     E04N1LL
 (PVU) Annual SW S&S R
IS Whse with Optim Data Ret Per Processor Value Unit     D03R5LL
 (PVU) Lic + SW S&S 12
IS Whse with Optim Data Ret Per Processor Value Unit     D03R6LL
 (PVU) SW S&S Reinstat

Passport Advantage trade-up licenses

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM InfoSphere Warehouse
 Enterprise Edition
DB2 DWE Base Edition        InfoSphere Whse Enterp Ed   D57UDLL
                             Per PVU fr DB2 DWE Base Ed
                             Trade Up Lic + SW
DB2 UDB ESE                 InfoSphere Whse Enterp Ed   D57UELL
                             Per PVU fr DB2 UDB ESE
                             Trade Up Lic + SW

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM InfoSphere Warehouse
 Departmental Base Edition
 Socket Option
IBM DB2 Workgroup Server    ISW Dept Bse Ed Skt Opt     D0A19LL
 Edition Limited Use Socket  Lmtd Use Skt fr DB2 Wkgp
 Option                      LUS Trade Up Lic+SW S&S 12

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM InfoSphere Warehouse
 Departmental Edition
 Socket Option
IBM InfoSphere Warehouse    ISW Dept Ed Skt Op Lmtd     D0A18LL
 Departmental Base Edition   Use Skt fr ISW Dept Base
 Socket Option               LUS Trade Up Lic+SW S&S 12

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM InfoSphere Warehouse
 Enterprise Base Edition
IBM DB2 ESE                 InfoSphere Whse Ent Base    D60JULL
                             Ed PVU from IBM DB2 ESE
                             Trade Up Lic + SW S&S 12

Passport Advantage supply

Program name/description                                 Part
                                                         number
 
Base Warehouse Feat DB2 V9.7.0
Base Warehouse Feat DB2 9.7 for Linux, UNIX and Windows  BB11MML
 DVD MP
Entpr Warehouse Feat DB2 V9.7.0
Entpr Warehouse Feat DB2 9.7 for Linux, UNIX and         BB11NML
 Windows DVD MP
IS Wh Dept Base Ed Sckt Opt V9.7.0
IS Wh Dept Base Ed Socket Option for Linux, UNIX and     BB11WML
 Windows DVD MP
IS Whse Base Edition V9.7.0
IS Whse Enterprise Base Edition 9.7 for Linux, UNIX and  BB11JML
 Windows DVD MP
IS Whse Departmental Edition V9.7.0
IS Whse Departmental Edition 9.7 for Linux, UNIX and     BB11RML
 Windows DVD MP
IS Whse Dept Base Edition V9.7.0
IS Whse Dept Base Edition 9.7 for Linux, UNIX and        BB11PML
 Windows DVD MP
IS Whse Dept Ed Socket Opt V9.7.0
IS Whse Dept Ed Socket Option for Linux, UNIX and        BB11SML
 Windows DVD MP
IS Whse Developer Edition V9.7.0
IS Whse Developer Edition 9.7 for Linux, UNIX and        BB11KML
 Windows DVD MP
IS Whse Enterprise Edition V9.7.0
IS Whse Enterprise Edition 9.7 for Linux, UNIX and       BB11LML
 Windows DVD MP
IS Whse with Optim Data Ret V9.7.0
IS Whse with Optim Data Ret 9.7 for Linux, UNIX and      BB11TML
 Windows DVD MP

Passport Advantage customer: Media pack entitlement details

Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.

IS Whse Dept Ed Socket Opt V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM Infosphere Warehouse    IS Whse Dept Ed Socket      BB11SML
Departmental Base Edition   Option for Linux, UNIX and
Limited Use Socket Opt      Windows DVD MP

IS Whse Dept Base Edition V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Warehouse    IS Whse Dept Base Edition   BB11PML
Departmental Base Edition   9.7 for Linux, UNIX and
Authorized User Option      Windows DVD MP

IS Whse Departmental Edition V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Warehouse    IS Whse Departmental        BB11RML
Departmental Edition        Edition 9.7 for Linux,
Authorized User Option      UNIX and Windows DVD MP

IS Whse with Optim Data Ret V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Warehouse    IS Whse with Optim Data     BB11TML
with Optim Data Retention   Ret 9.7 for Linux, UNIX
per Processor Value Unit    and Windows DVD MP

IS Whse Enterprise Edition V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Warehouse    IS Whse Enterprise Edition  BB11LML
Enterprise Edition          9.7 for Linux, UNIX and
Processor Value Unit        Windows DVD MP

IS Whse Developer Edition V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Warehouse    IS Whse Developer Edition   BB11KML
Developer Edition           9.7 for Linux, UNIX and
Authorized User             Windows DVD MP

Base Warehouse Feat DB2 V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM Base Warehouse Feature  Base Warehouse Feat DB2     BB11MML
 for DB2 per Value Unit      9.7 for Linux, UNIX and
                             Windows DVD MP
IBM Enterprise Warehouse    Base Warehouse Feat DB2     BB11MML
 Feature for DB2 Value Unit  9.7 for Linux, UNIX and
                             Windows DVD MP

IS Whse Base Edition V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Warehouse    IS Whse Enterprise Base     BB11JML
Enterprise Base Edition     Edition 9.7 for Linux,
Processor Value Unit        UNIX and Windows DVD MP

IS Wh Dept Base Ed Sckt Opt V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Whse         IS Wh Dept Base Ed Socket   BB11WML
Departmental Base Ed        Option for Linux, UNIX and
Socket Option per Lmtd Use  Windows DVD MP
Socket

Entpr Warehouse Feat DB2 V9.7.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM Enterprise Warehouse    Entpr Warehouse Feat DB2    BB11NML
Feature for DB2 Value Unit  9.7 for Linux, UNIX and
                            Windows DVD MP

On/Off CoD

IBM Base Warehouse Feature for DB2

Part description                                         Part
                                                         number
 
Base Warehouse Feature DB2 Processor-Days Per Use-Day    D06QDLL
OOCoD

IBM Enterprise Warehouse Feature for DB2

Part description                                         Part
                                                         number
 
IBM Entpris Whse Feature DB2 Processor-Days Per          D61W3LL
Use-Day OOCoD

IBM InfoSphere Warehouse Enterprise Base Edition

Part description                                         Part
                                                         number
 
InfoSphere Whse Ent Base Ed Processor-Days Per           D06QBLL
Use-DAY, On Off Capacity

IBM InfoSphere Warehouse Enterprise Edition

Part description                                         Part
                                                         number
 
InfoSphere Whse Enterp Ed Processor-Days Per Use-DAY,    D53ZLLL
On Off Capacity on

 
Back to topBack to top
 
Top rule
Terms and conditions
Bottom rule

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing

IBM International Program License Agreement including the License Information document and PoE govern your use of the program. PoEs are required for all authorized use.

Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

This software license includes Software Subscription and Support (also referred to as Software Maintenance).

License Information form numbers
Program name                              Program    Form number
                                          number
 
InfoSphere Warehouse 9.7, Departmental    5724-E34   L-CLAW-7Q3QUG
 Base Edition
InfoSphere Warehouse 9.7, Departmental    5724-E34   L-CLAW-7Q3QVZ
 Edition
InfoSphere Warehouse 9.7, Enterprise      5724-E34   L-CLAW-7Q3QYJ
 Base Edition
InfoSphere Warehouse 9.7, Enterprise      5724-E34   L-CLAW-7Q3R2B
 Edition
InfoSphere Warehouse 9.7, Developer       5724-E34   L-CLAW-7Q3R6H
 Edition
InfoSphere Warehouse 9.7, with Optim      5724-U85   L-CLAW-7Q3R7U
 Data Retention
Base Warehouse Feature for DB2 9.7        5724-E34   L-CLAW-7Q3R44
Enterprise Warehouse Feature for DB2 9.7  5724-E34   L-CLAW-7Q3R5J

The program's License Information will be available for review on the IBM Software License Agreement Web site

http://www.ibm.com/software/sla/sladb.nsf
Limited warranty applies

Yes

Warranty

IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known Program defects, defect corrections, restrictions, and bypasses at no additional charge. Consult the IBM Software Support Handbook for further information at

http://www.ibm.com/support/handbook

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Program technical support

Technical support of a program product will be available for a minimum of five years from the general availability date, as long as your Software Maintenance is in effect. This technical support allows you to obtain assistance (via telephone or electronic means) from IBM for product-specific, task-oriented questions regarding the installation and operation of the program product. Software Maintenance also provides you with access to updates, releases, and versions of the program. You will be notified, via announcement letter, of discontinuance of support with 12 months' notice. If you require additional technical support from IBM, including an extension of support beyond the discontinuance date, contact your IBM representative or IBM Business Partner. This extension may be available for a fee.

Money-back guarantee

If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For programs acquired under the IBM International Passport Advantage Agreement, this term applies only to your first acquisition of the program.

For programs acquired under any of IBM's On/Off CoD software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Authorization for use on home/portable computer

The program may be stored on the primary machine and another machine, provided that the program is not in active use on both machines at the same time. You may not copy and use this program on another computer without paying additional license fees.

IBM InfoSphere Warehouse:  No
InfoSphere Warehouse with Optim Data Retention:  No
Volume orders (IVO)

No

Passport Advantage applies

Yes, and through the Passport Advantage Web site at

http://www.ibm.com/software/passportadvantage

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Usage restriction

Yes

For a complete copy of the enclosed license with all of the detail information regarding usage restrictions of the InfoSphere Warehouse products refer to the License Information Document that is available on the IBM Software License Agreement website:

http://www.ibm.com/software/sla/sladb.nsf
International Passport Agreement
Software Subscription and Support (also referred to as Software Maintenance) applies

Yes. Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support (also referred to as Software Maintenance) offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software and Technical Support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Subscription and Support (also referred to as Software Maintenance) with each program license acquired. The initial period of Software Subscription and Support (also referred to as Software Maintenance) can be extended by the purchase of a renewal option, if available.

While your Software Subscription and Support (also referred to as Software Maintenance) is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance via telephone and, if available, electronic access, to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, 7 days a week. For additional details, consult your IBM Software Support Handbook at

http://www.ibm.com/support/handbook

Software Subscription and Support (also referred to as Software Maintenance) does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under the applicable agreements.

For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, visit the Passport Advantage Web site at

http://www.ibm.com/software/passportadvantage
Other terms
System i Software Maintenance applies

No

Educational allowance available

Not applicable.

On/Off CoD

To be eligible for On/Off CoD pricing, customers must be enabled for temporary capacity on the corresponding hardware, and the required contract - Z125-6907, Amendment for iSeries® and pSeries® Temporary Capacity On Demand - Software - must be signed prior to use.


 
Back to topBack to top
 
Top rule
IBM Electronic Services
Bottom rule

IBM has transformed its delivery of hardware and software support services to help you achieve higher system availability. Electronic Services is a Web-enabled solution that offers an exclusive, no-additional-charge enhancement to the service and support available for IBM servers. These services are designed to provide the opportunity for greater system availability with faster problem resolution and preemptive monitoring. Electronic Services comprises two separate, but complementary, elements: Electronic Services news page and Electronic Services Agent.

The Electronic Services news page is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. The news page enables you to gain easier access to IBM resources for assistance in resolving technical problems.

The Electronic Service Agent™ is no-additional-charge software that resides on your server. It monitors events and transmits system inventory information to IBM on a periodic, client-defined timetable. The Electronic Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to deliver proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent is made available to IBM service support representatives when they help answer your questions or diagnose problems. Installation and use of IBM Electronic Service Agent for problem reporting enables IBM to provide better support and service for your IBM server.


 
Back to topBack to top
 
Top rule
Prices
Bottom rule

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at

http://www.ibm.com/software/passportadvantage

Business Partner information

If you are an IBM Business Partner -- Distributor for Workstation Software acquiring products from IBM, you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBM ID and password are required.

https://www.ibm.com/software/howtobuy/passportadvantage/paoreseller

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, both from IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit

http://www.ibm.com/financing

IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.


 
Back to topBack to top
 
Top rule
Order now
Bottom rule

For more information, contact the Americas Call Centers.

Phone: 800-IBM-CALL (426-2255)
Fax: 800-2IBM-FAX (242-6329)
For IBM representative: callserv@ca.ibm.com
For IBM Business Partner: pwswna@us.ibm.com
Mail:
IBM Teleweb Customer Support
ibm.com® Sales Execution Center, Americas North
3500 Steeles Ave. East, Tower 3/4
Markham, Ontario
Canada
L3R 2Z1
Reference: YE001

The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

Note: Shipments will begin after the planned availability date.

Trademarks

pureXML, POWER, Database 2 and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, DB2, z/OS, Informix, System z, Redbooks, Passport Advantage, AIX, WebSphere, Tivoli, System i, System p, iSeries, pSeries and ibm.com are registered trademarks of IBM Corporation in the United States, other countries, or both.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Windows is a registered trademark of Microsoft Corporation in the United States, other countries, or both.

Intel is a registered trademark of Intel Corporation or its subsidiaries in the United States and other countries.

Other company, product, and service names may be trademarks or service marks of others.

Terms of use

IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at:

http://www.ibm.com/legal/us/en/

For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page

http://www.ibm.com/planetwide/us/

 

Back to topBack to top
 
Bottom grey rule
 
Printable version Printable version