Feedback

IBM InfoSphere Optim Query Tuner for DB2 LUW V3.1, InfoSphere Optim Query Workload Tuner for DB2 Linux , UNIX , Windows V3.1; IBM InfoSphere Warehouse Edition part numbers

IBM United States Software Announcement 211-450
October 18, 2011


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


Top rule
At a glance
Bottom rule

InfoSphere® Optim™ Query Workload Tuner for DB2® Linux®, UNIX®, and Windows® may help you:

  • Lower the total cost of ownership of hardware and software
  • Optimize the performance of your databases and the queries that run against them

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

Reference: YE001



Back to topBack to top
 
Top rule
Overview
Bottom rule

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1 offers tools and advisors that provide advice and recommendations to database administrators (DBAs) to help improve performance for a workload (group of queries).

The following tools and advisors are provided:

  • Workload Statistics Advisor provides advice on missing, outdated, and conflicting statistics and suggests additional statistics that should be gathered to improve query performance for those queries within a workload.
  • Workload Statistics View Advisor analyzes workload query plans and provides advice on creating statistical views to improve query performance within a workload. Data skews across joins occur often in data warehouse implementations. Statistical views involving joins can be used by DB2 optimizer to address data skews and choose a better query plan.
  • Workload Index Advisor provides advice on new indexes that may improve performance of a workload. Workload Index Advisor uses a set of predefined scenarios to perform an analysis based on the scenario selected.
  • Access Plan Explorer provides tabular view of the query plan for quicker diagnosis of performance issues.
  • Visual Plan Hint provides the ability to change and validate the plan to form a hint and deploy the hint.
  • Text Index Candidates will explain the SQL statement and determine the indexes in the plan (existing and test indexes) along with estimated disk space and performance improvements.
  • Query Advisor makes recommendations based on best practice rules to modify SQL to improve overall performance.
  • Access Path Advisor examines the access plan chosen by the optimizer and identifies certain common access path issues. The warnings provided by the Access Path Advisor will guide you to potential problematic areas in the access plan graph.

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1 delivers a unique solution to the marketplace. IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows fosters teamwork and collaboration by helping DBAs and developers gain insights into SQL performance. Developers can launch InfoSphere Optim Query Workload Tuner from IBM Data Studio V3.1 and gain immediate insight into performance enhancements during development.

Now with InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1, DBAs can identify and tune poorly performing queries and also workloads. DBAs are now able to handle workloads for DB2 Linux, UNIX, and Windows. DBAs are able to get advice on indexes, statistics, and statistical views of a workload and set of queries. Additionally, DBAs can notice virtual-index what-if analysis and visual plan hints that help improve the performance of the queries.



Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

refer to the Hardware requirements and Software requirements sections for details.



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

October 21, 2011: Electronic availability

November 18, 2011: Media availability



Back to topBack to top
 
Top rule
Description
Bottom rule

Applications and workloads need to be tuned to optimize performance and maximize return on investment. Effectively tuning single query or sets of queries (workload) requires thorough understanding of SQL access plan, capturing and analyzing set of SQL statements, collecting and understanding object statistics to improve performance, analyzing index usage, and object relationships. IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1 helps to simplify and speed up analysis for database administrators (DBAs), developers, designers, and other roles in the organization. It not only removes much of the tedium from query analysis, but it provides expert recommendations to improve query and workload performance. The improved workload performance and return on investment generated by InfoSphere Optim Query Workload Tuner helps to benefit the business.

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1 can be used by DBAs and Application Developers. DBAs are able to tune performance on the base of guidance on index creation and statistics. Developers benefit from its easily accessed expert advice on writing highly efficient SQL queries. They can also take advantage of integration with IBM Data Studio V3.1, making it easy to recognize and correct problematic queries during development.

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1 will also be included into the entitlement for existing and future InfoSphere Warehouse V9.7.3 Advanced Enterprise Edition customers. This feature will provide enhanced query tuning capabilities in replacement to the existing Optim Query Tuner already announced as part of the InfoSphere Warehouse Advanced Enterprise Edition.

