5697-Q05 IBM DB2 Accessories Suite for z/OS, 4.2

IBM Canada Sales Manual
Revised: June 8, 2021


Table of contents
Product life cycle datesProduct life cycle datesOperating environmentOperating environment
Program numberProgram numberPlanning informationPlanning information
AbstractAbstractPublicationsPublications
HighlightsHighlightsSecurity, auditability, and controlSecurity, auditability, and control
DescriptionDescription


Product life cycle dates

Top rule

Program Number VRM Announced Available Marketing Withdrawn Service Discontinued
5697-Q05 04.02.00 2021-06-08 2021-06-11 - -
5697-Q05 04.01.00 2016-10-04 2016-10-21 - -


Back to topBack to top

Program number

Top rule

  • IBM Db2 Accessories Suite for z/OS 4.2.0 (5697-Q05)
  • IBM Db2 Accessories Suite for z/OS Subscription and Support 1.1.0 (5655-R30)


Back to topBack to top

Abstract

Top rule

Db2 Accessories Suite for z/OS 4.2

Db2 Accessories Suite for z/OS 4.2 offers the Database Services Expansion Pack feature that delivers SQL Tuning Services to provide performance tuning capabilities for Db2 for z/OS SQL statements. SQL Tuning Services, installed on UNIX System Service (USS), exposes a rich set of RESTful APIs that clients can incorporate in their continuous integration and continuous deployment (CI/CD) pipeline for tuning SQL on their systems.

Db2 Accessories Suite for z/OS 4.1

