OI feedback

Enhancements to IBM InfoSphere Optim data management solutions for productivity, database performance, and availability exploit IBM DB2 for Linux , UNIX , and Windows 10.5 column-organized tables

IBM United States Software Announcement 213-198
April 23, 2013

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


Top rule
At a glance
Bottom rule

New releases of the products within the IBM® InfoSphere® Optim™ data management solutions:

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



Back to topBack to top
 
Top rule
Overview
Bottom rule

The IBM InfoSphere Optim data management solutions include a number of products that work together to help improve the productivity of database designers, administrators, and application developers. Many enhancements to these solutions help organizations accelerate performance improvements by exploiting IBM DB2 for Linux , UNIX , and Windows 10.5 column-organized tables.

IBM InfoSphere Data Architect V9.1 includes support for column-organized tables and various diagramming and reporting enhancements.

IBM Data Studio V4.1 includes support for column-organized tables and multiple high availability disaster recovery (HADR) standbys. It also includes significant enhancements to the execution of Structured Query Language (SQL) and command line processor (CLP) scripts and a new wizard for creating federated objects.

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V4.1 includes usability enhancements and an advisor function to identify which row-organized tables could benefit from being converted to column-organized tables.

IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.3 includes new statistics to support monitoring of column-organized tables, additional alerts, and a simpler query tuning workflow.

IBM InfoSphere Optim Configuration Manager for DB2 for Linux , UNIX , and Windows V3.1 includes support for monitoring rolling updates and application isolation for DB2's pureScale clustering technology.

IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.3 includes enhancements to SQL management and improved error reporting.

IBM DB2 Merge Backup for Linux , UNIX , and Windows V2.1 is enhanced to support column-organized tables.

IBM DB2 Recovery Expert for Linux , UNIX , and Windows V4.1 includes support for DB2's pureScale clustering technology, adaptive compression, multi-temperature storage, and remote log analysis.

IBM InfoSphere Optim High Performance Unload for DB2 for Linux , UNIX , and Windows V5.1 includes support for IBM DB2 for Linux , UNIX , and Windows 10.5 and integration with IBM InfoSphere Optim Data Masking Solution.



Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

Refer to the Hardware requirements and Software requirements sections.



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

June 14, 2013: Electronic delivery

July 26, 2013: Media availability



Back to topBack to top
 
Top rule
Description
Bottom rule

The IBM InfoSphere Optim data management solutions include several products that work together to help improve the productivity of database designers, administrators, and developers by providing advanced features for development, delivery, configuration, monitoring, tuning, and maintenance of applications, databases, and clients. Many of these solutions accelerate performance improvements available by exploiting the recently announced IBM DB2 for Linux , UNIX , and Windows 10.5 column-organized tables. This includes modeling, management (create, alter, drop), load and unload, monitoring, and advice and support for converting row-organized tables to column-organized tables. Column-organized tables combine proven in-memory and columnar data store capabilities with advanced compression and hardware exploitation techniques.

IBM InfoSphere Data Architect V9.1 is a powerful collaborative data design tool that helps users discover, model, visualize, relate, standardize, and integrate diverse and distributed assets across their enterprise. This release supports the column-organized tables as well as various diagramming and reporting enhancements. Enhancements have been made to XML modeling support to better associate XML Schemas with logical data model XML data type attributes and/or physical data model columns. In addition to enhancements to DB2 for Linux , UNIX , and Windows support, there is also expanded support for DB2 for i V6 and V7. IBM InfoSphere Data Architect V9.1 provides greater integration with Rational Team Concert™ and can shell share with the latest Rational® products.

IBM Data Studio V4.1 can help improve the productivity of database administrators (DBAs) and developers. With IBM Data Studio V4.1, users can create, alter, or drop column-organized tables as well as convert row-organized tables to column-organized tables. Enhancements to the Data Studio object management feature include a new wizard for setting up nicknames and the support of additional federated wrapper types.

Data Studio task assistants simplify the generation and execution of commands and utilities. Several task assistants were enhanced in V4.1. The Setup and Manage HADR task assistants were enhanced to support multiple HADR standbys. The Load task assistant was updated to support column-organized tables and the task assistants for DB2's pureScale clustering technology have been updated to provide more complete support for the db2cluster command.

There have been significant enhancements made to the execution of SQL and CLP scripts in Data Studio. Script execution may now be stopped at user-defined checkpoints. Execution can continue from any point or be limited to highlighted blocks of code, all within the same transaction. The results of a script may now be evaluated at any point before it is committed.

In addition to enhancements to DB2 for Linux , UNIX , and Windows support, there is also expanded support for DB2 for i. Users may now develop and debug user-defined functions for a DB2 for i database.