You are now able to order Linux on System z® part numbers for IBM InfoSphere Warehouse Enterprise Edition and IBM InfoSphere Warehouse Advanced Enterprise Edition. IBM System z customers can use these products to meet departmental and enterprise warehousing needs.

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

IBM InfoSphere Warehouse is capable as of November 18, 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 U.S. Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested on the following website

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


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

Product description            Language        GA date
 
IS OQW Tuner for DB2 LUW       Multilingual    November 18, 2011
 V3.1.0                         (French,
                                Russian,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                Hungarian,
                                English,
                                Czech,
                                Italian,
                                Polish)
IS Whs Adv Ent Ed(PVU) V9.7.3  Multilingual    July 8, 2011
                                (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whs Adv Ent Ed(Terabyte)    Multilingual    July 8, 2011
 V9.7.3                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English US,
                                Italian)
IS Whs Ent Ed-Terabyte Op      Multilingual    June 3, 2011
 V9.7.3                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)
IS Whse Ent Ed-PVU Option      Multilingual    June 3, 2011
 V9.7.3                         (French,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                English,
                                Italian)
Optim QT for DB2 for LUW       Multilingual    November 18, 2011
 V3.1.0                         (French,
                                Russian,
                                Korean,
                                Chinese -
                                Simplified,
                                Spanish,
                                Portuguese-Brazilian,
                                German,
                                Japanese,
                                Chinese -
                                Traditional,
                                Hungarian,
                                English,
                                Czech,
                                Italian,
                                Polish)


Back to topBack to top
 
Top rule
Program number
Bottom rule

Program    VRM                          Program name
number
 
5724-X97   3.1.0                        IBM InfoSphere Optim Query
                                         Tuner for DB2 for Linux,
                                         UNIX, and Windows
5725-E45   3.1.0                        IBM InfoSphere Optim Query
                                         Workload Tuner for DB2 for
                                         Linux, UNIX and Windows
5724-E34   9.7.3                        IBM InfoSphere Warehouse


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.



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 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.



Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

Before you install the InfoSphere Optim Query Workload Tuner client, verify that your system meets the minimum hardware requirements:

  • 1.5 GB available hard drive space
  • 1 GB memory (2 GB recommended)
  • 2 GHz Pentium® IV processor equivalent or better
Software requirements

The following operating systems are supported for this product:

  • Microsoft® Windows 7 x86-32 and x86-64
  • Microsoft Windows Vista x86-32 and x86-64
  • Microsoft Windows XP SP2 x86-64 and SP3 x86-32
  • Microsoft Windows Server 2003 x86-32 and x86-64
  • Microsoft Windows Server 2003 R2 x86-32 and x86-64
  • Microsoft Windows Server 2008 x86-32 and x86-64
  • Microsoft Windows Server 2008 R2 x86-64

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

The IBM InfoSphere Optim Query Workload Tuner for DB2 for LUW V3.1 (5655-W94) package includes:

  • IBM InfoSphere Optim Query Tuner Client Software V3.1 for Windows DVD
  • IBM InfoSphere Optim Query Workload Tuner for LUW V3.1.0.0 Server Configuration Kit DVD
  • IBM InfoSphere Optim Query Workload Tuner for LUW V3.1.0.0 Quick Start Guide (CD)
  • IBM InfoSphere Optim Query Workload Tuner for z/OS® V3.1.0.0 Quick Start Guide (Paper)
  • License document

Security, auditability, and control

IBM InfoSphere Warehouse 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.

Product information

Licensed function title             Product group   Product
                                                    category
 
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Enterprise Edition                  Management      Warehouse
                                     Other
IBM InfoSphere Warehouse            IBM Database    IBM InfoSphere
 Enterprise Edition Terabyte Option  Management      Warehouse
                                     Other
IBM Infosphere Warehouse Advanced   IBM Database    IBM InfoSphere
 Enterprise Edition - PVU Option     Management      Warehouse
                                     Other
IBM Infosphere Warehouse Advanced   IBM Database    IBM InfoSphere
 Enterprise Edition - Terabyte       Management      Warehouse
 Option                              Other
