Efficient data warehouse growth and archival access with IBM InfoSphere Warehouse with Optim Data Retention V9.5 software

IBM United States Software Announcement 208-054
March 25, 2008

 

 ENUS208054.PDF (34KB)

 

Table of contents  Document options  
TOC link At a glance TOC link Publications
TOC link Overview TOC link Technical information
TOC link Key prerequisites TOC link Software Services
TOC link Planned availability dates TOC link Ordering information
TOC link Description TOC link Terms and conditions
TOC link Offering Information TOC link Prices
 
Printable version Printable version

 
At a glance

IBM InfoSphere Warehouse with Optim Data Retention software is a bundled solution that includes:

  • IBM DB2 Warehouse Enterprise Edition V9.5
  • IBM Optim Data Growth Solution V6.5

The combination of these products provides a complete end-to-end data growth solution for IBM data warehouse customers.
 
Back topBack to top
 

Overview

IBM InfoSphere Warehouse with Optim Data Retention V9.5 software enables businesses to better manage the growth of information by integrating data warehousing and archiving capabilities. IBM delivers a single solution of policy-based data lifecycle management — reducing storage and data retrieval costs and improving performance. With InfoSphere Warehouse Optim Data Retention, you:

  • Improve business insights by maintaining, for online query access only, the information relevant to your daily business and archiving the rest with easy access and restore capabilities.
  • Effectively manage the size and performance of your data warehouse by archiving information with the confidence that it can be returned to the warehouse if needed.
  • Ensure accurate, timely response to audit and e-discovery requests, thereby lowering the cost of compliance.

InfoSphere Warehouse with Optim Data Retention is the first Warehouse offering in the new InfoSphere product family. IBM InfoSphere software is information middleware — providing the integration, warehousing, and management tools necessary to turn information into a strategic asset.

InfoSphere Warehouse with Optim Data Retention is composed of two existing IBM products:

  • IBM DB2® Warehouse Enterprise Edition V9.5
  • IBM Optim Data Growth Solution V6.5

For additional details about DB2 Warehouse Enterprise Edition V9.5, refer to Software Announcement 207-257 , dated October 16, 2007.
 
Back topBack to top
 

Key prerequisites

Refer to the Hardware requirements and Software requirements sections.


 
Back topBack to top
 

Planned availability dates
  • March 28, 2008: Electronic software delivery
  • April 25, 2008: Media and documentation

 
Back topBack to top
 
Description

IBM InfoSphere Warehouse with Optim Data Retention provides the complete solution for end-to-end data warehouse information lifecycle management by combining the power of two products, DB2 Warehouse Enterprise Edition V9.5 and Optim Data Growth Solution V6.5, into a single solution.

For a full description of the powerful capabilities of the DB2 Warehouse Enterprise Edition data warehouse platform, refer to Software Announcement 207-257 , dated October 16, 2007, Optim Data Growth Solution V6.5.

When applied to the DB2 Warehouse platform, Optim Data Growth V6.5 enables you to manage your archived information in tiered storage architecture that supports multiple temperatures of data priority:

  • Current (hot) data required for daily business operations, reporting, and analytics is maintained as usual online in the active DB2 Warehouse.
  • Very recent (warm) data needed for frequent access but not strictly for all day-to-day operations can be staged to an online archive DB2 Warehouse. This facilitates the rapid access, restore, or joining of near-term archival data with active warehouse data.
  • Less recent (warm) data needed for less frequent online access can be staged to archive files stored on less expensive disk storage. This data is still available for online access and restore, but with somewhat less query performance than the online archive database.
  • Older and very infrequently accessed (cold) data can be staged to offline disk or removable media storage for long-term archival. This data can be restored to an online form for query access.

InfoSphere Warehouse with Optim Data Retention provides the tooling necessary to design, deploy, and manage a multitiered archival strategy as described above.

Features of the tooling

  • Identify a start table within a data warehouse subject area
  • Identify the associated tables and relationships
  • Identify extraction rules and index specifications

Delete archived data

  • After archival, delete the archived data from the online data warehouse
  • Preserve the semantic information needed for query and restore

Create the physical archive

Restore archived data to the online data warehouse

  • Access archive metadata and indices to restore portions or all of the archived data

Accessibility by people with disabilities

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

IPLA and Subscription and Support considerations

IPLA licenses can be transferred from one machine to another within, but not limited to an enterprise. You may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single Proof of Entitlement (PoE). It is your responsibility to manage the distribution of Value Units within the limits of the entitlement of the product license.

Subscription and Support must cover the same capacity as the product license entitlement. Subscription and Support will be available in the country in which the agreement is made.

Trademarks

 
DB2 is a registered trademark of International Business Machines Corporation in the United States or other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Offering Information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back topBack to top
 
Publications

No publications are shipped with this product.

The IBM Publications Center

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.
 
Back topBack to top
 

Technical information

Specified operating environment

Hardware requirements

For the hardware requirements of IBM DB2® Warehouse Enterprise Edition V9.5, refer to Software Announcement 207-257 , dated October 16, 2007.