The Data Studio web console now provides the ability to view DB2 diagnostic logs and includes additional HADR, DB2 pureScale clustering technology, and logging condition alerts.

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V4.1 provides assistance in tuning individual SQL statements as well as tuning advice for a complete SQL workload, taking the whole workload into account. InfoSphere Optim Query Workload Tuner now includes an advisor function that can analyze a query workload and make recommendations on tables to convert to column-organized format. The advisor function will also provide an estimated performance gain if the recommended tables are converted from row to column organization. Usability enhancements include simpler configuration of IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows .

The IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.3 is designed to help IT staff and database administrators track performance and become alert to performance trends, and to enable them to take action early to maintain service level agreements. The Extended Insight capability in the Extended Edition extends monitoring across the application stack to help quickly narrow down bottlenecks to data access. InfoSphere Optim Performance Manager V5.3 provides a number of performance metrics to validate that a workload is behaving as expected when using the new DB2 for Linux , UNIX , and Windows column-organized tables. These metrics include table and column access statistics, I/O statistics, and extended insight statistics. For a simpler query tuning workflow, InfoSphere Optim Performance Manager V5.3 now includes the ability to execute the Optim Query Workload Tuner statistics and index advisor functions within the InfoSphere Optim Performance Manager user interface when monitoring a database that is enabled for InfoSphere Optim Query Workload Tuner. Finally, InfoSphere Optim Performance Manager includes various usability enhancements and inherits the new alerts introduced in the Data Studio web console.

IBM InfoSphere Optim Configuration Manager for DB2 for Linux , UNIX , and Windows V3.1 helps organizations automatically monitor, manage, and track multiple database servers and clients, including database objects and configuration parameters, for problem determination and building an inventory of clients for migration. The comparison feature supports new rich mapping schemes, making it easier and providing more control in comparing multiple database or client configurations to a "best practice" reference. Users may be notified when any number of test/production or active/active configurations deviate from the reference. In addition, users can now track changes and perform compares based on generic configuration settings. Users can now enforce any application client and driver properties or special registers to match "best practices." Enhancements to support for DB2 pureScale clustering technology include the display of the current maintenance levels of members in a data sharing group during rolling upgrades and the ability to isolate poorly behaving application clients within a data sharing group in order to meet performance and availability objectives. Enhanced storage management now includes the ability to analyze storage trends by user, application, or workload. The capability to redirect application clients from one DB2 for Linux , UNIX , and Windows system to another mirrored system may now be used for migrations, disaster recovery, or high availability without requiring application outages.

IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.3 provides the ability to improve SQL performance of both new and existing applications. The 3.3 release provides a new utility to enable users to locate captured SQL statements by Java™ application package, enabling better SQL management for managing execution privileges. This release also includes improved error reporting for batch implementation class generation, enabling users to help identify the interfaces for which the implementation generator command failed and to identify the cause of the failure.

IBM DB2 Merge Backup for Linux , UNIX , and Windows V2.1 enables the generation of full backups by merging full and incremental backups. Merge Backup V2.1 supports the new DB2 for Linux , UNIX , and Windows 10.5 column-organized tables for simpler and faster recovery and provides additional merge features to accommodate customized backup and restore environments.

IBM DB2 Recovery Expert V4.1 allows for more granular recovery than what is offered with DB2 for Linux , UNIX , and Windows . It also provides log analysis to enable the user to view changes to critical database assets. New features in this release include the full support for DB2's pureScale clustering technology capabilities as well as adaptive compression and multi-temperature storage. New remote log analysis reduces impacts on production.

IBM InfoSphere Optim High Performance Unload for DB2 for Linux , UNIX , and Windows V5.1 provides for high-speed unloads from live databases or from backup files. Version 5.1 provides for an easier install, an easier first time use, improved performance, and support for DB2 for Linux , UNIX , and Windows 10.5. The new version of High Performance Unload also now allows users to call the separately licensed IBM InfoSphere Optim Data Masking Solution libraries to mask and safeguard personally identifiable information, trade secrets, and financial and other sensitive data during an unload operation.

IBM DB2 for Linux , UNIX , and Windows 10.5 introduced the DB2 Advanced Recovery feature. This feature is a bundle of the advanced database backup, recovery, and data extraction tools described above to help users improve data availability, mitigate risk, and accelerate crucial administrative tasks, especially when time is of the essence. The feature bundle contains:

The DB2 Advanced Recovery feature is a separately purchasable licensable for-charge product that may be used with all DB2 Editions except DB2 Express-C.

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be requested at

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


Back to topBack to top
 