IBM Optim Query Tuner for DB2 for   IBM Database 2™  Data Studio
 Linux, UNIX, and Windows
InfoSphere Optim Query Workload     IBM Database 2  Data Studio
 Tuner for DB2 for Linux, UNIX and
 Windows
Program name                          PID        Charge unit
                                      number     description
 
IBM InfoSphere Warehouse Enterprise   5724-E34   Per Processor
 Edition                                          Value Unit (PVU)
                                                  for zBX and
                                                  Linux on System
                                                  z
IBM InfoSphere Warehouse Enterprise   5724-E34   Per Processor
 Edition                                          Value Unit (PVU)
IBM InfoSphere Warehouse Enterprise   5724-E34   Per Terabyte for
 Edition Terabyte Option                          Linux on System
                                                  z
IBM InfoSphere Warehouse Enterprise   5724-E34   Per Terabyte
 Edition Terabyte Option
IBM Infosphere Warehouse Advanced     5724-E34   Per Processor
 Enterprise Edition - PVU Option                  Value Unit (PVU)
                                                  for zBX and
                                                  Linux on System
                                                  z
IBM Infosphere Warehouse Advanced     5724-E34   Per Processor
 Enterprise Edition - PVU Option                  Value Unit (PVU)
IBM Infosphere Warehouse Advanced     5724-E34   Per Terabyte
 Enterprise Edition - Terabyte Option
IBM Infosphere Warehouse Advanced     5724-E34   Per Terabyte for
 Enterprise Edition - Terabyte Option             Linux on System
                                                  z
IBM Optim Query Tuner for DB2 for     5724-X97   PROCESSOR-Day(s)
 Linux, UNIX, and Windows
IBM Optim Query Tuner for DB2 for     5724-X97   Per Processor
 Linux, UNIX, and Windows                         Value Unit (PVU)
IBM Optim Query Tuner for DB2 for     5724-X97   Per Processor
 Linux, UNIX, and Windows                         Value Unit for
                                                  Linux on System
                                                  z
InfoSphere Optim Query Workload       5725-E45   Per Processor
 Tuner for DB2 for Linux, UNIX and                Value Unit (PVU)
 Windows
InfoSphere Optim Query Workload       5725-E45   Per Processor
 Tuner for DB2 for Linux, UNIX and                Value Unit (PVU)
 Windows                                          for zBX and
                                                  Linux on System
                                                  z

Charge metrics definitions

Terabyte (TB) metric guide

TB is a unit of measure by which the Program can be licensed. You are able to purchase the program based only on the amount of user data (TB) reported by the program. As your user data volumes grow, you can purchase additional warehousing capacity. User data is defined as user tables, derived summary tables (for multidimensional clustering), and temp tables.

For each database, you must acquire enough TB entitlements to cover the amount of user data reported by the program.

Example A

A database with 1.75 TB of data must acquire a 2 terabyte entitlement.

Example B

An instance with 2 databases, one storing 1.4 TB, and a second with 3.2 TB must acquire 6 TB (2 plus 4) worth of entitlement.

The actual amount of storage used can be measured by running the terabyte metric tool against each database.

Processor Value Unit (PVU)

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

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

and the number of processors made available to the program. 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 (refer to the webpage below). If using full capacity licensing, licensee must obtain PVU entitlements sufficient to cover all activated processor cores* 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

* 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

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 Advanced Enterprise Edition -
 Terabyte Option
IBM InfoSphere Warehouse Per Terabyte Annual SW S&S      E0CBLLL
 Rnwl
IBM InfoSphere Warehouse Per Terabyte Lic + SW S&S 12    D0K2BLL
 Mo
IBM InfoSphere Warehouse Per Terabyte SW S&S Reinstate   D0K2CLL
 12 Mo

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Enterprise Edition Terabyte
 Option
IBM InfoSphere Warehouse Per Terabyte Annual SW S&S      E0C6VLL
 Rnwl
IBM InfoSphere Warehouse Per Terabyte Lic + SW S&S 12    D0JPVLL
 Mo
