Raise performance with IBM InfoSphere Optim Performance Manager V5.2, IBM Query Workload Tuner, and IBM pureQuery Runtime V3.2 for Linux, UNIX, and Windows
IBM United States Software Announcement 212-489December 4, 2012
ENUS212-489.PDF
|
| At a glance |
 |
New releases of the products within the InfoSphere® Optim™ Performance Management solution deliver the following capabilities:
- Improved performance that can help to reduce cost of ownership for DB2® for Linux™ , UNIX™ , and Windows™ databases
- Improved and streamlined analysis of SQL workloads, functions to facilitate iterative improvements, and enhanced "what-if" analysis
- Enhanced alert management by the inclusion of improvements for customized alert views, blackout scheduling, and automated actions
- More complete stored procedure debugging, streamlined tuning, and comprehensive monitoring
The InfoSphere Optim Performance Management offering includes new releases of InfoSphere Optim Performance Manager, InfoSphere Optim Query Workload Tuner, InfoSphere Optim pureQuery™ Runtime, and Data Studio.
Back to top
|
|
| Overview |
|
The IBM® InfoSphere Optim Performance Management solution includes several products that work together to improve the performance of DB2 databases and can help reduce cost of ownership by improving system utilization and staff productivity.
IBM InfoSphere Optim Performance Manager V5.2 can help businesses improve database and application performance and reduce costs by giving database administrators and other IT staff the information needed to manage performance proactively. Enhancements to Version 5.2 include:
- Extending SQL analysis features
- Advancing alert management
- Facilitating report automation
IBM InfoSphere Optim Query Workload Tuner for DB2 Linux , UNIX , Windows V3.2 provides expert, actionable guidance for improving the performance of queries and query workloads. The program's "advisors" functionality can provide guidance on queries, statistics, statistical views, indexes, materialized query tables (MQTs), indexes on MQTs, multidimensional clustering and distributing data. Version 3.2 enables database administrators or developers to compare access plans for iterative tuning, "what-if" analysis, and preparation for database or application migration. Additional enhancements simplify "what-if" analysis to make it easier to assess the impact of changes before they are made; make it easier to capture a workloads for tuning; and to help streamline workflow when using IBM Data Studio.
IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2 provides the ability to improve SQL performance and mitigate security risks of both new and existing applications. Use IBM InfoSphere pureQuery Runtime to replace poorly performing SQL that occur dynamically or to help locate SQL to be changed in source code. Many enhancements to Version 3.2 make it easier to install and provide for more flexibility in both configuration and tuning. With this Version 3.2 of the program, you can capture SQL from the DB2 for z dynamic cache making it even easier to optimize applications.
IBM Data Studio V3.2 can help improve the productivity of database administrators and developers. Use Data Studio to manage DB2 instances and databases. Task assistants functionality help simplify the generation and execution of commands and utilities. Data Studio helps make even the most complex changes to database objects easy. For Developers, Data Studio offers comprehensive tooling for routine development and debugging.
In Version 3.2, there are many enhancements to the routine debugger that include support for triggers, PL/SQL anonymous blocks, and declared routines. The Data Studio web console provides database health monitoring and job scheduling capabilities. Enhancements made in Version 3.2 feature improved alert management in addition to others.
For ordering, contact your IBM representative or an IBM Business Partner. For more information contact the Americas Call Centers at 800-IBM-CALL (426-2255) Reference: YE001
Back to top
|
|
| Key prerequisites |
|
For details, refer to the Hardware requirements section.
Back to top
|
|
| Planned availability date |
|
- December 7, 2012: Electronic availability
- January 4, 2013: Media availability
Back to top
|
|
| Description |
|
InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.2 is designed to help IT staff and database administrators track performance, and become alert to performance trends and it can help enable them to take action early to maintain service level agreements. The "extended insight" capability extends monitoring across the application stack to help quickly narrow down bottlenecks to data access.
New to Version 5.2
- With InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.2, database administrators can better understand the performance of stored procedures. Stored procedures may be analyzed and ranked according to aggregate cost. Drill-down capabilities provide the ability to analyze call paths and correlate SQL statements with the procedures that issue them without the overhead of SQL statement tracing.
- Workload-specific monitoring templates are updated to reflect aggregated customer experience and to provide better guideline on use.
- Users can easily get regular reports via the new report scheduler that includes email notification and report storage and retention management in the repository.
- Blackouts for monitoring activities, job execution, and alerts can now be more flexibly scheduled. This includes multiday periods, repeating windows, and custom scheduled windows.
- Users can automate responses to alerts via user-defined jobs that may be triggered when either a predefined or user-defined alert is encountered.
- Database connection information may be kept in sync with the enterprise by utilizing the new synchronization between InfoSphere Optim Configuration Managers centralized database repository and InfoSphere Optim Performance Managers database list.
- The At-a-glance view in the performance overview dashboard now provides the operating system performance details for HP-UX and Solaris.
InfoSphere Optim Query Workload Tuner for DB2 Linux , UNIX , and Windows V3.2 provides assistance in tuning both individual SQL statements as well as tuning advice for a complete sql workload. It takes the whole workload into account. The program's "advisor" functionality can provide guidance on statistics, statistical views, indexes, MQTs, indexes on MQTs, multidimensional clustering and distributing data.
New to Version 3.2
- Improvements in "what-if" analysis allow for determining the impact on a workload of a change to one or more indexes. Determine the possible benefit or negative impact on a workload by the virtual creation or dropping of an index without actually implementing the change.
- Use the new workload access plan comparator to compare access paths using the "what-if" scenario above or to compare access paths between two workloads, even on different systems such as test and production. The workload access plan comparator can also be used to assist in locking down access plans for a very large workload.
- The index advisor may now provide recommendations for the elimination of existing non-unique indexes due to the presence of existing near-duplicate, unique indexes. It also now displays the LAST_USED time for existing indexes to further help with the analysis of the use of an index.
- Workloads may now be captured from EXPLAIN tables or ACTIVITY event monitors, along with their access plan.
- Users may now use the workload summary report to improve collaboration across their organization. This report summarizes the various recommendations provided by InfoSphere Optim Query Workload Tuner.
- InfoSphere Optim Query Workload Tuner now offers native 64-bit support.
IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2 provides the ability to improve SQL performance of both new and existing applications. Use IBM InfoSphere pureQuery Runtime to replace poorly performing SQL activities that develop or occur dymanically or to help locate SQL to be changed in source code.
New to Version 3.2
- New configuration scripts make it easier to install the pureQuery Runtime on a WebSphere® application server.
- Application SQL may now be captured directly from the DB2 for z/OS® dynamic cache, simplifying the application SQL capture process and reducing the time needed to use IBM InfoSphere pureQuery Runtime to optimize applications.
- Activate pureQuery property changes that control client application behavior on demand.
- IBM InfoSphere pureQuery Runtime can now be configured to use different repositories which provides customers with several benefits including the ability to use different repositories for different application verticals. Repositories used by different versions of IBM InfoSphere pureQuery Runtime may now reside on the same database through the support of multiple schemas.
- Identify and support singleton select statements used by applications to improve performance by using less expensive methods to retrieve database data.
IBM Data Studio V3.2 can help improve the productivity of database administrators and developers. Use Data Studio to manage DB2 instances and databases. Task assistant functionality help simplify the generation and execution of commands and utilities. Data Studio helps make even the most complex changes to database objects easy. For developers, Data Studio offers comprehensive tooling for routine development and debugging. The Data Studio web console provides database monitoring and job scheduling capabilities.
New to Version 3.2
- Data Studio web console supports blackout scheduling, automated alert response, synchronization of database connection information, and individually defined preferences for alert filters and grouping.
- Debug triggers and PL/SQL anonymous blocks by using the integrated debugger that allows for breakpoints, stepping options, and viewing-altering variables.
- Set and persist breakpoints in the routine editor. This is especially useful for debugging nested routines when the code of interest is several levels deep in the nesting.
- The debugger now supports declared routines. Global and package variables, associative arrays, and array of rows may now be viewed and altered in the debugger.
- To simplify debugging, when used with DB2 Linux , UNIX , and Windows V10 FP2 and later, Data Studio V3.2 supports recompiling routines without having to redeploy. Users no longer have to remember their deployment options when recompiling to and from debug mode.
- When profiling a procedure on DB2 Linux , UNIX , and Windows V9.7.4 or later, Data Studio can now provide consistent access plan information when using InfoSphere Optim Query Workload Tuner to tune a profiled statement.
- To improve readability, SQL statements may now be formatted within the routine editor.
- Data Studio Eclipse client now offers native 64-bit support.
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 Optim Query Workload Tuner, IBM Optim Performance Manager V5.2, IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2 are capable as of January 4, 2013 , when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. A US Section 508 Voluntary Product Accessibility Template (VPAT), containing details on the products accessibility compliance, can be requested on the following website
Back to top
|
|
| Product positioning |
|
Several separate products provide targeted functionality yet are integrated with each other to provide a continuous workflow.
InfoSphere Optim Performance Manager offerings are designed for those individuals responsible for the overall performance of their DB2 for Linux , UNIX , and Windows data servers, typically a DBA or an application owner. It provides 24x7 monitoring of the application database and alerts users to potential problems so that they can be resolved before impacting the business.
InfoSphere Optim Performance Manager provides drill down from alerts to diagnostic detail for determining whether the source of the problem is CPU, I/O, memory, workload, SQL, or another area. Integration with InfoSphere Optim Query Workload Tuner enables seamless analysis of query workloads and recommends resolutions to improve performance. InfoSphere Optim Performance Manager also enables users to collect, prune, and retain historical information facilitating problem determination, trend analysis, and capacity planning.
Historical information lets users go back in time and see how a problem arose, mitigate problems first, and do causal analysis later, or compare current values to earlier time periods. It also helps staff be proactive about query tuning to optimize resource utilization and to plan for growth.
IBM InfoSphere Optim Query Workload Tuner
IBM InfoSphere Optim Query Workload Tuner facilitates query and query workload analysis and provides expert recommendations for improving query and query workload performance. Use InfoSphere Optim Performance Manager to identify slow running queries, top CPU consumers, or query workloads needing performance improvements and seamlessly transfer them to InfoSphere Optim Query Workload Tuner for analysis and recommendations.
Query Workload Tuner facilitates query analysis using query formatting annotated with relevant statistics, access plan graphical or hierarchical views, and access plan analysis. It further provides recommendations for improving query structure, statistics collection, and indexes including generated command syntax and rationale for the recommendations.
IBM Data Studio
IBM Data Studio provides database development and administration tooling for DB2 and other databases at no charge. When performance problems indicate a need for database configuration changes, Data Studio may be used to make configuration changes, object changes, create and schedule command scripts, and more.
When using Data Studio for query development, developers can use the InfoSphere Optim Performance Manager integration to see the actual performance improvements across iterations of query executions. Data Studio also includes a taste of the Query Tuner capabilities by providing integrated query transfer from InfoSphere Optim Performance Manager, query formatting, access plan visualization, and statistics advice for a single query.
Data Studio also offers health monitoring for DB2 for Linux , UNIX , and Windows databases, a very small subset of InfoSphere Optim Performance Manager capabilities. Health monitoring is focused on assuring that applications are not blocked from running due to the state of the database, for example, a database is down, a tablespace is about to run out of storage, or other similar states. Providing a simple deployment, browser-based UI, and contextual launching from within the Data Studio eclipse clients, it is useful for monitoring development databases or providing an easy-to-use interface to IT staff not focused on deep database diagnostics.
IBM InfoSphere Optim Configuration Manager
IBM InfoSphere Optim Configuration Manager helps organizations discover, manage, and track their database and client inventory, configuration, and deployments. When performance degradation occurs, the first question is often "what changed?". InfoSphere Optim Performance Manager provides integration with InfoSphere Optim Configuration Manager to view changes for the performance context in question so database administrators can quickly determine whether recent changes may be the underlying cause of performance issues.
IBM Tivoli® Composite Application Manager for Transactions
IBM Tivoli Composite Application Manager for Transactions helps organizations more quickly and easily detect and isolate transaction response and availability issues. It enables faster problem resolution. IT staff can view auto-generated topology mappings to follow the path of a user transaction across the domains of the users' infrastructure in a process that is transparent to end users. View time spent in each components and launch in-context subject matter expert capabilities for deep-dive analysis directly from the topology mapping.
InfoSphere Optim Performance Manager is a complementary offering that provides the deep-dive analysis for DB2 for Linux , UNIX , and Windows databases. Contextual launch points are built in between Tivoli Composite Application Manager for Transactions and InfoSphere Optim Performance Manager.
IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows
IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows is used by both developers and administrators to simplify application code, improve application performance and improve data security. When used with Data Studio, it helps developers rapidly build database applications reinforcing best practices. The run time may be used by DBAs to improve SQL performance for an application without having to modify the application. pureQuery may be used to improve data security by allowing execution of only approved SQL.
Back to top
|
|
| Availability of national languages |
|
Product description Language General availability date
IBM InfoSphere Optim Multilingual January 4, 2013
Performance Manager for DB2 (French, Russian,
for Linux, UNIX, and Windows Portuguese-Brazilian,
Enterprise Edition V5.2.0 Korean, Spanish,
Chinese-Simplified,
German, Japanese,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
IBM InfoSphere Optim Multilingual January 4, 2013
Performance Manager for DB2 (French, Russian,
for Linux, UNIX, and Windows Korean, Spanish,
Workgroup Edition V5.2.0 Chinese-Simplified,
Portuguese-Brazilian,
German, Japanese,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
IBM InfoSphere Optim Multilingual January 4, 2013
Performance Manager for DB2 (French, Russian,
for Linux, UNIX, and Windows Korean, Spanish,
Content Manager Edition German, Japanese,
V5.2.0 Chinese-Simplified,
Portuguese-Brazilian,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
IBM InfoSphere Optim Multilingual January 4, 2013
Performance Manager Extended (French, Russian,
Edition for DB2 for Linux, Korean, Spanish,
UNIX, and Windows V5.2.0 Chinese-Simplified,
Portuguese-Brazilian,
German, Japanese,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
IBM InfoSphere Optim Multilingual January 4, 2013
Performance Manager Extended (French, Russian,
Insight for DB2 for Linux, Korean, Japanese,
UNIX, and Windows V5.2.0 Chinese-Simplified,
Spanish, German,
Portuguese-Brazilian,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
IBM InfoSphere Optim Query Multilingual January 4, 2013
Workload Tuner for DB2 for (French, Russian,
Linux, UNIX, and Windows Korean, Spanish,
V3.2.0 Chinese-Simplified,
Portuguese-Brazilian,
German, Japanese,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
IBM InfoSphere Optim Multilingual January 4, 2013
pureQuery RunTime for Linux, (French, Russian,
UNIX, and Windows V3.2.0 Korean, Spanish,
Chinese-Simplified,
Portuguese-Brazilian,
German, Japanese,
Chinese-Traditional,
Hungarian, English,
Czech, Italian, Polish)
Back to top
|
|
| Program number |
|
Program
number VRM Program name
5724-Z20 5.2.0 IBM InfoSphere Optim Performance Manager
Extended Edition for DB2
for Linux, UNIX, and Windows
5724-Y94 5.2.0 IBM InfoSphere Optim Performance Manager
for DB2 for Linux, UNIX, and Windows
5725-E45 3.2.0 IBM InfoSphere Optim Query Workload Tuner
for DB2 for Linux, UNIX and Windows
5724-X84 3.2.0 IBM InfoSphere Optim pureQuery Runtime
for Linux, UNIX, and Windows
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
For detailed hardware and software requirements, refer to the following support pages.
InfoSphere Optim Performance Manager server
InfoSphere Optim Performance Manager Extended Insight client
InfoSphere Optim Query Workload Tuner for DB2 Linux , UNIX , Windows V3.2
IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2
IBM Data Studio V3.2
Software requirements
The program's specifications and specified operating environment information may be found in documentation accompanying the program, if available, such as a README file, or other information published by IBM , such as an announcement letter. Documentation and other program content may be supplied only in the English language.
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
IBM InfoSphere Optim Performance Manager V5.1 for DB2 for Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Content Manager Edition Media Pack Multilingual
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start Guide -- Paper
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start -- CD
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Content Manager Edition - License Activation Kit -- DVD
- IBM InfoSphere Optim Performance Manager Server V5.2 for Multiplatforms -- DVD
- IBM DB2 Performance Expert Client V5.2 for Linux on System x® and Windows -- DVD
- DB2 ESE V10.1 Restricted use Quick Start and Activation -- CD
- DB2 Enterprise Server Edition V10.1 for Windows on 32-bit AMD and Intel™ systems (x86) -- DVD
- DB2 Enterprise Server Edition V10.1 for Windows on AMD64 and Intel(R) EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for AIX® -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on UltraSPARC systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on x64 systems --DVD
- DB2 Enterprise Server Edition V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on POWER® ( System i® and System p® ) systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on System z® -- DVD
- DB2 Enterprise Server Edition V10.1 for HP-UX on HP Integrity Itanium-based systems
- IBM Data Server Client V10.1 for Windows on 32-bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Windows on AMD64 and Intel EM64T systems (x64) -- DVD
- Data Server Client V10.1 for Linux on 32 bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- IBM Tivoli Common Reporting V2.1.1 Quick Start Guide Multiplatform Multilingual
- Tivoli Common Reporting V2.1.1 for Windows 32 bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 AIX-32 bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 32-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Solaris 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux on System z 32 bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Cognos® Framework Manager Multiplatform Multilingual
IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Enterprise Edition Media Pack Multilingual
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start Guide -- Paper
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start -- CD
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Enterprise Edition - License Activation Kit -- DVD
- IBM InfoSphere Optim Performance Manager Server V5.2 for Multiplatforms -- DVD
- DB2 Performance Expert Client V5.2 for Linux xSeries® , and Windows -- DVD
- DB2 ESE V10.1 Restricted use Quick Start and Activation -- CD
- DB2 Enterprise Server Edition V10.1 for Windows on 32 bit AMD and Intel systems (x86) -- DVD
- DB2 Enterprise Server Edition V10.1 for Windows on AMD64 and Intel(R) EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for AIX -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on UltraSPARC systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on x64 systems --DVD
- DB2 Enterprise Server Edition V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on POWER ( System i and System p ) systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on System z -- DVD
- DB2 Enterprise Server Edition V10.1 for HP-UX on HP Integrity Itanium-based systems
- Data Server Client V10.1 for Windows on 32-bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Windows on AMD64 and Intel EM64T systems (x64) -- DVD
- Data Server Client V10.1 for Linux on 32-bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- Tivoli Common Reporting V2.1.1 Quick Start Guide Multiplatform Multilingual
- Tivoli Common Reporting V2.1.1 for Windows 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 AIX 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 32-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Solaris 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux on System z 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Cognos Framework Manager Multiplatform Multilingual
IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Workgroup Edition Media Pack Multilingual
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start Guide -- Paper
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start -- CD
- IBM InfoSphere Optim Performance Manager V5.2 for DB2 for Linux , UNIX , and Windows , Workgroup Edition - License Activation Kit -- DVD
- IBM InfoSphere Optim Performance Manager Server V5.2 for Multiplatforms -- DVD
- DB2 Performance Expert Client V5.2 for Linux xSeries , and Windows -- DVD
- DB2 ESE V10.1 Restricted use Quick Start and Activation -- CD
- DB2 Enterprise Server Edition V10.1 for Windows on 32 bit AMD and Intel systems (x86) -- DVD
- DB2 Enterprise Server Edition V10.1 for Windows on AMD64 and Intel(R) EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for AIX -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on UltraSPARC systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on x64 systems --DVD
- DB2 Enterprise Server Edition V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on POWER ( System i and System p ) systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on System z -- DVD
- DB2 Enterprise Server Edition V10.1 for HP-UX on HP Integrity Itanium-based systems
- Data Server Client V10.1 for Windows on 32-bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Windows on AMD64 and Intel EM64T systems (x64) -- DVD
- Data Server Client V10.1 for Linux on 32 bit-AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- Tivoli Common Reporting V2.1.1 Quick Start Guide Multiplatform Multilingual
- Tivoli Common Reporting V2.1.1 for Windows 32 bit, 64 Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 AIX 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 32-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Solaris 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux on System z 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Cognos Framework Manager Multiplatform Multilingual
IBM InfoSphere Optim Performance Manager Extended Edition V5.2 for DB2 for Linux , UNIX , and Windows Media Pack Multilingual
- IBM InfoSphere Optim Performance Manager Extended Edition V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start Guide -- Paper
- IBM InfoSphere Optim Performance Manager Extended Edition V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start -- CD
- IBM InfoSphere Optim Performance Manager Extended Edition V5.2 for DB2 for Linux , UNIX , and Windows , License Activation Kit -- DVD
- IBM InfoSphere Optim Data Tools Runtime Client V2.2 -- DVD
- IBM InfoSphere Optim Performance Manager Extended Edition V5.2 Plugin for Tivoli Enterprise Portal - DVD
- IBM InfoSphere Optim Performance Manager Server V5.2 for Multiplatforms -- DVD
- DB2 Performance Expert Client V5.2 for Linux xSeries , and Windows -- DVD
- DB2 ESE V10.1 Restricted use Quick Start and Activation -- CD
- DB2 Enterprise Server Edition V10.1 for Windows on 32-bit AMD and Intel systems (x86) -- DVD
- DB2 Enterprise Server Edition V10.1 for Windows on AMD64 and Intel(R) EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for AIX -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on UltraSPARC systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Solaris on x64 systems --DVD
- DB2 Enterprise Server Edition V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on POWER ( System i and System p ) systems -- DVD
- DB2 Enterprise Server Edition V10.1 for Linux on System z -- DVD
- DB2 Enterprise Server Edition V10.1 for HP-UX on HP Integrity Itanium-based systems
- Data Server Client V10.1 for Windows on 32-bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Windows on AMD64 and Intel EM64T systems (x64) -- DVD
- Data Server Client V10.1 for Linux on 32-bit AMD and Intel systems (x86) -- DVD
- Data Server Client V10.1 for Linux on AMD64 and Intel EM64T systems (x64) -- DVD
- TIvoli Common Reporting V2.1.1 Quick Start Guide Multiplatform Multilingual
- Tivoli Common Reporting V2.1.1 for Windows 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 AIX 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 32-Bit Multilingual
- Tivoli Common Reporting V2.1.1 HP-UX 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Solaris 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Linux on System z 32-bit, 64-Bit Multilingual
- Tivoli Common Reporting V2.1.1 Cognos Framework Manager Multiplatform Multilingual
IBM InfoSphere Optim Performance Manager Extended Insight V5.2 for DB2 for Linux , UNIX , and Windows Media Pack Multilingual
- IBM InfoSphere Optim Performance Manager Extended Insight V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start Guide -- Paper
- IBM InfoSphere Optim Performance Manager Extended Insight V5.2 for DB2 for Linux , UNIX , and Windows , Quick Start -- CD
- IBM InfoSphere Optim Performance Manager Extended Insight V5.2 for DB2 for Linux , UNIX , and Windows , License Activation Kit -- DVD
- IBM InfoSphere Optim Data Tools Runtime Client V2.2 -- DVD
- IBM InfoSphere Optim Performance Manager Extended Edition V5.2 Plugin for Tivoli Enterprise Portal - DVD
The IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V3.2 package includes:
- IBM InfoSphere Optim Query Workload Tuner for DB2 for LUW V3.2.0 Quick Start Guide CD
- IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V3.2.0.0 - for Windows DVD
- IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V3.2.0.0 - for Linux with 32-bit Installation Manager DVD
- IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V3.2.0.0 - for Linux with 64-bit Installation Manager DVD
The IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2 package includes:
- IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2.0 Quick Start Guide
- IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.2.0 DVD
Security, auditability, and control
IS Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows 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 Optim pureQuery IBM Database 2 Data Studio
Runtime for Linux, UNIX, and
Windows
IBM InfoSphere Optim Performance IBM Database 2 DB2 Tools
Manager Extended Insight for DB2
for Linux, UNIX, and Windows
IBM InfoSphere Optim Performance IBM Database 2 DB2 Tools
Manager Extended Edition for DB2
for Linux, UNIX, and Windows
IBM InfoSphere Optim Performance IBM Database 2 DB2 Tools
Manager for DB2 for Linux, UNIX,
and Windows Enterprise Edition
IBM InfoSphere Optim Performance IBM Database 2 DB2 Tools
Manager for DB2 for Linux, UNIX,
and Windows Workgroup Edition
IBM InfoSphere Optim Performance IBM Database 2 DB2 Tools
Manager for DB2 for Linux, UNIX,
and Windows Content Manager
Edition
IBM InfoSphere Optim Query IBM Database 2 Data Studio
Workload Tuner for DB2 for Linux,
UNIX, and Windows
Program name PID Charge unit
number description
IBM InfoSphere Optim pureQuery 5724-X84 Per Processor Value
Runtime for Linux, UNIX, and Windows Value Unit (PVU)
IBM InfoSphere Optim pureQuery 5724-X84 Per PVU for
Runtime for Linux, UNIX, and Windows System z
IBM InfoSphere Optim Performance 5724-Z20 Per PVU for Linux
Manager Extended Insight for DB2 for on System z
Linux, UNIX, and Windows
IBM InfoSphere Optim Performance 5724-Z20 Per PVU
Manager Extended Insight for DB2 for
Linux, UNIX, and Windows
IBM InfoSphere Optim Performance 5724-Z20 Per PVU for Linux
Manager Extended Edition for DB2 for on System z
Linux, UNIX, and Windows
IBM InfoSphere Optim Performance 5724-Z20 Per PVU
Manager Extended Edition for DB2 for
Linux, UNIX, and Windows
IBM InfoSphere Optim Performance 5724-Y94 Per PVU for Linux
Manager for DB2 for Linux, UNIX, and on System z
Windows Enterprise Edition
IBM InfoSphere Optim Performance 5724-Y94 Per PVU
Manager for DB2 for Linux, UNIX, and
Windows Enterprise Edition
IBM InfoSphere Optim Performance 5724-Y94 Per PVU for Linux
Manager for DB2 for Linux, UNIX, and on System z
Windows Workgroup Edition
IBM InfoSphere Optim Performance 5724-Y94 Per PVU
Manager for DB2 for Linux, UNIX, and
Windows Workgroup Edition
IBM InfoSphere Optim Performance 5724-Y94 Per Server for Linux
Manager for DB2 for Linux, UNIX, and on System z
Windows Content Manager Edition
IBM InfoSphere Optim Performance 5724-Y94 Per Server
Manager for DB2 for Linux, UNIX, and
Windows Content Manager Edition
IBM InfoSphere Optim Query Workload 5725-E45 Per PVU
Tuner for DB2 for Linux, UNIX and
Windows
IBM InfoSphere Optim Query Workload 5725-E45 Per PVU for Linux
Tuner for DB2 for Linux, UNIX and on System z
Windows
Charge metrics definitions
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 web page 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_sp ecific_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.
Passport Advantage program licenses
IBM IS Optim pureQuery RT Linux , UNIX , and Windows
Part description Part
number
IBM Optim pureQuery Runtime
IS Optim pureQuery RT for LUW per Proc Value Unit (PVU) E048YLL
Annual SW S&S Rnwl
IS Optim pureQuery RT for LUW per Proc Value Unit (PVU) D61YKLL
License & SW S&S 12 Mo
IS Optim pureQuery RT for LUW per Proc Value Unit (PVU) D61YLLL
SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance manager Extended Edition for DB2 Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager Extended Insight for DB2 for Linux, UNIX, and Windows IS Optim Perf Mgr Ext Insight per Proc Value Unit (PVU) E0DAYLL Annual SW S&S Rnwl IS Optim Perf Mgr Ext Insight per Proc Value Unit (PVU) D0NE4LL Lic + SW S&S 12 Mo IS Optim Perf Mgr Ext Insight Per Proc Value Unit (PVU) D0NE5LL SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager Extended Edition for DB2 Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux, UNIX, and Windows IS Optim Perf Mgr Ext Edition per Proc Value Unit (PVU) E0DBFLL Annual SW S&S Rnwl IS Optim Perf Mgr Ext Edition per Proc Value Unit (PVU) D0NEPLL Lic + SW S&S 12 Mo IS Optim Perf Mgr Ext Edition per Proc Value Unit (PVU) D0NEQLL SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows Enterprise Edition Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU) E0210LL Annual SW S&S Rnwl Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU) Lic D55KALL + SW S&S 12 Mo Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU) SW D55KBLL S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows Workgroup Edition Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU) E020ALL Annual SW S&S Rnwl Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU) Lic D55IQLL + SW S&S 12 Mo Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU) SW D55IRLL S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows Content Manager Edition Optim Perf Mgr DB2 LUW CME per Server Annual SW S&S E031NLL Rnwl Optim Perf Mgr DB2 LUW CME per Server Lic + SW S&S 12 D59LALL Mo Optim Perf Mgr DB2 LUW CME per Server SW S&S Reinstate D59LBLL 12 Mo
IS Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows IS OQW Tuner for DB2 LUW per Proc Value Unit (PVU) E0CVALL Annual SW S&S Rnwl IS OQW Tuner for DB2 LUW per Proc Value Unit (PVU) Lic D0LFKLL + SW S&S 12 Mo IS OQW Tuner for DB2 LUW per Proc Value Unit (PVU) SW D0LFLLL S&S Reinstate 12 Mo
Passport Advantage supply
5724-Z20 IBM InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux, UNIX, and Windows V5.2.0 IBM InfoSphere Optim Performance BB1DKML Manager Extended Edition for DB2 for Linux, UNIX and Windows V5.2.0 Multilingual Media Pack 5724-Z20 IBM InfoSphere Optim Performance Manager Extended Insight for DB2 for Linux, UNIX, and Windows V5.2.0 IBM InfoSphere Optim Performance BB1DLML Manager Extended Insight for DB2 for Linux, UNIX and Windows V5.2.0 Multilingual Media Pack 5725-E45 IBM InfoSphere Optim Query Workload Tuner for DB2 for LUW V3.2.0 IBM InfoSphere Optim Query BB1DQML Workload Tuner for DB2 for Linux, UNIX and Windows V3.2.0 Multilingual Media Pack 5724-X84 IBM InfoSphere Optim pureQuery Runtime for DB2 for LUW V3.2.0 IBM InfoSphere Optim pureQuery BB1DJML Runtime for Linux, UNIX, and Windows V3.2.0 Multilingual Media Pack 5724-Y94 IBM InfoSphere Optim Performance Manager for DB2 for LUW V5.2.0 IBM InfoSphere Optim Performance BB1DMML Manager for DB2 for Linux, UNIX, and Windows Enterprise Edition V5.2.0 Multilingual Media Pack 5724-Y94 IBM InfoSphere Optim Performance Manager for DB2 for LUW V5.2.0 IBM InfoSphere Optim Performance BB1DNML Manager for DB2 for Linux, UNIX, and Windows Workgroup Edition V5.2.0 Multilingual Media Pack 5724-Y94 IBM InfoSphere Optim Performance Manager for DB2 for LUW V5.2.0 IBM InfoSphere Optim Performance BB1DPML Manager for DB2 for Linux, UNIX, and Windows Content Manager Edition V5.2.0 Multilingual Media Pack
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.
5725-E45 IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V3.2.0
Entitled maintenance Media packs description Part offerings description number IBM InfoSphere Optim Query IBM InfoSphere Optim Query BB1DQML Workload Tuner for DB2 for Workload Tuner for DB2 for Linux, UNIX, and Windows LUW V3.2.0 Multilingual per Processor Value Unit Media Pack IBM InfoSphere Optim Query IBM InfoSphere Optim Query BB1DQML Workload Tuner for DB2 for Workload Tuner for DB2 for Linux, UNIX, and Windows LUW V3.2.0 Multilingual per Processor Value Unit Media Pack for Linux on System z
5724-X84 IBM InfoSphere Optim pureQuery Runtime for DB2 for Linux , UNIX , and Windows V3.2.0
IBM InfoSphere Optim IBM InfoSphere Optim BB1DJML pureQuery Runtime for pureQuery Runtime for DB2 Linux UNIX, and Windows for LUW V3.2.0 per Processor Value Unit Multilingual Media Pack IBM InfoSphere Optim IBM InfoSphere Optim BB1DJML pureQuery Runtime for pureQuery Runtime for DB2 Linux, UNIX, and Windows for LUW V3.2.0 per Processor Value Unit Multilingual Media Pack for System z
5724-Y94 IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.2.0
IBM InfoSphere Optim IBM InfoSphere Optim BB1DMML Performance Manager for Performance Manager for DB2 for Linux, UNIX, and DB2 for LUW Enterprise Windows Enterprise Edition Edition V5.2.0 per Processor Value Unit Multilingual Media Pack IBM InfoSphere Optim IBM InfoSphere Optim BB1DMML Performance Manager for Performance Manager for DB2 for Linux, UNIX, and DB2 for LUW Enterprise Windows Enterprise Edition Edition V5.2.0 per Processor Value Unit Multilingual Media Pack for Linux on System z
5724-Y94 IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.2.0
IBM InfoSphere Optim IBM InfoSphere Optim BB1DNML Performance Manager for Performance Manager for DB2 for Linux, UNIX, and DB2 for LUW Workgroup Windows Workgroup Edition Edition V5.2.0 per Processor Value Unit Multilingual Media Pack IBM InfoSphere Optim IBM InfoSphere Optim BB1DNML Performance Manager for Performance Manager for DB2 for Linux, UNIX, and DB2 for LUW Workgroup Windows Workgroup Edition Edition V5.2.0 per Processor Value Unit Multilingual Media Pack for Linux on System z
5724-Y94 IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.2.0
IBM InfoSphere Optim IBM InfoSphere Optim BB1DPML Performance Manager for Performance Manager for DB2 for Linux, UNIX, and DB2 for LUW Content Windows Content Manager Manager Edition V5.2.0 Edition per Server Multilingual Media Pack IBM InfoSphere Optim IBM InfoSphere Optim BB1DPML Performance Manager for Performance Manager for DB2 for Linux, UNIX, and DB2 for LUW Content Windows Content Manager Manager Edition V5.2.0 Edition per Server for Multilingual Media Pack Linux on System z
5724-Z20 IBM InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux , UNIX , and Windows V5.2.0
IBM InfoSphere Optim IBM InfoSphere Optim BB1DLML Performance Manager Performance Manager Extended Edition for DB2 Extended Edition for DB2 for Linux, UNIX, and for LUW V5.2.0 Windows per Processor Multilingual Media Pack Value Unit IBM InfoSphere Optim IBM InfoSphere Optim BB1DLML Performance Manager Performance Manager Extended Edition for DB2 Extended Edition for DB2 for Linux, UNIX, and for LUW V5.2.0 Windows per Processor Multilingual Media Pack Value Unit for Linux on System z
5724-Z20 IBM InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux , UNIX , and Windows V5.2.0
IBM InfoSphere Optim IBM InfoSphere Optim BB1DKML Performance Manager Performance Manager Extended Insight for DB2 Extended Insight for DB2 for Linux, UNIX, and for LUW V5.2.0 Windows per Processor Multilingual Media Pack Value Unit IBM InfoSphere Optim IBM InfoSphere Optim BB1DKML Performance Manager Performance Manager Extended Insight for DB2 Extended Insight for DB2 for Linux, UNIX, and for LUW V5.2.0 Windows per Processor Multilingual Media Pack Value Unit for Linux on System z
Cross-platform products
Cross-platform products for use on System z
Order the part numbers that follow when the product is used for either the development of code that will be deployed on System z servers or when the product will be communicating or transferring data between a distributed server and a System z server. Otherwise 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 Optim pureQuery RT Linux , UNIX , and Windows
Part description Part
number
IBM Data Studio pureQuery Runtime
IS Optim pureQuery RT for LUW PVU for Sys z Annual SW E0571LL
S&S Rnwl
IS Optim pureQuery RT for LUW PVU for Sys z License & D04QBLL
SW S&S 12 Mo
IS Optim pureQuery RT for LUW PVU for Sys z SW S&S D04QCLL
Reinstate 12 Mo
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 Optim Performance Manager Extended Edition for DB2 Linux , UNIX , and Windows
Part description Part
number
IBM InfoSphere Optim Performance Manager Extended
Edition for DB2 for Linux, UNIX, and Windows
IS Optim Perf Mgr Ext Edition per Proc Value Unit (PVU) E0DBGLL
for Linux on System z Annual SW S&S Rnwl
IS Optim Perf Mgr Ext Edition per Proc Value Unit (PVU) D0NERLL
for Linux on System z Lic + SW S&S 12 Mo
IS Optim Perf Mgr Ext Edition per Proc Value Unit (PVU) D0NESLL
for Linux on System z SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager Extended Edition for DB2 Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager Extended Insight for DB2 for Linux, UNIX, and Windows IS Optim Perf Mgr Ext Insight per Proc Value Unit (PVU) E0DAZLL for Linux on System z Annual SW S&S Rnwl IS Optim Perf Mgr Ext Insight per Proc Value Unit (PVU) D0NE6LL for Linux on System z Lic + SW S&S 12 Mo IS Optim Perf Mgr Ext Insight per Proc Value Unit (PVU) D0NE7LL for Linux on System z SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager for DB2 for LUW
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows Enterprise Edition Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU) for E07QZLL Linux on System z Annual SW S&S Rnwl Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU) for D0AZ7LL Linux on System z Lic + SW S&S 12 Mo Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU) for D0AZ8LL Linux on System z SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows Workgroup Edition Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU) for E08N2LL Linux on System z Annual SW S&S Rnwl Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU) for D0CPFLL Linux on System z Lic + SW S&S 12 Mo Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU) for D0CPGLL Linux on System z SW S&S Reinstate 12 Mo
IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows
IBM InfoSphere Optim Performance Manager for DB2 for Linux, UNIX, and Windows Content Manager Edition Optim Perf Mgr DB2 LUW CME per Server for Linux on E07ABLL System z Annual SW S&S Rnwl Optim Perf Mgr DB2 LUW CME per Server for Linux on D09UWLL System z Lic + SW S&S 12 Mo Optim Perf Mgr DB2 LUW CME per Server for Linux on D09UYLL System z SW S&S Reinstate 12 Mo
InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows
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 D0LFPLL SW S&S Reinstate 12 Mo 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
On/Off CoD
IBM InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux , UNIX , and Windows
Part description Part
number
IBM InfoSphere Optim Performance Manager Extended D0NICLL
Edition PROCESSOR-Day(s) Per 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 number
Program name Program Form number
number
IBM InfoSphere Optim Performance Manager 5724-Z20 L-CHAR-8YBL65
Extended Edition for DB2 for Linux,
UNIX, and Windows
IBM InfoSphere Optim Performance Manager 5724-Z20 L-CHAR-8YCE3E
Extended Insight for DB2 for Linux,
UNIX, and Windows
IBM InfoSphere Optim Performance Manager 5724-Y94 L-CHAR-8YBKDV
for DB2 for Linux, UNIX, and Windows
Enterprise Edition
IBM InfoSphere Optim Performance Manager 5724-Y94 L-CHAR-8YCG4Y
for DB2 for Linux, UNIX, and Windows
Workgroup Edition
IBM InfoSphere Optim Performance Manager 5724-Y94 L-CHAR-8YCFMT
for DB2 for Linux, UNIX, and Windows
Content Manager Edition
IBM InfoSphere Optim pureQuery Runtime 5724-X84 L-MTHG-8X8UTZ
for Linux, UNIX, and Windows
IBM InfoSphere Optim Query Workload 5725-E45 L-MTHG-8WSVY2
Tuner for DB2 for Linux, UNIX, and
Windows
The program's License Information will be available for review on the IBM Software License Agreement website
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.
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 applies
Yes. Software Subscription and Support 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
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 website at
System i Software Maintenance applies
No
Educational allowance available
Not applicable.
IT system security involves protecting systems and information through prevention, detection, and response to improper access from within and outside your enterprise. Improper access can result in information being altered destroyed or misappropriated or can result in misuse of your systems to attack others. Without a comprehensive approach to security, no IT system or product should be considered completely secure and no single product or security measure can be completely effective in preventing improper access. IBM systems and products are designed to be part of a comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective. IBM does not warrant that systems and products are immune from the malicious or illegal conduct of any party.
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 |
|
Electronic Service Agent™ and the IBM Electronic Support web portal are dedicated to providing fast, exceptional support to IBM Systems customers. The IBM Electronic Service Agent tool is a no-additional-charge tool that proactively monitors and reports hardware events, such as system errors, performance issues, and inventory. The Electronic Service Agent tool can help you stay focused on your company's strategic business initiatives, save time, and spend less effort managing day-to-day IT maintenance issues. Servers enabled with this tool can be monitored remotely around the clock by IBM Support all at no additional cost to you.
Now integrated into the base operating system of AIX 5.3, AIX 6.1, and AIX 7.1, Electronic Service Agent is designed to automatically and electronically report system failures and utilization issues to IBM , which can result in faster problem resolution and increased availability. System configuration and inventory information collected by the Electronic Service Agent tool also can be viewed on the secure Electronic Support web portal, and used to improve problem determination and resolution by you and the IBM support team. To access the tool main menu, simply type "smitty esa_main", and select "Configure Electronic Service Agent ." In addition, ESA now includes a powerful Web user interface, giving the administrator easy access to status, tool settings, problem information, and filters. For more information and documentation on how to configure and use Electronic Service Agent , refer to
The IBM Electronic Support portal is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. This portal enables you to gain easier access to IBM resources for assistance in resolving technical problems. The My Systems and Premium Search functions make it even easier for Electronic Service Agent tool-enabled customers to track system inventory and find pertinent fixes.
Benefits
Increased uptime The Electronic Service Agent tool is designed to enhance the Warranty or Maintenance Agreement by providing faster hardware error reporting and uploading system information to IBM Support. This can translate to less wasted time monitoring the "symptoms," diagnosing the error, and manually calling IBM Support to open a problem record. Its 24 x 7 monitoring and reporting mean no more dependence on human intervention or off-hours customer personnel when errors are encountered in the middle of the night.
Security
The Electronic Service Agent tool is designed to be secure in monitoring, reporting, and storing the data at IBM . The Electronic Service Agent tool securely transmits either via the Internet (HTTPS or VPN) or modem, and can be configured to communicate securely through gateways to provide customers a single point of exit from their site. Communication is one way Activating Electronic Service Agent does not enable IBM to call into a customer's system. System inventory information is stored in a secure database, which is protected behind IBM firewalls. It is viewable only by the customer and IBM . The customer's business applications or business data is never transmitted to IBM .
More accurate reporting
Since system information and error logs are automatically uploaded to the IBM Support center in conjunction with the service request, customers are not required to find and send system information, decreasing the risk of misreported or misdiagnosed errors. Once inside IBM , problem error data is run through a data knowledge management system and knowledge articles are appended to the problem record.
Customized support
Using the IBM ID entered during activation, customers can view system and support information in the "My Systems" and "Premium Search" sections of the Electronic Support Web site at
My Systems provides valuable reports of installed hardware and software using information collected from the systems by Electronic Service Agent . Reports are available for any system associated with the customer's IBM ID. Premium Search combines the function of search and the value of Electronic Service Agent information, providing advanced search of the technical support knowledgebase. Using Premium Search and the Electronic Service Agent information that has been collected from your system, customers are able to see search results that apply specifically to their systems.
For more information on how to utilize the power of IBM Electronic Services, contact your IBM Systems Services Representative, or visit
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 Value Plus, 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 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
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, pureQuery and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.
InfoSphere, DB2, IBM, WebSphere, z/OS, Tivoli, Passport Advantage, Express, System x, AIX, POWER, System i, System p, System z, Cognos, xSeries, 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 is a trademark of Microsoft Corporation in the United States, other countries, or both.
Intel is a 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