Top rule
Product positioning
Bottom rule

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 database administrator (DBA) or an application owner. They provide 24x7 monitoring of the application database and alert users to potential problems so that they can be resolved before impacting the business. InfoSphere Optim Performance Manager enables users to 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 you go back in time and see how a problem arose, mitigate problems first and do causal analysis later, or compare current values to those of prior 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, make 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, 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 very simple deployment, a browser-based UI, and contextual launching from within the Data Studio eclipse clients, it is very useful for monitoring development databases or providing an easy-to-use interface to IT staff not focused on deep database diagnostics.

IBM SmartCloud® Application Performance Management

SmartCloud Application Performance Management (SmartCloud APM) provides a single, integrated solution which monitors essential system resources, critical applications, middleware, and their environments. It enables business owners to gain insight into the performance of their applications, as well as a view into end user experience metrics. SmartCloud APM enables infrastructure owners to get a holistic picture of how the applications are interacting with IT resources and take corrective actions as needed.

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 the Transactions Tracking component of SmartCloud APM and InfoSphere Optim Performance Manager.

IBM InfoSphere Optim Configuration Manager

IBM InfoSphere Optim Configuration Manager for Linux , UNIX , and Windows helps organizations automatically monitor, manage, and track multiple database servers, including database objects and configuration parameters, for problem determination and building an inventory of servers and clients for migration. The server connection repository of Optim Configuration Manager serves as a source for connection profiles for other tooling including Optim Performance Manager and Data Studio. 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 DBAs can quickly determine whether recent changes may be the underlying cause of performance issues. The comparison feature supports rich mapping schemes, making it very easy to compare multiple database or client configurations, and notifying users when test/production configurations or active/active configurations are out of sync. IBM InfoSphere Optim Configuration Manager remotely enforces any application client properties, driver properties, or special registers to match "best practices." The capability to redirect application clients from one DB2 for Linux , UNIX , and Windows system to another mirrored system can be used for migrations, disaster recovery, or high availability without requiring application outages. IBM InfoSphere Optim Configuration Manager shows storage savings opportunities across multiple databases, including compression opportunities, both static and dynamic, trapped storage, and objects that are not frequently accessed. Data migration schedules can be defined to move data from one storage group on a faster disk to another on a slower disk, or vice versa, leveraging DB2 V10 multi-temperature storage capabilities.

IBM DB2 Merge Backup for Linux , UNIX , and Windows

IBM DB2 Merge Backup for Linux , UNIX , and Windows enables backup strategies that have the lowest impact on production yet provide the necessary recovery assets. DB2 Merge Backup combines incremental and delta backups with the latest full backups to create a new and current full DB2 backup. This minimizes the cost of downtime and speeds data recovery by managing backups more effectively and keeping the most up to date and consistent data image readily available.

IBM DB2 Recovery Expert for Linux , UNIX , and Windows

IBM DB2 Recovery Expert for Linux , UNIX , and Windows recovers faster and with greater granularity than what is offered with DB2 for Linux , UNIX , and Windows . The log analysis feature allows users to monitor changes to a database and gives the DBA the capability to quickly restore or correct erroneous data using fewer resources, helping to reduce data outages.

IBM InfoSphere Optim High Performance Unload for DB2 for Linux , UNIX , and Windows

IBM InfoSphere Optim High Performance Unload for DB2 for Linux , UNIX , and Windows is a high-speed tool for unloading, extracting, and repartitioning data in DB2 for Linux , UNIX , and Windows databases. It helps DBAs work with very large quantities of data with less effort and with faster results. It also reduces the risk of impacting online production systems by fitting more work into tight or shrinking batch windows, for example, unload from backup files.

IBM InfoSphere Data Architect

IBM InfoSphere Data Architect is the premier IBM database modeling tool that helps users visualize, relate, standardize, and integrate diverse and distributed database assets across their enterprise. InfoSphere Data Architect provides simplified database modeling, warehouse design, and dimensional modeling. InfoSphere Data Architect shell shares with Data Studio and Query Workload Tuner. Models are compatible between InfoSphere Data Architect and Data Studio.



Back to topBack to top
 
Top rule
Program number
Bottom rule

 
Program                Program
number         VRM     name
 
  5724-Y94    5.3.0    IBM InfoSphere Optim Performance
                       Manager for DB2 for Linux, UNIX,
                       and Windows
 
  5724-Z20    5.3.0    IBM InfoSphere Optim Performance
                       Manager Extended Edition for DB2
                       for Linux, UNIX, and Windows
 
  5725-E45    4.1.0    IBM InfoSphere Optim Query
                       Workload Tuner for DB2 for
                       Linux, UNIX, and Windows
 
  5724-X84    3.3.0    IBM InfoSphere Optim pureQuery
                       Runtime for Linux, UNIX, and Windows
 
  5724-V15    9.1.0    IBM InfoSphere Data Architect
 
  5725-C10    3.1.0    IBM InfoSphere Configuration Manager
                       for DB2 for Linux, UNIX, and Windows
 
  5725-B07    2.1.0    IBM DB2 Merge Backup for Linux,
                       UNIX, and Windows
 
  5724-B90    5.1.0    IBM InfoSphere Optim High Performance
                       Unload for DB2 for Linux, UNIX, and Windows
 
  5724-H93    4.1.0    IBM DB2 Recovery Expert for Linux,
                       UNIX, and Windows


