IBM DB2 Tools offer new and enhanced tools to help improve user efficiency

IBM United States Software Announcement 216-164
May 10, 2016


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

 


(Corrected on May 25, 2016)

The At a glance, Overview, Description, and Software requirements sections were revised.



Top rule
At a glance
Bottom rule

IBM® DB2® Table Editor for z/OS®, V4.5 (5697-G65) helps you navigate DB2 for z/OS data more quickly and easily. Version 4.5 provides the following enhancements:

  • Performance improvements in storage allocation and memory usage to increase product efficiency
    • You can now browse and edit very large tables, removing the limitation of editing a specific number of rows at one time and removing the confirmation window.
    • Previous versions of Table Editor retrieved data by chunks, and when you wanted to move to another frame, it saved all changes and retrieved the next 5,000 rows, for example. Now Table Editor keeps only the changed rows in memory, which allows you to increase the number of operations you can do without committing the changes to DB2. That helps improve overall usability of the product and user experience.
  • Usability improvements
    • Improved usability, enabling more flexible viewing and editing options of DB2 table data.
    • The ability to hide specific rows while in ISPF that you aren't interested in seeing.
    • A new ISPF edit CHANGE ALL command will apply changes to all rows except the hidden rows. This enables you to retrieve and apply changes to all rows in the table that match the SELECT or WHERE clause without pausing to ask you if you want to continue retrieving the next set of rows. The pop-up window that had previously been displayed to confirm that users wanted to continue retrieving the next set of rows has been removed.

New and enhanced DB2 Tools bundles:

  • IBM DB2 Extended Utilities Suite for z/OS, V1.1 (5655-EUS) components can help you to optimize and extend the capabilities of operational utilities tasks.
  • IBM DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP) can help satisfy all your utilities, administration, and performance tasks for your most critical DB2 for z/OS environments and applications.
  • IBM DB2 Utilities Solution Pack for z/OS, V3.1 (5697-USP) enhancements can help reduce downtime costs and complexity by providing effective backup and recovery automation options.


Back to topBack to top

Top rule
Overview
Bottom rule

DB2 Table Editor for z/OS, V4.5 (5697-G65) is designed to enable you to access, update, and delete data quickly and easily on DB2 for z/OS.

DB2 Table Editor for z/OS, V4.5 enables a customization method for easier configuration. This method invokes the Tools Customizer for z/OS to customize DB2 Table Editor with the same look and feel as other DB2 tools.

The Tools Customizer for z/OS is a standard interface that assists in the post-SMP/E configuration, tailoring, and customization of IBM z™ /OS tools. With a common data store, Tools Customizer for z/OS provides a more consistent, usable, and simple solution for the configuration of multiple z/OS tools. The result is faster time to tool usage, easier simultaneous customization of multiple tools,faster propagation of customization across multiple LPARs, and easier upgrades. Tools Customizer for z/OS is a feature of IBM Tools Base (5655-V93).

DB2 Extended Utilities Suite for z/OS, V1.1 (5655-EUS) 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.

DB2 Extended Utilities Suite for z/OS, V1.1 combines capabilities from the following products:

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

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

DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP) offers the most comprehensive set of IBM DB2 Tools to implement best practices for administering and optimizing the DB2 for z/OS environment. Features and functions included in this package will satisfy all your utilities, administration, and performance tasks for your most critical DB2 for z/OS environments and applications. DB2 Management Solution Pack for z/OS, V1.1 combines capabilities from the following products:

  • DB2 Utilities Solution Pack for z/OS, V3.1 (5697-USP)
  • DB2 Administration Solution Pack for z/OS, V2.2 (5697-DAQ)
  • DB2 Performance Solution Pack for z/OS, V1.4 (5655-E74)

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

DB2 Utilities Solution Pack for z/OS, V3.1 (5697-USP) 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, V3.1 include:

  • Additional features and functions to reduce downtime costs by providing effective backup and recovery automation
  • Authorization to run DB2 Utilities Suite in all currently supported DB2 environments

DB2 Utilities Solution Pack for z/OS, V3.1 combines capabilities from the following products:

  • DB2 Extended Utilities Suite for z/OS, V1 (5655-EUS)
  • DB2 Automation Tool for z/OS, V4 (5655-E37)
  • DB2 Recovery Expert for z/OS, V3 (5655-W78)

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



Back to topBack to top

Top rule
Key prerequisites
Bottom rule

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



Back to topBack to top

