IBM Informix Ultimate Warehouse Edition brings new levels of performance to analytics

IBM United States Software Announcement 211-148
March 29, 2011


Table of contents
Overview Overview Publications Publications
Key prerequisites Key prerequisites Technical information Technical information
Planned availability date Planned availability date Ordering information Ordering information
Description Description Terms and conditions Terms and conditions
Product positioning Product positioning Prices Prices
Program number Program number Order
now Order now


Top rule
At a glance
Bottom rule

IBM® Informix® Ultimate Warehouse Edition:

  • Provides fast and predictable query response times on analytical workloads
  • Can help lower overall operating costs by significantly reducing requirements for database tuning
  • Significantly improves performance of analytical queries running on IBM Informix Ultimate Edition without requiring application changes
  • Enables customers to leverage the same database environment for mixed workloads

For ordering, contact your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).



Back to topBack to top
 
Top rule
Overview
Bottom rule

IBM Informix Ultimate Warehouse Edition is a high-performance offering for IBM Informix, delivering dramatically faster analytic query responses transparently to users when compared to an existing Informix environment without the capabilities available with the Informix Ultimate Warehouse Edition. It integrates into an IBM Informix data warehouse environment, providing high-performance query software that is based on advanced in-memory technology.

The IBM Informix Ultimate Warehouse Edition consists of the following components:

  • IBM Informix Ultimate Edition
  • IBM Informix Warehouse Accelerator
  • IBM Informix Storage Optimization Feature


Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

Refer to the Hardware requirements and Software requirements sections.



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

March 29, 2011: Electronic availability

April 7, 2011: Media availability



Back to topBack to top
 
Top rule
Description
Bottom rule

IBM Informix Ultimate Warehouse Edition addresses the following client challenges:

  • Long-running queries with unpredictable response time that do not allow for ad hoc processing
  • Need for DBA to tune the system, with increasingly inadequate results, due to the ad hoc, unpredictable nature of the data warehouse / analytical requests
  • Leveraging the same database server environment for mixed workloads

Informix Ultimate Warehouse Edition provides:

  • Faster query response times on unpredictable and long-running query workloads
  • Help in lowering operating costs by reducing database tuning efforts
  • Improved performance on analytical queries compared to your existing Informix environment
  • The ability to run mixed workloads

To accomplish these results, Informix Ultimate Warehouse Edition does not require changes in the business intelligence or data warehouse application or the application framework running in an existing Informix environment, because Informix remains the query engine and will offload the specific query to the Informix Warehouse Accelerator.

The implementation and administration of the IBM Informix Ultimate Warehouse Edition is supported by graphical tooling within the IBM Smart Analytics Studio. This provides easy-to-use graphical interfaces to configure and prepare data for deployment.

Informix Ultimate Warehouse Edition is designed to help mitigate database administration costs while significantly speeding up the performance of typical data warehouse or OLAP-specific workloads, in many cases by an order-of-magnitude or more. The Informix Ultimate Warehouse solution enables selected Informix query workloads to be redirected to another processing entity, namely the Informix Warehouse Accelerator. The Informix Warehouse Accelerator is designed as a logical extension to the Informix engine for quick off-loading and processing.

Accessibility by people with disabilities

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

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

Section 508 of the US Rehabilitation Act

Informix Ultimate Warehouse Edition is capable as of April 7, 2011, 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 US Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested at

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

The following third-party products are not covered under the IBM license agreement:

IBM product name                  Third-party product
 
Informix Ultimate Wrhs Ed         Sentinel Server Studio

IBM makes no representation about the Section 508 status of these third-party products included in this offering. Contact the vendor for specific, current information on the Section 508 status of these products.



Back to topBack to top
 
Top rule
Product positioning
Bottom rule

IBM Informix Ultimate Warehouse Edition is part of the IBM Informix family and joins a comprehensive IBM data warehousing and business intelligence solution for IBM Informix. IBM Informix Ultimate Warehouse Edition provides clients who have a majority of their data maintained on IBM Informix, XPS, or Red Brick™, the opportunity to further leverage the Informix platform for cost-effective data warehousing and business intelligence solutions.



Back to topBack to top
 
Top rule
Availability of national languages
Bottom rule

Product description            Language        GA date
 
Informix Ultimate Wrhs Ed      English         April 7, 2011
V11.70.0



Back to topBack to top
 
Top rule
Program number
Bottom rule

Program
number     VRM             Program name
 
5725-D14   11.70.0         IBM Informix Ultimate
                           Warehouse Edition



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 website

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

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

Available from IBM training, the newest offerings to support your training needs, enhance your skills and boost your success with IBM software. IBM offers a complete portfolio of training options, including traditional classroom, private onsite and eLearning courses. Many of our classroom courses are part of IBM's "Guaranteed to run program," ensuring your course will never be canceled. We have a robust eLearning portfolio including Instructor-Led Online (ILO) courses; and Self-Paced Virtual courses (SPVC). A perfect complement to classroom training, our eLearning portfolio offers something for every need and every budget; simply select the style that suits you.