Hardware requirements for IBM Optim Data Growth Solution V6.5

  • Intel® Pentium®, or greater (or comparable processor).
  • CD-ROM drive (unless installing from a LAN).
  • Hard disk space — 400 megabytes.
  • Disk space for the database — as required.
  • 256 MB of RAM is recommended. 64 MB minimum is supported. Additional memory enhances performance.

Software requirements

For the software requirements of IBM DB2 Warehouse Enterprise Edition V9.5, refer to Software Announcement 207-257 , dated October 16, 2007.

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

Software requirements for IBM Optim Data Growth Solution V6.5:

Client

  • Windows® XP Professional
  • Windows 2003 Server

Server

  • Windows XP Professional
  • Windows 2003 Server
  • Sun Solaris V9, V10 for UltraSPARC servers
  • AIX® V5.3
  • Red Hat Enterprise Linux™ (RHEL) 4.0 AS on AMD and Intel x86 or x86-64 systems

Note: IBM Optim Data Growth Solution V6.5 is a 32-bit application. On 64-bit environments, it will run in 32-bit emulation mode.

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

Packaging

Notes:

  • The Warehouse Server DVDs include DB2 Enterprise Server Edition, applicable DB2 feature entitlements, Warehouse components, and WebSphere® Application Server.
  • The Warehouse Client DVDs include IBM Data Server Client, Warehouse components, Information Center, samples, and tutorial.

InfoSphere Warehouse with Optim Data Retention V9.5

1. Overriding hardcopy license

2. InfoSphere Warehouse Quick Start CD

3. DB2 Warehouse Enterprise Edition V9.5

  • IBM DB2 Warehouse Enterprise Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Server for AIX DVD
  • IBM DB2 Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM DB2 Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM DB2 Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM WebSphere Application Server Toolkit for Windows on 32-bit AMD and Intel systems (x86) CD
  • 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

4. Optim Data Growth Solution V6.5

  • IBM Optim Data Growth Solution V6.5 for Windows, for Multiplatforms CD
  • IBM Optim Data Growth Solution V6.5 for AIX CD
  • IBM Optim Data Growth Solution V6.5 for Solaris on UltraSPARC systems CD
  • IBM Optim Data Growth Solution V6.5 for Linux CD

Security, auditability, and control

InfoSphere Warehouse with Optim Data Retention uses the security and auditability features of the host hardware and 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 topBack to top
 

Software Services

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 unmatched portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support any critical business need.

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

To locate an IBM Business Partner, visit


 
Back topBack to top
 
Ordering information

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

Product information

                                                    Product
Licensed function title       Product group         category
 
IBM InfoSphere Warehouse      IBM Database 2(TM)    DB2
 with Optim Data Retention

                               PID          Charge unit
Program name                   number       description
 
IBM InfoSphere Warehouse       5724-U85     SubCapacity
 with Optim Data Retention                   Processor Value
                                             Unit (PVU)
 
IBM InfoSphere Warehouse       5724-U85     Processor Value
 with Optim Data Retention                   Unit (PVU)

Charge metrics definitions

Value Unit

A Value Unit is a pricing charge metric for program license entitlements which is based upon the quantity of a specific designated measurement used for a given program. Each program has a designated measurement. The most commonly used designated measurement is a processor core. However, for select programs, there are other designated measurements such as users or resources which may include servers, client devices, and messages. The number of Value Unit entitlements required for a program depends on how the program is deployed in your environment and must be obtained from a Value Unit table. You must obtain a PoE for the calculated number of Value Unit entitlements for your implementation. The Value Unit entitlements are specific to a program and may not be exchanged, interchanged, or aggregated with Value Unit entitlements of another program.

Processor (Value Unit)

A processor core is a functional unit within a computing device that interprets and executes instructions. A processor core consists of at least an instruction control unit and one or more arithmetic or logic unit. With multicore technology, each core is considered a processor. Not all processor cores require the same number of Processor Value Unit entitlements. To calculate the number of Processor Value Unit entitlements required, refer to the Processor Value Unit table on the following Web site

With full capacity licensing, a Proof of Entitlement (PoE) must be acquired for the appropriate number of Processor Value Units based on all activated processor cores available for use on the server.

Sub-capacity processor (Value Unit)

For programs eligible for sub-capacity licensing, a PoE must be acquired for the appropriate number of Processor Value Units based on all activated processor cores available for use in each partition (utilizing eligible partitioning technologies) where the program runs. Refer to the International Passport Advantage Agreement Attachment for sub-capacity terms or the program's license information to determine applicable sub-capacity terms.

Passport Advantage program licenses

InfoSphere Warehouse with Optim Data Retention

                                                     Part
Part description                                     number
 
IBM InfoSphere Warehouse with Optim Data Retention
InfoSphere Warehouse with Optim Data Retention       D03R5LL
 (PVU) Lic and SW Maint 12 Mos
InfoSphere Warehouse with Optim Data Retention       E04N1LL
 (PVU) SW Maint Annual Renwl
InfoSphere Warehouse with Optim Data Retention       D03R6LL
 (PVU) SW Maint Reinst 12 Mos

Passport Advantage supply

                                                     Part