Back to topBack to top
 
Top rule
Offering Information
Bottom rule

Product information is available via the Offering Information website

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

Also, visit the Passport Advantage® website

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


Back to topBack to top
 
Top rule
Publications
Bottom rule

No hardcopy publications are shipped with these programs.

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 US) 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, free of charge.



Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

For detailed hardware and software requirements, refer to the following support pages.

InfoSphere Optim Performance Manager

http://www.ibm.com/support/docview.wss?uid=swg27019274

InfoSphere Optim Performance Manager Extended Edition

http://www.ibm.com/support/docview.wss?uid=swg27019273

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

http://www.ibm.com/support/docview.wss?uid=swg27037953 *

IBM InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows

http://www.ibm.com/support/docview.wss?uid=swg27022224

IBM Data Studio

http://www.ibm.com/support/docview.wss?uid=swg27016018

IBM DB2 Merge Backup for Linux, UNIX, and Windows

http://www.ibm.com/support/docview.wss?uid=swg27019864

IBM DB2 Recovery Expert for Linux, UNIX, and Windows

http://pic.dhe.ibm.com/infocenter/db2ars/v1r1/index.jsp?topic=%2Fcom.ibm.datatools.reco veryexpert.doc%2Famarsrq0.html

IBM InfoSphere Optim Configuration Manager for DB2 for Linux, UNIX, and Windows

http://www.ibm.com/support/docview.wss?uid=swg27038148 *

IBM InfoSphere Data Architect

http://www.ibm.com/support/docview.wss?uid=swg27038181 *

IBM InfoSphere Optim High Performance Unload for DB2 for Linux, UNIX, and Windows

http://www.ibm.com/support/docview.wss?uid=swg27014429

* Note: these links will be live on June 14, 2013.

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

Packaging

This program, when downloaded from a website, contains the applicable IBM license agreement and License Information, if appropriate, which will be presented for acceptance at the time of installation of the program. For future reference, the license and License Information will be stored in a directory such as LICENSE.TXT.



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

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.

5724Y94 IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.3

Entitled maintenance offerings
description                                                          Part number

OPTIM PERF MGR FOR DB2 FOR LUW ENTPR ED PVU ZLNX LIC +               D0AZ7LL
 SW S&S 12 MO
OPTIM PERF MGR FOR DB2 FOR LUW ENTPR ED PVU ZLNX ANNUAL              E07QZLL
 SW S&S RNWL
OPTIM PERF MGR FOR DB2 FOR LUW ENTPR ED PVU ZLNX SW S&S              D0AZ8LL
 REINSTATE 12 MO
 
IBM OPTIM PERF MGR WKGP ED PVU FOR LINUX ON SYS Z LIC +              D0CPFLL
 SW S&S 12 MO
IBM OPTIM PERF MGR WKGP ED PVU FOR LINUX ON SYS Z ANNUAL             E08N2LL
 SW S&S RNWL
IBM OPTIM PERF MGR WKGP ED PVU FOR LINUX ON SYS Z SW S&S             D0CPGLL
 REINSTATE 12 MO
 
OPTIM PERF MGR FOR DB2 LUW CONT ED MGD SVR ZLNX LIC + SW             D09UWLL
 S&S 12 MO
OPTIM PERF MGR FOR DB2 LUW CONT ED MGD SVR ZLNX ANNUAL SW            E07ABLL
 S&S RNWL
OPTIM PERF MGR FOR DB2 LUW CONT ED MGD SVR ZLNX SW S&S               D09UYLL
 REINSTATE 12 MO
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)                  D55KALL
Lic + SW S&S 12 Mo
Optim Perf Mgr DB2 LUW EE per Proc Value Unit (PVU)                  D55KBLL
SW S&S Reinstate 12 Mo
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)                  D55IQLL
Lic + SW S&S 12 Mo
Optim Perf Mgr DB2 LUW WE per Proc Value Unit (PVU)                  D55IRLL
SW S&S Reinstate 12 Mo
Optim Perf Mgr DB2 LUW CME per Server Annual SW S&S Rnwl             E031NLL
Optim Perf Mgr DB2 LUW CME per Server Lic + SW S&S 12 Mo             D59LALL
Optim Perf Mgr DB2 LUW CME per Server SW S&S Reinstate 12 Mo         D59LBLL

