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