Db2 Tools

Db2 Tools New Features Summary - Summer 2021 Edition

  • 1.  Db2 Tools New Features Summary - Summer 2021 Edition

    Broadcom Employee
    Posted 06-25-2021 02:34 AM
    Edited by Philippe Dubost 06-25-2021 02:34 AM

    Here's a summarized list of the enhancements we have made to Version 20.0 of the CA Database Management Solutions for Db2 for z/OS from April 2021 to June 2021:

    Feature Highlights

    DevOps: The CA DBM for Db2 Plug-in for Zowe CLI introduces new Zowe™ CLI commands that enable you to interact with Db2 using the CA Database Management Solutions for Db2 for z/OS. The Zowe CLI is a command-line interface that lets you interact with the mainframe in a familiar format.

    You can use the pre-GA version of the CA DBM for Db2 plug-in for Zowe CLI to automate Db2 schema provisioning to generate DDL and then verify and execute the syntax. You can also compare DDL and then execute it on a target subsystem using Zowe CLI.

    You can use the plug-in to integrate the CA Database Management Solutions for Db2 for z/OS into DevOps continuous integration/continuous development (CI/CD) DevOps workflows.

    The pre-GA version of the CA DBM for Db2 plug-in for Zowe CLI is now available from our validate site.

    AIOps: The Database Management Data Service has been enhanced to support a new generic endpoint (/api/v1/idb2/prometheus/generic). This endpoint lets you produce Db2 performance metrics in the Prometheus exposition format. CA SYSVIEW for DB2 introduces new IQL requests to exploit the new REST API endpoint. You can feed CA SYSVIEW for DB2 data to the Prometheus open-source monitoring system and use Grafana open-source visualisation tool with Prometheus to visualize the data.

    Four sample Grafana dashboard JSON files are now provided in the ../PXM/ds/config/ path of hlq.CDBAZFS. You can customize these dashboards to display the metrics that are most important to you.

    MTC-DBM Configuration Enhancements: A new ISPF-based Configuration Utility is now provided to configure the Mainframe Team Center - Database Management for Db2 for z/OS (MTC-DBM) user interface and the Database Management Data Service (DBM Data Service). The Configuration Utility:

    o   Integrates with existing post-installation tailoring steps.

    o   Tracks, reports, and saves your progress throughout the configuration process.

    o   Lets you pause the configuration process and then resume it later as needed.

    o   Simplifies configuration of the DBM Data Service and MTC-DBM user interface by soliciting, validating, and saving the required configuration parameter values.

    The Configuration Utility guides you through the process of generating and submitting the required jobs to complete the configuration process.

    Recovery Simulation: You can now use the IBM OPTIONS control statement for recovery simulations.

    Sample JCL for the recovery simulation feature is also now provided in member FRECOSIM of hlq.CDBAJCL.

    Recovery Estimator: The recovery estimator feature has a new VERIFY-DATASETS option that verifies that the data sets that are needed to recover your objects are cataloged in the z/OS ICF catalogs. When you run a Recovery Estimator job to analyze the recoverability of your objects, the resulting report displays which image copies are needed to recover the objects and the size of the required logs. The report also flags any image copy data sets or log data sets that could not be found in the catalogs. Identifying the missing data sets lets you resolve this problem proactively to ensure the recoverability of your objects.

    Sample JCL for the recovery estimator feature is also now provided in member FRECOEST of hlq.CDBAJCL. This batch job analyzes the recoverability of a Db2 object or group of objects and estimates the time it will take to recover them. Database Administrators can use this batch utility to verify that recovery service level agreements (SLAs) are met.

    Other Features

    • The post-installation tailoring process has also been enhanced to enable updates to all data sharing group members simultaneously. The group-wide changes are reflected in the corresponding data sharing group members immediately, saving time, and reducing potential errors.

    A new JCL member, PTAMIGLP, is also now provided in hlq.CDBAJCL to convert PTLLPARM into the PTIPARM data set easily. Support for PTLLPARM will be removed in the future so use of this member can ease this transition.

    • The DB2 Command Processor has been enhanced to support the following Db2 12 commands: DISPLAY BLOCKERS, DISPLAY LOG, DISPLAY PROFILE, DISPLAY RESTSVC, START PROFILE, START RESTSVC, STOP PROFILE, and STOP RESTSVC.
    • The DB2L command has been enhanced to display the code level with the function level, catalog level, and previous highest function level. You can use this command in batch and online to identify synchronization issues in your environments and to prevent Db2 connection errors.
    • New global options and IDAA expressions that were introduced in Db2 12 FL507 (V12R1M507) SQL DML syntax are now supported in CA Bind Analyzer, CA Plan Analyzer, and CA SQL-Ease.
    • The Alternate Catalog Mapping value pack component can now be used with the SYSTABSPACESTATS_H and SYSIXSPACESTATS_H history tables. These tables are associated with the SYSTABLESPACESTATS and SYSINDEXSPACESTATS Db2 catalog tables for system-period temporal versioning.
    • CA Database Analyzer has been enhanced to provide LISTDEF support in REORG and Image Copy action JCL. New model members, MJULDRO and MJULDIC, are now provided to generate action JCL to execute REORG with a LISTDEF statement or Image Copy with a LISTDEF statement. To control the number of objects that are processed in each step, use the LISTDEF_STEP_LIMIT parameter in the PDA parmlib member or model members. LISTDEF statements allow for greater concurrency during executions.
    • CA Detector has been enhanced to enable filtering of collection data by connection type. The ability to filter by connection type gives you more granular control over the collection of your Db2 application statistics, which helps you optimize the use of system resources.
    • The SORTLOG NO option in CA Fast Recover has been enhanced to support FlashCopies, which increases your options for recovering data.
    • CA Fast Unload now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from a LOB column or with an ORDER BY clause. zIIP support is provided when you unload LOB data with INPUT-FORMAT TABLE or order by a specified column. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
    • CA Log Analyzer enhancements:
      • Table mapping support for source and target tables is now provided in DML Redo/Undo SQL reports. You can now use creator and table name masks to quickly replace source system object names with corresponding target system object names in the generated DML SQL statements.
      • Improvement to DDL Report performance. Log records that are not required are now excluded from the DDL report processing. This enhancement improves the performance of the report.
      • A new option is now provided that ensures the parmlib values are set to their optimal settings. The current settings are checked and changes are suggested that can optimize the performance of your environment.
      • Support for COMMENT and LABEL statements in the DDL Summary Report. The Comments field in the report now includes the number of COMMENT and LABEL statements that were encountered.
      • Support of ALTER SEQUENCE statements in the DDL Report.
      • The DML Detail report can now include serialized XML record data in a readable format. A new XML column data panel option is provided.
    • The COBOL source code in CA Report Facility has been migrated to COBOL version 6.2. The CDBACICS and CDBAIMS load libraries have also been converted from PDS to PDSE to support this maintenance.
    • CA SYSVIEW for Db2 enhancements:
      • New global contention fields and IRLM statistics have been added in trace record 002 STATS. These statistics are now included in batch, real-time, and history reports.
      • Existing archive tables have been updated with new Db2 12 statistics such as Db2 command counts, remote location details, FTP usage, Db2 Accelerator 7 and zHyperLink details, and Db2 zParms.
        The following new archive tables have also been added: SUBSYS_ACCT_BY_CONN_DETAIL and SUBSYS_ACCT_BY_CONN_DAILY. The new tables are built on IFCID 369 data and store the accounting data aggregated by the connection type. You can use this data to monitor the overall application activity and tune the workload.
      • The USERS command has been enhanced to report the amount of storage that is allocated in the data collector for every connected user. The command output is now logged to DBGPRINT at the time interval that is specified by the HISTORY-MESSAGE-TIME system parameter.

    For more information about these enhancements, see New Features in the Release Notes.