IBM DB2 Tools updated to unlock the power of IBM DB2 12 and to enhance your IBM DB2 for z/OS environments

IBM Europe Software Announcement ZP16-0415
October 4, 2016


Table of contents
OverviewOverviewTechnical informationTechnical information
Key prerequisitesKey prerequisitesOrdering informationOrdering information
Planned availability datePlanned availability dateTerms and conditionsTerms and conditions
DescriptionDescriptionPricesPrices
Program numberProgram numberAnnouncement countriesAnnouncement countries
PublicationsPublications 

 


(Corrected on December 5, 2016)

Revised the Overview, Description, and Publications sections.


(Corrected on October 12, 2016)

Removed Orderable supply ID in Basic License section.



Top rule
At a glance
Bottom rule

IBM® DB2® Tools deliver enhancements in the following areas:

  • Utilities management
    • IBM DB2 Utilities Suite for z/OS®, V12.1 (5770-AF4)
    • IBM DB2 Automation Tool for z/OS, V4.3, (5655-E37)
    • IBM DB2 Extended Utilities Suite for z/OS, V2.1 (5655-EU2)
    • IBM DB2 Backup and Recovery Solution Pack for z/OS, V1.1 (5655-BR1)
    • IBM DB2 Utilities Solution Pack for z/OS, V4.1 (5697-US4)
  • Database administration
    • IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2)
    • IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2)
    • IBM DB2 Change Management Solution Pack for z/OS, V1.1 (5655-CH1)
    • IBM DB2 Administration Solution Pack for z/OS, V3.1 (5655-ASP)
  • Performance management
    • IBM Tivoli® OMEGAMON® XE for DB2 Performance Expert on z/OS, V5.4 (5655-W37)
    • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 (5655-W38)
    • IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42)
    • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)
    • IBM DB2 SQL Performance Solution Pack for z/OS, V1.1 (5655-SQ1)
    • IBM DB2 Performance Solution Pack for z/OS, V1.5 (5655-E74)
  • Miscellaneous
    • IBM DB2 Management Solution Pack for z/OS, V2.1 (5655-MS2)
    • IBM Tools Customizer for z/OS, V1.1 (5655-TC1)
    • IBM DB2 Accessories Suite for z/OS, V4.1 (5697-Q05)


Back to topBack to top

Top rule
Overview
Bottom rule

IBM DB2 Utilities Suite for z/OS, V12.1 (5770-AF4) includes the following benefits:

  • Supports all major new functions and structural changes in the IBM DB2 12 for z/OS (DB2 12) product
  • Delivers improved application and data availability
  • Offers better performance and reduced resource consumption, including additional zIIP 1 exploitation
  • Delivers simplified data management and improved usability
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 clients 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).

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 clients are authorized to use SEs only to process certain types or amounts of workloads as specified by IBM in the AUT.

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 (5655-W37) delivers support for DB2 12. In addition, it rolls up features delivered in the service stream in support of DB2, the IBM DB2 Analytics Accelerator, and various other enhancements requested by clients.

Key new features of Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 include:

  • Support for DB2 12, including key DB2 features like LOB compression, dynamic plan stability, and lifted partition limits
  • Updates to DB2 Analytics Accelerator monitoring capabilities
  • Enhancements to the buffer pool analysis feature
  • Removal of the CUA interface to reduce complexity and cost of ownership in the monitoring environment

Trade-up options for Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 are available. The following list includes the 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 Expert for z/OS, V2.1 (5655-J49)
  • 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)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5 (5655-W38) and DB2 Buffer Pool Analyzer for z/OS, V5 (5655-W35)

IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 (5655-W38) delivers support for DB2 12. In addition, Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 rolls up features delivered in the service stream in DB2, the DB2 Analytics Accelerator, and various other enhancements requested by clients.

Key new features of Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 include:

  • Support for DB2 12, including key DB2 features like LOB compression, dynamic plan stability, and lifted partition limits
  • Updates to DB2 Analytics Accelerator monitoring capabilities
  • Removal of the CUA interface to reduce complexity and cost of ownership in the monitoring environment

Trade-up options for Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 are available. The following list includes the 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 on z/OS, V4 (5655-CXE) and IBM DB2 Performance Monitor for z/OS, V8 (5655-J50)

IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) offers current and historical views of query activity throughout DB2 subsystems. It gives you the ability to efficiently customize and tune your SQL workload and DB2 objects to validate the effectiveness of your DB2 subsystems and improve overall performance. It also offers you extensive choices so you can determine what monitoring information you will gather and when.

DB2 Query Monitor for z/OS enables you to identify problem SQL activity and applications, pinpointing your focus to areas requiring improvement. DB2 Query Monitor enables you to do the following:

  • Proactively manage DB2 resources.
  • React quickly and effectively to supply and demand related DB2 problems, such as those resulting from inefficient SQL or inadequate object structures.
  • Identify SQL requests that prevent critical workloads from completing on schedule.

Key new features of DB2 Query Monitor for z/OS, V3.3 include:

  • Ability to run seamlessly in a DB2 12 environment
  • Improved operational experience
  • Reduced CPU consumption by enabling detailed object collection by workload
  • Enhanced presentation of Query Monitor information in OMEGAMON and Data Server Manager interfaces
  • Usability improvements
  • Improved offload of Query Monitor data for better performance analysis
  • Enhanced reporting

IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4) offers tools and advisors that provide expert recommendations to database administrators (DBAs) to help improve performance for a single query or group of queries (workload). It also helps enable greater collaboration between developers and DBAs by enabling them to gain insights into SQL performance. DB2 Query Workload Tuner for z/OS, V5.2 is based on the Data Server Manager web-based tooling platform that provides a simple integrated environment to streamline ongoing administration of complex database environments.

Key new features of DB2 Query Workload Tuner for z/OS, V5.2 include:

  • Support for DB2 12
  • Enhanced integration of DB2 Query Workload Tuner for z/OS and DB2 Query Monitor for z/OS to enable more detailed information about SQL statements to be provided to the DB2 Optimizer, resulting in better and more efficient access paths to the data

IBM DB2 SQL Performance Solution Pack for z/OS, V1.1 (5655-SQ1) delivers complete performance lifecycle management for SQL that is being executed in the DB2 for z/OS environment. Detailed information captured by the SQL monitor can be used to populate and invoke tuning capabilities to help resolve SQL performance issues that have been identified. This solution combines the function from the following IBM products:

  • IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42)
  • IBM DB2 SQL Performance Analyzer for z/OS, V5.1 (5655-W51)
  • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)

Upgrade credit will be provided to reduce the price of DB2 SQL Performance Solution Pack for z/OS, V1.1 when entitlement is held for products that are included in the bundle. Additional savings can be achieved by canceling existing IBM Software Subscription and Support (S&S) for products that are included in the bundle. Contact your IBM representative for more details.

IBM DB2 Performance Solution Pack for z/OS, V1.5 (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.4 (5655-W37)
  • IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42)
  • IBM DB2 SQL Performance Analyzer for z/OS, V5.1 (5655-W51)
  • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)

Upgrade credit will be provided to reduce the price of DB2 Performance Solution Pack for z/OS, V1.5 when entitlement is held for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

Trade-up options for DB2 Performance Solution Pack for z/OS, V1.5 (5655-E74) are available. The following list includes the 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 Performance Expert on z/OS, V5 (5655-W37)
  • IBM DB2 Query Monitor for z/OS, V3 (5655-V42)
  • IBM DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60)
  • IBM InfoSphere® Optim™ Query Workload Tuner for z/OS, V3 (5655-W94)
  • IBM DB2 Query Monitor for z/OS, V3 (5655-V42) and IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)
  • IBM DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60) and IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)
  • IBM DB2 Query Monitor for z/OS, V3 (5655-V42) and IBM DB2 SQL Performance Analyzer for z/OS, V4 (5655-W60) and IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5 (5655-W37)

IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2) include the following enhancements:

  • Change management
    • The ability to overwrite the RESTRICT ON DROP attribute for tables
    • The ability to verify that the attributes for objects that are being changed are valid on their system and to report any incorrect attribute values, as well as to stop the process if errors are found
    • The ability to analyze and run a multitarget change using the batch interface for invoking change management functions (CM Batch)
    • The ability to produce a report containing affected object counts when analyzing a multitarget change
    • The ability to allow changes to table spaces and indexes to generate new ADMIN ALTER statements that reflect the intended change and are stored in the change management database
    • The ability to produce a report containing statement totals when running a multitarget change
    • The ability to format change statements when registering a change using ALT
  • IBM DB2 Analytics Accelerator (the Accelerator)
    • The ability to have granular control over accelerator objects (add, delete, or load operations) during alter, compare, and change management scenarios
    • The ability to restore distribution and organization keys associated with accelerated tables when corresponding DB2 tables are dropped and re-created
    • The ability to work with accelerator-only tables (AOTs) in Catalog Navigation, including DDL and GEN, and to use the panels to create an AOT.
  • DB2 12 supports:
    • New columns or new values for existing columns in DB2 12 catalog tables
    • The new type of partitioned-by range (UTS)
    • Temporal enhancements
    • Advanced triggers
    • Array global variables
    • New built-in functions
    • Enhancements to the MERGE statement
    • Unqualified references to transition variables
  • DB2 Tools integration
    • The ability to edit IBM DB2 High Performance Unload for z/OS (HPU) parameters using panels
    • Support through Data Server Manager for GEN (re-engineering DDL) and CM Batch functions
  • Usability
    • A new RUNSTATS option that enables users to minimize RUNSTATS and only run RUNSTATS if a table is created or an index is changed.
    • The ability for users to generate a CM batch job with various options specified when using the RN / RNO and AN / ANO line commands against a multitarget change.
    • The ability to save the options on the system catalog panel (ADB21) so that users do not have to enter a value for the option every time the panel is entered. This increases productivity, especially in cases where users are repetitively querying the same type of object.
    • The ability to ignore fields for a subset of objects during a Compare.

IBM DB2 Change Management Solution Pack for z/OS, V1.1 (5655-CH1) delivers integrated object management capabilities for DB2 for z/OS by combining the function from the following programs:

  • IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2)
  • IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2)
  • IBM DB2 Table Editor for z/OS, V4.5 (5697-G65)

New RESTful APIs have been instrumented in DB2 Administration Tool and DB2 Object Comparison Tool to facilitate the implementation of an automated process for rapid deployment of applications and database schema changes using DB2 for z/OS.

Upgrade credit will be provided to reduce the price of the DB2 Change Management Solution Pack, V1.1 when entitlement is held for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

IBM DB2 Administration Solution Pack for z/OS, V3.1 (5655-ASP) delivers integrated object management, configuration management, and fast data cloning capabilities for DB2 for z/OS by combining the function from the following programs:

  • IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2)
  • IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2)
  • IBM DB2 Table Editor for z/OS, V4.5 (5697-G65)
  • IBM DB2 Cloning Tool for z/OS, V3.2 (5655-N15)
  • IBM DB2 Configuration Manager for z/OS, V4.1.2 feature

New RESTful APIs have been instrumented in DB2 Administration Tool and DB2 Object Comparison Tool to facilitate the implementation of an automated process for rapid deployment of applications and database schema changes using DB2 for z/OS.

Upgrade credit will be provided to reduce the price of DB2 Administration Solution Pack, V3.1 when entitlement is held for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