Be sure to take advantage of our custom training plans to map your path to acquiring skills. Enjoy further savings when you purchase training at a discount with an IBM Education Pack - online account -- a flexible and convenient way to pay, track, and manage your education expenses online.

Check your local Information Management Training website or chat with your training representative for the most recent training schedule.

                                                    Self-Paced
                                   Instructor-Led   Virtual
Course Name       Classroom        Online           Classroom                          
 
Informix System   IX81             3X81             2X81
 Administration
Informix          IX22             3X22             2X22
 Database
 Administration:
 Managing and
 Optimizing Data
Informix          IX13             3X13             2X13
 Structured
 Query Language
Informix 11.7     X30              3X30             2X30

Descriptions of courses for IT professionals and managers are available at

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

For scheduling and enrollment, call IBM training at 800-IBM-TEACH (426-8322) or visit

http://www.ibm.com/training

IBM Professional Certification:

Information Management Professional Certification is a business solution for skilled IT professionals to demonstrate their expertise to the world. Certification validates skills and demonstrates proficiency with the most recent IBM technology and solutions.

Exam #       Exam name              Certification title
 
919          Informix 11.70 System  IBM Certified System
              Administrator          Administrator -
                                     Informix 11.70
555          IBM Informix Dynamic   IBM Certified
              Server 11.50           Database Associate -
              Fundamentals           Informix Dynamic
                                     Server 11.50
                                     Fundamentals

For additional information about this exam, refer to the following

http://www-03.ibm.com/certify/tests/ovr919.shtml
http://www-03.ibm.com/certify/tests/ovr555.shtml


Back to topBack to top
 
Top rule
Offering Information
Bottom rule

Product information is available via the Offering Information website

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

Also, visit the Passport Advantage® website

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


Back to topBack to top
 
Top rule
Publications
Bottom rule

No publications are shipped with this product.

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.

IBM Redbooks®

IBM Redbooks offer deep 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-7847-00                      Migrating from Microsoft® SQL
                                   Server to IBM Informix
SG24-7884-00                      Informix Developer's Handbook
SG24-7730-00                      Migrating from Oracle to IBM
                                   Informix on Linux®, Unix, and
                                   Windows
SG24-7666-01                      Embedding Informix
SG24-7788-00                      Data Warehousing with Informix

For additional Redbooks, visit

http://www.redbooks.ibm.com


Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

The following table lists the supported hardware and operating system for the following products:

Informix Ultimate Edition

Processor/System       Operating system       Informix 11.70
 
IBM Power® (IBM System  AIX® 6.1 (64-bit)     64-bit
 p)