IBM InfoSphere Warehouse Per Terabyte SW S&S Reinstate   D0JPWLL
 12 Mo

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM Infosphere Warehouse Advanced Enterprise Edition -
 PVU Option
IBM InfoSphere Warehouse Per Processor Value Unit (PVU)  E0CBKLL
 Annual SW S&S Rnwl
IBM InfoSphere Warehouse Per Processor Value Unit (PVU)  D0K29LL
 Lic + SW S&S 12 Mo
IBM InfoSphere Warehouse Per Processor Value Unit (PVU)  D0K2ALL
 SW S&S Reinstate 1

IS Optim QT for DB2 for LUW

Part description                                         Part
                                                         number
 
IBM Optim Query Tuner for DB2 for Linux, UNIX, and
 Windows
IS Optim QT for DB2 LUW Processor Value Unit (PVU) SW    D094MLL
 S&S Reinstate 12Mo
IS Optim QT for DB2 for LUW Processor Value Unit (PVU)   E06WMLL
 Annual SW S&S Rnwl
IS Optim QT for DB2 for LUWnProcessor Value Unit (PVU)   D094LLL
 Lic + SW S&S 12Mo

IS Optim Query Workload Tuner for DB2 for LUW

Part description                                         Part
                                                         number
 
InfoSphere Optim Query Workload Tuner for DB2 for
 Linux, UNIX and Windows
IS OQW Tuner for DB2 LUW Per Processor Value Unit (PVU)  E0CVALL
 Annual SW S&S Rnwl
IS OQW Tuner for DB2 LUW Per Processor Value Unit (PVU)  D0LFKLL
 Lic + SW S&S 12 Mo
IS OQW Tuner for DB2 LUW Per Processor Value Unit (PVU)  D0LFLLL
 SW S&S Reinstate 1

Passport Advantage trade-up licenses

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Trade-up
                                                        part
                                                        number
 
IBM InfoSphere Warehouse
 Enterprise Edition
 Terabyte Option
Infosphere Warehouse        IS Whs Per Terabyte fm Is   D0JUVLL
 Enterprise Base Edition     Whs Ent Bs Ed PVU Trade Up
 Per Processor Value Unit    Lic + SW S&S 12 Mo
 Option
Infosphere Warehouse        Is Whs Per Terabyte from    D0JUULL
 Enterprise Edition Per      IS Whs Ent Ed PVU Trade Up
 Processor Value Unit        Lic + SW S&S 12 Mo
 Option

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Trade-up
                                                        part
                                                        number
 
IBM Infosphere Warehouse
 Advanced Enterprise
 Edition - PVU Option
IBM InfoSphere Warehouse    IBM InfoSphere Warehouse    D0K2FLL
 Enterprise Edition          Per Processor Value Unit
                             (PVU) Trade Up Lic + SW

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Trade-up
                                                        part
                                                        number
 
IBM InfoSphere Warehouse
 Enterprise Edition
IBM DB2 Enterprise Server   InfoSphere Whse Enterp Ed   DOGIKLL
 Edition(PVU) and            Per Processor Value Unit
 Enterprise Warehouse        (PVU) Trade Up Lic + SW
 Feature (PVU)
IBM DB2 Advanced            InfoSphere Whse Enterp Ed   DOG6GLL
 Enterprise Server Edition   Per Processor Value Unit
 (PVU)                       (PVU) Trade Up Lic + SW

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Trade-up
                                                        part
                                                        number
 
IBM Infosphere Warehouse
 Advanced Enterprise
 Edition - Terabyte Option
IBM InfoSphere Warehouse    IBM InfoSphere Warehouse    D0K2GLL
 Enterprise Edition          Per Terabyte Trade Up Lic
 Terabyte Option             + SW S&S 12 Mo

IS Optim Query Workload Tuner for DB2 for LUW

Precursor product           Trade-up product            Trade-up
                                                        part
                                                        number
 
InfoSphere Optim Query
 Workload Tuner for DB2 for
 Linux, UNIX and Windows
IBM Optim Query Tuner for   IS OQW Tuner for DB2 LUW    D0LFMLL
 DB2 for Linux, UNIX, and    Per Processor Value Unit
 Windows                     (PVU) Trade Up Lic + SW