IBM DB2 Automation Tool for z/OS, V4.3 (5655-E37) automates the execution of DB2 utilities while reducing the effort and resources needed to perform routine and exception-based DB2 tasks.

Key new features of DB2 Automation Tool for z/OS, V4.3 include:

  • Usability improvements such as enhanced functionality to prevent DB2 outages due to out-of-space conditions and to automate corrective action
  • Ability to manage Automation Tool profiles within the IBM Data Server Manager (DSM) web-based graphical console
  • Ability to automate the process of loading or refreshing data to the DB2 Analytics Accelerator

Enhancements to the recovery process have been added in support of new DB2 12 options:

  • If you want to recover only the objects that have changed after a specific TORBA or TOLOGPOINT value, you can specify the SCOPE UPDATED option for RECOVER.
  • To specify or override the behavior for FlashCopy® requests when recovering from system-level backups or FlashCopy image copies, you can specify the FLASHCOPY_PPRCP option.
  • You can choose to use an alternate copy pool to be used for a system-level backup, and select an alternate copy pool from a list.

Enhancements to statistics processing have been added in support of new DB2 12 options:

  • DB2 Automation Tool supports the new INVALIDATECACHE option for the REORG TABLESPACE, REORG INDEX, REBUILD INDEX, and RUNSTATS utilities. This option controls whether statements in the dynamic statement cache are invalidated as a result of inline statistics collection.
  • Optional keywords for FREQVAL processing on indexes during inline statistics have been added. The utility can now collect the most or least frequently occurring values, or both, for the specified set of key columns. DB2 Automation Tool supports the new options for the REORG INDEX, REBUILD INDEX, and REORG TABLESPACE utilities.

The syntax diagrams in the DB2 command processor have been updated to add new DB2 12 commands and parameters for DB2 12 subsystems. DB2 Automation Tool detects when current real-time statistics are not being used by exception processing on a DB2 12 subsystem, enabling you to review the job output and determine if the job should be rerun using more current statistics. A new exception for ALTER INDEX COMPRESS enables you to determine if an index has been altered for compression and whether the index needs to be reorganized. If an index has been altered, but not yet REORGed, the REORG could be performed to complete the alter of the index.

IBM DB2 Extended Utilities Suite for z/OS, V2.1 (5655-EU2) is built on the foundation of IBM DB2 Utilities Suite that many companies bet their business on every day. The components include features and functions designed to optimize utilities performance and resource utilization of utility management activities as well as extend utilities syntax to support a broader range of capabilities and authorization to run DB2 Utilities Suite in all supported DB2 for z/OS environments.

Enhancements to DB2 Extended Utilities Suite for z/OS, V1.1 include:

  • Improvements to sort processing for variable-length records to improve performance characteristics (both elapsed time and CPU consumption) during utilities processing
  • Authorization to run DB2 Utilities Suite in all currently supported DB2 environments

In addition to providing authorization to run all currently supported versions of DB2 Utilities Suite for z/OS, DB2 Extended Utilities Suite for z/OS, V2.1 combines capabilities from the following products:

  • IBM DB2 Utilities Enhancement Tool for z/OS, V2.2 (5655-T58)
  • IBM DB2 High Performance Unload for z/OS, V4.3 (5655-AA1)
  • IBM DB2 Sort for z/OS, V2.1 (5655-AA9)

This new version offers use of DB2 Utilities in support of DB2 12 for z/OS.

Upgrade credit is offered to reduce the price of DB2 Extended Utilities Suite for z/OS, V2.1 when entitlement is held for DB2 Utilities Suite for z/OS and for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

IBM DB2 Backup and Recovery Solution Pack for z/OS, V1.1 (5655-BR1) combines advanced DB2 Tools that provide functions required to effectively establish data backup strategies as well as streamline the process of analyzing potential data recovery strategies and implementing recovery operations. It combines capabilities from the following products:

  • IBM DB2 Automation Tool for z/OS, V4.3 (5655-E37)
  • Autonomics Director for DB2 for z/OS feature (FMID HAKP160)
  • IBM DB2 Recovery Expert for z/OS, V3.3 (5655-W78)

Upgrade credit will be provided to reduce the price of DB2 Backup and Recovery Solution Pack for z/OS, V1.1 when entitlement is held for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

IBM DB2 Utilities Solution Pack for z/OS, V4.1 (5697-US4) combines advanced DB2 Tools that help you to more efficiently execute and manage DB2 utilities as well as optimize performance and resource utilization.

Enhancements to DB2 Utilities Solution Pack for z/OS, V4.1 include:

  • Additional features and functions to reduce downtime costs by providing effective backup and recovery automation
  • Improvements to sort processing for variable-length records to improve performance characteristics (both elapsed time and CPU consumption) during utilities processing
  • Authorization to run DB2 Utilities Suite in all currently supported DB2 environments

In addition to providing authorization to run all currently supported versions of DB2 Utilities Suite for z/OS, DB2 Utilities Solution Pack for z/OS, V4.1 combines capabilities from the following products:

  • IBM DB2 Extended Utilities Suite for z/OS, V2.1 (5655-EU2)
  • IBM DB2 Automation Tool for z/OS, V4.3 (5655-E37)
  • Autonomics Director for DB2 for z/OS feature (FMID HAKP160)
  • IBM DB2 Recovery Expert for z/OS, V3.3 (5655-W78)

Enhancements delivered in this version:

  • New release of DB2 Automation Tool for z/OS,V4.3.0 (see a detailed description in the Description section.)
  • Authorization to run DB2 Utilities in your DB2 12 for z/OS environment

Upgrade credit will be provided to reduce the price of DB2 Utilities Solution Pack for z/OS, V4.1 when entitlement is held for DB2 Utilities Suite for z/OS and for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

IBM DB2 Management Solution Pack for z/OS, V2.1 (5655-MS2) offers the most comprehensive set of DB2 Tools to implement best practices for administering and optimizing the DB2 for z/OS environment. Features and functions help satisfy the utilities, administration, and performance tasks for your most critical DB2 for z/OS environments and applications. In addition to providing authorization to run all currently supported versions of DB2 Utilities Suite for z/OS, DB2 Management Solution Pack combines capabilities from products included in the following solution packs:

  • IBM DB2 Utilities Solution Pack for z/OS, V4.1 (5697-US4)
  • Autonomics Director for DB2 for z/OS feature (FMID HAKP160)
  • IBM DB2 Administration Solution Pack for z/OS, V3.1 (5697-ASP)
  • IBM DB2 Performance Solution Pack for z/OS, V1.5 (5655-E74)

Upgrade credit is offered to reduce the price of DB2 Management Solution Pack for z/OS, V2.1 when entitlement is held for DB2 Utilities Suite for z/OS and for products that are included in the bundle. Additional savings can be achieved by canceling existing S&S for products that are included in the bundle. Contact your IBM representative for more details.

IBM Tools Customizer for z/OS, V1.1 (5655-TC1) can help you with post-installation customization of DB2 Tools for z/OS installed in your environment. With IBM Tools Customizer for z/OS, you can enter or discover common parameters used for customizing multiple tools in a simplified, efficient manner.

Note: IBM Tools Customizer for z/OS was previously delivered as a component of IBM Tools Base for z/OS, V1.5 (5655-V93). New versions or releases of Tools Base for z/OS will not deliver Tools Customizer.

IBM DB2 Accessories Suite for z/OS, V4.1 (5697-Q05) consists of three separately orderable features, each bundling components that are designed to enhance your use of DB2 for z/OS. This new version introduces the DB2 Accessories Suite 12 feature, which provides spatial, text search capabilities, and JSON support for DB2 12.

  • IBM DB2 Accessories Suite 12 (for use with DB2 12)
  • IBM DB2 Accessories Suite 11 (for use with DB2 11)
  • IBM DB2 Adapter for z/OS Connect (for use with DB2 10 and DB2 11)

The DB2 Adapter for z/OS Connect feature is a complete solution that enables clients to make existing DB2 assets such as SQL and Stored Procedures available to the growing mobile and cloud application ecosystem. Although the DB2 Adapter for z/OS Connect feature will operate with DB2 12, it is recommended that clients instead utilize the DB2 DDF native RESTFUL API capabilities delivered in the DB2 12 for z/OS product (5650-DB2 or 5770-AF3).



Back to topBack to top

Top rule
Key prerequisites
Bottom rule

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
  • October 21, 2016
    • DB2 Accessories Suite for z/OS, V4.1
    • DB2 Administration Tool for z/OS, V12.1
    • DB2 Automation Tool for z/OS, V4.3
    • DB2 Object Comparison Tool for z/OS, V12.1
    • DB2 Query Monitor for z/OS, V3.3
    • IBM Tools Customizer for z/OS, V1.1
    • DB2 Utilities Suite for z/OS, V12.1
    • DB2 Accessories Suite for z/OS, V4.1
  • December 9, 2016
    • Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4
    • Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4
    • DB2 Backup and Recovery Solution Pack for z/OS, V1.1
    • DB2 Change Management Solution Pack for z/OS, V1.1
    • DB2 Extended Utilities Suite for z/OS, V2.1
    • DB2 Management Solution Pack for z/OS, V2.1
    • DB2 Performance Solution Pack for z/OS, V1.5
    • DB2 SQL Performance Solution Pack for z/OS, V1.1
    • DB2 Utilities Solution Pack for z/OS, V4.1
    • DB2 Administration Solution Pack for z/OS, V3.1
    • DB2 Query Workload Tuner for z/OS, V5.2


Back to topBack to top

Top rule
Description
Bottom rule

The IBM Autonomics Director for DB2 for z/OS feature (FMID HAKP160), is delivered as a feature of DB2 Utilities Solution Pack for z/OS, V4.1 (5697-US4), DB2 Backup and Recovery Solution Pack for z/OS, V1.1 (5655-BR1), and DB2 DB2 Management Solution Pack for z/OS, V2.1 (5655-MS2).

The Autonomics Director for DB2 for z/OS feature delivers two classes of pluggable functions:

  • Evaluators: Analyze the state of the system and identify symptoms they register in the SYMPTOMS table and make recommendations by registering them in the ACTIONS table.
  • Enactors: Perform a specified action out of the ACTIONS table as instructed by the Autonomics Director for DB2. Enactors are also responsible for providing projections of time and CPU for actions.

The external evaluators and enactors communicate and interact by manipulating the various tables provided and managed by the Autonomics Director for DB2. The set of tables created by Autonomics Director for DB2 include registered evaluators and enactors, discovered symptoms and their corresponding recommended actions, maintenance window definitions, and historical records of autonomic actions, utility runs, and Real Time Statistics (RTS).

Enhancements in this release include:

  • New Autonomic Console option can help you to set the priority of actions, objects, and symptoms
  • New action registry editor can help you to set the default priority for every Autonomic Console action
  • New capability to associate a Notification Profile with an Autonomic Maintenance window