Program name/description                             number
 
InfoSphere V9.5.0
InfoSphere Warehouse with Optim Data                 BB0WIML
 Retention V9.5.0

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.

InfoSphere V9.5.0

Entitled maintenance                                 Part
offerings description     Media packs description    number
 
IBM InfoSphere Warehouse  InfoSphere Warehouse with  BB0WIML
 w/Optim Data Retention    Optim Data Retention
 Subcap PVU                V9.5.0
IBM InfoSphere Warehouse  InfoSphere Warehouse with  BB0WIML
 with Optim Data           Optim Data Retention
 Retention PVU             V9.5.0

Sub-capacity

IBM InfoSphere Warehouse with Optim Data Retention

Part
number              Part description
 
D03R8LL             InfoSphere Warehouse with Optim Data
                     Retention SubCap (PVU) Lic and SW Maint
E04N3LL             InfoSphere Warehouse with Optim Data
                     Retention SubCap (PVU) SW Maint Ann Ren
D03R9LL             InfoSphere Warehouse with Optim Data
                     Retention SubCap (PVU) SW Maint Reinst

Sub-capacity for selected middleware products

Sub-capacity licensing on a per processor or per Value Unit basis is available for selected middleware products. To offer sub-capacity licensing, IBM software products implement IBM Tivoli License Compliance Manager within their offerings so that you can monitor and report quarterly to IBM on the use of the programs on a continuous basis.

More information can be found on the Passport Advantage Web site

Eligibility requirements for sub-capacity licensing

To be eligible for sub-capacity licensing terms on this product, you must agree to install and configure IBM Tivoli License Manager for IBM Software, in accordance with the IBM Tivoli License Manager publications, and to enable the collection of program use data on all eligible machines subject to sub-capacity terms.

For those machines running programs with sub-capacity licensing terms, you must use IBM Tivoli License Manager for IBM Software to monitor program use and submit to IBM an IBM Use Report each calendar quarter. Multiple copies of IBM Tivoli License Manager for IBM Software or IBM Tivoli License Manager are not required. You can use more copies if you need them to support your operational environment, but only one copy is required to monitor all your sub-capacity licensed products.

Additionally, if this is the first product you have licensed under sub-capacity terms, you must agree to the terms of an attachment to your Passport Advantage or Passport Advantage Express contract and submit a new Passport Advantage enrollment form. First-time sub-capacity clients also have an opportunity to ensure a primary business contact is established for their contracts.

For more information on required and entitled license capacity, license requirements, and reporting, refer to Software Announcement 205-093 , dated April 19, 2005.

If you order (this product) under sub-capacity terms, IBM Tivoli License Manager for IBM Software will be made available to you if you do not already have one. You must install and configure this tool for your sub-capacity products. Alternately, you can use Tivoli License Manager. Once the license manager software is installed, you will be required to register online (IBM may need to contact you in order to finalize the registration process.) You must monitor program use on a continuous basis with an IBM Tivoli License Manager for IBM Software and submit IBM Use Reports to IBM on a calendar quarterly basis.

IBM Tivoli License Manager for IBM Software is documented in the following customer publications, which are available from IBM Publications Center at

Publication                                        Form
 
Planning, Installation, and Configuration          SC32-1431
Administration                                     SC32-1430
Problem Determination                              SC32-9102
Data Dictionary                                    SC32-1432
Release Notes(R)                                   SC32-1429

For IBM Tivoli License Manager configuration guidance and instructions for specific products (including this product) acquired with sub-capacity terms, refer to

The Web site will give you information about how to set up the product for detection by IBM Tivoli License Manager, any required maintenance, and any required steps that are unique to this product.
 
Back topBack to top
 

Terms and conditions

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.

License Information form number

                           Program
Program name               number    Form number
 
InfoSphere Warehouse with  5724-U85  Hardcopy overriding
 Optim Data Retention                 License Information
                                      L-CLAW-7C2U9Q

Limited warranty applies: Yes

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.

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.

Product name
 
InfoSphere Warehouse with Optim Data Retention            No

Usage restriction: Yes

The bundle includes a hardcopy overriding License Information. Refer to this hardcopy license for terms and conditions as well as any usage restrictions.

For additional information refer to the License Information Document that is available on the IBM Software License Agreement Web site

International Passport Agreement

Passport Advantage applies: Yes, and through the Passport Advantage Web site at

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

Agreement for Acquisition of Software Maintenance: The following agreement applies for maintenance and does not require customer signatures:


    IBM Agreement for Acquisition of Software Maintenance (Z125-6011)

Volume orders (IVO): No

IBM Operational Support Services — SoftwareXcel: No

System i Software Maintenance applies: No

Educational allowance available: Not applicable
 
Back topBack to top
 

Prices

Passport Advantage

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

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.

Trademarks

 
System z, POWER, System p, System i, Database 2, and IBMLink are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, DB2, AIX, WebSphere, Tivoli, Lotus, Notes, and PartnerWorld are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel and Pentium are registered trademarks of Intel Corporation.
 
Windows is a registered trademark of Microsoft Corporation.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version