Top rule
Planned availability date
Bottom rule
  • May 27, 2016, for IBM DB2 Table Editor for z/OS, V4.5
  • June 10, 2016, for IBM DB2 Extended Utilities Suite for z/OS, V1.1, IBM DB2 Management Solution Pack for z/OS, V1.1, and IBM DB2 Utilities Solution Pack for z/OS, V3.1


Back to topBack to top

Top rule
Description
Bottom rule

DB2 Table Editor for z/OS, V4.5 (5697-G65) offers database administrators (DBAs), developers, and the entire enterprise direct update and data creation operations on DB2 for z/OS databases.

Quick and easy manipulation of data  

DB2 Table Editor helps you make the best use of your time. It can reduce staff training time, enhance DBA productivity, increase the ability to respond to your workforce's need for high-performance business applications, and enable the IT team to institute proactive database maintenance.

DB2 Table Editor is designed to make quick and easy work of navigating DB2 databases, tables, and views, finding related data, and updating, deleting, or creating data.

Control of data integrity 

In today's competitive environment, data integrity is more important than ever. Whether your concern is as basic as accurate customer records or as complex as running applications that depend on hundreds of interdependent tables, DB2 Table Editor is designed to make preserving data integrity easy to accomplish, no matter the level of experience of your employees. With DB2 Table Editor, users, both novice and expert, can use this single, powerful tool to manipulate your data while you maintain tight control over their data editing privileges.

Performance improvement

Storage allocation and memory utilization is more efficient.

Usability improvement

Usability has been improved by enabling more flexible viewing and editing options of DB2 table data.

DB2 Table Editor now retrieves all data rows that match the SELECT or WHERE clause without pausing to ask users if they want to continue retrieving the next set of rows. The pop-up window that is displayed for users to confirm that they want to continue retrieving the next set of rows has been removed.

DB2 Table Editor, V4.5 removed the 1 MB size limitation for editing XML data. The XML data can be edited as long as the user region size is big enough to load the data into the memory.

The graphical user interface and LOB support has been deprecated. ISPF will be used exclusively.

DB2 Extended Utilities Suite for z/OS, V1.1 (5655-EUS) 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 zIIP1 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, allowing 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

DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP) 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 zIIP1 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, allowing 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 Data Server Manager architecture that provides expert recommendations which 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
    • Features 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

DB2 Utilities Solution Pack for z/OS, V3.1 (5697-USP) 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, V3.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

DB2 Utilities Solution Pack, V3.1 integrates with IBM Data Server Manager Base Edition, V1.1.2.1 (5725-R75) or Management Console for IMS™ and DB2 for z/OS, V1.1 (5655-TAC) to deliver the following features:

  • Graphical reporting, categorizing, sorting, and ordering of DB2 utility symptoms and actions as part of the various DB2 subsystem, tablespace, indexspace, and partition-level dashboards
  • Graphical reporting of historical DB2 utility runs listed on the various levels of DB2 dashboards
  • Ability to graphically view DB2 utility profiles, including object, exception, utility, and job profiles
1
This information provides only general descriptions of the types and portions of workloads that are eligible for execution on Specialty Engines (SEs). IBM authorizes clients to use IBM SEs such as zIIPs, zAAPs, and IFLs only to execute the processing of Eligible Workloads of specific programs expressly authorized by IBM as specified in the Authorized Use Table for IBM Machines (AUT) provided at the AUT website.

No other workload processing is authorized for execution on an SE. IBM offers SEs at a lower price than general processors/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

IBM DB2 Table Editor for z/OS, V4.5 is capable as of May 27, 2016, and IBM DB2 Extended Utilities Suite for z/OS, V1.1, IBM DB2 Management Solution Pack for z/OS, V1.1, and IBM DB2 Utilities Solution Pack for z/OS, V3.1 are capable as of June 10, 2016, 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.



Back to topBack to top

Top rule
Reference information
Bottom rule

See Software Announcement 212-258, dated August 7, 2012, for information regarding IBM DB2 Table Editor for z/OS, V4.4.

See Software Announcement 215-086, dated May 5, 2015, for information regarding IBM DB2 Utilities Solution Pack for z/OS, V2.2.



Back to topBack to top

Top rule
Program number
Bottom rule
Program number VRM Program name
5697-G65 4.5.0 IBM DB2 Table Editor for z/OS
5655-EUS 1.1.0 IBM DB2 Extended Utilities Suite for z/OS
5655-MSP 1.1.0 IBM DB2 Management Solution Pack for z/OS
5697-USP 3.1.0 IBM DB2 Utilities Solution Pack for z/OS

Product identification number