Passport Advantage supply

Program name/description                                 Part
                                                         number
 
IS OQW Tuner for DB2 LUW V3.1.0
IBM InfoSphere Optim Query Workload Tuner for DB2 for    BB18PML
 LUW V3.1 ML MP
IS Whs Adv Ent Ed(PVU) V9.7.3
IS Whs Adv Ent Ed(PVU) AIX® 6,Solaris x86 Platform        BB17UML
 Edition (Sun),SUSE Linux
IS Whs Adv Ent Ed(Terabyte) V9.7.3
IS Whs Adv Ent Ed(Terabyte) AIX 6,Solaris x86 Platform   BB17VML
 Edition (Sun),SUSE
IS Whs Ent Ed-Terabyte Op V9.7.3
IS Whs Ent Ed-Terabyte Op AIX 6,Solaris x86 Platform     BB17IML
 Edition (Sun),SUSE Li
IS Whse Ent Ed-PVU Option V9.7.3
InfoSphere Warehouse Enterprise Edition per PVU Option   BB17HML
 Multiplatform ML
Optim QT for DB2 for LUW V3.1.0
IBM InfoSphere Optim Query Tuner for DB2 for Linux,      BB18RML
 UNIX and Win V3.1 ML 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 Whs Ent Ed-Terabyte Op V9.7.3

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM IS Whse Ent Ed          IS Whs Ent Ed-Terabyte Op   BB17IML
 Terabyte Op for zEnt        AIX 6,Solaris x86 Platform
 BladeCenter® Extension and   Edition (Sun),SUSE Li
 Linux on Sys z per
 Terabyte
IBM Infosphere Warehouse    IS Whs Ent Ed-Terabyte Op   BB17IML
 Enterprise Edition          AIX 6,Solaris x86 Platform
 Terabyte Option per         Edition (Sun),SUSE Li
 Terabyte

IS Whs Adv Ent Ed(Terabyte) V9.7.3

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM IS Whse Advanced Ent    IS Whs Adv Ent              BB17VML
 Ed-Terabyte Op for zEnt     Ed(Terabyte) AIX 6,Solaris
 BladeCenter Extension and   x86 Platform Edition
 Linux on Sys z Terabyte     (Sun),SUSE
IBM Infosphere Warehouse    IS Whs Adv Ent              BB17VML
 Advanced Enterprise         Ed(Terabyte) AIX 6,Solaris
 Edition - Terabyte Option   x86 Platform Edition
 per Terabyte                (Sun),SUSE

Optim QT for DB2 for LUW V3.1.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM Optim Query Tuner for   IBM InfoSphere Optim Query  BB18RML
 DB2 for Linux, UNIX, and    Tuner for DB2 for Linux,
 Windows Per Processor       UNIX and Win V3.1 ML MP
 Value Unit Linux on System
 z
Optim Query Tuner for DB2   IBM InfoSphere Optim Query  BB18RML
 for Linux, UNIX, and        Tuner for DB2 for Linux,
 Windows PVU                 UNIX and Win V3.1 ML MP

IS Whse Ent Ed-PVU Option V9.7.3

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM IS Whse Ent Ed for      InfoSphere Warehouse        BB17HML
 zEnt BladeCenter Extension  Enterprise Edition per PVU
 and Linux on Sys z PVU      Option Multiplatform ML
IBM InfoSphere Warehouse    InfoSphere Warehouse        BB17HML
 Enterprise Edition          Enterprise Edition per PVU
 Processor Value Unit        Option Multiplatform ML

IS Whs Adv Ent Ed(PVU) V9.7.3

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM IS Whse Advanced Ent    IS Whs Adv Ent Ed(PVU) AIX  BB17UML
 Ed PVU Op for zEnt          6,Solaris x86 Platform
 BladeCenter Extension and   Edition (Sun),SUSE Linux
 Linux on Sys z PVU
IBM Infosphere Warehouse    IS Whs Adv Ent Ed(PVU) AIX  BB17UML
 Advanced Enterprise         6,Solaris x86 Platform
 Edition - PVU Option per    Edition (Sun),SUSE Linux
 Processor Value Unit