5724Z20 - InfoSphere Optim Perf Mgr Extended Ed DB2 LUW

Entitled maintenance offerings
description                                                          Part number

INFOSPHERE OPM EXT INSIGHT FOR DB2 FOR LUW PVU LXZ LIC +             D0NE6LL
SW S&S 12 MO
INFOSPHERE OPM EXT INSIGHT FOR DB2 FOR LUW PVU LXZ ANNUAL            E0DAZLL
SW S&S RNWL
INFOSPHERE OPM EXT INSIGHT FOR DB2 FOR LUW PVU LXZ SW S&S            D0NE7LL
REINSTATE 12 MO
 
IBM INFOSPHERE OPM EXTENDED ED FOR DB2 LUW PVU LXZ LIC +             D0NERLL
SW S&S 12 MO
IBM INFOSPHERE OPM EXTENDED ED FOR DB2 LUW PVU LXZ ANNUAL            E0DBGLL
SW S&S RNWL
IBM INFOSPHERE OPM EXTENDED ED FOR DB2 LUW PVU LXZ SW S&S            D0NESLL
REINSTATE 12 MO

5725E45 - IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V4.1

Entitled maintenance offerings
description                                                          Part number

IS OQW Tuner for DB2 LUW Per Processor Value Unit (PVU)              E0CVALL
Annual SW S&S Rnwl
IS OQW Tuner for DB2 LUW Per Processor Value Unit (PVU)              D0LFKLL
Lic + SW S&S 12 Mo
IS OQW Tuner for DB2 LUW Per Processor Value Unit (PVU)              D0LFLLL
SW S&S Reinstate 12 Mo
 
IS OPTIM QUERY WORKLOAD TUNER DB2LUW PVU ZBX LXSYZ LIC +             D0LFNLL
SW S&S 12 MO
IS OPTIM QUERY WORKLOAD TUNER DB2LUW PVU ZBX LXSYZ ANNUAL            E0CVBLL
SW S&S RNWL
IS OPTIM QUERY WORKLOAD TUNER DB2LUW PVU ZBX LXSYZ SW S&S            D0LFPLL
REINSTATE 12 MO

5724X84 - InfoSphere Optim pureQuery Runtime for LUW

Entitled maintenance offerings
description                                                          Part number
 
OPTIM PUREQUERY RUNTIME FOR LUW PROCESSOR VALUE UNIT                 D61YKLL
LIC + SW S&S 12 MO
OPTIM PUREQUERY RUNTIME FOR LUW PROCESSOR VALUE UNIT                 E048YLL
ANNUAL SW S&S RNWL
OPTIM PUREQUERY RUNTIME FOR LUW PROCESSOR VALUE UNIT                 D61YLLL
SW S&S REINSTATE 12 MO
 
OPTIM PUREQUERY RUNTIME FOR LUW PVU FOR SYSTEM Z LIC +               D04QBLL
SW S&S 12 MO
OPTIM PUREQUERY RUNTIME FOR LUW PVU FOR SYSTEM Z ANNUAL              E0571LL
SW S&S RNWL
OPTIM PUREQUERY RUNTIME FOR LUW PVU FOR SYSTEM Z SW S&S              D04QCLL
REINSTATE 12 MO
 
InfoSphere Data Architect Authorized User Annual SW S&S Rnwl         E02BRLL
InfoSphere Data Architect Authorized User Lic + SW S&S 12 Mo         D56SGLL
InfoSphere Data Architect Authorized User SW S&S Reinstate 12Mo      D56SHLL
 
InfoSphere Data Architect Floating User Annual SW S&S Rnwl           E02BSLL
InfoSphere Data Architect Floating User Lic + SW S&S 12 Mo           D56SMLL
InfoSphere Data Architect Floating User SW S&S Reinstate 12 Mo       D56SNLL
 
INFO DATA ARCHITECT ZSERIES FLOATING USER LIC + SW                   D59ETLL
S&S 12 MO
INFO DATA ARCHITECT ZSERIES FLOATING USER ANNUAL SW                  E02YNLL
S&S RNWL
INFO DATA ARCHITECT ZSERIES FLOATING USER SW S&S                     D59EVLL
REINSTATE 12 MO
 
INFO DATA ARCHITECT ZSERIES AUTHORIZED USER LIC +                    D59F9LL
SW S&S 12 MO
INFO DATA ARCHITECT ZSERIES AUTHORIZED USER ANNUAL                   E02YWLL
SW S&S RNWL
INFO DATA ARCHITECT ZSERIES AUTHORIZED USER SW S&S                   D59FBLL
REINSTATE 12 MO

5725C10 - IBM InfoSphere Optim Configuration Manager for DB2 for Linux , UNIX , and Windows V3.1

Entitled maintenance offerings
description                                                          Part number
 