Program PID number Subscription and Support PID number
5697-G65 5655-E84
5655-EUS 5655-ESS
5655-MSP 5655-MSS
5697-USP 5697-DUS


Back to topBack to top

Top rule
Offering Information
Bottom rule

Product information is available on the IBM Offering Information website.



Back to topBack to top

Top rule
Business Partner information
Bottom rule

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

BP Attachment for Announcement Letter 216-164


Back to topBack to top

Top rule
Publications
Bottom rule

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

Title Order number
IBM DB2 Table Editor for z/OS, V4.5 (5697-G65)  
License Information GC27-1200
Program Directory GI10-8401
IBM DB2 Extended Utilities Suite for z/OS, V1.1 (5655-EUS)  
License Information GI13-4619
Program Directory GI10-4622
IBM DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP)  
License Information GI13-4620
Program Directory GI10-4623
IBM DB2 Utilities Solution Pack for z/OS, V3.1 (5697-USP)  
License Information GI13-4618
Program Directory GI10-4621

The following publication cannot be ordered in hardcopy. It will be available on the product availability date, on the DB2 Tools Product Documentation web page.

Title Order number
DB2 Table Editor for z/OS, V4.5  
User's Guide SC27-8804


Back to topBack to top

Top rule
Services
Bottom rule

Software Services

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

To learn more about IBM Software Services or to contact a Software Services sales specialist, go to the IBM Software Services website.



Back to topBack to top

Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

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

In addition:

DB2 Table Editor for z/OS, V4.5 (5697-G65) requires a minimum of a 40000 region size.

SQL performance monitoring features in DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP) require:

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

Using the Data Server Manager web-based interface to perform SQL tuning functions in DB2 Management Solution Pack for z/OS, V1.1 requires:

  • 2 GB of available disk space
  • Minimum memory requirement of 1 GB; recommended is 2 GB of memory
Software requirements

Mandatory installation requirements:  

The products in this announcement require:

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

In addition:

Integrating the DB2 system performance monitoring information from the DB2 Management Solution Pack for z/OS, V1.1 into the IBM Tivoli® Enterprise Portal requires IBM Tivoli Monitoring, V6.3.0 (5698-A79) fix pack 2.

SQL data collection for monitoring SQL performance in the DB2 Management Solution Pack for z/OS, V1.1 requires IBM DB2 Data Access Common Collector for z/OS, V1.1 (5639-OLC), or later.

For requirements associated with the configuration management feature in DB2 Management Solution Pack, V1.1 go to the DB2 Management Solution Pack for z/OS, V1.1 Configuration management feature requirements web page.

For requirements associated with SQL tuning features in IBM DB2 Management Solution Pack, V1.1 leveraging the Data Server Manager interface, go to the DB2 Management Solution Pack for z/OS, V1.1 SQL tuning features requirements web page.

Mandatory operational requirements:  

DB2 Table Editor for z/OS, V4.5 (5697-G65):

  • Operates with:
    • IBM DB2 for z/OS, V10.1 NFM (5605- DB2)
    • IBM DB2 for z/OS Value Unit Edition, V10.1 NFM (5697-P31)
    • IBM DB2 for z/OS, V11.1 NFM (5615- DB2)
    • IBM DB2 for z/OS Value Unit Edition, V11.1 NFM (5697-P43 )
  • Requires:
    • IBM Tools Base, V1.5 (5655-V93), or later, a no-charge product at the latest maintenance level, in order to utilize the function delivered by IBM Tools Customizer for z/OS
    • IBM Tools Customizer for z/OS (FMID HTCZ110) maintenance at current level before starting customization

DB2 Extended Utilities Suite for z/OS, V1.1 (5655-EUS), DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP), and DB2 Utilities Solution Pack for z/OS, V3.1 (5697-USP) operate with:

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

The DB2 Utilities Solution Pack for z/OS, V3.1 and DB2 Management Solution Pack for z/OS, V1.1 autonomic capability requires:

  • IBM Data Server Manager Base Edition, V1.1.2.1 (5725-R75) or IBM Management Console for IMS™ and DB2 for z/OS, V1.1 (5655-TAC)
  • IBM Tools Base for z/OS, V1.5 (5655-V93), IBM Autonomics Director for DB2 for z/OS FMID HAKP150

The DB2 Utilities Solution Pack for z/OS, V3.1 and DB2 Management Solution Pack for z/OS, V1.1 web browser user interface for recovery management features requires a browser that supports web sockets. Currently, the following browsers support web sockets:

  • Google Chrome 16, or later
  • Mozilla Firefox 11.0, or later
  • Microsoft Internet Explorer 10, or later
  • Opera 12.10, or later
  • Apple Safari 6.0, or later (non Microsoft Windows Version)

