IBM DB2 Tools deliver new functions and enhancements

IBM United States Software Announcement 215-086
May 5, 2015


Table of contents
OverviewOverviewTechnical informationTechnical information
Key prerequisitesKey prerequisitesOrdering informationOrdering information
Planned availability datePlanned availability dateTerms and conditionsTerms and conditions
DescriptionDescriptionPricesPrices
Program numberProgram numberOrder nowOrder now
PublicationsPublications 

 


(Corrected on August 21, 2015)
Changed capacity terms from reference-based to full machine-based. In the Description section headings corrected references to IBM® Tivoli® OMEGAMON® XE for DB2® Performance Expert on z/OS®, V5.3 (5655-W37) and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38).



Top rule
At a glance
Bottom rule

New and enhanced IBM DB2 Tools deliver the following benefits:

  • Utilities management:
    • IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1)
    • IBM DB2 Utilities Solution Pack for z/OS, V2.2 (5697-DUP)
  • Recovery management: IBM DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56)
  • Performance management:
    • IBM DB2 Buffer Pool Analyzer for z/OS, V5.3 (5655-W35)
    • IBM DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74)
    • IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32)
    • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37)
    • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38)



Back to topBack to top

Top rule
Order now
Bottom rule

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: LE001



Back to topBack to top

Top rule
Overview
Bottom rule

IBM DB2 Buffer Pool Analyzer for z/OS, V5.3 (5655-W35) can aid in optimizing database performance by helping buffer pools function at high efficiency. DB2 Buffer Pool Analyzer makes it easier to tune your database and substantially boost its capacity, speed, and reliability, supporting your efforts to succeed in the information economy. This release provides more user control over the DB2 for z/OS native buffer pool simulation facility. You can organize groupings of DB2 objects, enable data collection of virtual buffer pool activity, and generate activity reports in multiple formats.

IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1) is a flexible, easy-to-use product that delivers a fast and efficient tool to unload and extract data for movement across enterprise systems or for in-place reorganizations. This release provides greater performance options for unloading DB2 data that resides in the DB2 Analytics Accelerator appliance by extending support to IBM DB2 Analytics Accelerator for z/OS when using the SQL interface.

IBM DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56) performs rich log analysis, recovery operations, auditing analysis, and replication that can help organizations protect their valuable data. New features offer greater performance and usability options. The new 64-bit processing mode increases confidence that a job can complete without a restart when approaching a maximum limit. You will have more flexibility to customize the log analysis panels. The quick start panels enable you to organize your views based on what type of activity in DB2 Log Analysis Tool is most important to you.

IBM DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74) delivers integrated performance management for DB2 for z/OS by combining function from the following IBM products:

  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3
  • IBM DB2 Query Monitor for z/OS, V3.2
  • IBM DB2 SQL Performance Analyzer for z/OS, V4.2
  • IBM InfoSphere® Optim™ Query Workload Tuner for DB2 for z/OS, V4.1

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 delivers new features for this iteration of the pack. Refer to the Description section for more details.

Trade-up options for DB2 Performance Solution Pack for z/OS, V1.3 are available. The following list includes eligible products, or eligible combinations of products, for each trade-up option. Contact your IBM representative for all available trade-ups.

  • Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)
  • DB2 Query Monitor for z/OS, V3 (5655-V42)
  • DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60)
  • InfoSphere Optim Query Workload Tuner for z/OS, V3 (5655-W94))
  • DB2 Query Monitor for z/OS, V3 (5655-V42); and Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)
  • DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60); and Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)
  • DB2 Query Monitor for z/OS, V3 (5655-V42); and DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60)
  • DB2 Query Monitor for z/OS, V3 (5655-V42); and DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60); and Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)

IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32) can help you to manage your DB2 for z/OS databases within your SAP ERP environment. DB2 Tools have helped clients worldwide to reduce total cost of ownership (TCO). They support and exploit the most current versions of DB2 for z/OS, including DB2 for z/OS, V11, as well as the most current versions of IBM z/OS, including z/OS V2.1. This product combines function from the following IBM products:

  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3
  • IBM DB2 Query Monitor for z/OS, V3.2

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 delivers new features for this iteration of the pack. Refer to the Description section for more details.

IBM DB2 Utilities Solution Pack for z/OS, V2.2 (5697-DUP) combines advanced DB2 Tools that enable you to more efficiently execute and manage DB2 utilities. It also helps to optimize the performance and resource utilization of utility management activities. DB2 Utilities Solution Pack for z/OS, V2.2 comprises the following components:

  • IBM DB2 Automation Tool for z/OS, V4.2
  • IBM DB2 High Performance Unload for z/OS, V4.3
  • IBM DB2 Sort for z/OS, V2.1
  • IBM DB2 Utilities Enhancement Tool for z/OS, V2.2

DB2 High Performance Unload for z/OS, V4.3 delivers new features for this iteration of the pack. Refer to the Description section for more details.

Trade-up options for DB2 Utilities Solution Pack for z/OS, V2.2 are available. The following list includes eligible products, or eligible combinations of products, for each trade-up option. Contact your IBM representative for all available trade-ups:

  • DB2 Automation Tool for z/OS, V4 (5655-E37)
  • DB2 High Performance Unload for z/OS, V4 (5655-AA1)
  • DB2 Automation Tool for z/OS, V4 (5655-E37); and DB2 High Performance Unload for z/OS, V4 (5655-AA1)
  • DB2 Automation Tool for z/OS, V4 (5655-E37); and DB2 High Performance Unload for z/OS, V4 (5655-AA1); and DB2 Utilities Enhancement Tool for z/OS, V2 (5655-T58)
  • DB2 Automation Tool for z/OS, V4 (5655-E37); and DB2 Utilities Enhancement Tool for z/OS, V2 (5655-T58)
  • DB2 High Performance Unload for z/OS, V4 (5655-AA1); and DB2 Sort for z/OS, V2 (5655-AA9)
  • DB2 Automation Tool for z/OS, V4 (5655-E37); and DB2 High Performance Unload for z/OS, V4 (5655-AA1); and DB2 Sort for z/OS, V2 (5655-AA9)
  • DB2 Automation Tool for z/OS, V4 (5655-E37); and DB2 Sort for z/OS, V2 (5655-AA9); and DB2 Utilities Enhancement Tool for z/OS, V2 (5655-T58)

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38) offer the following benefits:

  • Continued migration of key classic 3270 user interface features to the enhanced 3270 user interface
  • Integration themes, including:
    • Enterprise monitoring integration with IBM Tivoli OMEGAMON XE for CICS® on z/OS
    • Integration within the DB2 Tools family of products: DB2 Query Monitor for z/OS and IBM Management Console for IMS™ and DB2 for z/OS
  • Updates to DB2 Analytics Accelerator for z/OS, V4.1 (5697-DAB) monitoring capabilities
  • Enhancements to the historical performance and trend analysis tools:
    • Batch reporting
    • The performance database (PDB)
    • The spreadsheet input data generator (CSV)

Trade-up options for Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 are available. The following list includes eligible products, or eligible combinations of products, for each trade-up option. Contact your IBM representative for all available trade-ups:

  • IBM Tivoli OMEGAMON XE for DB2 on z/OS, V4 (5655-CXE)
  • IBM DB2 Performance Monitor for z/OS, V8 (5655-J50)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V4 (5655-Q08)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V4 (5655-Q08); and DB2 Buffer Pool Analyzer for z/OS, V4 (5655-R98)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5 (5655-W38)
  • BM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5 (5655-W38); and DB2 Buffer Pool Analyzer for z/OS, V5 (5655-W35)

Trade-up options for Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 are available. The following list includes eligible products, or eligible combinations of products, for each trade-up option. Contact your IBM representative for all available trade-ups:

  • IBM Tivoli OMEGAMON XE for DB2 on z/OS, V4 (5655-CXE)
  • IBM DB2 Performance Monitor for z/OS, V8 (5655-J50)

Notice of features withdrawn:

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 no longer provides the Japanese Kanji supply feature (S0165KL) previously available with Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.2 (5655-W37).

Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 no longer provides the Japanese Kanji supply feature (S0165KN) previously available with Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.2 (5655-W38).



Back to topBack to top

Top rule
Key prerequisites
Bottom rule

IBM DB2 Tools operate on any IBM z Systems hardware configuration that supports the required software. Refer to the Hardware requirements and Software requirements sections for details.



Back to topBack to top

Top rule
Planned availability date
Bottom rule
  • May 29, 2015
    • IBM DB2 Buffer Pool Analyzer for z/OS, V5.3
    • IBM DB2 High Performance Unload for z/OS, V4.3
    • IBM DB2 Log Analysis Tool for z/OS, V3.5
    • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3
    • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3
  • June 12, 2015
    • IBM DB2 Performance Solution Pack for z/OS, V1.3
    • IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5
    • IBM DB2 Utilities Solution Pack for z/OS, V2.2


Back to topBack to top

Top rule
Description
Bottom rule