DB2 Utilities Suite for z/OS, V12.1 (5770-AF4) is at the core of managing DB2 for z/OS. The utilities help you to minimize downtime associated with routine DB2 data maintenance while ensuring the highest degree of data integrity. Several key elements can be found in each and every release of the DB2 utilities:

  • Supporting core function in DB2 for z/OS. The utilities are critically important to clients from early testing of new versions of DB2, day one support of DB2 for z/OS, and ongoing DB2 maintenance that requires the utilities to respond quickly and accurately.
  • Reducing system resources. Each release of the DB2 utilities delivers significant savings in CPU usage and other system costs, as well as reductions in elapsed time.
  • Providing global and nonstop availability. This requires more than support for online utility processing. It also requires a need to support performance and administrative tasks that require no application outage.
  • Removing constraints and limitations. As the size and complexity of your databases grow, so does the need to simplify database management and remove scalability constraints to support the growth of your business.
  • Simplifying data management. As new features are added into the engine, the utilities help to remove the complexity and details, while maintaining availability and protecting data integrity.

DB2 Utilities Suite for z/OS, V12.1 contains the following enhancements:

  • REORG utility enhancements
    • Full support for new online schema capability in DB2 12
    • Improved FlashCopy exploitation
    • Better PBG partition-level management and handling of LOB data in PBG tables
    • Increased exploitation of zIIP 1 processors to reduce CPU cost
    • Improved serviceability for drain processing
    • Improved catalog REORG management
  • LOAD and UNLOAD utility enhancements
    • Better performance for LOAD PART REPLACE of empty PBR partitions
    • LOAD SHRLEVEL CHANGE PARALLEL support for PBG table spaces
    • Up to 90% additional offload to zIIP 1 processors
    • Avoids the need for data recovery in the event of LOAD RESUME failure
    • Improved identity column and sequence support
    • Reduced data sharing overhead during UNLOAD utility processing
    • Ability to ignore records during discard processing
  • COPY utility enhancements
    • Improved FlashCopy PPRC management
    • COPY CHANGELIMIT usability improvements
    • Improved DFSMS ACS routine handling for FlashCopy
    • Improved management of FlashCopy image copies through ability to enforce FlashCopy
  • RECOVER utility enhancements
    • Lifted point-in-time recovery restrictions associated with PBG table spaces
    • RECOVER utility performance improved up to 35%
    • Ability to skip unnecessary data recovery
    • Automatic retry of GRECP and LPL recovery
  • RESTORE SYSTEM utility enhancements
    • Multiple copypool support for system-level backups
    • Improved serviceability and usability with DFSMShsm messages included in utility job output
  • RUNSTATS utility enhancements
    • Profile support for inline statistics
    • Ability to control dynamic statement cache invalidation in RUNSTATS
    • Improved statistics profile management with direct input from DB2 Optimizer and DDL processing statistics
    • Reduced data sharing overhead
    • Performance improvements in COLGROUP and LISTDEF processing
  • Overall utility enhancements
    • New DSNUTILV stored procedure supporting statements beyond 32,000
    • Improved utility concurrency
    • Improved utility sort performance

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 (5655-W37) enables users to assess the efficiency of DB2 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.

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 introduces the following functionality in support of DB2 12:

  • LOB compression
  • Dynamic plan stability
  • Lifted partition limits
  • SQL transfer ownership
  • Additional statement-level statistics
  • Buffer pool enhancements

The buffer pool analysis feature has been enhanced to include the ability to feed object analysis results directly into the simulation capability.

Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 also updates its DB2 Analytics Accelerator monitoring capabilities with support for accelerator-only tables (AOT) along with displaying key metrics from accelerated SQL statements used to accurately understand accelerated statement performance.

Additionally, Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 integrates with IBM Data Server Manager (DSM), providing key performance indicators about DB2 for z/OS subsystems known to DSM.

Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 (5655-W38) 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.

Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 introduces the following functionality in support of DB2 12:

  • LOB compression
  • Dynamic plan stability
  • Lifted partition limits
  • SQL transfer ownership
  • Additional statement-level statistics
  • Buffer pool enhancements

Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 also updates its DB2 Analytics Accelerator monitoring capabilities with support for AOTs along with displaying key metrics from accelerated SQL statements used to accurately understand accelerated statement performance.

Additionally, Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 integrates with DSM, providing key performance indicators about DB2 for z/OS subsystems known to DSM.

DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2), when used together, deliver a function-rich object management solution. Both tools are designed with an easy-to-use Interactive System Productivity Facility (ISPF) interface that lets you manage and process DB2 objects and organize DB2 objects for better system throughput.

DB2 Administration Tool for z/OS enables the day-to-day tasks that are associated with managing a DB2 database, simplifying the complex tasks associated with safely managing DB2 objects and schema throughout the application lifecycle with the least possible impact to availability.

DB2 Object Comparison Tool for z/OS helps you to compare and synchronize different DB2 objects while helping maintain system availability and object integrity.

With DB2 Administration Tool for z/OS, you can:

  • Enable users to navigate the DB2 catalog quickly and easily
  • Build and execute dynamic SQL statements without knowing the exact SQL syntax
  • Manage and track changes made to DB2 object definitions, resolving any potential conflicts prior to execution
  • Help build DB2 commands to execute against databases and tables
  • Enable users to create, alter, migrate, drop, and reverse-engineer DB2 objects
  • Build and execute utility jobs, enabling users to take advantage of LISTDEFs and TEMPLATEs for increased productivity

DB2 Object Comparison Tool for z/OS provides users with:

  • A GEN function which, in addition to extracting DDL, can also generate statements for the object authorizations and the catalog statistics
  • A batch compare feature that compares two version files, produces reports describing any of the object differences, and generates the information needed to apply the changes
  • Support for masking and ignore files, which address intentional differences or naming conventions, enabling you to deal with only net changes between objects

With new enhancements to DB2 Administration Tool for z/OS, users can now:

  • Enable changes to table spaces and indexes to generate new ADMIN ALTER statements that reflect the intended change and are stored in the change management database.
  • Format change statements when registering a change using ALT.
  • Work with AOTs in Catalog Navigation, including DDL and GEN, and to use the panels to create an AOT.
  • Have support for new columns or new values for existing columns in DB2 12 catalog tables.
  • Generate a CM batch job with various options specified when using the RN / RNO and AN / ANO line commands against a multitarget change.
  • Save the options on the system catalog (ADB21) so that users do not have to enter a value for the option every time they enter the panel.

With new enhancements to DB2 Object Comparison Tool for z/OS, users can now ignore fields for a subset of objects during a Compare.

Other new enhancements to DB2 Administration Tool for z/OS and DB2 Object Comparison Tool for z/OS provide users with the ability to:

  • Exploit new features in DB2 Version 12.
  • Overwrite the RESTRICT ON DROP attribute for tables.
  • Verify that the attributes for objects that are being changed are valid on their system and to report any incorrect attribute values, as well as to stop the process if errors are found.
  • Analyze and run a multitarget change using the batch interface for invoking the change management function (CM Batch).
  • Produce a report containing affected object counts when analyzing a multitarget change.
  • Produce a report containing statement totals when running a multitarget change.
  • Have granular control over accelerator objects (add, delete, or load operations) during alter, compare, and change management scenarios.
  • Restore distribution and organization keys associated with accelerated tables when corresponding DB2 tables are dropped and re-created.
  • Use a new RUNSTATS option to minimize RUNSTATS and only run RUNSTATS if a table is created or an index is changed.

Additionally, DB2 Administration Tool for z/OS and DB2 Object Comparison Tool for z/OS now provide support through Data Server Manager for GEN (re-engineering DDL) and CM Batch functions, as well as enhanced integration with DB2 High Performance Upload for z/OS (HPU) to enable users to edit HPU parameters using panels.

DB2 Query Monitor for z/OS, V3.3 (5655-V42) offers current and historical views of query activity throughout DB2 subsystems. DB2 Query Monitor gives you the ability to efficiently customize and tune your SQL workload and DB2 objects to validate the effectiveness of your DB2 subsystems and improve overall performance. DB2 Query Monitor also offers you extensive choices so you can determine what monitoring information you will gather, and when.

DB2 Query Monitor for z/OS enables you to identify problem SQL activity and applications, enabling you to focus your efforts on improvement. DB2 Query Monitor for z/OS enables you to do the following:

Provides

  • Compatibility of the Consolidation and Analysis Engine (CAE) server with previous maintenance levels of the DB2 Query Monitor subsystems and ISPF clients to help you rollout maintenance gradually across your data centers, particularly when there are many DB2 Query Monitor subsystems on different LPARs.
  • Removes requirement for CAE to be APF authorized.
  • Security support for DB2 connection by using Resource Recovery Services Attachment Facility (RRSAF) instead of Call Attach Facility. This change enables DB2 authorization checking based on the user that is logged in when accessing remote data sharing members through the CAE.

Performance / Integration  

  • Enable deeper performance analysis through the ability to request a collection of host variable values for selected SQL statements.
    • Ability to view the SQL text and captured host variables in the web interface.
  • Reduce CPU by enabling detailed object collection by workload rather than subsystem wide.
  • Enable DB2 Query Monitor data to be displayed directly in the OMEGAMON interface and data repositories for improved historical analysis.
  • Integration with IBM Data Server Manager to simplify the process of query tuning. IBM Data Server Manager (DSM) integrates various browser client interfaces, such as the DB2 Query Workload Tuner, on a single server and provides a single interface that users can access to work with information about their DB2 subsystems.

Usability  

  • Perform dynamic configuration changes without requiring that you stop and start the started task.
  • New ISPF panels provide line commands in a pop-up window for ease of use and to provide more space to display results.
  • Ability to limit the collection of metrics to dynamic SQL, static SQL, or both. This enables those who are not interested in gathering static SQL metrics to gather statistics only on dynamic SQL.

Improved offload and data management support  

  • Simplified support to store Query Monitor data in DB2 tables to enable you to retain DB2 Query Monitor performance data on a consolidated, centralized DB2 system away from production and potentially keep the data longer for more historical analysis.
  • Ability to load DB2 Query Monitor data directly to the DB2 Analytics Accelerator (requires IBM DB2 Analytics Loader for z/OS, 2.1).
  • Collect data without the requirement to be offloaded to tables, offload only certain intervals for long-term storage, and better manage noncritical interval data.
  • The optional LOAD card enhancement enables you to choose not to place the target table in COPY PENDING through new NOCOPYPEND. Additionally, the INDEX(ALL) clause for the STATISTICS eliminates the need to do a RUNSTATS after you do a load because it keeps the statistics up to date. This new option has been added to enable you to collect index statistics when user-defined indexes have been added to the performance history schema.
  • Performance history database ("Offload") improvements that enable reports, such as the CAE Archive Feature, to reproduce all of the data displayed in ISPF panels.

Enhanced reporting  

  • Several new reporting options have been added, including:
    • Summarized interval statistics, enabling you to quickly and easily assess a particular interval that is out of the ordinary and needs further investigation:
      • Addition of DB2 metrics, including total elapsed time, total CPU time, total GETPAGES, total delay time, and total SQL calls.
      • Ability for users to make exceptions to the RETAIN parameter by releasing specific intervals or to prevent an interval from rolling off using RELEASE or KEEP, or delete empty intervals and corresponding interval performance history files.
      • Newest intervals are now sorted at the top of the display for ease of use.
    • Several new summarizations to enable clients to summarize DB2 Query Monitor data by jobname, connection name, connection type, DB2 schema, stored procedures, DB2 parallelism, collection ID, and so on. This enables users to view and see the data in the organization they most want.
    • Additional reporting enhancements include:
      • Information about the consistency token and package version associated with SQL activity (RFE5561).
      • DB2 Analytics Accelerator eligibility metrics when browsing exceptions to locate exception activity that did not run so it can be made eligible in the future.
      • More granular detail at collection level to enable drill downs from DB2 operational summaries provides view summary counts for a single DB2 Collection ID (RFE56388).
      • Additional summary information has been added to help users find out more about negative SQLCODE activity. The CORRID and CORRNAME grouping commands, line commands, and columns provide users with additional information about their negative SQLCODE activity.
    • Ability to include specific SQLCODEs you want to see instead of excluding numerous unwanted codes.
    • CAE Browser Client enhancements, including:
      • Improved pie charts
      • Better support to remember current user configuration
      • Improved top-n most expensive SQL reporting
      • Improved LOAD progress indicator that now enables access to the history of recent messages instead of just the most recent one.

DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4) offers tools and advisors that provide expert recommendations to DBAs to help improve performance for a single query or group of queries(workload). It also enables greater collaboration between developers and DBAs by helping them to gain insights into SQL performance. DB2 Query Workload Tuner for z/OS, V5.2 is based on the DSM web-based tooling platform that provides a simple integrated environment to streamline ongoing administration of complex database environments.

New in this release is support for DB2 for z/OS, V12 and enhanced integration of DB2 Query Workload Tuner for z/OS and DB2 Query Monitor for z/OS whereby users can collect more detailed information about SQL statements and provide better information to the DB2 Optimizer which, in turn, helps to select better and more efficient access paths to the data. DB2 Query Workload Tuner for z/OS can be purchased on its own or as part of the DB2 Performance Solution Pack for z/OS.

DB2 Automation Tool for z/OS, V4.3 (5655-E37) key enhancements:

New integration with complementary products in portfolio:  

  • Support for managing DB2 Automation Tool utility, object, exception, and job profiles from within DSM. From a simple, web-based graphical console, you can manage maintenance tasks, view the overall health of your database assets, detect and prevent problems by performing corrective actions to avoid downtime. This solution provides DB2 for z/OS utilities automation and management in the DSM interface.
  • View and assess the health of accelerated DB2 tables and automate the process of loading or refreshing data to the DB2 Analytics Accelerator. DB2 Automation Tool will check the status of an accelerated DB2 object, detect when it needs to be loaded, and automatically generate the JCL to load only the changed data.

Usability improvements:  

  • Enhanced functionality to prevent DB2 outages due to out-of-space conditions and to automate corrective action.
  • OPTIONS is a new primary command on the Update Exception Profile Display panel. This command can be used to limit which static fields to display to enlarge the scrolling area of the terminal.
  • New exception condition TABLESPACESTATS.SPACEUSED_PCT .
  • Calculate more accurate space values for the reallocation utility by using real-time statistics (RTS) as an alternative to MVS™ catalog statistics. RTS values are more accurate than MVS catalog statistics when many rows have been deleted from a table space because MVS catalog statistics do not reflect the freed-up space. Therefore, using RTS values can save space during reallocation.
  • Eliminate manual processes when "un-scheduling" a maintenance window. DB2 Automation Tool will automatically un-schedule a maintenance window from the DB2 administration task scheduler whenever a maintenance window is deleted. It also provides the capability to reassign actions to another maintenance window.
  • Conditionally issue a TERM UTILITY (terminate utility) command when a DB2 utility ends abnormally, thus ensuring the resources are freed.
  • Expanded notifications to keep you informed through email or text about DB2 maintenance tasks. The notification feature includes a framework that enables other tools to plug in and create their own notifications.
  • The ability to include the total number or a list of all triggered objects through email or the total number of triggered objects through text. The ability to notify you when a maintenance window begins and ends.

Tools Customizer usability:  

  • Addition of OWNER parameter to all plan binds.

Deprecated features:  

  • The data page display and edit functions and the associated data page verification reporting option in utility profiles have been deprecated. These are not recommended methods for accessing DB2 data. Deprecation was announced in DB2 Automation Tool V4.2.
  • Several real-time statistics have been deprecated from the 'Update Exceptions Profile Display'. The SYSTABLESPACESTATS.UNCOMPRESSED_DATASIZE and SYSTABLESPACESTATS.COMPRESSION_RATIO exceptions have been removed. In the IBM DB2 V10 and V11 SQL Reference, UNCOMPRESSED_DATASIZE is always set to 0. Because COMPRESSION_RATIO is based on UNCOMPRESSED_DATASIZE, this calculated value is always 0. Therefore, both of these exception conditions are always 0, and no longer have meaning.

DB2 Extended Utilities Suite for z/OS, V2.1 (5655-EU2) combines the core IBM utilities that many companies bet their business on with additional features and functions that optimize utilities performance and resource utilization of utility management activities as well as extend utilities syntax to support a broader range of capabilities:

  • High-speed DB2 utility for unloading DB2 tables from either a table space or from an image copy
  • Significant reductions in elapsed time and processor usage and increased zIIP 1 offload during utility sort processing, helping you to eliminate the need for duplicate utilities from various ISVs, reducing overall use of system resources, and improving business resiliency
  • Ability to transparently cancel active threads and block new threads on DB2 objects
  • Utility syntax monitor to establish company-wide procedures and assist with auditing
  • Message monitor, enabling customization of DB2 utility return codes to meet DB2 application needs
  • Authorization to run DB2 Utilities in all supported DB2 for z/OS environments, including the DB2 12 for z/OS environment

New in this release of the Extended Utilities Suite for z/OS is authorization to run DB2 Utilities Suite capabilities in a DB2 for z/OS 12 environment.

DB2 Backup and Recovery Solution Pack for z/OS, V1.1 (5655-BR1) combines advanced DB2 Tools that provide functions required to effectively establish data backup strategies as well as streamline the process of analyzing potential data recovery strategies and implementing recovery operations.

DB2 Utilities Solution Pack for z/OS, V4.1 (5697-US4) combines the autonomic capability for DB2 utilities. It can help relieve time and workload burdens from users who are faced with growing volume and complexity, but who have less time to manage DB2 for z/OS environments. Autonomics addresses 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

Enhancements to DB2 Utilities Solution Pack for z/OS, V4.1 include:

  • A simple, self-managing recovery solution that facilitates database recovery operations with minimal disruption.
  • Intelligent analysis of altered, incorrect, or missing database assets, including table spaces, tables, indexes, and data.
  • Automation of the process of rebuilding these assets to a specified point in time, often without taking the database or the business operations offline.
  • Authorization to run DB2 Utilities Suite in all supported DB2 for z/OS environments, including DB2 12 for z/OS.
  • New features and functions to extend the Utilities Solution Pack modernization infrastructure.
  • Ability to simulate active automation by monitoring the resulting decisions that are made without generating any action, before turning on full automation.
  • Ability to expand the web-based interface to manage object, utility, exception, and job profiles without needing to use the ISPF interface. Management and automation of DB2 utilities can now be done fully through the browser interface.
  • Ability to set the priorities for symptoms to ensure those with higher priorities will be processed before other symptoms.
  • Ability to ensure the most important or critical conditions are resolved first by enabling you to set the priority of actions, objects, and symptoms in relation to each other.

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

These products are included in DB2 Performance Solution Pack for z/OS, V1.5:

  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 (5655-W37)
  • IBM DB2 Query Monitor for z/OS, V3,3 (5655-V42)
  • IBM DB2 SQL Performance Analyzer for z/OS, V5.1 (5697-W51)
  • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)

DB2 SQL Performance Solution Pack for z/OS (5655-SQ1) delivers integrated query performance management for DB2 for z/OS by combining function from the IBM products listed below.

These products are included in DB2 SQL Performance Solution Pack for z/OS, V1.1:

  • IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42)
  • IBM DB2 SQL Performance Analyzer for z/OS, V5.1 (5697-W51)
  • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)

DB2 Query Monitor provides detailed information about the SQL queries being executed in the DB2 for z/OS environment, enabling you to focus your efforts on improvement. A more detailed description of DB2 Query Monitor capabilities can be found under the individual product description in this announcement.

When poorly performing queries are identified by DB2 Query Monitor, this context can be passed on to either of the other two products in this solution to expedite resolution. DB2 Query Workload Tuner for z/OS, V5.2 offers a set of advisors that analyze the information passed by DB2 Query Monitor and provide expert recommendations to DBAs to help improve performance. DB2 Query Workload Tuner is based on the Data Server Manager (DSM) web-based tooling platform. More information about new features delivered in DB2 Query Workload Tuner for z/OS, V5.2 can be found elsewhere in the Description section.

If the user prefers working with a 3270-based user interface, DB2 SQL Performance Analyzer for z/OS, V5.1 helps analyze and tune SQL queries with features including:

  • Producing and interpreting cost reports
  • Extensively analyzing SQL queries without running them
  • Diagnosing SQL query problems to facilitate prompt recovery
  • Iterative WHAT-IF analysis so that modifications can be done until the user is satisfied with the results
  • Reports with CSV delimiters that enables users to generate reports in specific formats or displays to act as input to another step in the data management process

IBM DB2 Change Management Solution Pack for z/OS, V1.1 (5655-CH1) delivers integrated object management capabilities for DB2 for z/OS by combining the function from the following programs:

  • IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2)
  • IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2)
  • IBM DB2 Table Editor for z/OS, V4.5 (5697-G65)

New RESTful APIs have been instrumented in DB2 Administration Tool and DB2 Object Comparison Tool to facilitate the implementation of an automated process for rapid deployment of applications and database schema changes using DB2 for z/OS.

IBM DB2 Administration Solution Pack for z/OS, V3.1 (5697-ASP) offers features, functions, and processes that DBAs can use to more effectively and efficiently manage DB2 environments. Delivered capabilities can help DBAs to more easily complete tasks associated with object management, change management, application management, and configuration management.

