Feedback

IBM Optim Query Tuner for Linux , UNIX , and Windows , V2.2 cuts costs and improves performance by providing expert advice on writing high quality queries

IBM United States Software Announcement 209-132
June 2, 2009

 
 ENUS209-132.PDF (100KB)

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

 
Top rule
At a glance
Bottom rule

IBM® Optim Query Tuner for Linux®, UNIX®, and Windows®, V2.2 is a new solution designed to provide expert advice on query tuning.

  • Graphical query information: Access Plan Graph, Query Annotation, and the Query Report provide key information needed to understand the access path and tune the query.
  • Query Advisors: Query Advisor, Access Path Advisor, Statistics Advisor, and Index Advisor guide the user with expert advice on how to boost the performance of the SQL statement.
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers 
at 800-IBM-CALL (Reference:  YE100).

 
Back to topBack to top
 
Top rule
Overview
Bottom rule

IBM Optim Query Tuner for Linux, UNIX, and Windows, V2.2 can help cut costs and improve performance by providing expert advice on writing high quality queries and improving database design. Its easier-to-use advisors can encourage developers to write higher quality SQL code. Built-in integration with Optim Development Studio makes it even easier to find problematic queries in development and launch Query Tuner in context. Database administrators can further tune performance by optimizing statistics and index creation. Both novice and expert SQL developers will find facilities designed to help them develop better performing SQL code.

IBM Optim Query Tuner for DB2® for Linux, UNIX, and Windows offers tools and advisors that provide expert recommendations to DBAs and developers to help improve the performance of individual queries. The following tools and advisors are provided:

  • Access Plan Graph provides a graphical view of the access chosen by the optimizer.
  • Query Annotation formats the query and provides catalog statistics and cost estimates.
  • Query Advisor provides query rewrite advice based on a set of best practice rules.
  • Access Path Advisor provides advice on how to resolve access path issues that may result in poor performance.
  • Statistics Advisor provides advice on missing, outdated, and conflicting statistics and suggests additional statistics that should be gathered to improve query performance.
  • Index Advisor provides advice on new indexes that may improve performance as well as the ability to define user-defined virtual indexes.
  • Query Report reports that identify key statistics, access path information, and physical database design information related to a query.

New features in this release:

  • Integrate with IBM Optim Development Studio, including the ability to launch Query Tuner in context from any SQL statement.
  • Manage connections in common across Optim Query Tuner, Optim Development Studio, Optim Database Administrator, and InfoSphere Data Architect.
  • Capture and analyze queries from the Integrated Query Editor (IQE) and routine editor.
  • Capture and analyze queries from the pureQuery profiler and editor.
  • Capture and analyze queries within code editors.
  • Capture and analyze SQL, UDFs, SQL-stored procedures, triggers, packages, and views from the Data Source Explorer.
  • Integrate with IBM Optim Development Studio Data Perspective.
  • Experience integrated look and feel when evaluating advisor recommendations.
  • Group statements and maintain versions of statements and analysis results using expanded project management capabilities.
  • Compare Access Plan Graphs between two statements or tuning analysis results visually.
  • Using Statistics Advisor, save implemented RUNSTAT recommendations to the server statistics profile table for later recall.
  • Using Statistics Advisor, interact with the auto-stats feature of DB2 for Linux, UNIX, and Windows.
  • Act on Index Advisor recommendations for indexes that could be dropped or combined to save storage.

 
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 dates
Bottom rule

June 19, 2009 (electronic software delivery)

July 17, 2009 (media and documentation)


 
Back to topBack to top
 
Top rule
Description
Bottom rule

Accessibility by people with disabilities

A U.S. Section 508 Voluntary Product Accessibility Template (VPAT) can be requested at

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

Section 508 of the U.S. Rehabilitation Act

Optim QT for DB2 for LUW is capable as of July 17, 2009, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. A U.S. Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested on the following Web site

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

 
Back to topBack to top
 
Top rule
Product positioning
Bottom rule

Optim Query Tuner is designed for those individuals that would like to tune singular SQL statements as part of their development process or to tune poor-performing queries running in production. This functionality is most commonly used by developers, and for that reason, Optim Development Studio V2.2 provides integration to Optim Query Tuner, making it easier for a developer to tune the query as part of the development process. Earlier and easier access to tuning advice will encourage SQL optimization prior to deployment into production, helping to prevent performance issues and significantly cut maintenance costs.


 
Back to topBack to top
 
Top rule
Program number
Bottom rule

Program
number     VRM                          Program name
 
5724-X97   2.2.0                        IBM Optim Query Tuner for
                                        DB2 for Linux, UNIX, and
                                        Windows V2.2

 
Back to topBack to top
 
Top rule
Education support
Bottom rule

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

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

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

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 range of training options from traditional classroom to Instructor-Led Online to meet your demanding schedule. Instructor-Led Online (ILO) is an innovative learning format where students get the benefit of being in a classroom with the convenience and cost savings of online training.