IBM DB2 Buffer Pool Analyzer for z/OS, V5.3 (5655-W35) optimizes database performance by helping to tune buffer pools to enable applications to function at their highest efficiency. With DB2 Buffer Pool Analyzer, you can easily tune your database and substantially boost capacity, speed, and reliability.

Going beyond DB2 for z/OS native buffer pool simulation facility, DB2 Buffer Pool Analyzer can help you in the following ways:

  • Enable data collection of virtual buffer pool activity
  • Organize groupings of DB2 for z/OS objects
  • Generate activity reports in multiple formats
  • Optimize object placement, including support of inactive objects like table spaces and buffer pools

IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1) is a high-speed DB2 utility for unloading DB2 tables from either a table space or an image copy. Tables are unloaded to one or more files based on a format that you specify.

New features and enhancements provided in DB2 High Performance Unload, V4.3:

Performance enhancements:

  • DB2 High Performance Unload integration with IBM DB2 Analytics Accelerator for z/OS: DB2 Analytics Accelerator component is used when SET CURRENT QUERY ACCELERATION parmlib variable is set and a logical unload is performed in SQL mode and table and rows have been enabled for DB2 Analytics Accelerator.
  • Set current optimization hint: New parmlib variable OPTIMIZATION_HINT. This sets the current OPTIMIZATION HINT special register for an unload processed in SQL mode.

Compatibility enhancements:

  • DB2 High Performance Unload user exit can handle larger object descriptors as VARCHAR: DB2 High Performance Unload user exit (OUTEXIT keyword) can handle table descriptors (table name and creator)
  • NUMRECS option in the generated LOAD statement: DB2 High Performance Unload can generate LOAD control statement (LOADDN keyword) with the NUMRECs option
  • More DSNTYPE keywords supported: BASIC, LARGE, EXTREQ, EXTPREF
  • Support of DB2 for z/OS UNLOAD syntax: DB2 High Performance Unload support controls cards and the related features of the DB2 UNLOAD (DSNUTILB) utility
  • XML FORMAT additional features: Parmlib XMLSET supports additional XML output

Serviceability enhancements:

  • Issue return information from FIELDPROC if an error occurs: If a fieldproc fails, then fieldproc return and reason codes or an error message is returned in the DB2 High Performance Unload issued error message
  • Numbered message used to report errors at the record level: When errors (internal) occur while processing a specific record of the data, DB2 High Performance Unload issues a formal DB2 High Performance Unload numbered error message
  • Enhanced data integrity checking: New parmlib variable CHECK_INTEGRITY specifies the level of data integrity control to be performed when reading the input data from the LDS of a DB2 object or from an Image Copy. This only applies to the native mode.
    • BASIC - basic controls such as broken page indicator are performed, PGCOMB check
    • LEVEL1 - same as basic control with additional controls for LDS: check if the read page is the expected one.
  • Control data loss during column format conversions: New parmlib variable CHARACTER_LOSS. This variable is used to control what happens when unloading using INTO keyword and the target column is smaller than the source column. Possible values:
    • IGNORE - no control
    • WARNING - issue warning message, set return code to 4 and continue processing
    • REJECT - issue error message, set return code to 8 and terminate processing

Process enhancements:

  • Wait for migrated data sets to be recalled: DB2 High Performance Unload waits for data sets to be recalled when the datasets have been migrated to tapes.
  • Enqueue at the partition level: DB2 High Performance Unload enqueues per partition unless more than 20 partitions are involved in which case the enqueue is taken for the whole table space.

Usability enhancements:

  • Request progress messages via the UNLOAD command: New parmlib variable PROGRESS_MSG_FREQ to request DB2 High Performance Unload to issuing of progression messages via an option in the UNLOAD statement. This variable specifies the frequency of the informational message that displays the current number of unloaded rows for each output file.
  • Improved help for VUU045/ULFORMAT parameter: New help text for ULFORMAT.

IBM DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56) is a powerful tool used to support efforts to maintain high data availability and complete control over data integrity. You can monitor data changes by automatically building reports of changes that are made to database tables. The DB2 Log Analysis Tool performs the following tasks:

Reporting:

  • View data changes by dates, users, tables, and other criteria
  • Create summary and detail reports that show:
    • Original state of the data
    • Current state
    • Other valuable information, such as who changed the data
  • From this process, institute tighter controls over the data to ensure that it can no longer be compromised

Recovery:

  • Generate SQL to UNDO or REDO changes recorded in the log
  • Support for dropped object recoveries:
    • Report on and recover data for dropped objects using both old and new DB2 identifiers
    • After DDL is recreated, restore the data in the regenerated table back to its state before the table was dropped

Auditing:

  • Monitor/Audit table changes
  • UPDATE/INSERT/DELETE
  • Who is changing data?
  • What is the sequence of the changes?
  • Validating SQL activity without traces: Is my program doing what I expect?
  • Load reports into audit tables for review

Replication:

  • Replay changes on another system / object: LOAD or REDO SQL
  • Used for data warehousing / internal processes
  • Used for setting up test systems: Use production data for authentic application testing

DB2 Log Analysis Tool, V3.5 includes the following enhancements:

Performance improvements:

  • DB2 Log Analysis Tool now checks the maximum allowed 64-bit storage value and will switch over to work file mode in case the value is about to be exceeded. This means the job can complete successfully without a restart if the memory limit would otherwise be exceeded. This allows greater usage of 64 bit mode, which is the most efficient method of processing.
  • Exploit SYSIBM.SYSLGRNX to determine if there are ranges of log activity that can be eliminated if no activity is found for any particular object.

Usability improvements:

  • DB2 Log Analysis Tool quick start panels are designed for quicker and easier job generation. The quick start panels are organized so you can choose what type of DB2 Log Analysis Tool activity is wanted and only see the most important options that are relevant to that activity.
  • Continuous mode restarts enable you to request that DB2 Log Analysis Tool track where it failed in continuous mode. DB2 Log Analysis Tool automatically restores continuous mode files on a restart.
  • You can create profiles after you generate a job and edit or submit it. You do not have to use the profile panel to create a new profile or copy from an existing one.
  • You can edit the SSID within the JCL and run a job on a new subsystem. DB2 Log Analysis Tool will see the change and make appropriate adjustments without causing an error condition.
  • Implicitly hidden columns are fully supported and listed in the SQL statement when required for INSERTs.
  • DB2 Log Analysis Tool identifies a mismatch in the Bootstrap Datasets with a warning message when reading the BSDS for log file names.
  • DB2 Log Analysis Tool can use the data sharing member name for data sharing subsystems or the SSID when reporting on non-data sharing subsystems instead of using just the ID.
  • With the new reports and improvements you can do the following:
    • Review storage activity in 24-, 31-, and 64-bit storage with the Storage Activity Report.
    • Identify SYSCOPY entries for DB2 objects with the SYSCOPY Report.
    • Resolve issues more quickly by supplying support personnel with the information from the control file in the Control File Report.
    • Identify table versioning issues with information from the TVFILE report.
  • Easier product installation with IBM Tools Customizer for z/OS automatically discovering the values of DB2 mode and level.

IBM DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74) offers features, functions, and processes that DBAs can use to more effectively identify, diagnose, and solve performance challenges across DB2 for z/OS environments, as well as help prevent them from reoccurring in the future. Key integration features within individual products, such as in-context launching of other tools, direct data import/export and so on, enable users to maintain problem solving context as they move from one tool to the next.

