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-450October 18, 2011
ENUS211-450.PDF| Table of contents | ||||||||||||||||||||||
|
|
| At a glance |
 |
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 top
|
|
| Overview |
|
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 top
|
|
| Key prerequisites |
|
refer to the Hardware requirements and Software requirements sections for details.
Back to top
|
|
| Planned availability date |
|
October 21, 2011: Electronic availability
November 18, 2011: Media availability
Back to top
|
|
| Description |
|
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
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
Back to top
|
|
| Availability of national languages |
|
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 top
|
|
| Program number |
|
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 top
|
|
| Education support |
|
IBM training provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM training website
Call IBM training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
Back to top
|
|
| Offering Information |
|
Product information is available via the Offering Information website
Also, visit the Passport Advantage® website
Back to top
|
|
| Publications |
|
No hardcopy publications are shipped with these products.
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 to top
|
|
| Technical information |
|
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 top
|
|
| Ordering information |
|
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
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
* 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 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 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
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
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
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
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
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 top
|
|
| IBM Electronic Services |
|
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 top
|
|
| Prices |
|
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
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.
Back to top
|
|
| Order now |
|
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
For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page