For post-installation customizations, DB2 Extended Utilities Suite for z/OS, V1.1, DB2 Management Solution Pack for z/OS, V1.1, and DB2 Utilities Solution Pack for z/OS, V3.1 require FMID HTCZ110 IBM Tools Customizer for z/OS at the latest maintenance level, with APAR PI60076 applied. Tools Customizer for z/OS is delivered in IBM Tools Base, V1.5 (5655-V93).

Configuring the SQL performance monitoring features within the DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP) requires:

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

For the SQL performance monitoring web client:

  • Mozilla Firefox, 2.0.1.3, or later
  • Microsoft Internet Explorer, V8, or later
  • AdobeFlash Player 10

Conditional operational requisites

The DB2 system performance monitoring feature within DB2 Management Solution Pack for z/OS, V1.1 supports the following additional subsystems:

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

The DB2 recovery management features in DB2 Utilities Solution Pack for z/OS, V3.1 and DB2 Management Solution Pack for z/OS, V1.1 require:

  • One of the following product pairs:
    • DB2 for z/OS, V10.1 (5605- DB2) or DB2 for z/OS, V10.1 VUE (5697-P31)
    • DB2 for z/OS, V11.1 (5615- DB2) or DB2 for z/OS, V11.1 VUE (5697-P43)
  • BCV and SNAP backups require:
    • EMC Symmetrix 6, or later, running with Microcode 5x67, or later.
    • To use Enginuity Consistency Assist (ECA), Microcode 5x67 with patch 14882, 5x68 with patch 18954, or 5x69, or later, is required. To use ECA with SNAP VOLUME technology, the EMC SNAP library must be level 5.5, or higher. Protected BCV restore requires Microcode 5x70, or later.
  • FlashCopy® requirements for backup and restore:
    • Use of FlashCopy for full system backup and restore requires the storage subsystem to be FlashCopy V1 capable.
    • Object-level restore requires the storage subsystem be FlashCopy V2 capable.
  • DFSMSdss requirements:
    • For DFSMSdss backups, DFSMSdss must be version 1 release 8, or later.
    • To perform encryption during offloads, DFSMSdss requires the following software:
      • Encryption Facility DFSMSdss Encryption Feature (FMID)
      • IBM Cryptographic Services Facility (ICSF) (HCR770B, or later)

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 two requirements from one or more of the worldwide user group communities. Groups include COMMON, COMMON Europe, Guide Share Europe (GSE), InterAction (Australia/New Zealand), Japan Guide Share (JGS), and SHARE Inc.

DB2 Table Editor for z/OS, V4.5 (5697-G65) satisfies the following requirements:

RFE55738 RFE64842

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)



Back to topBack to top

Top rule
Ordering information
Bottom rule

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

Program number Program name Value Unit exhibit
5697-G65 IBM DB2 Table Editor for z/OS VUE007
5655-EUS IBM DB2 Extended Utilities Suite for z/OS VUE007
5655-MSP IBM DB2 Management Solution Pack for z/OS VUE007
5697-USP IBM DB2 Utilities Solution Pack for z/OS VUE007

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

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


Value Unit exhibit VUE007

  MSUs 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). For more details and availability, go to the Shopz website.

Charge metric

Program name PID number Charge metric
IBM DB2 Table Editor for z/OS 5697-G65 Value Unit
IBM DB2 Extended Utilities Suite for z/OS 5655-EUS Value Unit
IBM DB2 Management Solution Pack for z/OS 5655-MSP Value Unit
IBM DB2 Utilities Solution Pack for z/OS 5697-USP Value Unit

Basic license


On/Off CoD

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

Translation from MSUs to Value Units

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

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 Table Editor for z/OS

Program PID: 5697-G65

Entitlement identifier Description License option/Pricing metric
S00V175 DB2 Table Editor for z/OS, V4 Basic OTC, Value Units
    Basic OTC, per MSU-day TUC
Orderable supply ID Language Distribution medium
S016D2L US English 3590 Tape cartridge

Program name: IBM DB2 Extended Utilities Suite for z/OS

Program PID: 5655-EUS

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

Program name: DB2 Management Solution Pack for z/OS

Program PID: 5655-MSP

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

Program name: IBM DB2 Utilities Solution Pack for z/OS

Program PID: 5697-USP

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

Subscription and Support PID: 5655-E84