DB2 Performance Solution Pack, V1.3 enhancements include a new release of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS. DB2 Performance Solution Pack, V1.3 is composed of the following tools:

  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) is a single tool that enables you to monitor, analyze, and tune the performance of DB2 for z/OS and IBM DB2 applications. It helps you detect performance problems so they can be isolated and resolved more quickly. Version 5.3 introduces the following functionality to the enhanced 3270 user interface:
    • Complete SQL text available for key thread displays
    • Support for OMEGAMON family history
    • Seamless integration of monitoring data from related IBM performance monitoring and analysis: integration initially provided for Tivoli OMEGAMON XE for CICS on z/OS, V5.3 (5698-T07) and DB2 Query Monitor for z/OS, V3.2 (5655-V42)
    • Integration with IBM Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC)
    • Key performance indicators about DB2 for z/OS subsystems known to the management console
    • Support for IBM DB2 Analytics Accelerator for z/OS, V4.1 (5697-DAB)
  • IBM DB2 Query Monitor for z/OS, V3.2 (5655-V42) enables users to identify problem SQL activity and includes robust statistics for SQL tuning. It can work with IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS and IBM DB2 SQL Performance Analyzer for z/OS to enable users to customize and tune the poorly performing SQL statement or workload and to support the effectiveness of DB2 subsystems and improve overall performance.
    • Monitors SQL activities and delivers automatic alerts to exceptional events on a monitored DB2 subsystem in real time
    • Monitors DB2 commands, host variables, and SQL CA and SQL code in real time
    • Includes user-friendly ISPF, GUI, and web interfaces with SQL statistics of multiple DB2 subsystems Integrates with other DB2 Tools to reduce resource consumption
    • Supports single sign-on for the ISPF view of data sharing group
  • IBM DB2 SQL Performance Analyzer for z/OS, V4.2 (5655-W60) for z/OS gives DBAs and application developers the ability to do extensive analysis of SQL queries without executing them. This analysis aids users in tuning queries to achieve maximum performance. It can also help reduce the escalating costs of database queries by estimating their cost prior to execution. Candidate queries can be passed from both DB2 Query Monitor and Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS to facilitate the analysis of a problem query once identified.
    • Performs performance analysis and recommendations for DB2 plans, packages, DBRMs, and SQL without executing them
    • Includes several interfaces: Batch, ISPF, and QMF™
    • Offers what-if scenarios to help determine the performance for various database design alternatives
    • Generates comprehensive and easy-to-use performance reports to assist in analysis
    • Analyzes economic cost for each query statement
    • Provides an enhanced interface to DB2 Query Monitor that accepts either a DDNAME or a DSNAME when DB2 SQL Performance Analyzer is called
  • IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS, V4.1 (5655-AA4) empowers users to more efficiently manage performance by proactively optimizing the performance of SQL queries and query workloads. InfoSphere Optim Query Workload Tuner for DB2 for z/OS makes it easy to access candidate queries and define workloads from a number of common sources. It is integrated with other separately available DB2 Tools, such as DB2 Query Monitor and Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS to enable a more complete solution for monitoring and tuning SQL. This integration helps organizations reduce the risk of customer complaints, missed SLAs, and financial losses due to performance problems.
    • Analyzes SQL queries and workloads to proactively optimize physical database design and improve performance
    • Helps to proactively solve query performance problems by enabling faster and deeper analysis of queries
    • Offers expert recommendations to help maximize application performance while reducing specialized skill requirements
    • Helps reduce the total cost of ownership for DB2 for z/OS
    • Reduces CPU usage for statistics collection by collecting only what is helpful to improve performance
    • Tunes queries holistically with integration with other separately available DB2 performance tools

Trade-up options are available for DB2 Performance Solution Pack, V1.3. Refer to the Ordering information section.

IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32) offers features, functions, and processes that DBAs can use to more effectively identify, diagnose, and solve performance challenges across DB2 for z/OS databases within SAP ERP environments, as well as help prevent them from reoccurring in the future. DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 is composed of the following tools:

  • Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) is a single tool that enables you to monitor, analyze, and tune the performance of DB2 for z/OS and IBM DB2 applications. It helps you detect performance problems so they can be isolated and resolved more quickly. Version 5.3 introduces the following functionality to the enhanced 3270 user interface:
    • Complete SQL text available for key thread displays
    • Support for OMEGAMON family history
    • Seamless integration of monitoring data from related IBM performance monitoring and analysis: integration initially provided for Tivoli OMEGAMON XE for CICS on z/OS, V5.3 (5698-T07), and DB2 Query Monitor for z/OS, V3.2 (5655-V42)
    • Integration with Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC)
    • Key performance indicators about DB2 for z/OS subsystems known to the management console
  • DB2 Query Monitor for z/OS, V3.2 (5655-V42) enables users to identify problem SQL activity and includes robust statistics for SQL tuning. It can work with InfoSphere Optim Query Workload Tuner for DB2 for z/OS and DB2 SQL Performance Analyzer for z/OS to enable users to customize and tune the poorly performing SQL statement or workload and to support the effectiveness of DB2 subsystems and improve overall performance.
    • Monitors SQL activities and delivers automatic alerts to exceptional events on a monitored DB2 subsystem in real time.
    • Monitors DB2 commands, host variables, and SQL CA and SQL code in real time.
    • Includes user-friendly ISPF, GUI, and web interfaces with SQL statistics of multiple DB2 subsystems.
    • Integrates with other DB2 Tools to reduce resource consumption.
    • Supports single sign-on for the ISPF view of data sharing group .

IBM DB2 Utilities Solution Pack for z/OS, V2.2 (5697-DUP) combines autonomic capability for DB2 utilities. It can help to relieve time and workload burdens from users who are faced with growing volume and complexity, but less time to manage DB2 for z/OS environments. Autonomics address the ever-shrinking batch window by adding intelligence and decision-making when performing critical DB2 utility maintenance with:

  • Routine collection and reporting of DB2 utility data.
  • Identification of symptoms and recommendation of actions for maintenance, based on collection and analysis of DB2 data.
  • Support for passive autonomic problem identification and notification of recommended actions with no automated actions taken.
  • Support for active autonomic utility execution within a user-defined maintenance window.

DB2 Utilities Solution Pack, V2.2 consists of the following tools:

  • IBM DB2 Automation Tool for z/OS, V4.2 (5655-E37), offering the following benefits:
    • Flexibility to perform a combination of maintenance functions within a single job profile.
    • Ability to send an email, text message, or WTO notification when selected events occur, such as at the start or end of a job build, or at the start or end of a maintenance window.
  • IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1) is a high-speed DB2 utility for unloading DB2 tables from either a table space or from an image copy, with the following new features:
    • Integration with IBM DB2 Analytics Accelerator
    • Support of DB2 UNLOAD syntax
    • Enqueue at the partition level
  • IBM DB2 Sort for z/OS, V2.1 (5655-AA9) delivers a bidirectional, multirecord interface, giving you the following benefits:
    • Reduces elapsed time required to complete sort processing.
    • Enables larger amounts of sort processing to be offloaded to a zIIP1 engine that can further improve CPU consumption.

DB2 Utilities Solution Pack, V2.2 integrates with Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC) to deliver the following features:

  • Graphical reporting, categorizing, sorting, and ordering of DB2 utility symptoms and actions as part of the various DB2 subsystem, tablespace, indexspace, and partition-level dashboards
  • Graphical reporting of historical DB2 utility runs listed on the various levels of DB2 dashboards
  • Ability to graphically view DB2 utility profiles including object, exception, utility, and job profiles

Trade-up options are available for Utilities Solution Pack, V2.2. Refer to the Ordering information section.

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) is a single tool that enables you to monitor, analyze, and tune the performance of DB2 for z/OS and DB2 applications. It helps you detect performance problems so they can be isolated and resolved more quickly.

Version 5.3 introduces the following functionality to the enhanced 3270 user interface:

  • Complete SQL text available for key thread displays
  • Support for OMEGAMON family history

In addition, Version 5.3:

  • Provides seamless integration of monitoring data from related IBM performance monitoring and analysis: initially provided for Tivoli OMEGAMON XE for CICS on z/OS, V5.3 (5698-T07) and DB2 Query Monitor for z/OS, V3.2 (5655-V42)
  • Integrates with the IBM Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC) giving you key performance indicators about DB2 for z/OS subsystems known to the management console
  • Supports IBM DB2 Analytics Accelerator for z/OS, V4.1 (5697-DAB)

Trade-up options are available for Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3. Refer to the Ordering information section.

IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38) enables users to assess the efficiency of DB2 for z/OS and optimize its performance, combining sophisticated response time tracking, reporting, monitoring, stored procedure, and buffer pool analysis features, as well as expert database analysis functions.

Version 5.3 introduces the following functionality to the enhanced 3270 user interface:

  • Complete SQL text available for key thread displays
  • Support for OMEGAMON family history

In addition, Version 5.3:

  • Introduces new cross-monitor linking with embedded data integration in the enhanced 3270 user interface
  • Provides seamless integration of monitoring data from related IBM performance monitoring and analysis tools: initially provided for Tivoli OMEGAMON XE for CICS on z/OS, V5.3 (5698-T07) and DB2 Query Monitor for z/OS, V3.2 (5655-V42)
  • Integrates with the IBM Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC) giving you key performance indicators about DB2 for z/OS subsystems known to the management console
  • Supports IBM DB2 Analytics Accelerator for z/OS, V4.1 (5697-DAB)

Trade-up options are available for Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3. Refer to the Ordering information section.

1
This information provides only general descriptions of the types and portions of workloads that are eligible for execution on Specialty Engines (SEs). IBM authorizes customers to use IBM SEs such as zIIPs, zAAPs, and IFLs only to execute the processing of Eligible Workloads of specific programs expressly authorized by IBM as specified in the Authorized Use Table for IBM Machines (AUT) provided at
http://www.ibm.com/systems/support/machine_warranties/machine_code/aut.html

No other workload processing is authorized for execution on an SE. IBM offers SEs at a lower price than General Processors and Central Processors because customers are authorized to use SEs only to process certain types or amounts of workloads as specified by IBM in the AUT.

Section 508 of the US Rehabilitation Act

The products in this announcement are capable as of their general availability, 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) can be requested via IBM's website at the following

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

Value Unit-based pricing

Value Unit pricing for eligible IBM z Systems IBM International Program License Agreement (IPLA) programs enables a lower cost of incremental growth and enterprise aggregation. Each z Systems IPLA product with Value Unit pricing has a single price per Value Unit and a conversion matrix, called Value Unit Exhibit, for converting from some designated measurement to Value Units. Most commonly, Millions of Service Units (MSUs) is the measurement designated by IBM to be converted to Value Units. Some other measurements are engines or messages. Since MSUs are the most common measurement, that measurement will be used for the remainder of this description.