IS Optim Config Mgr for DB2 for LUW Per PVU Annual SW S&S R          E0CV8LL
IS Optim Config Mgr for DB2 for LUW Per PVU Lic + SW S&S 12          D0LFGLL
IS Optim Config Mgr for DB2 for LUW Per PVU SW S&S Reinstat          D0LFHLL
 
INFOSPHERE OPTIM CONFIG MGR DB2 LUW PVU ZBX LXSYSZ LIC + SW          D0LFILL
S&S 12 MO
INFOSPHERE OPTIM CONFIG MGR DB2 LUW PVU ZBX LXSYSZ ANNUAL SW         E0CV9LL
S&S RNWL
INFOSPHERE OPTIM CONFIG MGR DB2 LUW PVU ZBX LXSYSZ SW S&S            D0LFJLL
REINSTATE 12 MO

5725B07 - IBM DB2 Merge Backup for Linux , UNIX , and Windows V2.1

Entitled maintenance offerings
description                                                          Part number
 
DB2 Merge Backup for LUW Per Processor Value Unit                    E0AHULL
(PVU) Annual SW S&S Rnwl
DB2 Merge Backup for LUW Per Processor Value Unit                    D0G7HLL
(PVU) Lic + SW S&S 12 Mo
DB2 Merge Backup for LUW Per Processor Value Unit                    D0G7ILL
(PVU) SW S&S Reinstate 12 Mo
 
DB2 MERGE BACKUP FOR LUW PVU FOR LINUX ON SYS Z LIC +                D0GAFLL
SW S&S 12 MO
DB2 MERGE BACKUP FOR LUW PVU FOR LINUX ON SYS Z ANNUAL               E0AIULL
SW S&S RNWL
DB2 MERGE BACKUP FOR LUW PVU FOR LINUX ON SYS Z SW S&S               D0GAGLL
REINSTATE 12 MO

IBM InfoSphere Optim High Performance Unload for DB2 for Linux , UNIX , and Windows V5.1

5724B90 - Optim High Performance Unload for MP

Entitled maintenance offerings
description                                                          Part number
 
OPTIM HIGH PERFORMANCE UNLOAD FOR MP PVU LINX SYS Z LIC +            D0AZ1LL
SW S&S 12 MO
OPTIM HIGH PERFORMANCE UNLOAD FOR MP PVU LINX SYS Z ANNUAL           E07QWLL
SW S&S RNWL
OPTIM HIGH PERFORMANCE UNLOAD FOR MP PVU LINX SYS Z SW S&S           D0AZ2LL
 REINSTATE 12 MO
OPTIM HIGH PERFORMANCE UNLOAD FOR MP PVU LIC + SW S&S 12 MO          D55JYLL
OPTIM HIGH PERFORMANCE UNLOAD FOR MP PVU ANNUAL SW S&S RNWL          E020VLL
OPTIM HIGH PERFORMANCE UNLOAD FOR MP PVU SW S&S                      D55JZLL
REINSTATE 12 MO
TEMP USE CHRG

5724H93 - IBM DB2 Recovery Expert V4.1 for Linux , UNIX , and Windows

Entitled maintenance offerings
description                                                          Part number
 
DB2 Recovery Expert for LUW Per Processor Value Unit                 E022GLL
Annual SW S&S Rnwl
DB2 Recovery Expert for LUW Per Processor Value Unit                 D55NELL
Lic + SW S&S 12 Mo
DB2 Recovery Expert for LUW Per Processor Value Unit                 D55NFLL
SW S&S Reinst 12Mo

Passport Advantage supply

Media pack descriptions                                              Part number

IBM InfoSphere Optim Performance Manager for DB2 for Linux , UNIX , and Windows V5.3:

5724Y94 - InfoSphere Optim Performance Mgr for DB2 LUW

IBM IS Optm Perfmc Mngr Enterprise Edition for DB2 for               BB1F0ML
LUW V5.3 MPck
IBM IS Optm Perfmc Mngr for DB2 LUW Workgroup Edition                BB1F1ML
V5.3 ML MPck
IBM IS Optm Perfmc Mngr for DB2 LUW Content Manager                  BB1F2ML
Ed V5.3 ML MPck

IBM InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux , UNIX , and Windows V5.3

5724Z20 - InfoSphere Optim Perf Mgr Extended Ed DB2 LUW

IBM IS Optm Perfmc Mngr Extended Edition V5.3 for DB2                BB1F3ML
 for LUW MP ML MPck
IBM IS Optm Perfmc Mngr Extended Insight for DB2 for                 BB1F4ML
LUW V5.3 ML MP MPck

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux , UNIX , and Windows V4.1

5725E45 - IS Optim Query Workload Tuner for DB2 for LUW