DB2 Administration Solution Pack for z/OS is composed of the following tools and components:

  • IBM DB2 Administration Tool for z/OS  enables you to manage the tasks that keep DB2 performing at peak levels. It offers a comprehensive set of functions that helps your DB2 personnel manage their DB2 environments efficiently and effectively, including:
    • Providing in-depth catalog navigation by:
      • Displaying and interpreting objects in the DB2 catalog
      • Executing dynamic SQL statements
    • Integration with other separately available DB2 Tools to simplify the task process flow:
      • DB2 Table Editor
      • DB2 SQL Performance Analyzer
      • DB2 High Performance Unload
      • DB2 Cloning Tool
      • The DSM-based implementation of the configuration management function
    • Adding summary reports that give an overview on complex data changes and data migration
  • IBM DB2 Object Comparison Tool for z/OS helps maximize system availability by keeping production and testing database environments running in parallel. It offers the following benefits:
    • Simplifies the process of comparing objects and their dependents from different sources
    • Synchronizes sources
    • Consistently keeps production databases in step with those for testing and development

      Enhancements in DB2 Administration Tool for z/OS, V12.1 and DB2 Object Comparison Tool for z/OS, V12.1 include:

    • Change management
      • The ability to overwrite the RESTRICT ON DROP attribute for tables.
      • The ability to verify that the attributes for objects that are being changed are valid on their system and to report any incorrect attribute values, as well as to stop the process if errors are found.
      • The ability to analyze and run a multitarget change using the batch interface for invoking change management functions (CM Batch).
      • The ability to produce a report containing affected object counts when analyzing a multitarget change.
      • The ability to enable changes to table spaces and indexes to generate new ADMIN ALTER statements that reflect the intended change and are stored in the change management database.
      • The ability to produce a report containing statement totals when running a multitarget change.
      • The ability to format change statements when registering a change using ALT.
    • IBM DB2 Analytics Accelerator (the Accelerator)
      • The ability to have granular control over accelerator objects (add, delete, or load operations) during alter, compare, and change management scenarios.
      • The ability to restore distribution and organization keys associated with accelerated tables when corresponding DB2 tables are dropped and re-created.
      • The ability to work with AOTs in Catalog Navigation, including DDL and GEN, and to use the panels to create an AOT.
    • DB2 12 support:
      • New columns or new values for existing columns in DB2 12 catalog tables.
      • New type of partitioned-by range (UTS)
      • Temporal enhancements
      • Advanced triggers
      • Array global variables
      • New built-in functions
      • Enhancements to the MERGE statement
      • Unqualified references to transition variables
    • DB2 Tools integration
      • The ability to edit DB2 High Performance Unload for z/OS (HPU) parameters using panels
      • Support through Data Server Manager for GEN (re-engineering DDL) and CM Batch functions
    • Usability
      • A new RUNSTATS option that enables users to minimize RUNSTATS and only run RUNSTATS if a table is created or an index is changed.
      • The ability for users to generate a CM batch job with various options specified when using the RN/RNO and AN/ANO line commands against a multitarget change.
      • The ability to preserve menu options on the system catalog panel ADB21 across multiple interactions.
      • The ability to ignore fields for a subset of objects during a Compare.
  • IBM DB2 Table Editor for z/OS is a multipurpose table-editing environment that offers DBAs, developers, and the entire enterprise direct update and data creation operations on DB2 for z/OS databases from Java™, ISPF, or Microsoft™ Windows™-based user interfaces. See Software Announcement ZP16-0222, dated May 10, 2016 (DB2 Table Editor for z/OS, V4.5).
  • IBM DB2 Cloning Tool for z/OS can make it easy to clone a DB2 subsystem or DB2 table spaces. DB2 Cloning Tool for z/OS can also be used to clone non-DB2 volumes. Traditional cloning and refresh methods are time consuming, use large amounts of host processing resources, and when copying DB2 systems, require a separate LPAR to house the copy. Today's storage-based fast replication technologies provide services to copy DB2 data without using host CPU or I/O resources. DB2 Cloning Tool for z/OS leverages these technologies to make the cloning process faster and to help reduce the costs of cloning and refreshing data.
    • DB2 subsystem cloning: DB2 Cloning Tool for z/OS integrates storage system volume fast-replication and automation to clone entire DB2 subsystems within the same or a shared LPAR. DB2 Cloning Tool for z/OS renames the data sets, updates the volume identifiers, and manages the DB2 metadata to enable the data to be used by a cloned DB2 subsystem quickly.
    • DB2 table space refresh: DB2 Cloning Tool for z/OS integrates storage system data set fast-replication and automation to refresh table and index spaces within the same or to a different DB2 instance. DB2 Cloning Tool for z/OS copies the data quickly and automatically translates the object IDs that differ between source and target subsystems.
    • Fast replication support: The fast replication copy services outlined here can be used to create the volume copies used for DB2 system clones or to create the data set copies used for table space and index space refreshes. A storage blade represents fast replication copy services invoked directly by DB2 Cloning Tool for z/OS. DB2 Cloning Tool for z/OS executes the DFSMSdss blade to issue IBM FlashCopy or STK SnapShot copy commands either by volume or by data set. When cloning DB2 systems or table spaces that reside on EMC DASD, DB2 Cloning Tool uses the EMC API to invoke TimeFinder/Clone to copy the data either by volume or by data set. When cloning DB2 subsystems that reside on EMC DASD and use TimeFinder/Mirror, or that reside on Hitachi Storage Systems, an appropriate replication process is performed before DB2 Cloning Tool cloning automation is invoked and a list of copied storage volumes are passed to DB2 Cloning Tool for use in later processing steps.
  • The DB2 Configuration Manager for z/OS, V4.1, a DSM-based feature, enables you to build an inventory of DB2 for z/OS data servers and clients, and manage their configurations through a centralized host.

    The web-based architecture of Data Server Manager provides a more streamlined interface to help quickly build a DB2 for z/OS data server and client inventory for configuration problem determination and migration planning. You can also continually enforce best practice configuration settings to avoid outages and receive automated alerts regarding deviations to help aid in compliance.

    New in this release is support for DB2 12 as well as licensing improvements and database management improvements like feature validation that enable you to validate access to certain database objects needed by the configuration management function available in this solution.

DB2 Management Solution Pack for z/OS, V2.1 (5655-MS2) provides all the IBM products needed to implement best practices for administering and optimizing the DB2 for z/OS environment. New features and functions address user needs in the areas of database administration, performance management, utilities management, and recovery management:

  • Ability to more efficiently execute and manage DB2 utilities
    • High-speed DB2 utility for unloading DB2 tables from either a table space or from an image copy
    • Significant reductions in elapsed time and processor usage and increased zIIP 1 offload during utility sort processing, helping you to eliminate the need for duplicate utilities from various ISVs, reducing overall use of system resources, and improving business resiliency
    • Ability to transparently cancel active threads and block new threads on DB2 objects
    • Utility syntax monitor to establish company-wide procedures and assist with auditing
    • Message monitor, enabling customization of DB2 utility return codes to meet DB2 application needs
    • Authorization to run DB2 Utilities Suite in all supported DB2 for z/OS environments
    • Autonomic capability for DB2 Utilities
  • Integrated performance management for DB2 for z/OS
    • Comprehensive system and SQL performance monitoring to identify performance issues
    • Web-based interface built on the DSM architecture that provides expert recommendations that can help you improve the performance of query workloads
    • Ability to iteratively explore "What if" scenarios to quickly evaluate potential changes to SQL syntax
    • Integration between monitoring and tuning capabilities to expedite problem identification and resolution
    • Monitoring and tuning capabilities to assist in optimizing the use of DB2 Analytics Accelerator for z/OS
    • Flexibility to use 3270 or web-based interfaces, depending on user preferences and needs
  • Ability to manage the complexity, growth, and change of your DB2 for z/OS objects and schema as well as DB2 for z/OS configuration throughout the application lifecycle with features, including:
    • In-depth catalog navigation
    • Ability to implement complex data changes and migrations across multiple DB2 for z/OS environments
    • Ability to administer the DB2 Analytics Accelerator environment through interactive 3720 interface or in batch
    • Ability to build the inventory of DB2 for z/OS data servers and clients, and manage their configurations through a centralized tool

IBM Tools Customizer for z/OS, V1.1 (5655-TC1) can help you with post-installation customization of DB2 Tools for z/OS installed in your environment. With Tools Customizer for z/OS, you can enter or discover common parameters used for customizing multiple tools in a simplified, efficient manner.

Note: Tools Customizer for z/OS was previously delivered as a component of IBM Tools Base for z/OS, V1.5 (5655-V93). New versions or releases of IBM Tools Base for z/OS will not deliver Tools Customizer.

IBM DB2 Accessories Suite for z/OS, V4.1 (5697-Q05) enhancements include the new IBM DB2 Accessories Suite 12 feature, which provides spatial, text search capabilities and JSON support for DB2 12 for z/OS. The three features available in this new version are:

  • IBM DB2 Accessories Suite 12
  • IBM DB2 Accessories Suite 11
  • IBM DB2 Adapter for z/OS Connect

DB2 Adapter for z/OS Connect is a service provider that connects RESTful web, mobile, and cloud applications to DB2 in the z/OS environment for service discovery and invocation. DB2 Adapter for z/OS Connect provides an integrated solution, including the IBM Liberty Profile for z/OS and the z/OS Connect component. It leverages the IBM Data Studio for tooling support. DB2 Adapter for z/OS Connect provides a fast, dynamic, scalable, and secure solution for you to interact with protected DB2 assets through RESTful services in JSON data format. Although the DB2 Adapter for z/OS Connect feature will operate with DB2 12, it is recommended that clients instead utilize the DB2 DDF native RESTFUL API capabilities delivered in the DB2 12 for z/OS product (5650-DB2 or 5770-AF3).

Data Studio V4.1.2 (APAR3 or later) when used as the front-end tooling can create, deploy, or remove DB2 Adapter for z/OS services. DB2 Adapter for z/OS Connect does the service transformation into an SQL or Stored Procedure call as defined in the Liberty Profile for z/OS Connect service configuration. The DB2 Adapter for z/OS Connect is capable of performing data conversion from JSON payload to the input of SQL or stored procedures and generates JSON payload from SQL and stored procedures results as output.

This solution is effective for companies looking to simplify the deployment of mobile or cloud-based applications that require access to their mission-critical DB2 for z/OS assets. It can supplement existing user-written mobile solutions and mobile solutions offered by IBM.

The latest version of Data Studio is available for download at the IBM Data Studio website.

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

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 clients are authorized to use SEs only to process certain types or amounts of workloads as specified by IBM in the AUT.

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be found on the Product accessibility information website.

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. If you want 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, go to the IBM System z® Software Pricing website.

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
Program number
Bottom rule
Program number VRM Program name
5697-Q05 4.1.0 IBM DB2 Accessories Suite for z/OS
5697-ASP 3.1.0 IBM DB2 Administration Solution Pack for z/OS
5655-DT2 12.1.0 IBM DB2 Administration Tool for z/OS
5655-E37 4.3.0 IBM DB2 Automation Tool for z/OS
5655-BR1 1.1.0 IBM DB2 Backup and Recovery Solution Pack for z/OS
5655-CH1 1.1.0 IBM DB2 Change Management Solution Pack for z/OS
5655-EU2 2.1.0 IBM DB2 Extended Utilities Suite for z/OS
5655-MS2 2.1.0 IBM DB2 Management Solution Pack for z/OS
5655-DC2 12.1.0 IBM DB2 Object Comparison Tool for z/OS
5655-E74 1.5.0 IBM DB2 Performance Solution Pack for z/OS
5655-V42 3.3.0 IBM DB2 Query Monitor for z/OS
5655-AB4 5.2.0 IBM DB2 Query Workload Tuner for z/OS
5655-SQ1 1.1.0 IBM DB2 SQL Performance Solution Pack for z/OS
5655-TC1 1.1.0 IBM Tools Customizer for z/OS
5697-US4 4.1.0 IBM DB2 Utilities Solution Pack for z/OS
5770-AF4 12.1.0 IBM DB2 Utilities Suite for z/OS
5655-W37 5.4.0 Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
5655-W38 5.4.0 Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

Product identification number

Program PID number Subscription and Support PID number
5697-Q05 5655-R30
5697-ASP 5697-DAS
5655-DT2 5655-E90
5655-E37 5655-E38
5655-BR1 5655-BRS
5655-CH1 5655-CHS
5655-EU2 5655-ESS
5655-MS2 5655-MSS
5655-DC2 5655-E40
5655-E74 5655-E75
5655-V42 5655-E87
5655-AB4 5655-S20
5655-SQ1 5655-SQS
5697-US4 5697-DUS
5770-AF4 5648-D68
5655-TC1 5655-TCS
5655-W37 5655-R07
5655-W38 5655-R08