Value Unit pricing offers price benefits for you. For each z Systems IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Each of the various Value Unit Exhibits stipulate that the larger your required license capacity, the fewer Value Units per MSU you will need. Value Unit Exhibits are uniquely identified by a three digit code and referred to using the nomenclature VUExxx, where xxx is the three digit code.

Subsequent acquisitions of Value Unit priced programs offer additional price benefits. The quantity of each z Systems IPLA program that you have acquired is referred to as entitled license capacity . To grow your entitled license capacity for a z Systems IPLA program, the calculation to determine additional needed Value Units is based upon the number of Value Units already acquired.

For each z Systems IPLA program with Value Unit pricing, you should:

  • Determine the required license capacity, in MSUs
  • Aggregate the MSUs across the enterprise
  • Convert the total MSUs to Value Units, using the applicable Value Unit Exhibit
  • Multiply the price per Value Unit by the total number of Value Units to determine the total cost

To simplify conversion from the designated measurement to Value Units or vice-versa, use the Value Unit Converter Tool. For additional information or to obtain a copy of the Value Unit Converter Tool, visit the Value Unit Converter Tool website

http://www.ibm.com/zseries/swprice/vuctool

Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.

To determine the required license capacity for the z Systems IPLA program you selected, refer to the Terms and conditions section.



Back to topBack to top

Top rule
Reference information
Bottom rule

Refer to the following announcements:

  • Software Announcement 213-395, dated October 1, 2013, for IBM DB2 Buffer Pool Analyzer for z/OS, V5.2, IBM DB2 Log Analysis Tool for z/OS, V3.4, IBM DB2 Performance Solution Pack for z/OS, V1.2, IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.2, and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.2
  • Software Announcement 212-258, dated August 7, 2012, for IBM DB2 High Performance Unload for z/OS, V4.2
  • Software Announcement 214-016, dated February 11, 2014, for IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.4
  • Software Announcement 214-371, dated October 7, 2014, for DB2 Utilities Solution Pack for z/OS, V2.1



Back to topBack to top

Top rule
Program number
Bottom rule
Program number VRM Program name
5655-W35 5.3 IBM DB2 Buffer Pool Analyzer for z/OS
5655-AA1 4.3 IBM DB2 High Performance Unload for z/OS
5655-T56 3.5 IBM DB2 Log Analysis Tool for z/OS
5655-E74 1.3 IBM DB2 Performance Solution Pack for z/OS
5697-M32 2.5 IBM DB2 Performance Toolkit for z/OS the SAP Edition
5697-DUP 2.2 IBM DB2 Utilities Solution Pack for z/OS
5655-W37 5.3 IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
5655-W38 5.3 IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

Product identification number

Program PID number Subscription and Support PID number
5655-W35 5655-E55
5655-AA1 5655-E89
5655-T56 5655-E86
5655-E74 5655-E75
5697-M32 5697-N32
5697-DUP 5697-DUS
5655-W37 5655-R07
5655-W38 5655-R08


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



Back to topBack to top

Top rule
Business Partner information
Bottom rule

If you are a Direct Reseller - System Reseller acquiring products from IBM, you may link directly to Business Partner information for this announcement. A PartnerWorld® ID and password are required (use IBM ID).

BP Attachment for Announcement Letter 215-086


Back to topBack to top

Top rule
Publications
Bottom rule

The following publications are shipped with the product:

Title Order number
IBM DB2 Buffer Pool Analyzer for z/OS, V5.3 (5655-W35)  
License Information GH12-6974
Program Directory GI19-5017
IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1)  
License Information GC19-3170
Program Directory GI10-8859
IBM DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56)  
License Information GC19-1301
Program Directory GI10-8772
IBM DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74)  
License Information GC19-3988
Program Directory GI10-8940
ITOA Support Files for z/OS V5.1.1 DVD LCD7-5139
KKIT Collection: DB2 ESE V10.5.0.4 for OMPE V5.3.0 L-Pkit LK4T-5002
KKIT Component: Data Server Client V10.5.0.4 Linux™ 32-bit LCD7-5735
KKIT Component: Data Server Client V10.5.0.4 Linux 64-bit LCD7-5736
KKIT Component: Data Server Client V10.5 Windows™ 64-bit LCD7-5738
KKIT Component: Data Server Client V10.5.0.4 Windows 32-bit LCD7-5737
KKIT Component: DB2 ESE V10.5.0.4 AIX® DVD LCD7-5729
KKIT Component: DB2 ESE V10.5.0.4 HP-UX Itanium-based DVD LCD7-5730
KKTI Component: DB2 ESE V10.5.0.4 Linux 64-bit DVD LCD7-5726
KKIT Component: DB2 ESE V10.5.0.5 Linux Power® (Systems i and p) LCD7-5728
KKIT Component: DB2 ESE V10.5.0.4 Linux System z® DVD LCD7-5727
KKIT Component: DB2 ESE V10.5.0.4 Restricted Use Activation LCD7-5739
KKIT Component: DB2 ESE V10.5.0.4 Solaris 32-bit DVD LCD7-5731
KKIT Component: DB2 ESE V10.5.0.4 Solaris 64-bit DVD LCD7-5732
KKIT Component: DB2 ESE V10.5.0.4 Windows 64-bit DVD LCD7-5734
KKIT Collection: OMPE on z/OS V5.3.0 L-Pkit LK4T-5001
KKIT Component: Optim Data Tools Runtime Client LCD7-2622
KKIT Component: Option Data Tools Runtime Client Bulk LCD7-2627
KKIT Component: Optim PE Extended Edition Plugin TEP LCD7-2623
KKIT Component: Optim PE for LUW Server AIX, Linux, Win LCD7-2621
KKIT Component: Tivoli OMEGAMON DB2 PE Activation Key LCD7-2624
IBM Tivoli OMEGAMON XE z/OS Language Pack CD-ROM LCD7-5138
IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32)  
License Information GC18-9965
Program Directory GI10-8718
ITOA Support Files for z/OS V5.1.1 DVD LCD7-5139
KKIT Collection: DB2 ESE V10.5.0.4 for OMPE V5.3.0 L-Pkit LK4T-5002
KKIT Component: Data Server Client V10.5.0.4 Linux 32-bit LCD7-5735
KKIT Component: Data Server Client V10.5.0.4 Linux 64-bit LCD7-5736
KKIT Component: Data Server Client V10.5 Windows 64-bit LCD7-5738
KKIT Component: Data Server Client V10.5.0.4 Windows 32-bit LCD7-5737
KKIT Component: DB2 ESE V10.5.0.4 AIX DVD LCD7-5729
KKIT Component: DB2 ESE V10.5.0.4 HP-UX Itanium-based DVD LCD7-5730
KKTI Component: DB2 ESE V10.5.0.4 Linux 64-bit DVD LCD7-5726
KKIT Component: DB2 ESE V10.5.0.5 Linux Power (Systems i and p) LCD7-5728
KKIT Component: DB2 ESE V10.5.0.4 Linux System z DVD LCD7-5727
KKIT Component: DB2 ESE V10.5.0.4 Restricted Use Activation LCD7-5739
KKIT Component: DB2 ESE V10.5.0.4 Solaris 32-bit DVD LCD7-5731
KKIT Component: DB2 ESE V10.5.0.4 Solaris 64-bit DVD LCD7-5732
KKIT Component: DB2 ESE V10.5.0.4 Windows 64-bit DVD LCD7-5734
KKIT Collection: OMPE on z/OS V5.3.0 L-Pkit LK4T-5001
KKIT Component: Optim Data Tools Runtime Client LCD7-2622
KKIT Component: Optim Data Tools Runtime Client Bulk LCD7-2627
KKIT Component: Optim PE Extended Edition Plugin TEP LCD7-2623
KKIT Component: Optim PE for LUW Server AIX, LINUX, WIN LCD7-2621
KKIT Component: Tivoli OMEGAMON DB2 PE Activation Key LCD7-2624
IBM DB2 Utilities Solution Pack for z/OS, V2.2 (5697-DUP)  
License Information GC19-4391
Program Directory GI10-9005
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37)  
License Information GH12-6971
Program Directory GI19-5014
KKIT Collection: DB2 ESE V10.5.0.4 for OMPE V5.3.0 L-Pkit LK4T-5002
KKIT Component: Data Server Client V10.5.0.4 Linux 32-bit LCD7-5735
KKIT Component: Data Server Client V10.5.0.4 Linux 64-bit LCD7-5736
KKIT Component: Data Server Client V10.5 Windows 64-bit LCD7-5738
KKIT Component: Data Server Client V10.5.0.4 Windows 32-bit LCD7-5737
KKIT Component: DB2 ESE V10.5.0.4 AIX DVD LCD7-5729
KKIT Component: DB2 ESE V10.5.0.4 HP-UX Itanium-based DVD LCD7-5730
KKIT Component: DB2 ESE V10.5.0.4 Linux 64-bit DVD LCD7-5726
KKIT Component: DB2 ESE V10.5.0.4 Linux System z DVD LCD7-5727
KKIT Component: DB2 ESE V10.5.0.4 Restricted Use Activation LCD7-5739
KKIT Component: DB2 ESE V10.5.0.4 Solaris 32-bit DVD LCD7-5731
KKIT Component: DB2 ESE V10.5.0.4 Solaris 64-bit DVD LCD7-5732
KKIT Component: DB2 ESE V10.5.0.4 Windows 64-bit DVD LCD7-5734
KKIT Component: DB2 ESE V10.5.0.5 Linux Power (systems i&p) LCD7-5728
KKIT Collection: OMPE on z/OS V5.3.0 L-Pkit LK4T-5001
KKIT Component: Optim Data Tools Runtime Client LCD7-2622
KKIT Component: Optim Data Tools Runtime Client Bulk LCD7-2627
KKIT Component: Optim PE Extended Edition Plugin TEP LCD7-2623
KKIT Component: Optim PE for LUW Server AIX, Linux, WIN LCD7-2621
KKIT Component: Tivoli OMEGAMON DB2 PE Activation Key LCD7-2624
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38) - English  
License Information GH12-6972
Program Directory GI19-5016
Tivoli OMEGAMON XE z/OS Language Pack CD-ROM LCD7-5138
ITOA Support Files for z/OS V5.1.1 DVD LCD7-5139