IBM InfoSphere Optim Query Workload Tuner for DB2 for                BB1EZML
 LUW V4.1.0 ML MP MPck

IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V4.1

5724X84 - InfoSphere Optim pureQuery Runtime for LUW

IBM IS Optim pureQuery Runtime for Linux, UNIX, and                  BB1F6ML
 Windows V3.3.0MPck

IBM InfoSphere Data Architect V9.1

5724V15 - InfoSphere Data Architect

IBM InfoSphere Data Architect V9.1 Multiplatform                     BB1EYML
 Multilingual Media Pack

IBM InfoSphere Optim Configuration Manager for DB2 for Linux , UNIX , and Windows V3.1

5725C10 - InfoSphere Optim Configuration Manager

IBM InfoSphere Optim Configuration Manager for DB2 for               BB1F5ML
 LUW V3.1 MPck

IBM DB2 Merge Backup for Linux , UNIX , and Windows V2.1

5725B07 - DB2 Merge Backup for Linux , UNIX and Windows

IBM DB2 Merge Backup for Linux, UNIX, and Windows V2.1 MP            BB1EVML
 ML Media Pack

IBM InfoSphere Optim High Performance Unload for DB2 for Linux , UNIX , and Windows V5.1

5724B90 - Optim High Performance Unload for MP

IBM Optim High Performance Unload for DB2 for Linux,                 BB1EXML
 UNIX, and Win V5.1MPck

IBM DB2 Recovery Expert for Linux , UNIX , and Windows V4.1

5724H93 - DB2 Recovery Expert

IBM DB2 Recovery Expert for Linux, UNIX, and Windows                 BB1EWML
 V4.1 ML MP Media Pack

Passport Advantage trade up

You must have previously acquired licenses for the following precursor products to be eligible to acquire equivalent licenses of the trade-up products.

5724V15 - IBM InfoSphere Data Architect V9.1

Entitled maintenance offerings
description                                                          Part number
 
INFO DATA ARCHITECT FL FROM ROSE DATA MODELER FL TRDUP LIC +         D56SSLL
SW S&S 12 MO
INFO DATA ARCHITECT FL F ROSE XDE/ROSE DEV JAVA FL TRDUP LIC +       D56STLL
SW S&S 12 MO
INFO DATA ARCHITECT FL F ROSE XDE/ROSE DEV VS FL TRDUP LIC +         D56SULL
SW S&S 12 MO
INFO DATA ARCHITECT FL F ROSE XDE® PLUS/ROSE ENT FL TRDUP LIC +       D56T3LL
SW S&S 12 MO
 
INFO DATA ARCHITECT AU FROM ROSE DATA MODELER AU                     D56SILL
INFO DATA ARCHITECT AU F ROSE XDE/ROSE DEV JAVA AU TRDUP LIC +       D56SJLL
SW S&S 12 MO
INFO DATA ARCHITECT AU F ROSE XDE/ROSE DEV VS AU TRDUP LIC +         D56SKLL
SW S&S 12 MO
INFO DATA ARCHITECT AU F ROSE XDE PLUS/ROSE ENT AU TRDUP LIC +       D56SLLL
SW S&S 12 MO

On/Off Capacity on Demand (CoD)

 
Description                                                          Part number

OPMEXTEDDB2LUW PROC DAY OOCOD TEMP USE CHRG                          D0NICLL
DB2 HIGH PERFORMANCE UNLOAD FOR MP PROC DAY OOCOD                    D615VLL
DB2 RECOVERY EXPERT FOR LUW PROC DAY OOCOD TEMP USE CHRG             D615WLL

Charge metric

Authorized User

Authorized User is a unit of measure by which the Program can be licensed. An Authorized User is a unique person who is given access to the Program. The Program may be installed on any number of computers or servers and each Authorized User may have simultaneous access to any number of instances of the Program at one time. Licensee must obtain separate, dedicated entitlements for each Authorized User given access to the Program in any manner directly or indirectly (for example: via a multiplexing Program, device, or application server) through any means. An entitlement for an Authorized User is unique to that Authorized User and may not be shared, nor may it be reassigned other than for the permanent transfer of the Authorized User entitlement to another person.

Note: Some programs may be licensed where devices are considered users. In that case, the following applies. Any computing device that requests the execution of or receives for execution a set of commands, procedures, or applications from the Program or that is otherwise managed by the Program is considered a separate User of the Program and requires an entitlement as if that device were a person.

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 the website below) 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. The PVU table can be found at

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