Back to topBack to top

Top rule
Offering Information
Bottom rule

Product information is available on the IBM Offering Information website.



Back to topBack to top

Top rule
Publications
Bottom rule

The following publications are shipped with the products in this announcement:

Title Order number
IBM DB2 Accessories Suite for z/OS, V4.1 (5697-Q05)  
DB2 Accessories Suite 12 feature:  
License Information GC27-8813
Program Directory GI13-4637
Text Search for DB2 for z/OS V1.5 DVD LCD4-8423
DB2 Accessories Suite 11 feature:  
License Information GC27-8814
Program Directory GI13-4638
Text Search for DB2 for z/OS V1.5 DVD LCD4-8423
DB2 Adapter for z/OS Connect feature:  
License Information GC27-8815
Program Directory GI13-4639
IBM DB2 Administration Solution Pack for z/OS, V3.1.0 (5697-ASP)  
License Information GC27-9108
Program Directory GI13-4647
IBM DB2 Administration Tool for z/OS, V12.1.0 (5655-DT2)  
License Information GC27-9101
Program Directory GI13-4642
IBM DB2 Automation Tool for z/OS, V4.3.0 (5655-E37)  
License Information GC19-3411
Program Directory GI10-8911
IBM DB2 Backup and Recovery Solution Pack for z/OS, V1.1.0 (5655-BR1)  
License Information GC27-9109
Program Directory GI13-4648
Program Directory IBM Autonomics Director for DB2 for z/OS feature, FMID HAKP160 GI13-4654
IBM DB2 Change Management Solution Pack for z/OS, V1.1.0 (5655-CH1)  
License Information GC27-9110
Program Directory GI13-4649
IBM DB2 Extended Utilities Suite for z/OS, V2.1.0 (5655-EU2)  
License Information GC27-9103
Program Directory GI13-4644
IBM DB2 Management Solution Pack for z/OS, V2.1.0 (5655-MS2)  
License Information GC27-9111
Program Directory GI13-4650
Program Directory IBM Autonomics Director for DB2 for z/OS feature, FMID HAKP160 GI13-4654
IBM DB2 Object Comparison Tool for z/OS, V12.1.0 (5655-DC2)  
License Information GC27-9102
Program Directory GI13-4643
IBM DB2 Performance Solution Pack for z/OS, V1.5.0 (5655-E74)  
License Information GC19-3988
Program Directory GI10-8940
IBM DB2 Query Monitor for z/OS, V3.3.0 (5655-V42)  
License Information GC19-4142
Program Directory GI10-8976
IBM DB2 Query Workload Tuner for z/OS, V5.2.0 (5655-AB4)  
License Information GC27-6775
Program Directory GI13-4611
DB2 Query Workload Tuner for AIX® DVD LCD4-8591
DB2 Query Workload Tuner for Linux™ DVD LCD4-8592
DB2 Query Workload Tuner for Windows™ DVD LCD4-8593
DB2 Query Workload Tuner Lic. Act. Kit LCD4-8584
IBM DB2 SQL Performance Solution Pack for z/OS, V1.1.0 (5655-SQ1)  
License Information GC27-9112
Program Directory GI13-4651
IBM Tools Customizer for z/OS, V1.1.0 (5655-TC1)  
License Information GC27-9126
Program Directory GI13-4653
IBM DB2 Utilities Solution Pack for z/OS, V4.1.0 (5697-US4)  
License Information GC27-9115
Program Directory GI13-4652
Program Directory IBM Autonomics Director for DB2 for z/OS feature, FMID HAKP160 GI13-4654
IBM DB2 Utilities Suite for z/OS, V12.1.0, (5770-AF4)  
License Information GC27-8812
Program Directory GI13-4632
Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4. 0 (5655-W37)  
License Information GH12-6971
Program Directory GI19-5019
Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4. 0 (5655-W38)  
License Information GH12-6972
Program Directory GI19-5020

The publications for the products in this announcement cannot be ordered in hardcopy. These publications will be available on the product availability dates, on the DB2 Tools Product Documentation page.



Back to topBack to top

Top rule
Services
Bottom rule

Global Technology Services

Contact your IBM representative for the list of selected services available in your country, either as standard or customized offerings for the efficient installation, implementation, or integration of this product.



Back to topBack to top

Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

The products in this announcement will operate on any hardware configuration that supports the required operating environments and the required software.

Software requirements

Mandatory installation requirements

The products in this announcement require:

  • IBM z™/OS, V2.1 (5650-ZOS), or later
  • IBM SMP/E for z/OS, V3.6 (5655-G44), or later

Additional, product-specific mandatory installation requirements are as follows:

IBM DB2 Accessories Suite for z/OS, V4.1 (5697-Q05)

  • IBM DB2 Accessories Suite 12 feature:
    • IBM DB2 for z/OS, V12 (5650-DB2) or IBM DB2 for z/OS Value Unit Edition, V12 (5770-AF3)
    • IBM z/OS V2.1 (5650-ZOS), or later
  • IBM DB2 Accessories Suite 11 feature:
    • IBM DB2 for z/OS, V11 (5615-DB2), or IBM DB2 for z/OS Value Unit Edition, V11 (5697-P43)
    • IBM z/OS V1.13 (5694-A01), or later
  • IBM DB2 Adapter for z/OS Connect feature:
    • IBM z/OS (UNIX™ System Services) V1.13 (5694-A01), or later
    • One of the following:
      • IBM DB2 for z/OS, V11 (5615-DB2)
      • IBM DB2 for z/OS Value Unit Edition, V11 (5697-P43)
      • IBM DB2 for z/OS, V10 (5605-DB2)
      • IBM DB2 for z/OS Value Unit Edition, V10 (5697-P31)

Mandatory operational requisites

  • IBM DB2 Administration Solution Pack for z/OS, V3.1 (5655-ASP)
  • IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2)
  • IBM DB2 Automation Tool for z/OS, V4.3, (5655-E37)
  • IBM DB2 Backup and Recovery Solution Pack for z/OS, V1.1 (5655-BR1)
  • IBM DB2 Change Management Solution Pack for z/OS, V1.1 (5655-CH1)
  • IBM DB2 Extended Utilities Suite for z/OS, V2.1 (5655-EU2)
  • IBM DB2 Management Solution Pack for z/OS, V2.1 (5655-MS2)
  • IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2)
  • IBM DB2 Performance Solution Pack for z/OS, V1.2 (5655-E74)
  • IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42)
  • IBM DB2 Query Workload Tuner for z/OS, V5.2 (5655-AB4)
  • IBM DB2 SQL Performance Solution Pack for z/OS, V1.1 (5655-SQ1)
  • IBM Tools Customizer for z/OS, V1.1 (5655-TC1)
  • IBM DB2 Utilities Solution Pack for z/OS, V4.1 (5697-US4)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 (5655-W37)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor z/OS, V5.4 (5655-W38)

The products above require one of the following:

  • 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)
  • IBM DB2 V12.1 (5650-DB2)
  • IBM DB2 Value Unit Edition, V12.1 (5770-AF3)

Additional mandatory operational requisites are as follows:

5639-OLC DB2 Data Access Common Collector for z/OS, should be identified as a Mandatory Operational Requisite to DB2 Query Monitor for z/OS.

IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) requires IBM DB2 Data Access Common Collector for z/OS (5639-OLC).

IBM DB2 Utilities Suite for z/OS, V12.1 (5770-AF4)

  • DB2 Utilities Suite for z/OS, V12.1 is packaged for installation and operation with DB2 12 for z/OS (5650-DB2 or 5770-AF3).
  • Use of Product Registration Services is mandatory to enable DB2 Utilities Suite for z/OS, V12.1

IBM DB2 Accessories Suite for z/OS, V4.1: 

  • IBM DB2 Accessories Suite for z/OS DB2 12 feature:
    • IBM DB2 for z/OS, V12 (5650-DB2), or IBM DB2 for z/OS Value Unit Edition, V12 (5770-AF3).
    • DB2 LUW 10.5.Fixpack 3 (for JSON), or later. For more details, go to the following IBM Support website and refer to Information APAR II14727.
  • IBM DB2 Accessories Suite for z/OS DB2 11 feature:
    • IBM DB2 for z/OS, V11 (5615-DB2), or IBM DB2 for z/OS Value Unit Edition, V11 (5697-P43), plus DB2 for z/OS, V11 APARs PI05250 and PI10521 (for JSON).
    • DB2 LUW 10.5.Fixpack 3 (for JSON), or later. For more details, go to the following IBM Support website and refer to Information APAR II14727
  • IBM DB2 Adapter for z/OS Connect feature:
    • IBM Data Server Driver for JDBC and SQLJ 4.0 level driver delivered in any of the following products:
      • IBM DB2 for z/OS, V11 (5615-DB2) JDBC FMID JDBBB12
      • IBM DB2 for z/OS Value Unit Edition, V11 (5697-P43) JDBC FMID JDBBB12
      • IBM DB2 for z/OS, V10 (5605-DB2) JDBC FMID JDBAA12
      • IBM DB2 for z/OS Value Unit Edition (5697-P31) JDBC FMID JDBAA12
    • IBM 64-bit SDK for z/OS, Java™ Technology Edition, V7 (5655-W44), or later
    • IBM Data Studio, V4.1.2 (APAR3) or later, available for download at the IBM Data Studio website. For additional details, refer to Information APAR II14775.

IBM DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and IBM DB2 Object Comparison Tool for z/OS, V12.1 (5655-DC2):

For post-installation customization, DB2 Administration Tool for z/OS, V12.1 and DB2 Object Comparison Tool for z/OS, V12.1 require either IBM Tools Customizer for z/OS delivered as a component of IBM Tools Base for z/OS, V1.5 (5655-V93), or IBM Tools Customizer for z/OS, V1.1 (5655-TC1).

DB2 Object Comparison Tool for z/OS, V12.1 requires DB2 Administration Tool for z/OS, V12.1.

DB2 Administration Tool for z/OS, V12.1 requires DB2 Object Comparison Tool for z/OS, V12.1 for use of the Change Management function.

Conditional operational requirements

IBM DB2 Accessories Suite for z/OS, V4.1:

  • DB2 Accessories Suite 12 feature requires any of the following for the IBM Text Search for DB2 for z/OS (for Linux, Windows, and Linux on System z):
    • 64-bit Red Hat Enterprise Linux 5 (with the latest updates)
    • 64-bit SUSE Linux Enterprise 10
    • 64-bit SUSE Linux Enterprise Server 10x for System z
    • 64-bit Red Hat Enterprise Linux 5 for System z (with the latest updates)
    • 64-bit Microsoft™ Windows
    • Use of Text Search with DB2 12 requires DB2 12 APAR PI68310
  • DB2 Accessories Suite DB2 11 feature requires any of the following for the IBM Text Search for DB2 for z/OS (for Linux, Windows, and Linux on System z):
    • 32-bit or 64-bit Red Hat Enterprise Linux 5 (with the latest updates)
    • 32-bit or 64-bit SUSE Linux Enterprise 10
    • 64-bit SUSE Linux Enterprise Server 10x for System z
    • 64-bit Red Hat Enterprise Linux 5 for System z (with the latest updates)
    • 32-bit or 64-bit Microsoft Windows

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 the following requirements from one or more of the worldwide user group communities.