The following publications can be ordered immediately after planned availability. To order, use the Publications Center or contact your IBM representative.

Title Order number
IBM DB2 Buffer Pool Analyzer for z/OS, V5.3  
User's Guide SH12-7057
Configuration Guide SH12-7058
IBM DB2 High Performance Unload for z/OS, V4.3  
User's Guide SC27-6557
IBM DB2 Log Analysis Tool for z/OS, V3.5  
User's Guide SC27-6559
IBM DB2 Performance Solution Pack for z/OS, V1.3  
IBM Tivoli OMEGAMON XE and Tivoli Management Services on z/OS: Upgrade Guide SC22-5486
IBM Tivoli OMEGAMON XE for DB2 Performance Expert for DB2 for z/OS, V5.3  
Tivoli OMEGAMON XE and Tivoli Management Services on z/OS: Upgrade Guide SC22-5486
Tivoli OMEGAMON XE Monitoring Agents on z/OS Quick Start Guide GI32-3140
Quick Start Guide for SQL Dashboard and end-to-end SQL monitoring function GH12-7046
Report Reference SH12-7047
Report Command Reference SH12-7048
Messages GH12-7049
Monitoring Performance from the OMEGAMON Classic Interface SH12-7050
Monitoring Performance from Performance Expert Client SH12-7051
Monitoring Performance from ISPF SH12-7052
Reporting User's Guide SH12-7053
Configuration and Customization GH12-7054
Parameter Reference SH12-7055
Enhanced 3270 User Interface SH12-7056
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor for DB2 for z/OS, V5.3  
Tivoli OMEGAMON XE and Tivoli Management Services on z/OS: Upgrade Guide SC22-5486
Tivoli OMEGAMON XE Monitoring Agents on z/OS Quick Start Guide GI32-3140
Report Reference SH12-7047
Report Command Reference SH12-7048
Messages GH12-7049
Monitoring Performance from the OMEGAMON Classic Interface SH12-7050
Monitoring Performance from Performance Expert Client SH12-7051
Monitoring Performance from ISPF SH12-7052
Reporting User's Guide SH12-7053
Configuration and Customization GH12-7054
Parameter Reference SH12-7055
Enhanced 3270 User Interface SH12-7056

The IBM Publications Center portal is located at

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. A large number of publications are available online in various file formats, and they can all be downloaded by all countries.



Back to topBack to top

Top rule
Services
Bottom rule

Software Services

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
Technical information
Bottom rule

Specified operating environment

Hardware requirements

The products in this announcement operate on any IBM z System hardware configuration that supports the required software.

In addition:

The IBM DB2 Query Monitor for z/OS component in IBM DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74) and IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32), requires:

  • Any hardware configuration that supports Microsoft™ Windows XP or Windows 7
  • Minimum 1 GB RAM
  • Minimum 1 GB disk space
  • Minimum 1 GHz processor speed
  • Network access via LAN, T1, DSL, or cable modem
  • Network protocol TCP/IP
  • SVGA monitor supporting 256 colors, or greater
Software requirements

Mandatory installation requirements

The products in this announcement require:

  • One of the following:
    • IBM z/OS , V1.13 (5694-A01), or later
    • IBM z/OS , V2.1 (5650-ZOS), or later
  • IBM SMP/E for z/OS V3.6 (5655-G44), or later

In addition:

  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 and IBM Tivoli OMEGAMON XE for DB Performance Monitor on z/OS, V5.3 require IBM Tivoli Monitoring, V6.3.0 (5698-A79) fixpack 2
  • IBM DB2 Performance Solution Pack for z/OS, V1.3 and IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 require:
    • The IBM DB2 Query Monitor for z/OS component requires IBM DB2 Data Access Common Collector for z/OS, V1.1 (5639-OLC) or later
    • The Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS component requires IBM Tivoli Monitoring, V6.3.0 (5698-A79) fixpack 2

Mandatory operational requirements

The following tools:

  • DB2 Buffer Pool Analyzer for z/OS, V5.3 (5655-W35)
  • DB2 High Performance Unload for z/OS, V4.3 (5655-AA1)
  • DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56)
  • DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74)
  • DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32)
  • Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37)
  • Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38

operate with:

  • IBM DB2 V10.1 (5605-DB2)
  • IBM DB2 Value Unit Edition, V10.1 (5697-P31)
  • IBM DB2 V11.1 (5615-DB2)
  • IBM DB2 Value Unit Edition, V11.1 (5697-P43)

DB2 Utilities Solution Pack for z/OS, V2.2 (5697-DUP) operates with:

  • IBM DB2 V10.1 (5605-DB2)
  • IBM DB2 Value Unit Edition, V10.1 (5697-P31)
  • IBM DB2 Utilities Suite for z/OS, V10.1 (5655-V41) with maintenance applied up to and including PI19784
  • IBM DB2 V11.1 (5615-DB2)
  • IBM DB2 Value Unit Edition, V11.1 (5697-P43)
  • IBM DB2 Utilities Suite for z/OS, V11.1 (5655-W87) with maintenance applied up to and including PI19784

DB2 Utilities Solution Pack for z/OS, V2.2 autonomic capability requires:

  • IBM Management Console for IMS and DB2 for z/OS, V1.1 (5655-TAC)
  • IBM Tools Base for z/OS, V1.5 (5655-V93), IBM Autonomics Director for DB2 for z/OS FMID HAKP150

For post-installation customizations, DB2 High Performance Unload for z/OS, V4.3, DB2 Log Analysis Tool for z/OS, V3.5, DB2 Performance Solution Pack for z/OS, V1.3, DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 and DB2 Utilities Solution Pack for z/OS, V2.2 require FMID HTCZ110 IBM Tools Customizer for z/OS at the latest maintenance level which is delivered in IBM Tools Base, V1.5 (5655-V93).

DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74) and DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32) the DB2 Query Monitor for z/OS component requires:

  • If you want to run the CAE Server under USS, requires the most current maintenance of (31-bit) Java™ 1.6 (including all prerequisites) must be installed on your mainframe. Note: This requirement applies to running the CAE Server under USS and is not required if you only plan to run the CAE Agent on an LPAR. Java builds are available at

http://www-03.ibm.com/servers/eserver/zseries/software/java/j5pcont31.html

  • For the DB2 Query Monitor Web Client:
    • Mozilla Firefox, 2.0.1.3, or later
    • Microsoft Internet Explorer, V8, or later
    • Adobe™ Flash Player 10

Conditional operational requirements

DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56) requires IBM DB2 Sort for z/OS to be installed on the DB2 subsystem you plan to use with DB2 Log Analysis Tool if you want to use DB2 SORT for sort processing.

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) and Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38) support the following additional subsystems:

  • IBM CICS Transaction Server for z/OS, V3.1 (5655-M15), or higher
  • IBM CICS Transaction Server for z/OS, V4.1 (5655-S97), or higher
  • IBM CICS Transaction Server for z/OS, V5.1 (5655-Y04) or higher
  • IBM IMS, V12.1(5655-A03)
  • IBM IMS, V13.1 (5655-A04)

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.

User Group requirements

This announcement satisfies or partially satisfies requirements from one or more of the worldwide user group communities. Groups include COMMON, COMMON Europe, Guide Share Europe (GSE), InterAction (Australia/New Zealand), Japan Guide Share (JGS), and SHARE Inc.

IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1) satisfies the following requirements:

RFE36366 RFE36361 RFE41655
RFE53669 RFE41655 RFE36367
RFE36353 RFE43636 RFE36370

IBM DB2 Log Analysis Tool for z/OS, V3.5 (5655-T56) satisfies the following requirements:

RFE34659 RFE30213 MR060608589
RFE31431 RFE54764 MR0615096123
RFE28817    

IBM DB2 Performance Solution Pack for z/OS, V1.3 (5655-E74) satisfies the following requirements:

MR0813094254 RFE39146 RFE45618
RFE42237 RFE33140 RFE28359
RFE53587 RFE14988 MR032109318
RFE39250 MR0211083836 RFE61541

IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 (5697-M32) satisfies the following requirements:

MR0813094254 RFE39146 RFE45618
RFE42237 RFE33140 RFE28359
RFE53587 RFE14988 MR032109318
RFE39250 MR0211083836 RFE61541

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) satisfies the following requirements:

MR0813094254 RFE39146 RFE45618
RFE42237 RFE33140 RFE28359
RFE53587 RFE14988 MR032109318
RFE39250 MR0211083836 RFE61541

IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 (5655-W38) satisfies the following requirements:

MR0813094254 RFE39146 RFE45618
RFE42237 RFE33140 RFE28359
RFE53587 RFE14988 MR032109318
RFE39250 MR0211083836 RFE61541

Planning information

Packaging

The programs in this announcement are distributed with the following content:

  • Basic machine-readable material
  • Program Directory
  • IBM International Program License Agreement (IPLA)
  • IBM Agreement for Acquisition of Software Maintenance (IAASM)

Security, auditability, and control

The programs in this announcement uses the security and auditability features of the host operating system software.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



Back to topBack to top

Top rule
Ordering information
Bottom rule

The programs in this announcement have Value Unit-Based pricing.

Program number Program name Value Unit exhibit
5655-W35 IBM DB2 Buffer Pool Analyzer for z/OS VUE007
5655-AA1 IBM DB2 High Performance Unload for z/OS VUE007
5655-T56 IBM DB2 Log Analysis Tool for z/OS VUE007
5655-E74 IBM DB2 Performance Solution Pack for z/OS VUE007
5697-M32 IBM DB2 Performance Toolkit for z/OS the SAP Edition VUE007
5697-DUP IBM DB2 Utilities Solution Pack for z/OS VUE007
5655-W37 IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS VUE007
5655-W38 IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS VUE007

For each z Systems IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Your required license capacity is based upon the following factors:

  • The z Systems IPLA program you select
  • The applicable Value Unit Exhibit
  • The applicable terms
  • Whether your current mainframes are full capacity or sub-capacity


Value Unit exhibit VUE007

            MSUs      MSUs
            minimum   maximum   Value Units/MSU

 
Base          1         3       1
Tier A        4        45       0.45
Tier B       46       175       0.36
Tier C      176       315       0.27
Tier D      316         +       0.2

Ordering example

The total number of Value Units is calculated according to the following example.

If your required license capacity is 1,500 MSUs for your selected z Systems IPLA product, the applicable Value Units would be:

Translation from MSUs to Value Units
 
          MSUs    *  Value Units/MSU = Value Units
Base          3   *  1.00            =    3.00
Tier A       42   *   .45            =   18.90
Tier B      130   *   .36            =   46.80
Tier C      140   *   .27            =   37.80
Tier D    1,185   *   .20            =  237.00

Total     1,500                         343.50

When calculating the total number of Value Units, the sum is to be rounded up to the next integer.


Ordering z/OS through the Internet

Shopz provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze your current installation, determine the correct product migration, and present your new configuration based on z/OS. Additional products can also be added to your order (including determination of whether all product requisites are satisfied). Shopz is available in the US and several countries in Europe. In countries where Shopz is not available yet, contact your IBM representative (or IBM Business Partner) to handle your order via the traditional IBM ordering process. For more details and availability, visit the Shopz website at

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

Charge metric

Program name PID number Charge metric
IBM DB2 Buffer Pool Analyzer for z/OS 5655-W35 Value Unit
IBM DB2 High Performance Unload for z/OS 5655-AA1 Value Unit
IBM DB2 Log Analysis Tool for z/OS 5655-T56 Value Unit
IBM DB2 Performance Solution Pack for z/OS 5655-E74 Value Unit
IBM DB2 Performance Toolkit for z/OS the SAP Edition 5697-M32 Value Unit
IBM DB2 Utilities Solution Pack for z/OS 5697-DUP Value Unit
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5655-W37 Value Unit
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS 5655-W38 Value Unit

Basic license


On/Off CoD

The products in this announcement are eligible for On/Off CoD with a temporary use charge calculated based on MSUs per-day usage.

Translation from MSUs to Value Units

  MSUs Value Units/MSU
Base 1-3 1.00
Tier A 4-45 0.45
Tier B 46-175 0.36
Tier C 176-315 0.27
Tier D 316+ 0.20

To order, specify the program product number and the appropriate license or charge option. Also, specify the desired distribution medium. To suppress shipment of media, select the license-only option in CFSW.

Program name: IBM DB2 Buffer Pool Analyzer for z/OS, V5.3

Program PID: 5655-W35

Entitlement identifier Description License option/Pricing metric
S016GL6 DB2 Buffer Pool Analyzer for z/OS, V5 Basic OTC, Value Units
    Basic OTC per MSU-day TUC
Orderable supply ID Language Distribution medium
S016K5H English 3590 Tape cartridge

Program name: IBM DB2 High Performance Unload for z/OS, V4.3

Program PID: 5655-AA1

Entitlement identifier Description License option/Pricing metric
S016GLC DB2 High Performance Unload for z/OS, V4 Basic OTC, Value Units
    Basic OTC per MSU-day TUC
Orderable supply ID Language Distribution medium
S016GLB English 3590 Tape cartridge

Program name: IBM DB2 Log Analysis Tool for z/OS, V3.5

Program PID: 5655-T56

Entitlement identifier Description License option/Pricing metric
S014J6K DB2 Log Analysis Tool for z/OS, V3 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0166C9 English 3590 Tape cartridge

Program name: IBM DB2 Performance Solution Pack for z/OS, V1.3

Program PID: 5655-E74

Entitlement identifier Description License option/Pricing metric
S0175XN DB2 Performance Solution Pack for z/OS, V1 Basic OTC, Value Units
  Trade-up from 5655-W37 Basic OTC, per MSU-day TUC
  Trade-up from 5655-W37 and 5655-V42  
  Trade-up from 5655-W37 and 5655-V42 and 5655-W60  
  Trade -up from 5655-W37 and 5655-W60  
  Trade-up from 5655-V42  
  Trade-up from 5655-V42 and 5655-W60  
  Trade-up from 5655-W60  
  Trade-up from 5655-W94  
Orderable supply ID Language Distribution medium
S0175KG English 3590 Tape cartridge
S0175ZD English 3590 Tape cartridge

Program name: IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5

Program PID: 5697 - M32

Entitlement identifier Description License option/Pricing metric
S012M3P DB2 Performance Toolkit for z/OS the SAP Edition, V2 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0168RH English 3590 Tape cartridge
S0168RJ English 3590 Tape cartridge

Program name: IBM DB2 Utilities Solution Pack for z/OS, V2.2

Program PID: 5697-DUP

Entitlement identifier Description License option/Pricing metric
S017KDL DB2 Utilities Solution Pack for z/OS, V2 Basic OTC, Value Units
  Trade up from 5655-E37 Basic OTC, per MSU-day TUC
  Trade up from 5655-AA1  
  Trade up from 5655-E37 and 5655-AA1  
  Trade up from 5655-E37 and 5655-AA1 and 5655-T58  
  Trade up from 5655-E37 and 5655-T58  
  Trade up from 5655-AA1 and 5655-AA9  
  Trade up from 5655-E37 and 5655-AA1 and 5655-AA9  
  Trade up from 5655-E37 and 5655-AA9 and 5655-T58  
Orderable supply ID Language Distribution medium
S017KDK English 3590 Tape cartridge

Program name: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3

Program PID: 5655-W37

Entitlement identifier Description License option/Pricing metric
S016K5T Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 Basic OTC, Value Units
  Trade up from 5655-CXE Basic OTC, Per MSU-day TUC
  Trade up from 5655-J50  
  Trade up from 5655-Q08  
  Trade up from 5655-Q08 and 5655-R98  
  Trade up from 5655-W38  
  Trade up from 5655-W38 and 5655-W35  
Orderable supply ID Language Distribution medium
S016K5K English 3590 Tape cartridge

Program name: IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3

Program PID: 5655-W38

Entitlement identifier Description License option/Pricing metric
S016K5X Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5 Basic OTC, Value Units
  Trade up from 5655-CXE Basic OTC, per MSU-day TUC
  Trade up from 5655-J50  
Orderable supply ID Language Distribution medium
S016K5P English 3590 Tape cartridge

Subscription and Support PID: 5655-E55

Entitlement identifier Description License option/Pricing metric
S00VZFD DB2 Buffer Pool Analyzer for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00VZFF English Hardcopy publication

Subscription and Support PID: 5655-E89

Entitlement identifier Description License option/Pricing metric
S00V747 DB2 High Performance Unload for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TH8K English Hardcopy publication

Subscription and Support PID: 5655-E86

Entitlement identifier Description License option/Pricing metric
S00V748 DB2 Log Analysis Tool for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TH8N English Hardcopy publication

Subscription and Support PID: 5655-E75