Entitlement identifier Description License option/Pricing metric
S00V74V DB2 Table Editor 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
S00TH8L 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: 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

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 release will be withdrawn from marketing, effective on the date the new release becomes available.

Release to be withdrawn from marketing effective May 27, 2016:

Name of product being withdrawn Ver Rel Mod Product number
IBM DB2 Table Editor for z/OS 4 4 0 5697-G65

IBM DB2 Table Editor for z/OS, V4.4.0 (5697-G65) is replaced by IBM DB2 Table Editor for z/OS, V4.5.0 (5697-G65).

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, see 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 two weeks after general availability.



Back to topBack to top

Top rule
Terms and conditions
Bottom rule

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

Licensing

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

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 numbers

Title Order number
IBM DB2 Table Editor for z/OS, V4.5 (5697-G65) GC27-1200
IBM DB2 Extended Utilities Suite for z/OS, V1.1 (5655-EUS) GI13-4619
IBM DB2 Management Solution Pack for z/OS, V1.1 (5655-MSP) GI13-4620
IBM DB2 Utilities Solution Pack for z/OS, v3.1 (5697-USP) GI13-4618

See the License Information documents page on the IBM Software License Agreement website for more information.

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

Program support

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

Money-back guarantee

If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For clarification, note that for programs acquired under any of IBM 's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Volume orders (IVO)

No

Passport Advantage applies

No

Software Subscription and Support applies

Yes. During the S&S period, for the unmodified portion of a program, and to the extent problems can be re-created 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, that includes IBM contact information, are provided in the IBM Software Support Handbook.

S&S does not include assistance for:

  • The design and development of applications
  • Organization's use of program in other than their specified operating environment, or
  • Failures caused by products for which IBM is not responsible under the IBM Agreement for Acquisition of Software Maintenance.

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

IBM Operational Support Services - SoftwareXcel

Yes

System i Software Maintenance applies

No

Variable charges apply

No

Educational allowance available

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

Sub-capacity terms and conditions

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

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

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

Program number Program name Terms Parent, if applicable
5697-G65 DB2 Table Editor for z/OS Reference-based DB2 for z/OS, V10.1 (5605- DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
      DB2 for z/OS, V11.1 (5615- DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
5655-EU DB2 Extended Utilities Suite for z/OS Reference-based DB2 for z/OS, V10.1 (5605- DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
      DB2 for z/OS, V11.1 (5615- DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
5655-MSP DB2 Management Solution Pack for z/OS Reference-based DB2 for z/OS, V10.1 (5605- DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
      DB2 for z/OS, V11.1 (5615- DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
5697-USP DB2 Utilities Solution Pack for z/OS Reference-based DB2 for z/OS, V10.1 (5605- DB2)
      DB2 for z/OS Value Unit Edition, V10.1 (5697-P31)
      DB2 for z/OS, V11.1 (5615- DB2)
      DB2 for z/OS Value Unit Edition, V11.1 (5697-P43)
Full-capacity mainframes

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

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

Sub-capacity mainframes

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

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

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

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

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

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

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

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

When a z Systems IPLA sub-capacity program with reference-based terms is used in a qualified Parallel Sysplex environment, the required license capacity of the z Systems IPLA program must equal with the license capacity of the parent program across the Parallel Sysplex. Qualified Parallel Sysplex refers to one:

  • Where MLC pricing is aggregated across the sysplex.

Sub-capacity eligibility

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

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

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

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

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

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

Sub-capacity utilization determination

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

On/Off CoD

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



Back to topBack to top

Top rule
Statement of good security practices
Bottom rule

IT system security involves protecting systems and information through prevention, detection, and response to improper access from within and outside your enterprise. Improper access can result in information being altered, destroyed, or misappropriated or can result in misuse of your systems to attack others. Without a comprehensive approach to security, no IT system or product should be considered completely secure and no single product or security measure can be completely effective in preventing improper access. IBM systems and products are designed to be part of a lawful, comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective.

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



Back to topBack to top

Top rule
Prices
Bottom rule

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

IBM Global Financing

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

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

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



Back to topBack to top

Top rule
Order now
Bottom rule

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

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

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

For IBM representative: callserv@ca.ibm.com

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

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

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


Note: Shipments will begin after the planned availability date.
Trademarks

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

IBM, DB2, z/OS, PartnerWorld, Passport Advantage, System i, System z, Tivoli, CICS, FlashCopy, 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.

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

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

Other company, product, and service names may be trademarks or service marks of others.

Terms of use

IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at

Terms of use

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

http://www.ibm.com/planetwide/us/

Share this page

Digg Linked In

Contact IBM

Feedback

-->