IS OQW Tuner for DB2 LUW V3.1.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
IBM InfoSphere Optim Query  IBM InfoSphere Optim Query  BB18PML
 Workload Tuner for DB2 for  Workload Tuner for DB2 for
 LUW per Linux Sys z         LUW V3.1 ML MP
 Processor Value Unit
IBM InfoSphere Optim Query  IBM InfoSphere Optim Query  BB18PML
 Workload Tuner for DB2 for  Workload Tuner for DB2 for
 LUW per Processor Value     LUW V3.1 ML MP
 Unit

Cross-platform products

Cross-platform product for use on System z IFL engines

Order the part numbers that follow when the product is intended to run on the Linux operating system on System z IFL engines. If the product is not intended to run on the Linux operating system on System z IFL engines, order from the other set of part numbers in this announcement. This set of part numbers provides the identical supply and authorization as the other set in this announcement.

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Enterprise Edition Terabyte
 Option
IBM InfoSphere Warehouse Per Terab for Lin on Sys z      E0D29LL
 Annual SW S&S Rnwl
IBM InfoSphere Warehouse Per Terab for Lin on Sys z Lic  D0LVKLL
 + SW S&S 12 Mo
IBM InfoSphere Warehouse Per Terab for Lin on Sys z SW   D0LVLLL
 S&S Reinstate 12 Mo

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM Infosphere Warehouse Advanced Enterprise Edition -
 PVU Option
IBM InfoSphere Whse Ent Adv Per PVU for zBX and Lin on   E0D2ALL
 z Annual SW S&S Rnwl
IBM InfoSphere Whse Ent Adv Per PVU for zBX and Lin on   D0LVPLL
 z Lic + SW S&S 12 Mo
IBM InfoSphere Whse Ent Adv Per PVU for zBX and Lin on   D0LVQLL
 z SW S&S Reinstate

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM InfoSphere Warehouse Enterprise Edition
InfoSphere Whse Enterp Ed Per PVU for zBX and Linux on   E0D28LL
 z Annual SW S&S Rnwl
InfoSphere Whse Enterp Ed Per PVU for zBX and Linux on   D0LVGLL
 z Lic + SW S&S 12 Mo
InfoSphere Whse Enterp Ed Per PVU for zBX and Linux on   D0LVHLL
 z SW S&S Reinstate

IBM InfoSphere Warehouse

Part description                                         Part
                                                         number
 
IBM Infosphere Warehouse Advanced Enterprise Edition -
 Terabyte Option
IBM InfoSphere Warehouse Adv Per Terab for Lin on Sys z  E0D2BLL
 Annual SW S&S Rnwl
IBM InfoSphere Warehouse Adv Per Terab for Lin on Sys z  D0LVSLL
 Lic + SW S&S 12 Mo
IBM InfoSphere Whse Adv Per Terab for Lin on Sys z SW    D0LVTLL
 S&S Reinstate 12 Mo

IS Optim QT for DB2 for LUW

Part description                                         Part
                                                         number
 
IBM Optim Query Tuner for DB2 for Linux, UNIX, and
 Windows
IS Optim QT for DB2 for LUW Per Proc VU for Lin Sys z    E07R3LL
 Annual SW S&S Rnwl
IS Optim QT for DB2 for LUW Per Proc VU for Lin Sys z    D0AZFLL
 Lic + SW S&S 12 Mo
IS Optim QT for DB2 for LUW Proc VU for Lin Sys z SW     D0AZGLL
 S&S Reinstate 12 Mo

IS Optim Query Workload Tuner for DB2 for LUW

Part description                                         Part
                                                         number
 
InfoSphere Optim Query Workload Tuner for DB2 for
 Linux, UNIX and Windows
IS OQW Tuner for DB2 LUW Per PVU for zBX and Linux on z  E0CVBLL
 Annual SW S&S Rnwl
IS OQW Tuner for DB2 LUW Per PVU for zBX and Linux on z  D0LFNLL
 Lic + SW S&S 12 Mo