Entitlement identifier Description License option/Pricing metric
S0175XP DB2 Performance Solution Pack for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0175XS English Hardcopy Publication

Subscription and Support PID: 5697-N32

Entitlement identifier Description License option/Pricing metric
S011VW6 DB2 Performance Toolkit for z/OS the SAP Edition S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S011VW7 English Hardcopy publication

Subscription and Support PID: 5697-DUS

Entitlement identifier Description License option/Pricing metric
S0171WS DB2 Utilities Solution Pack for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0171WV English Hardcopy publication

Subscription and Support PID: 5655-R07

Entitlement identifier Description License option/Pricing metric
S0122MR Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0122MS English Hardcopy publication

Subscription and Support PID: 5655-R08

Entitlement identifier Description License option/Pricing metric
S0122MV Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0122MW English Hardcopy publication


Subscription and Support

To receive voice technical support via telephone and future releases and versions at no additional charge, Subscription and Support must be ordered. The capacity of Subscription and Support (Value Units) must be the same as the capacity ordered for the product licenses.

To order, specify the Subscription and Support program number (PID) referenced above and the appropriate license or charge option.

IBM is also providing Subscription and Support for these products via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Software Maintenance. This offering:

  • Includes and extends the support services provided in the base support to include technical support via telephone.
  • Entitles you to future releases and versions, at no additional charge. Note that you are not entitled to new products.

When Subscription and Support is ordered, the charges will automatically renew annually unless cancelled by you.

The combined effect of the IPLA license and the Agreement for Acquisition of Software Maintenance gives you rights and support services comparable to those under the traditional ICA S/390® and z Systems license or its equivalent. To ensure that you continue to enjoy the level of support you are used to in the ICA business model, you must order both the license for the program and the support for the selected programs at the same Value Unit quantities.

Withdrawal from marketing information

A new product release within a version supersedes the release level that precedes it. Accordingly, the following product releases will be withdrawn from marketing, effective on the date the new release becomes available.

Releases to be withdrawn from marketing effective May 29, 2015:

Name of product being withdrawn Ver Rel Mod Product number
IBM DB2 Buffer Pool Analyzer for z/OS 5 2 0 5655-W35
IBM DB2 High Performance Unload for z/OS 4 2 0 5655-AA1
IBM DB2 Log Analysis for z/OS 3 4 0 5655-T56
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5 2 0 5655-W37
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS 5 2 0 5655-W38

5655-W35 IBM DB2 Buffer Pool Analyzer for z/OS, V5.2.0 is replaced by 5655-W35 IBM Buffer Pool Analyzer for z/OS V5.3.0, 5655-AA1 IBM DB2 High Performance Unload for z/OS, V4.2.0 is replaced by 5655-AA1 IBM DB2 High Performance Unload for z/OS, V4.3.0, 5655-T56 IBM DB2 Log Analysis Tool for z/OS, V3.4.0 is replaced by 5655-T56 IBM DB2 Log Analysis Tool for z/OS, V3.5.0, 5655-W37 IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.2.0 is replaced by 5655-W37 IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3.0, 5655-W38 IBM OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.2.0 is replaced by 5655-W38 IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3.0.

Releases to be withdrawn from marketing effective June 12, 2015:

Name of product being withdrawn Ver Rel Mod Product number
IBM DB2 Performance Solution Pack for z/OS 1 2 0 5655-E74
IBM DB2 Performance Toolkit for z/OS the SAP Edition 2 4 0 5697-M32
IBM DB2 Utilities Solution Pack for z/OS 2 1 0 5697-DUP

5655-E74 IBM DB2 Performance Solution Pack for z/OS, V1.2.0 is replaced by 5655-E74 IBM Performance Solution Pack for z/OS, V1.3.0, 5697-M32 IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.4.0 is replaced by 5697-M32 IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5.0, 5697-DUP IBM DB2 Utilities Solution Pack for z/OS, V2.1.0 is replaced by 5697-DUP IBM DB2 Utilities Solution Pack for z/OS, V2.2.0.

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:

  • 3590
  • 3592

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://www.software.ibm.com/ShopzSeries

For additional information on the Product ServerPac option, refer to Software Announcement 212-272, dated July 7, 2012 .

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

  • CBPDO shipments will begin one week after general availability.
  • ServerPac shipments will begin two weeks after general availability.



Back to topBack to top

Top rule
Terms and conditions
Bottom rule

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage® Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing

IBM International Program License Agreement including the License Information document and Proof of Entitlement (PoE) govern your use of the program. PoEs are required for all authorized use.

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

Agreement for Acquisition of Software Maintenance

The following agreement applies for Software Subscription and Support (Software Maintenance) and does not require customer signatures: IBM Agreement for Acquisition of Software Maintenance (Z125-6011)

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. 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. IBM z Systems Operational Support Services - SoftwareXcel is an option if you desire added services.

License Information number

Program name Program number License Information
IBM DB2 Buffer Pool Analyzer for z/OS 5655-W35 GH12-6974
IBM DB2 High Performance Unload for z/OS 5655-AA1 GC19-3170
IBM DB2 Log Analysis Tool for z/OS 5655-T56 GC19-1301
IBM DB2 Performance Solution Pack for z/OS 5655-E74 GC19-3988
IBM DB2 Performance Toolkit for z/OS the SAP Edition 5697-M32 GC18-9965
IBM DB2 Utilities Solution Pack for z/OS 5697-DUP GC19-4391
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5655-W37 GH12-6971
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS 5655-W38 GH12-6972

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

Limited warranty

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

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

http://www.ibm.com/support/handbook
IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Program support

Enhanced support, called Subscription and Support, includes telephone assistance, as well as access to updates, releases, and versions of the program as long as support is in effect. You will be notified of discontinuance of support with 12 months' notice.

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

No

Software Subscription and Support applies

Not applicable

IBM Operational Support Services - SoftwareXcel

Yes

System i Software Maintenance applies

No

Variable charges apply

No

Educational allowance available

Yes. A 15% education allowance applies to qualified education institution customers.

Sub-capacity terms and conditions

For each z Systems IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Your required license capacity is based upon the following factors:

  • The z Systems IPLA program you select
  • The applicable Value Unit Exhibit
  • The applicable terms
  • Whether your current mainframes are full capacity or sub-capacity

For more information on the Value Unit Exhibit for the z Systems IPLA program you selected, refer to the Ordering information section.

Program number Program name Terms Parent, if applicable
5655-W35 DB2 Buffer Pool Analyzer for z/OS, V5.3 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5655-AA1 DB2 High Performance Unload for z/OS, V4,3 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5655-T56 DB2 Log Analysis Tool for z/OS, V3.5 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5655-E74 DB2 Performance Solution Pack for z/OS, V1.3 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5697-M32 DB2 Performance Toolkit for z/OS the SAP Edition, V2.5 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5697-DUP DB2 Utilities Solution Pack for z/OS, V2.2 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5655-W37 Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
5655-W38 Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 Full machine-based DB2 for z/OS, V11 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      DB2 for z/OS, V10 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10 (5697-P31)
Full-capacity mainframes

In cases where full capacity is applicable, the following terms apply.

Execution based, z/OS based, full machine based: The required capacity of a z Systems IPLA program with these terms equals the MSU-rated capacity of the machines where the z Systems IPLA program executes.

For more information on mainframe MSU-rated capacities, visit

http://www-1.ibm.com/servers/eserver/zseries/library/swpriceinfo/

Reference based: The required license capacity of a z Systems IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the parent program.

Sub-capacity mainframes

In cases where sub-capacity is applicable, the following terms apply.

Execution based: The required capacity of a z Systems IPLA sub-capacity program with these terms equals the capacity of the LPARs where the z Systems IPLA program executes.

z/OS based: The required license capacity of a z Systems IPLA program with these terms equals the license capacity of z/OS on the machines where the z Systems IPLA program executes.

Reference based: The required license capacity of a z Systems IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the parent program.

Full machine based: The required license capacity of a z Systems IPLA program with full machine based terms equals the MSU-rated capacity of the machines where the z Systems IPLA program executes.

For more information on mainframe MSU-rated capacities, refer to The IBM z Systems Machines Exhibit , Z125-3901, or visit the Mainframes section of the z Systems Exhibits website.

http://ibm.com/zseries/library/swpriceinfo/

For additional information for products with full machine-based terms, z Systems IPLA sub-capacity programs with full machine-based terms adds value to the parent program across the environment, regardless of where in the environment the z Systems IPLA program executes.

An environment is defined as either a single or stand-alone machine or a qualified Parallel Sysplex®. You may have one or more different environments across the enterprise. To determine the required license capacity for each z Systems IPLA program with referenced-based terms, each environment should be assessed separately.

When a z Systems IPLA sub-capacity program with full machine-based terms is used in a qualified Parallel Sysplex environment, the required license capacity of the z Systems IPLA program must equal with the license capacity of the parent program across the Parallel Sysplex. Qualified Parallel Sysplex refers to one where MLC pricing is aggregated across the sysplex.

Sub-capacity eligibility