IBM Db2 Accessories Suite for z/OS 4.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 program (5650-Db2 or 5770-AF3



Back to topBack to top

Highlights

Top rule

Db2 Accessories Suite for z/OS 4.2

Db2 Accessories Suite for z/OS 4.2 SQL Tuning Services offers many useful SQL performance tuning enhancements, including the capability to capture the following:

  • Dynamic SQLs from the cache
  • Static SQLs from the plans and packages
  • Stabilized dynamic SQLs from the catalogue
  • SQLs from user-defined repository
  • SQLs from a file

The SQL performance tuning features also include:

  • Query Environment Collecting
  • Visual Explain
  • Statistics Advisor
  • Query Format

Db2 Accessories Suite for z/OS 4.1

IBM Db2 Tools deliver enhancements in the following areas:

  • Miscellaneous
    • IBM Db2 Accessories Suite for z/OS 4.1 (5697-Q05)


Back to topBack to top

Description

Top rule

Db2 Accessories Suite for z/OS 4.2

The new Database Services Expansion Pack feature of Db2 Accessories Suite provides clients with access to SQL tuning APIs that can be incorporated with the CI/CD process to help customers tune their statistics, check the access plan of SQLs, and help ensure SQLs are optimally tuned by the time new codes are deployed. In addition to APIs that help capture SQLs from various sources, there are APIs that help provide features that include Visual Explain, Statistics Advisors, and help address query formatting.

Db2 Accessories Suite for z/OS 4.1

IBM Db2 Accessories Suite for z/OS 4.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 program (5650-Db2 or 5770-AF3).

Data Studio 4.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.

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.



Back to topBack to top

Operating environment

Top rule

Hardware requirements

Db2 Accessories Suite for z/OS 4.2

Db2 Accessories Suite for z/OS 4.2 will operate on any IBM Z server that supports the required operating environments and the required software. These include:

  • IBM z15 (all models)
  • IBM z14 (all models)
  • IBM z13 (all models)
  • IBM zEnterprise EC12
  • IBM zEnterprise BC12

Db2 Accessories Suite for z/OS 4.1

Db2 Accessories Suite for z/OS 4.1 will operate on any hardware configuration that supports the required operating environments and the required software.

Software requirements

Db2 Accessories Suite for z/OS 4.2

Db2 Accessories Suite for z/OS 4.2 requires:

  • z/OS 2.3, or later, with the PTF for APAR OA56570 applied.
  • IBM 64-bit SDK for z/OS Java Technology Edition Version 8 Service Refresh 4 Fix Pack 6 (Java 8 SR4 FP6), or later. Set JAVA_HOME to your installation directory.
  • z/OS ICSF. Properly configure and start the ICSF component. See ICSF Version and FMID for details.
  • Db2 12 for z/OS with PTF UI17988 applied.

Db2 Accessories Suite for z/OS 4.1

  • IBM DB2 Accessories Suite 12 feature:
    • IBM DB2 for z/OS 12 (5650-DB2) or IBM DB2 for z/OS Value Unit Edition, 12 (5770-AF3)
    • IBM z/OS 2.1 (5650-ZOS), or later
  • IBM DB2 Accessories Suite 11 feature:
    • IBM DB2 for z/OS 11 (5615-DB2), or IBM DB2 for z/OS Value Unit Edition,V11 (5697-P43)
    • IBM z/OS 1.13 (5694-A01), or later
  • IBM DB2 Adapter for z/OS Connect feature:
    • IBM z/OS (UNIX(tm)System Services) 1.13 (5694-A01), or later
    • One of the following:
      • IBM DB2 for z/OS 11 (5615-DB2)
      • IBM DB2 for z/OS Value Unit Edition, 11 (5697-P43)
      • IBM DB2 for z/OS 10 (5605-DB2)
      • IBM DB2 for z/OS Value Unit Edition, 10 (5697-P31)

Mandatory operational requisites

  • IBM DB2 Administration Solution Pack for z/OS 3.1 (5655-ASP)
  • IBM DB2 Administration Tool for z/OS 12.1 (5655-DT2)
  • IBM DB2 Automation Tool for z/OS 4.3, (5655-E37)
  • IBM DB2 Backup and Recovery Solution Pack for z/OS 1.1 (5655-BR1)
  • IBM DB2 Change Management Solution Pack for z/OS 1.1 (5655-CH1)
  • IBM DB2 Extended Utilities Suite for z/OS 2.1 (5655-EU2)
  • IBM DB2 Management Solution Pack for z/OS 2.1 (5655-MS2)
  • IBM DB2 Object Comparison Tool for z/OS 12.1 (5655-DC2)
  • IBM DB2 Performance Solution Pack for z/OS 1.2 (5655-E74)
  • IBM DB2 Query Monitor for z/OS 3.3 (5655-V42)
  • IBM DB2 Query Workload Tuner for z/OS 5.2 (5655-AB4)
  • IBM DB2 SQL Performance Solution Pack for z/OS 1.1 (5655-SQ1)
  • IBM Tools Customizer for z/OS 1.1 (5655-TC1)
  • IBM DB2 Utilities Solution Pack for z/OS 4.1 (5697-US4)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS 5.4 (5655-W37)
  • IBM Tivoli OMEGAMON XE for DB2 Performance Monitor z/OS 5.4 (5655-W38)

The programs above require one of the following:

  • IBM DB2 10.1 (5605-DB2)
  • IBM DB2 Value Unit Edition, 10.1 (5697-P31)
  • IBM DB2 11.1 (5615-DB2)
  • IBM DB2 Value Unit Edition, 11.1 (5697-P43)
  • IBM DB2 12.1 (5650-DB2)
  • IBM DB2 Value Unit Edition, 12.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 3.3 (5655-V42) requires IBM DB2 Data Access Common Collector for z/OS (5639-OLC).

IBM DB2 Utilities Suite for z/OS 12.1 (5770-AF4)

  • DB2 Utilities Suite for z/OS 12.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 12.1

IBM DB2 Accessories Suite for z/OS 4.1:

  • IBM DB2 Accessories Suite for z/OS DB2 12 feature:
    • IBM DB2 for z/OS 12 (5650-DB2), or IBM DB2 for z/OS Value Unit Edition, 12 (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 11 (5615-DB2), or IBM DB2 for z/OS Value Unit Edition, 11 (5697-P43), plus DB2 for z/OS 11 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 programs:
      • IBM DB2 for z/OS 11 (5615-DB2) JDBC FMID JDBBB12
      • IBM DB2 for z/OS Value Unit Edition, 11 (5697-P43) JDBC FMID JDBBB12
      • IBM DB2 for z/OS 10 (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(tm)Technology Edition, 7 (5655-W44), or later
    • IBM Data Studio, 4.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 12.1 (5655-DT2) and IBM DB2 Object Comparison Tool for z/OS 12.1 (5655-DC2):

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

DB2 Object Comparison Tool for z/OS 12.1 requires DB2 Administration Tool for z/OS 12.1.

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

Conditional operational requirements

IBM DB2 Accessories Suite for z/OS 4.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(tm)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


Back to topBack to top

Planning information

Top rule

Customer responsibilities

Not applicable.



Back to topBack to top

Publications

Top rule

Db2 Accessories Suite for z/OS 4.2

The following publications are shipped with the program:

Title                                                          Order
                                                               number
-------------------------------------------------------------- ---------
IBM Db2 Accessories Suite for z/OS 4.2 License Information     GC27-8813
IBM Db2 Accessories Suite for z/OS 4.2 Program Directory       GI13-4637
IBM Db2 Accessories Suite for z/OS 4.2 (Database Services      GC28-3247
Expansion Pack feature) License Information
IBM Db2 Accessories Suite for z/OS 4.2 (Database Services      GI13-5929
Expansion Pack feature) Program Directory

Program documentation will be available on the planned availability date in IBM Documentation ,

Db2 Accessories Suite for z/OS 4.1

The following publications are shipped with the program:

Title                                                    Order number
-------------------------------------------------------  ------------
IBM Db2 Accessories Suite for z/OS 4.1 (5697-Q05)
 Db2 Accessories Suite 12 feature:
  License Information                                    GC27-8813
  Program Directory                                      GI13-4637
  Text Search for Db2 for z/OS 1.5 DVD                  LCD4-8423
Db2 Accessories Suite 11 feature:
License Information                                      GC27-8814
Program Directory                                        GI13-4638
Text Search for Db2 for z/OS 1.5 DVD                    LCD4-8423
Db2 Adapter for z/OS Connect feature:
License Information                                      GC27-8815
Program Directory                                        GI13-4639

The publications for programs described in this document cannot be ordered in hardcopy. All of the publications described in this document available at:

Db2 Accessories Suite for z/OS


Back to topBack to top

Security, auditability, and control

Top rule

The announced program uses the security and auditability features of the host operating system software.



Back to topBack to top

Trademarks

Top rule

(R), (TM), * Trade-mark or registered trade-mark of International Business Machines Corporation.

** Company, program, or service name may be a trade-mark or service mark of others.

Windows is a trade-mark of Microsoft Corporation.

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 Sales Manual at any time without notice. This Sales Manual is provided for your information only. Additional terms of use are located at

Terms of use


© IBM Corporation 2021.