Sun Sparc              Solaris 10 (64-bit)    64-bit
Intel x64 (Intel®       Linux RHEL 5 (64-bit, 64-bit
 EM64T)                 SUSE 11 (64-bit)
HP Itanium®             HP-UX 11.31 (64-bit)  64-bit

The Informix Warehouse Accelerator component is supported on the following platforms:

                                              Informix Warehouse 
Processor/System       Operating system       Accelerator
 
Intel x64 (Intel       Linux RHEL 5 (64-bit,  64-bit
EM64T)                 SUSE 11 (64-bit)

Software requirements

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.

Security, auditability, and control

IBM Informix Ultimate Warehouse Edition uses the security and auditability features of the host hardware or 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
Ordering information
Bottom rule

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

These products may only be sold directly by IBM or by authorized IBM Business Partners for Software ValueNet®.

For more information about IBM Software ValueNet, visit

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

To locate IBM Business Partners for Software ValueNet in your geography for a specific Software ValueNet portfolio, contact your IBM representative.

Product information

                                                    Product
Licensed function title             Product group   category
 
IBM Informix Ultimate Warehouse     IBM Informix    Informix
Edition CPU Option                  Servers         Editions

                                      PID        Charge unit
Program name                          number     description
 
IBM Informix Ultimate Warehouse       5725-D14   Per Processor
 Edition CPU Option                               Value Unit (PVU)
IBM Informix Ultimate Warehouse       5725-D14   PROCESSOR-Day(s)
 Edition CPU Option

Charge metrics definitions

Processor Value Unit (PVU)

Processor Value Unit (PVU) is a unit of measure by which the program can be licensed. The number of PVU entitlements required is based on the processor technology (defined within the PVU Table by processor value, brand, type, and model number at the following website and the number of processors made available to the program.

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

IBM continues to define a processor, for the purpose of PVU-based licensing, to be each processor core on a chip. A dual-core processor chip, for example, has two processor cores.

Licensee can deploy the program using either Full Capacity licensing or Virtualization Capacity (Sub-Capacity) licensing according to the Passport Advantage Sub-Capacity Licensing Terms (see webpage below). If using Full Capacity licensing, Licensee must obtain PVU entitlements sufficient to cover all activated processor cores1 in the physical hardware environment made available to or managed by the program, except for those servers from which the program has been permanently removed. If using Virtualization Capacity licensing, Licensee must obtain entitlements sufficient to cover all activated processor cores made available to or managed by the program, as defined according to the Virtualization Capacity License Counting Rules at

http://www.ibm.com/software/lotus/passportadvantage/Counting_Software_licenses_using_specific_virtualization_technologies.html
1
An Activated processor core is a processor core that is available for use in a physical or virtual server, regardless of whether the capacity of the processor core can be or is limited through virtualization technologies, operating system commands, BIOS settings, or similar restrictions.

Notes

  • Some programs may require licenses for the program and what is being managed. In that case, the following applies: In addition to the entitlements required for the program directly, Licensee must obtain PVU entitlements for this program sufficient to cover the processor cores managed by the program.
  • Some programs may be licensed on a managed basis only. In that case, the following applies: Instead of the entitlements required for the program directly, Licensee must obtain PVU entitlements for this program sufficient to cover the processor cores managed by the program.
  • A few programs on an exception basis may be licensed on a referenced basis. In that case, the following applies: Rather than obtaining entitlements for the activated processor cores available to the program, Licensee must obtain PVU entitlements for this program sufficient to cover the environment made available to the referenced program as if the program itself were executing everywhere the referenced program was executing, independent of the basis on which the referenced program is licensed.
  • Express® and Workgroup programs may be licensed with maximum use terms. In that case, the following applies: The maximum authorized use terms and conditions for PVU licensed IBM Express and Middleware Programs can be found in the IBM Express and Middleware Licensing Guide.

Passport Advantage program licenses

Informix Ultimate Warehouse Edition

                                                         Part
Part description                                         number
 
IBM Informix Ultimate Warehouse Edition CPU Option
Informix Ultimate Whse Ed Per Processor Value Unit       E0BQ7LL
 (PVU) Annual SW S&S Rnwl
Informix Ultimate Whse Ed Per Processor Value Unit       D0IJGLL
 (PVU) Lic + SW S&S 12 Mo
Informix Ultimate Whse Ed Per Processor Value Unit       D0IJHLL
 (PVU) SW S&S Reinstate

Passport Advantage Trade-up licenses

Informix Ultimate Warehouse Edition

                                                        Part
Precursor product           Trade-up product            number
 
IBM Informix Ultimate
 Warehouse Edition CPU
 Option
IBM Informix Ultimate       Informix Ultimate Whse Ed   D0IJILL
 Edition CPU Option          PVU fr IFMX Ultimate Ed
                             PVU Trade Up Lic + SW

Passport Advantage supply

                                                         Part
Program name/description                                 number

Informix Ultimate Wrhs Ed V11.70.0
Informix Ultimate Wrhs Ed AIX 6,SUSE Linux Enterprise    BB16MML
 Server (SLES),Red Ha

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.

Informix Ultimate Warehouse Edition V11.70.0

Entitled maintenance                                    Part
offerings description       Media packs description     number

IBM Informix Ultimate       Informix Ultimate Wrhs Ed   BB16MML
Warehouse Edition CPU       AIX 6,SUSE Linux
Option per Processor Value  Enterprise Server
Unit Metric                 (SLES),Red Ha

On/Off CoD

IBM Informix Ultimate Warehouse Edition CPU Option

                                                         Part
Part description                                         number
 
Informix Ultimate Whse Ed PROCESSOR-Day(s) Per Use-Day   D0IK6LL
OOCoD



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 Proof of Entitlement (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
 
Informix Ultimate Warehouse Edition       5725-D14   L-STTN-8CSNUJ

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

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

Yes

Money-back guarantee

For clarification, note that 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 clarification, note that for programs acquired under the IBM International Passport Advantage Agreement, this term applies only to your first acquisition of the program.
  • For clarification, note that 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.
Volume orders (IVO)

No

Passport Advantage applies

Yes, and through the Passport Advantage website 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 additional information, refer to the License Information document that is available on the IBM Software License Agreement website

http://www.ibm.com/software/sla/sladb.nsf
IBM Operational Support Services -- SoftwareXcel

No

System i Software Maintenance applies

No

Educational allowance available

Not applicable.

On/Off Capacity on Demand (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
Prices
Bottom rule

For additional information and current prices, contact your local IBM representative.

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner, or authorized IBM Business Partner for Software ValueNet, if applicable. 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


Back to topBack to top
 
Top rule
Order now
Bottom rule

To order, contact the Americas Call Centers or your local IBM representative, or your IBM Business Partner.

To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968).

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.

IBM Software ValueNet

These products are available under IBM Software ValueNet, either directly from IBM or through authorized Business Partners who invest in skills and high-value solutions. IBM customers may benefit from the industry-specific or horizontal solutions, skills, and expertise provided by these Business Partners.

Additions to Software ValueNet will be communicated through standard product announcements. For a current list of IBM software available under Software ValueNet, visit

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

Questions regarding IBM Software ValueNet may be sent to AskSoftwareValueNet@us.ibm.com

Trademarks

Red Brick is a trademark of IBM Corporation in the United States, other countries, or both.

IBM, Informix, Passport Advantage, Redbooks, Power, AIX, ValueNet, Express, iSeries, pSeries and ibm.com are registered trademarks of IBM Corporation in the United States, other countries, or both.

Microsoft is a registered trademark of Microsoft 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.

Intel and Itanium are registered trademarks 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/

Terms of use