To be eligible for sub-capacity charging on select z Systems IPLA programs, you must first implement and comply with all terms of either sub-capacity Workload License Charges (WLC) or sub-capacity Entry Workload License Charges (EWLC). To implement sub-capacity WLC or EWLC, a machine must be z Systems (or equivalent). On that machine:

  • All instances of the OS/390® operating system must be migrated to the z/OS operating systems.
  • Any licenses for the OS/390 operating system must be discontinued.
  • All instances of the z/OS operating systems must be running in z/Architecture® (64-bit) mode.

For that machine, you must create and submit a Sub-Capacity Report to IBM each month. Sub-Capacity Reports must be generated using the Sub-Capacity Reporting Tool (SCRT). For additional information or to obtain a copy of SCRT, visit the z Systems Software Pricing website

http://ibm.com/zseries/swprice

You must comply with all of the terms of the WLC or EWLC offering, whichever is applicable:

  • The complete terms and conditions of sub-capacity WLC are defined in the IBM Customer Agreement - Attachment for z Systems Workload License Charges (Z125-6516).
  • The complete terms and conditions for sub-capacity EWLC are defined in the IBM Customer Agreement - Attachment for EWLC, TWLC, zELC, and z/OS.e License Charges (Z125-6587).

Additionally, you must sign and comply with the terms and conditions specified in the amendment to the IPLA contract - Amendment for Amendment for IBM z Systems Programs Sub-Capacity Pricing (Z125-6929). Once the amendment is signed, the terms in the amendment replace any and all previous z Systems IPLA sub-capacity terms and conditions.

Sub-capacity utilization determination

Sub-capacity utilization is determined based on the utilization of a sub-capacity eligible reference product and machine.

On/Off CoD

To be eligible for On/Off CoD pricing, you must be enabled for temporary capacity on the corresponding hardware, and the required contract, Attachment for IBM z Systems On/Off Capacity on Demand (Z125-7883) must be signed prior to use.



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

Information on charges is available at

http://www.ibm.com/support

Choose the option entitled Purchase/upgrade tools.

Program name: IBM DB2 Buffer Pool Analyzer for z/OS, V5.3

Program PID: 5655-W35

Entitlement identifier Description License option/Pricing metric
S016GL6 DB2 Buffer Pool Analyzer for z/OS, V5 Basic OTC, Value Units
    Basic OTC per MSU-day TUC
Orderable supply ID Language Distribution medium
S016K5H English 3590 Tape cartridge

Program name: IBM DB2 High Performance Unload for z/OS, V4.3

Program PID: 5655-AA1

Entitlement identifier Description License option/Pricing metric
S016GLC DB2 High Performance Unload for z/OS, V4 Basic OTC, Value Units
    Basic OTC per MSU-day TUC
Orderable supply ID Language Distribution medium
S016GLB English 3590 Tape cartridge

Program name: IBM DB2 Log Analysis Tool for z/OS, V3.5

Program PID: 5655-T56

Entitlement identifier Description License option/Pricing metric
S014J6K DB2 Log Analysis Tool for z/OS, V3 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0166C9 English 3590 Tape cartridge

Program name: IBM DB2 Performance Solution Pack for z/OS, V1.3

Program PID: 5655-E74

Entitlement identifier Description License option/Pricing metric
S0175XN DB2 Performance Solution Pack for z/OS, V1 Basic OTC, Value Units
  Trade-up from 5655-W37 Basic OTC, per MSU-day TUC
  Trade-up from 5655-W37 and 5655-V42  
  Trade-up from 5655-W37 and 5655-V42 and 5655-W60  
  Trade -up from 5655-W37 and 5655-W60  
  Trade-up from 5655-V42  
  Trade-up from 5655-V42 and 5655-W60  
  Trade-up from 5655-W60  
  Trade-up from 5655-W94  
Orderable supply ID Language Distribution medium
S0175KG English 3590 Tape cartridge
S0175ZD English 3590 Tape cartridge

Program name: IBM DB2 Performance Toolkit for z/OS the SAP Edition, V2.5

Program PID: 5697 - M32

Entitlement identifier Description License option/Pricing metric
S012M3P DB2 Performance Toolkit for z/OS the SAP Edition, V2 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0168RH English 3590 Tape cartridge
S0168RJ English 3590 Tape cartridge

Program name: IBM DB2 Utilities Solution Pack for z/OS, V2.2

Program PID: 5697-DUP

Entitlement identifier Description License option/Pricing metric
S017KDL DB2 Utilities Solution Pack for z/OS, V2 Basic OTC, Value Units
  Trade up from 5655-E37 Basic OTC, per MSU-day TUC
  Trade up from 5655-AA1  
  Trade up from 5655-E37 and 5655-AA1  
  Trade up from 5655-E37 and 5655-AA1 and 5655-T58  
  Trade up from 5655-E37 and 5655-T58  
  Trade up from 5655-AA1 and 5655-AA9  
  Trade up from 5655-E37 and 5655-AA1 and 5655-AA9  
  Trade up from 5655-E37 and 5655-AA9 and 5655-T58  
Orderable supply ID Language Distribution medium
S017KDK English 3590 Tape cartridge

Program name: IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3

Program PID: 5655-W37

Entitlement identifier Description License option/Pricing metric
S016K5T Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 Basic OTC, Value Units
  Trade up from 5655-CXE Basic OTC, Per MSU-day TUC
  Trade up from 5655-J50  
  Trade up from 5655-Q08  
  Trade up from 5655-Q08 and 5655-R98  
  Trade up from 5655-W38  
  Trade up from 5655-W38 and 5655-W35  
Orderable supply ID Language Distribution medium
S016K5K English 3590 Tape cartridge

Program name: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3

Program PID: 5655-W38

Entitlement identifier Description License option/Pricing metric
S016K5X Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5 Basic OTC, Value Units
  Trade up from 5655-CXE Basic OTC, per MSU-day TUC
  Trade up from 5655-J50  
Orderable supply ID Language Distribution medium
S016K5P English 3590 Tape cartridge

Subscription and Support PID: 5655-E55

Entitlement identifier Description License option/Pricing metric
S00VZFD DB2 Buffer Pool Analyzer for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00VZFF English Hardcopy publication

Subscription and Support PID: 5655-E89

Entitlement identifier Description License option/Pricing metric
S00V747 DB2 High Performance Unload for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TH8K English Hardcopy publication

Subscription and Support PID: 5655-E86

Entitlement identifier Description License option/Pricing metric
S00V748 DB2 Log Analysis Tool for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TH8N English Hardcopy publication

Subscription and Support PID: 5655-E75

Entitlement identifier Description License option/Pricing metric
S0175XP DB2 Performance Solution Pack for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0175XS English Hardcopy Publication

Subscription and Support PID: 5697-N32

Entitlement identifier Description License option/Pricing metric
S011VW6 DB2 Performance Toolkit for z/OS the SAP Edition S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S011VW7 English Hardcopy publication

Subscription and Support PID: 5697-DUS

Entitlement identifier Description License option/Pricing metric
S0171WS DB2 Utilities Solution Pack for z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0171WV English Hardcopy publication

Subscription and Support PID: 5655-R07

Entitlement identifier Description License option/Pricing metric
S0122MR Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0122MS English Hardcopy publication

Subscription and Support PID: 5655-R08

Entitlement identifier Description License option/Pricing metric
S0122MV Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS S&S Basic ASC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0122MW English Hardcopy publication

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit

http://www.ibm.com/financing

IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.

Financing from IBM Global Financing helps you preserve cash and credit lines, enables more technology acquisition within current budget limits, permits accelerated implementation of economically attractive new technologies, offers payment and term flexibility, and can help match project costs to projected benefits. Financing is available worldwide for credit-qualified customers.

For more financing information, visit

http://www.ibm.com/financing



Back to topBack to top

Top rule
Order now
Bottom rule

To order, contact your Americas Call Centers, local IBM representative, or your IBM Business Partner. To identify your local IBM representative or IBM Business Partner call 800-IBM-4YOU (426-4968). For more information, contact the Americas Call Centers.

Phone: 800-IBM-CALL (426-2255)

Fax: 800-2IBM-FAX (242-6329)

For IBM representative: callserv@ca.ibm.com

For IBM Business Partner: pwcs@us.ibm.com

Mail:
IBM Teleweb Customer Support
ibm.com® Sales Execution Center, Americas North
3500 Steeles Ave. East, Tower 3/4
Markham, Ontario
Canada L3R 2Z1
Reference:

LE001

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, IMS and QMF are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, DB2, Tivoli, OMEGAMON, z/OS, InfoSphere, CICS, PartnerWorld, Passport Advantage, System i, AIX, Power, System z, S/390, Parallel Sysplex, OS/390, z/Architecture 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.

Windows and Microsoft are trademarks of Microsoft Corporation in the United States, other countries, or both.

Oracle and Java are trademarks of Oracle and/or its affiliates in the United States, other countries, or both.

Adobe is a trademark of Adobe Systems Incorporated in the United States, and/or 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:

Terms of use

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/

Share this page

Digg Linked In

Contact IBM

Feedback