Go green with IBM Onsite training for groups as small as three or as large as 14. Choose from the same quality training delivered in classrooms, or customize a course or a selection of courses to best suit your business needs.

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 and Education Web site or with your training representative for the most recent training schedule.

Descriptions of courses for IT professionals and managers are available at

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

Visit ibm.com/training or call IBM training at 800-IBM-TEACH (426-8322) for scheduling and enrollment.


 
Back to topBack to top
 
Top rule
Offering Information
Bottom rule

Product information is available via the Offering Information Web site

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

Also, visit the Passport Advantage® Web site

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

 
Back to topBack to top
 
Top rule
Publications
Bottom rule

No hardcopy publications are shipped with 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® 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.

For additional Redbooks, refer to

http://www.redbooks.ibm.com/

 
Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows, V2.2 requires a workstation with:

  • 500 MB of DASD
  • 1 GB of memory
  • Pentium® IV processor, or equivalent
Software requirements

IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows, V2.2 supports the following databases:

  • DB2 for Linux, UNIX, and Windows, V9.5 Fixpack1, or later, and V9.7

The Optim Query Tuner client requires workstations with:

  • Microsoft® Windows Vista Business, Enterprise, or Ultimate 32 and 64 bit (in 32-bit compatibility mode)
  • Microsoft Windows XP Professional 32 and 64 bit (SP2) (in 32-bit compatibility mode)

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

Planning information

Customer responsibilities

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 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 with each program license acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available.

Packaging

The IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows package includes:

  • IBM Optim Query Tuner Client Software V2.2 for Windows DVD
  • IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows V2.2 Server Configuration Kit - Multimedia CD
  • Quick Start CD

Security, auditability, and control

Optim QT for DB2 for LUW 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
Software Services
Bottom rule

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

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

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

 
Back to topBack to top
 
Top rule
Ordering information
Bottom rule

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

Product information

                                                    Product
Licensed function title             Product group   category
 
IBM Optim Query Tuner for DB2 for   IBM Database 2™  DB2
Linux, UNIX, and Windows
                                      PID        Charge unit
Program name                          number     description
 
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   PROCESSOR-Day(s)
 Linux, UNIX, and Windows

Charge metrics definitions

Processor Value Unit (PVU)

PVU is the unit of measure by which this program is licensed. PVU entitlements are based on processor families (vendors and brands). A Proof of Entitlement (PoE) must be obtained for the appropriate number of PVUs based on the level or tier of all processor cores activated and available for use by the program on the server. Some programs allow licensing to less than the full capacity of the server's activated processor cores, sometimes referred to as sub-capacity licensing. For programs which offer sub-capacity licensing, if a server is partitioned utilizing eligible partitioning technologies, then a PoE must be obtained for the appropriate number of PVUs based on all activated processor cores available for use in each partition where the program runs or is managed by the program. Refer to the International Passport Advantage Agreement Attachment for Sub-Capacity Terms or the program's License Information to determine applicable sub-capacity terms. The PVU entitlements are specific to the program and may not be exchanged, interchanged, or aggregated with PVU entitlements of another program.

For general overview of PVUs for processor families (vendors and brands), go to

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

To calculate the exact PVU entitlements required for the program, go to

https://www-112.ibm.com/software/howtobuy/passportadvantage/ valueunitcalculator/vucalc.wss

Passport Advantage program licenses

Optim QT for DB2 for LUW

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

Passport Advantage supply

                                                         Part
Program name/description                                 number
 
Optim QT for DB2 for LUW V2.2.0
Optim QT for DB2 for LUW Windows Vista Business,Windows  BB11HML
 Vista Enterprise,W

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.

Optim QT for DB2 for LUW V2.2.0

Entitled maintenance                                    Part
offerings description       Media packs description     number
 
Optim Query Tuner for DB2   Optim QT for DB2 for LUW    BB11HML
for Linux, UNIX, and        Windows Vista
Windows PVU                 Business,Windows Vista
                            Enterprise,W

On/Off CoD

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

                                                         Part
Part description                                         number
 
Optim Query Tuner for DB2 for LUW Processor Day 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
Program name                              number    Form number
 
Optim QT for DB2 for LUW                  5724-X97   L-DNAA-7PSNJL

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

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

Yes

Warranty

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

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

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

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

Program technical support

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

Money-back guarantee

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

  • For programs acquired under the IBM International Passport Advantage Agreement, this term applies only to your first acquisition of the program.
  • For programs acquired under any of IBM's On/Off CoD software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.
Authorization for use on home/portable computer

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

Product name
 
Optim QT for DB2 for LUW               No
Volume orders (IVO)

No

Passport Advantage applies

Yes, and through the Passport Advantage Web site at

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

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

Usage restriction

Yes

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

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

Yes. Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support 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 with each program license acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available.

While your Software Subscription and Support 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 does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under the applicable agreements.

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

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

No

Educational allowance available

Not applicable.

On/Off CoD

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


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

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

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

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


 
Back to topBack to top
 
Top rule
Prices
Bottom rule

Passport Advantage

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

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

Business Partner information

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

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

 
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)
Internet:   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: YE100

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

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

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

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

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

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

 

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