Licensee can deploy the program using either full capacity licensing or virtualization capacity (sub-capacity) licensing according to the Passport Advantage Sub-Capacity Licensing Terms (refer to the 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 :

Customized Offerings

Product deliverables are shipped only via CBPDO and ServerPac. These customized offerings are offered for Internet delivery in countries where ShopzSeries product ordering is available. Internet delivery reduces software delivery time and allows you to install software without the need to handle tapes. For more details on Internet delivery, refer to the Shopz help information at

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

You choose the delivery method when you order the software. IBM recommends Internet delivery. In addition to Internet and DVD, the supported tape delivery options include:

Most products can be ordered in ServerPac the month following their availability in CBPDO. z/OS® can be ordered via CBPDO and ServerPac at general availability. Many products will also be orderable in a Product ServerPac without also having to order the z/OS operating system or subsystem.

Shopz and CFSW will determine the eligibility based on product requisite checking. For more details on the Product ServerPac, visit the Help section on the Shopz website at

http://www14.software.ibm.com/webapp/ShopzSeries/ShopzSeries.jsp

Production of software product orders will begin on the planned general availability date.



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

These programs are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, which provide for support with ongoing access to releases and versions of the program. IBM includes one year of Software Subscription and Support (also referred to as Software Maintenance) with the initial license acquisition of each program 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. These programs have a one-time license charge for use of the program and an annual renewable charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours), as well as access to updates, releases, and versions of the program as long as support is in effect.

License Information form number
L-MTHG-95L484 IBM Data Studio web console V4.1
 
L-MTHG-94PTUY IBM InfoSphere Optim Configuration Manager V3.1
L-MTHG-94PV4B IBM InfoSphere Optim Configuration Manager for
              Linux, UNIX, and Windows V3.1
 
L-MTHG-94PVEZ IBM InfoSphere Optim pureQuery Runtime for
              Linux, UNIX, and Windows V3.3
 
L-MTHG-94PVLY IBM InfoSphere optim Data Tools Runtime Client V3.1
 
L-DNAA-94TPJU IBM DB2 Recovery Expert for Linux, UNIX, and Windows V4.1
 
L-DNAA-94TPP9 IBM DB2 Merge Backup for Linux, UNIX, and Windows V2.1
 
L-DNAA-94TPSX IBM Optim High Performance Unload for DB2 for Linux, UNIX,
              and Windows V5.1
 
L-HYWU-95Q2F8 InfoSphere Data Architect 9.1
 
L-CHAR-94MHA2 IBM InfoSphere Optim Performance Manager for LUW,
              Workgroup Edition 5.3
L-CHAR-94MH6W IBM InfoSphere Optim Performance Manager for LUW,
              Content Manager Edition 5.3
L-CHAR-94MGP7 IBM InfoSphere Optim Performance Manager for LUW,
              Enterprise Edition 5.3
L-CHAR-94MH3T IBM InfoSphere Optim Performance Manager Extended
              Insight for DB2 for LUW 5.3
L-CHAR-94MGUE IBM InfoSphere Optim Performance Manager Extended
              Edition for DB2 for LUW 5.3
 
L-HYWU-8SLSED IBM InfoSphere Optim Query Workload Tuner 4.1

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

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

Yes

Money-back guarantee

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 (1) for programs acquired under the IBM International Passport Advantage offering, this term applies only to your first acquisition of the program and (2) for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Volume orders (IVO)

No

Passport Advantage applies

Yes, and through the Passport Advantage website at

http://www.ibm.com/software/passportadvantage
Software Subscription and Support 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, only 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 website at

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

Yes

Variable charges apply

Yes

Educational allowance available

Not applicable



Back to topBack to top
 
Top rule
Statement of good security practices
Bottom rule

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.



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 for Software Value Plus. Additional information is also available at

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

Variable charges: The applicable processor-based one-time charge will be based on the group of the designated machine on which the program is licensed for use. If the program is designated to a processor in a group for which no charge is listed, the charge of the next higher group listed applies. For movement to a machine in a higher group, an upgrade charge equal to the difference in the then-current charges between the two groups will apply. For movement to a machine in a lower group, there will be no adjustment or refund of charges paid.

For all local charges, contact your IBM representative.

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
Mail:       IBM Teleweb Customer Support
            ibm.com® Sales Execution Center, Americas North
            3500 Steeles Ave. East, Tower 3/4
            Markham, Ontario
            Canada
            L3R 2Z1

Reference: YE001

The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.


Note: Shipments will begin after the planned availability date.

IBM Software Value Plus

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

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

http://www.ibm.com/partnerworld/page/svp_authorized_portfolio_criteria

For questions regarding Software Value Plus, visit

http://www.ibm.com/partnerworld/page/svp_authorized_portfolio_contacts
Trademarks

Optim and Rational Team Concert are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, InfoSphere, DB2, pureScale, pureQuery, Rational, IBM SmartCloud, Passport Advantage, XDE, z/OS, Express 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.

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/

Close [x]

Close [x]