Product name Requirement number Description
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) RFE63902 Provides compatibility of the Consolidation and Analysis Engine (CAE) Server with previous maintenance levels of the DB2 Query Monitor subsystems and IPSF clients to help you rollout maintenance gradually across your data centers.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) MR1123073612 Reduce CPU by allowing detailed object collection by workload rather than subsystem wide.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) RFE54623, MR0425054151, RFE54624, RFE36952, RFE63869, MR0404083446, MR0225092448 Enhancements to the QM offload process and QM DB2 performance history database.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) MR052506580, MR0826073042, MR030210150, MR0302122323, RFE65213 Summarize DB2 Query Monitor data by jobname, connection name, connection type, DB2 schema, stored procedures, DB2 parallelism, collection ID, and so on.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) RFE5561 Information about the consistency token and package version associated with SQL activity.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) RFE56388 More granular detail at collection level to allow drill downs from DB2 operational summaries provides view summary counts for a single DB2 Collection ID.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) RFE81598 Additional summary information has been added to help users find out more about negative SQLCODE activity. The CORRID and CORRNAME grouping commands, line commands, and columns provide users with additional information about their negative SQLCODE activity.
IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42) RFE78979 Ability to include specific SQLCODEs you want to see instead of excluding numerous unwanted codes.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE43011 Provides formatted change statements when registering a change using ALT.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE63225 Provides the ability to overwrite the RESTRICT ON DROP attribute for tables.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE70296 Provides the ability to analyze and run a multitarget change via CM batch.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE70530 Provides the ability to verify that the attributes for objects that are being changed are valid on their system and to report any incorrect attribute values, as well as to stop the process if errors are found.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE72222 RFE83447 Allows the user to specify whether a Totals report is generated when analyzing a multitarget change using CM batch.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE72224 Allows users to have granular control over accelerator objects (add, delete, or load operations) during alter, compare, and change management scenarios.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE79164 Allows for support for IDAA accelerator-only tables in GEN, DDL, DROP, and CatNav functions
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE80522 Allows users to generate a CM batch job with various options specified when using the RN and AN line commands against a multi-target change.
DB2 Administration Tool for z/OS, V12.1 (5655-DT2) and DB2 Object Comparison Tool for z/OS, 12.1 (5655-DC2) RFE80986 Allows users to minimize RUNSTATS and only run RUNSTATS if a table is created or an index is changed.

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

Consult your IBM representative.

The following programs in this announcement have Value Unit-Based pricing:

Program number Program name Value Unit exhibit
5697-ASP DB2 Administration Solution Pack for z/OS VUE007
5655-DT2 DB2 Administration Tool for z/OS VUE007
5655-E37 DB2 Automation Tool for z/OS VUE007
5655-BR1 DB2 Backup and Recovery Solution Pack for z/OS VUE007
5655-CH1 DB2 Change Management Solution Pack for z/OS VUE007
5565-EU2 DB2 Extended Utilities Suite for z/OS VUE007
5655-MS2 DB2 Management Solution Pack for z/OS VUE007
5655-DC2 DB2 Object Comparison Tool for z/OS VUE007
5655-E74 DB2 Performance Solution Pack for z/OS VUE007
5655-V42 DB2 Query Monitor for z/OS VUE007
5655-AB4 DB2 Query Workload Tuner VUE007
5655-SQ1 DB2 SQL Performance Solution Pack for z/OS VUE007
5655-US4 DB2 Utilities Solution Pack for z/OS VUE007
5770-AF4 DB2 Utilities Suite for z/OS VUE001
5655-W37 Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS VUE007
5655-W38 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
The following programs in this announcement have unlimited installs:

Program number Program name Value Unit exhibit
5697-Q05 DB2 Accessories Suite for z/OS Unlimited installs
5655-TC1 Tools Customizer for z/OS Unlimited installs


Value Unit exhibit VUE001

Level Minimum Maximum Value Units/MSU
Base 1 3 5.25
Tier A 4 45 0.83
Tier B 46 175 0.35
Tier C 176 315 0.26
Tier D 316 + 0.20


Value Unit exhibit VUE007

  MSUs minimum MSUs 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.20

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:

Tier MSUs Multiplied by Value Units per MSU Equal 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, see the Shopz website.

The products in this announcement have one charge unit - Value Units.

  MSUs Value Units/MSU
Base 1-3 5.25
Tier A 4-45 .83
Tier B 46-175 .35
Tier C 176-315 .26
Tier D 316+ .20

Note: For the actual translation from MSUs to Value Units for this product, refer to the table that follows.

Ordering example

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

If the customer has installed 1,000 MSUs, the applicable Value Units would be:

  MSUs * Value Units/MSU = Value Units
Base 3 * 5.25 = 15.75
Tier A 42 * .83 = 34.86
Tier B 130 * .35 = 45.50
Tier C 140 * .26 = 36.40
Tier D 685 * .20 = 137
  -----       ---
Total 1,000       270

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

Value Units for non-MSU-based S/390® processors using VUE001:

Model Value Units per machine
H30 21.00
H50 22.00
H70 26.00
ESL models 9

Charge metric

Program name Part number or PID number Charge metric
IBM DB2 Accessories Suite for z/OS 5697-Q05 No charge Install(s)
IBM DB2 Administration Solution Pack for z/OS 5697-ASP Value Unit
IBM DB2 Administration Tool for z/OS 5655-DT2 Value Unit
IBM DB2 Automation Tool for z/OS 5655-E37 Value Unit
IBM DB2 Backup and Recovery Solution Pack for z/OS 5655-BR1 Value Unit
IBM DB2 Change Management Solution Pack for z/OS 5655-CH1 Value Unit
IBM DB2 Extended Utilities Suite for z/OS 5655-EU2 Value Unit
IBM DB2 Management Solution Pack for z/OS 5655-MS2 Value Unit
IBM DB2 Object Comparison Tool for z/OS 5655-DC2 Value Unit
IBM DB2 Performance Solution Pack for z/OS 5655-E74 Value Unit
IBM DB2 Query Monitor for z/OS 5655-V42 Value Unit
IBM DB2 Query Workload Tuner for z/OS 5655-AB4 Value Unit
IBM DB2 SQL Performance Solution Pack for z/OS 5655-SQ1 Value Unit
IBM Tools Customizer for z/OS 5655-TC1 No charge (Installs)
IBM DB2 Utilities Solution Pack for z/OS 5697-US4 Value Unit
IBM DB2 Utilities Suite for z/OS 5770-AF4 Value Unit
Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5655-W37 Value Unit
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, with the following exceptions:

  • 5697-Q05, IBM DB2 Accessories Suite for z/OS
  • 5655-TC1, IBM Tools Customizer for z/OS

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
  MSUs Value Units/MSU
Base 1-3 5.25
Tier A 4-45 .083
Tier B 46-175 0.35
Tier C 176-315 0.26
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 Accessories Suite for z/OS, V4.1

Program PID: 5697-Q05

Entitlement identifier Description License option/Pricing metric
S01801P DB2 Accessories Suite 12, V4 No charge, unlimited installs
Orderable supply ID Language Distribution medium
S01801M US English 3590 Tape cartridge
Entitlement identifier Description License option/Pricing metric
S0181ZW DB2 Accessories Suite 11, V4 No charge, unlimited installs
Orderable supply ID Language Distribution medium
S0181ZV US English 3590 Tape cartridge
Entitlement identifier Description License option/Pricing metric
S01801R DB2 Adapter for z/OS Connect, V4 No charge, unlimited installs
Orderable supply ID Language Distribution medium
S01801N US English 3590 Tape cartridge

Program name: IBM DB2 Administration Solution Pack for z/OS, V3.1

PID: 5697-ASP

Entitlement identifier Description License option/Pricing metric
S01801F DB2 Administration Solution Pack for z/OS, V3.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S01801D US English 3590 Tape cartridge

Program name: IBM DB2 Administration Tool for z/OS, V12.1

PID: 5655-DT2

Entitlement identifier Description License option/Pricing metric
S01805N DB2 Administration Tool for z/OS, V12.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S01805M US English 3590 Tape cartridge

Program name: IBM DB2 Automation Tool for z/OS, V4.3

Program PID: 5655-E37

Entitlement identifier Description License option/Pricing metric
S016WC2 DB2 Automation Tool for z/OS, V4.3 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S016WC1 US English 3590 Tape cartridge

Program name: IBM DB2 Backup and Recovery Solution Pack for z/OS, V1.1

PID: 5655-BR1

Entitlement identifier Description License option/Pricing metric
S0182SJ DB2 Backup and Recovery Solution Pack for z/OS Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0182SH US English 3590 Tape cartridge

Program name: IBM DB2 Change Management Solution Pack for z/OS, V1.1

PID: 5655-CH1

Entitlement identifier Description License option/Pricing metric
S0182SR DB2 Change Management Solution Pack for z/OS Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0182SP US English 3590 Tape cartridge

Program name: IBM DB2 Extended Utilities Suite for z/OS, V2.1

Program PID: 5655-EU2

Entitlement identifier Description License option/Pricing metric
S0182P8 DB2 Extended Utilities Suite for z/OS, V2.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0182P7 US English 3590 Tape cartridge

Program name: IBM DB2 Management Solution Pack for z/OS, V2.1

Program PID: 5655-MS2

Entitlement identifier Description License option/Pricing metric
S0182X7 DB2 Management Solution Pack for z/OS, V2.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0182X5 DB2 Mgmt Sol Pk DBS US English 3590 Tape cartridge
S0182X6 DB2 Mgmt Sol Pk MVS™ US English 3590 Tape cartridge

Program name: IBM DB2 Object Comparison Tool for z/OS, V12.1

PID: 5655-DC2

Entitlement identifier Description License option/Pricing metric
S01805S DB2 Object Comparison Tool for z/OS, V12.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S01805R US English 3590 Tape cartridge

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

PID: 5655-E74

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

Program name: IBM DB2 Query Monitor for z/OS, V3.3

PID: 5655-V42

Entitlement identifier Description License option/Pricing metric
S0166H0 DB2 Query Monitor for z/OS, V3.3 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0166GZ US English 3590 Tape cartridge

Program name: IBM DB2 Query Workload Tuner for z/OS, V5.2

PID: 5655-AB4

Entitlement identifier Description License option/Pricing metric
S017V73 DB2 Query Workload Tuner for z/OS, V5.2 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S017V72 US English 3590 Tape cartridge

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

PID: 5655-SQ1

Entitlement identifier Description License option/Pricing metric
S0182SZ DB2 SQL Performance Solution Pack for z/OS Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S0182SX US English 3590 Tape cartridge

Program name: IBM Tools Customizer for z/OS, V1.1

Program PID: 5655-TC1

Entitlement identifier Description License option/Pricing metric
S0181T3 Tools Customizer for z/OS, V1.1 No charge, unlimited installs
Orderable supply ID Language Distribution medium
S0181T2 US English 3590 Tape cartridge

Program name: IBM DB2 Utilities Solution Pack for z/OS, V4.1

Program PID: 5697-US4

Entitlement identifier Description License option/Pricing metric
S01827T DB2 Utilities Solution Pack for z/OS, V4.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S01827S US English 3590 Tape cartridge

Program name: IBM DB2 Utilities Suite for z/OS, V12.1

Program PID: 5770-AF4