IS OQW Tuner for DB2 LUW Per PVU for zBX and Linux on z  D0LFPLL
 SW S&S Reinstate 1

Trade-up licenses for cross-platform products

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM InfoSphere Warehouse
 Enterprise Edition
IBM InfoSphere Warehouse    InfoSphere Whse Enterp Ed   D0LVILL
 Advanced or Enterprise      Per PVU for zBX and Linux
 Base Edition (PVU)          on z Trade Up Lic + SW
IBM DB2 Enterprise Server   InfoSphere Whse Enterp Ed   D0LVJLL
 Edition (PVU)               Per PVU for zBX and Linux
                             on z Trade Up Lic + SW
IBM DB2 Advanced            InfoSphere Whse Enterp Ed   D0M2CLL
 Enterprise Server Edition   Per PVU for zBX and Linux
 PVU Option                  on z Trade Up Lic + SW
IBM DB2 Enterprise Server   InfoSphere Whse Enterp Ed   D0M2DLL
 Edition (PVU) and           Per PVU for zBX and Linux
 Enterprise Warehouse        on z Trade Up Lic + SW
 Feature (PVU)

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM Infosphere Warehouse
 Advanced Enterprise
 Edition - Terabyte Option
IBM InfoSphere Warehouse    IBM InfoSphere Whse         D0LVULL
 Enterprise Edition          Advanced Per Ter for Lin
 Terabyte Option             on Sys z Trade Up Lic + SW
                             S&S

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM InfoSphere Warehouse
 Enterprise Edition
 Terabyte Option
IBM InfoSphere Warehouse    IBM InfoSphere Warehouse    D0LVNLL
 Enterprise Edition          Per Terab for Lin on Sys z
                             Trade Up Lic + SW S&S
IBM InfoSphere Warehouse    IBM InfoSphere Warehouse    D0LVMLL
 Enterprise Base Edition     Per Terab for Lin on Sys z
                             Trade Up Lic + SW S&S

IBM InfoSphere Warehouse

Precursor product           Trade-up product            Part
                                                        number
 
IBM Infosphere Warehouse
 Advanced Enterprise
 Edition - PVU Option
IBM InfoSphere Warehouse    IBM InfoSphere Whse Adv     D0LVRLL
 Enterprise Edition          Per PVU for zBX and Linux
                             on z Trade Up Lic + SW

IS Optim Query Workload Tuner for DB2 for LUW

Precursor product           Trade-up product            Part
                                                        number
 
InfoSphere Optim Query
 Workload Tuner for DB2 for
 Linux, UNIX and Windows
IBM Optim Query Tuner for   IS OQW Tuner for DB2 LUW    D0LFQLL
 DB2 for Linux, UNIX, and    Per PVU for zBX and Linux
 Windows                     on z Trade Up Lic + SW

On/Off CoD

IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows

Part description                                         Part
                                                         number
 
IS Optim QT for DB2 for LUW PROCESSOR-Day(s) Per         D094SLL
Use-Day 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.

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

License Information form numbers
Program name                              Program    Form number
                                          number
 
IBM InfoSphere Warehouse                  5724-E34   L-DCLN-7NPV2N
IS Optim QT for DB2 for LUW               5724-X97   L-HYWU-8JXASU
IS Optim Query Workload Tuner for DB2     5725-E45   L-HYWU-8JXAXN
 for LUW

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

Limited 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. For further information, consult the IBM Software Support Handbook found 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 version or release 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 (modifications or fixes), 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

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.

International Passport Agreement
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.

Software Subscription and Support (Software Maintenance)

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 website at

http://www.ibm.com/software/passportadvantage
Other terms
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
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, 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 your local IBM representative or your IBM Business Partner.

To identify your local IBM Business Partner or IBM representative, call 1 800-IBM-4YOU (426-4968). 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

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

InfoSphere, DB2, IBM, System z, Passport Advantage, Express, z/OS, AIX, BladeCenter, iSeries, pSeries, ValueNet 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 and Microsoft are registered trademarks of Microsoft Corporation in the United States, other countries, or both.

Pentium 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/

Terms of use