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

IBM United States Software Announcement 216-326
October 4, 2016

Table of contents

	Overview		Technical information
	Key prerequisites		Ordering information
	Planned availability date		Terms and conditions
	Description		Prices
	Program number		Order now
	Publications

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

At a glance

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)

Overview

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 ¹ exploitation
Delivers simplified data management and improved usability

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

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

Key prerequisites

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.

Planned availability date

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

Description

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

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 216-164, 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 ¹ 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.

¹

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.

Section 508 of the US Rehabilitation Act

The products in this announcement are capable as of their date of general availability, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. A US Section 508 Voluntary Product Accessibility Template (VPAT) can be 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.

Program number

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

Offering Information

Product information is available on the IBM Offering Information website.

Business Partner information

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

BP Attachment for Announcement Letter 216-326

Publications

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.

Services

Software Services

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

To learn more about IBM Software Services contact your Lab Services Sales or Delivery Leader.

Technical information

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.

Ordering information

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
S017R3F	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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S0182SL	US English	Hardcopy publication

Subscription and Support PID: 5655-CHS

Entitlement identifier	Description	License option/Pricing metric
S0182SV	DB2 Change Management Solution Pack for z/OS S&S	Basic ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S0175XS	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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S103K22	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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S0182XC	US English	Hardcopy publication

Subscription and Support PID: 5655-TCS

Entitlement identifier	Description	License option/Pricing metric
S0181T5	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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S0171WV	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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S0122MS	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 ASC, per Value Unit SW S&S
		No charge, decline SW S&S
		Per MSU SW S&S registration

Orderable supply ID	Language	Distribution medium
S0122MW	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	Product number
IBM Query Workload Tuner for z/OS	5	1	5655-AB4
IBM DB2 Performance Solution Pack for z/OS	1	4	5655-E74
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS	5	3	5655-W37
IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS	5	3	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 and ServerPac. 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 the month following their availability in CBPDO. z/OS can be ordered through CBPDO and ServerPac at general availability. Many products will also be orderable in a Product ServerPac without also having to order the z/OS operating system or subsystem.

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

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

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

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

Terms and conditions

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

Licensing

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

Agreement for Acquisition of Software Maintenance

The following agreement applies for Software Subscription and Support (Software Maintenance) and does not require customer signatures:

IBM Agreement for Acquisition of Software Maintenance (Z125-6011)

These programs are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, which provide for support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an annual renewable charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours), as well as access to updates, releases, and versions of the program as long as support is in effect. IBM z Systems Operational Support Services - SoftwareXcel is an option if you desire added services.

License Information number

Program name	Program number	License Information
IBM DB2 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)

Passport Advantage applies

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

Variable charges apply

Educational allowance available

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

Sub-capacity terms and conditions

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.

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.

Statement of good security practices

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.

Prices

For additional information and current prices, contact your local IBM representative.

Information on charges is available on the IBM Support Portal website.

Choose the option entitled Purchase/upgrade tools.

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.

Order now

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

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

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

For IBM representative: callserv@ca.ibm.com

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

Mail:

IBM Teleweb Customer Support

ibm.com® Sales Execution Center, Americas North

3500 Steeles Ave. East, Tower 3/4

Markham, Ontario

Canada L3R 2Z1

Reference:

YE001

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

Note: Shipments will begin after the planned availability date.

Trademarks

Optim, 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, Passport Advantage, System i, System z, AIX, S/390, Parallel Sysplex, OS/390, z/Architecture and ibm.com are registered trademarks of IBM Corporation in the United States, other countries, or both.

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. Additional terms of use are located at

For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page

IBM United States