Entitlement identifier Description License option/Pricing metric
S01800F DB2 Utilities Suite for z/OS, V12.1 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S01800D US English 3590 Tape cartridge

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

Program PID: 5655-W37

Entitlement identifier Description License option/Pricing metric
S016K5T Tivoli OMEGAMON XE for DB2 Expert on z/OS, V5.4 Basic OTC, Value Units
  Trade up from 5655-CXE and 5655-J49 Basic OTC, per MSU-day TUC
  Trade up from 5655-CXE and 5655-J50  
  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 US English 3590 Tape cartridge

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

Program PID: 5655-W38

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

Subscription and Support PID: 5655-R30

Entitlement identifier Description License option/Pricing metric
S018200 DB2 Accessories Suite 12 S&S No charge, unlimited installs
    SW S&S registration, no charge
Orderable supply ID Language Distribution medium
S018276 US English Hardcopy publication
Entitlement identifier Description License option/Pricing metric
S017BM7 DB2 Accessories Suite 11, S&S No charge, unlimited installs
    SW S&S registration, no charge
Orderable supply ID Language Distribution medium
S017D12 US English Hardcopy publication
Entitlement identifier Description License option/Pricing metric
S017T3F DB2 Adapter for z/OS Connect S&S No charge, unlimited installs
    SW S&S registration, no charge
Orderable supply ID Language Distribution medium
S017R3D US English Hardcopy publication

Subscription and Support PID: 5697-DAS

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

Subscription and Support PID: 5655-E90

Entitlement identifier Description License option/Pricing metric
S00V746 DB2 Administration Tool for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TH8J US English Hardcopy publication

Subscription and Support PID: 5655-E38

Entitlement identifier Description License option/Pricing metric
S00V1HW DB2 Automation Tool for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00V3B5 US English Hardcopy publication

Subscription and Support PID: 5655-BRS

Entitlement identifier Description License option/Pricing metric
S0182SM DB2 Backup and Recovery Solution Pack for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0182SL US English Hardcopy publication

Subscription and Support PID: 5655-CH1

Entitlement identifier Description License option/Pricing metric
S0182SV DB2 Change Management Solution Pack for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0182ST US English Hardcopy publication

Subscription and Support PID: 5655-ESS

Entitlement identifier Description License option/Pricing metric
S01810X DB2 Extended Utilities Suite for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S01810W US English Hardcopy publication

Subscription and Support PID: 5655-MSS

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

Subscription and Support PID: 5655-E40

Entitlement identifier Description License option/Pricing metric
S00V1JB DB2 Object Comparison Tool for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00V1XZ US 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 MSC, 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 US English Hardcopy publication

Subscription and Support PID: 5655-E87

Entitlement identifier Description License option/Pricing metric
S00V785 DB2 Query Monitor for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TH77 US English Hardcopy publication

Subscription and Support PID: 5655-S20

Entitlement identifier Description License option/Pricing metric
S013K21 DB2 Query Workload Tuner for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S013K22 Optim Query Wrkld Tuner S&S US English Hardcopy publication

Subscription and Support PID: 5655-SQS

Entitlement identifier Description License option/Pricing metric
S0182XD DB2 SQL Performance Solution Pack for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S0182XC US English Hardcopy publication

Subscription and Support PID: 5655-TCS

Entitlement identifier Description License option/Pricing metric
S0181T5 IBM Tools Customizer for z/OS S&S No charge, unlimited installs
    SW S&S registration, no charge
Orderable supply ID Language Distribution medium
S0181TB US 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 MSC, 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 US English Hardcopy publication

Subscription and Support PID: 5648-D68

Entitlement identifier Description License option/Pricing metric
S00TKMF DB2 Utilities Suite for z/OS S&S Basic MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TKMK US 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 MSC, 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 US 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 MSC, per Value Unit SW S&S
    No charge, decline SW S&S
    Per MSU SW S&S registration
Orderable supply ID Language Distribution medium
S00TKMK US 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 canceled 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 (WFM) 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 October 21, 2016:

Name of product being withdrawn Ver Rel Mod Product number
IBM DB2 Automation Tool for z/OS 4 2 0 5655-E37
IBM DB2 Query Monitor for z/OS 3 2 0 5655-V42

IBM DB2 Automation Tool for z/OS, V4.2 (5655-E37) will be replaced by IBM DB2 Automation Tool for z/OS, V4.3 (5655-E37). IBM DB2 Query Monitor for z/OS, V3.2 (5655-V42) will be replaced by IBM DB2 Query Monitor for z/OS, V3.3 (5655-V42).

Releases to be withdrawn from marketing effective December 9, 2016:

Name of product being withdrawn Ver Rel Mod Product number
IBM Query Workload Tuner for z/OS 5 1 0 5655-AB4
IBM DB2 Performance Solution Pack for z/OS 1 4 0 5655-E74
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5 3 0 5655-W37
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS 5 3 0 5655-W38

IBM Query Workload Tuner for z/OS, V5.1 (5655-AB4) will be replaced by IBM Query Workload Tuner for z/OS, V5.2 (5655-AB4), IBM DB2 Performance Solution Pack for z/OS, V1.4 (5655-E74) will be replaced by IBM DB2 Performance Solution Pack for z/OS, V1.5 (5655-E74), IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.3 (5655-W37) will be replaced by IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V5.4 (5655-W37), IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.3 will be replaced by IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4 (5655-W38).

Customized Offerings

Product deliverables are shipped only through CBPDO, ServerPac, SystemPac, FunctionPac, and ProductPac®.

All of these customized offerings are offered for internet delivery in countries where Shopz 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, go to the Help section on the Shopz website.

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, SystemPac, FunctionPac, and ProductPac the month following their availability in CBPDO. z/OS can be ordered through CBPDO, ServerPac, and SystemPac 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, go to the Help section on the Shopz website.

For additional information about the Product ServerPac option, refer to Software Announcement ZP12-0358, 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, SystemPac, FunctionPac, and ProductPac shipments will begin four weeks after general availability due to additional customization and data input verification.



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.

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 - Support Line is an option if you desire added services.

License Information number

Program name Program number License Information
IBM DB2 Accessories Suite for z/OS, V4.1 : 5697-Q05  
DB2 Accessories Suite DB2 12 feature   GC27-8813
DB2 Accessories Suite DB2 11 feature   GC27-8814
DB2 Adapter for z/OS Connect feature   GC27-8815
DB2 Administration Solution Pack for z/OS 5697-ASP GC27-9108
DB2 Administration Tool for z/OS 5655-DT2 GC27-9101
DB2 Automation Tool for z/OS 5655-E37 GC19-3411
DB2 Backup and Recovery Solution Pack 5655-BR1 GC27-9109
DB2 Change Management Solution Pack 5655-CH1 GC27-9110
DB2 Extended Utilities Suite for z/OS 5655-EU2 GC27-9103
DB2 Management Solution Pack for z/OS 5655-MS2 GC27-9111
DB2 Object Comparison Tool for z/OS 5655-DC2 GC27-9102
DB2 Performance Solution Pack for z/OS 5655-E74 GC19-3988
DB2 Query Monitor for z/OS 5655-V42 GC19-4142
DB2 Query Workload Tuner for z/OS 5655-AB4 GC27-6775
DB2 SQL Performance Solution Pack for z/OS 5655-SQ1 GC27-9112
Tools Customizer for z/OS 5655-TC1 GC27-9126
DB2 Utilities Solution Pack for z/OS 5697-US4 GC27-9115
DB2 Utilities Suite for z/OS 5770-AF4 GC27-8812
Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5655-W37 GH12-6971
Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS 5655-W38 GC12-6972

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

Limited warranty applies

Yes

Limited warranty

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

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

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

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

Yes. During the Software Subscription and Support period, for the unmodified portion of a program, and to the extent problems can be recreated in the specified operating environment, IBM will provide the following:

  • Defect correction information, a restriction, or a bypass.
  • Program updates: Periodic releases of collections of code corrections, fixes, functional enhancements and new versions and releases to the program and documentation.
  • Technical assistance: A reasonable amount of remote assistance by telephone or electronically to address suspected program defects. Technical assistance is available from the IBM support center in the organization's geography.

Additional details regarding Technical Assistance, which includes IBM contact information, are provided in the IBM Software 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
  • Failures caused by products for which IBM is not responsible under the IBM Agreement for Acquisition of Software Maintenance.

Software Subscription and Support is provided only if the program is within its support time frame as specified in the Software Support Lifecycle policy for the program.

For operating system software, the revised IBM Operational Support Services - Support Line offering will provide support for those operating systems and associated products that are not available with the Software Subscription and Support (Software Maintenance) offering.

This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised offering, go to the Supported product list website.

System i Software Maintenance applies

No

Variable charges apply

No

Educational allowance available

Yes. When ordering through the program number process, a 15% education allowance applies to qualified education institution customers.

Education Software Allowance Program applies when ordering through the program number process.

ESAP available

Yes, to qualified 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
5697-Q05 DB2 Accessories Suite for z/OS Full machine-based N/A
5697-ASP DB2 Administration Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43 )
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-DT2 DB2 Administration Tool for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-E37 DB2 Automation Tool for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-BR1 DB2 Backup and Recovery Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-CH1 DB2 Change Management Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-EU2 DB2 Extended Utilities Suite for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-MS2 DB2 Management Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-DC2 DB2 Object Comparison Tool for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-E74 DB2 Performance Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-V42 DB2 Query Monitor for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-AB4 DB2 Query Workload Tuner for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-SQ1 DB2 SQL Performance Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5697-US4 DB2 Utilities Solution Pack for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5770-AF4 DB2 Utilities Suite for z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
5655-TC1 Tools Customizer for z/OS Full machine-based N/A
5655-W37 Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
5655-W38 Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS Reference-based DB2 for z/OS, V12.1 (5650-DB2)
      DB2 for z/OS Value Unit Edition, V12.1 (5770-AF3)
      DB2 for z/OS, V11.1 (5615-DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
      DB2 for z/OS, V10.1 (5605-DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (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, go to the IBM z Systems Software Contracts website.

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.

For additional information for products with reference-based terms, z Systems IPLA sub-capacity programs with reference-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 reference-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, see the z Systems Software Pricing website.

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 lawful, comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective.

Important: IBM does not warrant that any systems, products, or services are immune from, or will make your enterprise immune from, the malicious or illegal conduct of any party.



Back to topBack to top

Top rule
Prices
Bottom rule

For all local charges, contact your IBM representative.

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 go to the IBM Global Financing website for more information.

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.



Back to topBack to top

Top rule
Announcement countries
Bottom rule

All European, Middle Eastern, and African countries except Islamic Republic of Iran, Sudan, and Syrian Arab Republic.

Trademarks

Optim, IBM z Systems, z Systems, MVS and IBM z are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, DB2, z/OS, Tivoli, OMEGAMON, InfoSphere, FlashCopy, Global Technology Services, Passport Advantage, System i, System z, AIX, S/390, ProductPac, Parallel Sysplex, OS/390 and z/Architecture are registered trademarks of IBM 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.

Microsoft and Windows are trademarks of Microsoft 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.

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. Reference to other products in this announcement does not necessarily imply those products are announced, or intend to be announced, in your country. 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

IBM Directory of worldwide contacts

Share this page

Digg Linked In

Contact IBM

Considering a purchase?