New Features

Review this high-level summary of the new features and enhancements in Version 20.0 of the CA Database Management Solutions for DB2 for z/OS.
dm20
The following list provides a high-level summary of the new features and enhancements that have been delivered to date in Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
:
To ensure availability of all features and fixes, ensure that your products are current on maintenance. To download and receive maintenance automatically, Configure CA SMP/E Internet Service Retrieval. To view a list of available solutions and fixes, select the link for PTFs since GA on the CA Database Management Solutions for DB2 for z/OS Maintenance Grid (login required).
To request product enhancements, contact a product manager or post your request in the "Ideas" section of the Db2 Tools community.
To review the Version 20.0 features that were released under the Incremental Release model, see New Features Introduced under Incremental Release.
2
2
Filter CA Detector Collection Data by Connection Type (LU01002)
When you run
CA Detector® for DB2 for z/OS
collections, you can now filter the collected data by connection type. A new field, Connection Type, has been added to the Add Include/Exclude Entry panel. This panel is accessible through your CA Detector collection profile. 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.
For more information, see Limit Collection Activity.
Support for LISTDEF in Image Copy Action JCL (LU00890)
CA Database Analyzer™ for DB2 for z/OS
now supports the use of LISTDEF to execute Image Copy (IC) against a list of objects in
one step
. Previously, you could only execute RUNSTATS against the objects in a LISTDEF in one step. A new model member (MJULDIC) is provided to create action JCL to execute Image Copy with a LISTDEF statement. You can use the LISTDEF_STEP_LIMIT parameter in the PDA parmlib member or model members to control the number of objects that are processed per step. LISTDEF statements allow for greater concurrency during executions.
For more information, see CA Database Analyzer New Features.
Post-install Data Sharing Group Enhancements (LU00847)
The post-installation tailoring process for the
CA Database Management Solutions for DB2 for z/OS
has been enhanced so that you can change group-wide options for all data sharing group members at the same time. This enhancement lets you apply group-wide changes in the SETUP global parmlib member simultaneously instead of editing each member individually. The group-wide changes are reflected into the corresponding members of the data sharing group immediately, saving time, and reducing potential errors. When selecting Db2 subsystems to process, you can also now sort by data sharing group. For more information, see Create a SETUP Global Parmlib Member.
zIIP Unloads from LOB Columns and with ORDER BY (LU00887)
CA Fast Unload® for DB2 for z/OS
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.
For more information, see CA Fast Unload New Features.
MTC-DBM UI and DBM Data Service Post-Install Improvement (LU00839)
The post-installation tailoring process for the
CA Database Management Solutions for DB2 for z/OS
has been enhanced to enable configuration of the
Mainframe Team Center - Database Management for Db2 for z/OS
(MTC-DBM) user interface and the Database Management Data Service (DBM Data Service). You can now select MTC during post-install tailoring and then configure these components using the Database Management for Db2 for z/OS (DBM for Db2) ISPF-based Configuration Utility. Previously, this configuration was performed by editing JCL manually.
The Configuration Utility:
  • Integrates with existing post-installation tailoring steps.
  • Tracks, reports, and saves your progress throughout the configuration process.
  • Lets you pause the configuration process and then resume it later as needed.
  • Simplifies configuration of the DBM Data Service and MTC-DBM user interface by soliciting, validating, and saving the required configuration parameter values.
After all required parameter values have been entered and saved, the Configuration Utility guides you through the process of generating and submitting the jobs to complete the configuration process.
Storage Statistics Added to USERS Command (LU00881)
CA SYSVIEW® Performance Management Option for DB2
command USERS has been enhanced to report the amount of storage allocated in the data collector for every connected user. The command output is now logged to DBGPRINT at the regular time interval. For more information, see CA SYSVIEW for DB2 New Features.
Table Masking in DML Redo/Undo SQL Report (LU00759)
CA Log Analyzer™ for DB2 for z/OS
now supports table masking in the DML Redo/Undo SQL report. For more information, see CA Log Analyzer New Features.
Support for COBOL Version 6.2 (LU00581)
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.
PTLLPARM Support Removal Phase 1 (LU00592)
Support for PTLLPARM will be removed in the future. To prepare for this change, a new JCL member, PTAMIGLP, is now provided in
hlq
.CDBAJCL. Use this member to convert PTLLPARM into the PTIPARM data set. A new message, PT806W, is generated online and in batch when the PTLLPARM load module is present in the load library.
New Features (Spring 2021)
The following list summarizes the enhancements that we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
from winter 2020 to spring 2021:
  • Improved Performance for Batch Unloads (LU00565)
  • Monitor ECSA Storage Availability (LU00523)
  • Support for Db2 V12R1M509 (LU00277, LU00304)
  • Partition-Level DSSIZE PBR2 Alteration Support (LU00446)
  • Compare Summary Reporting in Explain Strategies (LU00440)
  • Capture Threshold Values (CTV) for Action Procedures (LU00314)
  • zIIP Support for Unloads from Versioned Tables (LU00216)
  • Enhanced Data Collection for Recover Statistics in Automated Dropped Object Recovery (LU00165)
  • Support for LISTDEF in RUNSTATS Action JCL (LU00145)
  • Keep Recovery Simulation Shadow Data Sets (LU00135)
  • Bypass the Extract File (LU00131, LU00132, LU00133)
  • Interval Delta Processing for IFCID 148 (SO16300)
  • Support for New Fast Index Traversal Metric (SO16270)
  • Online Execution Mode is Discontinued in CA Database Analyzer(SO16205)
  • zIIP Support for Unloads from Image Copies (SO16194)
  • zIIP Support for Loads with OUTPUT-CONTROL ALL and REORG (SO16090)
  • Increased Number of Intervals for Data Stores (SO16175 for CA Subsystem Analyzer, and SO16173, SO16174 for CA Detector)
  • VTAM Data Stream Compression Support (SO16116)
  • DB2L Batch Execution Support (SO15980)
  • Enhanced IUIBATCH Support (SO15952)
Improved Performance for Batch Unloads (LU00565)
CA Detector® for DB2 for z/OS
now provides better performance when the PDTBATCH job is used with NORMALIZE=Y to unload collection data from the data store. For more information about this enhancement, see CA Detector New Features.
Monitor ECSA Storage Availability (LU00523)
Xmanager can now monitor the amount of ECSA storage that is in use. If the used storage exceeds your specified percentage, Xmanager terminates any active
CA Detector® for DB2 for z/OS
data collections to free up storage space. For more information about this parameter, see Value Pack Enhancements.
Support for Db2 V12R1M509 (LU00277, LU00304)
Db2 12 function level and catalog level V12R1M509 support is now available. The
CA Database Management Solutions for DB2 for z/OS
are usable on Db2 12 subsystems with the function level activated and with an updated catalog (maintenance applied).
However
, you may not be able to use the new features in the function level. For feature support in each function level, see the product-specific enhancement documentation. For more information about the supported function levels, see Db2 Version Support.
Partition-Level DSSIZE PBR2 Alteration Support (LU00446)
CA RC/Migrator™ for DB2 for z/OS
(CA RC/Migrator),
CA RC/Compare™ for DB2 for z/OS
(CA RC/Compare), and
CA RC/Update™ for DB2 for z/OS
(CA RC/Update) have been enhanced to provide partition-level DSSIZE alteration support for PBR2 tablespaces and indexes. For PBR2 objects, the following statements are now also supported:
  • ALTER TABLESPACE PART DSSIZE
  • CREATE INDEX DSSIZE
  • ALTER INDEX DSSIZE
This support includes the syntax checker, compare rules, global changes, incremental change language (ICL), and recovery scenarios. For more information about these new features, see CA RC/Migrator and CA RC/Compare New Features or CA RC/Update New Features.
Compare Summary Reporting in Explain Strategies (LU00440)
CA Plan Analyzer® for DB2 for z/OS
has a new Compare History function and Compare Summary report that enhances your ability to identify changes to access paths and SQL costs in your Db2 subsystems. When you use the new Compare History function in your explain strategies, the compare results are collected and saved. You can use the Explain Strategy Services to generate a Compare Summary report from the saved comparison data. This report helps you identify statement access paths with performance degradation, and access paths with improved performance that can benefit from a rebind.
For more information about these new features, see CA Plan Analyzer New Features.
Capture Threshold Values (CTV) for Action Procedures (LU00314)
CA Database Analyzer™ for DB2 for z/OS
now lets you capture the threshold (condition) values of database objects that are selected for actions, based on the conditions in action procedures that are tied to an extract procedure with Real Time Object Selection (RTOS). Previously, you could only capture threshold values for objects that are selected by extract procedures. Now, you can capture threshold values that trigger action procedures that are tied to an extract procedure.
For more information, see CA Database Analyzer New Features.
zIIP Support for Unloads from Versioned Tables (LU00216)
CA Fast Unload® for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from versioned tables. Previously, zIIP support was not available for unloads from rows in multiple tablespace versions. Now, zIIP support is provided for versioned tables. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
For more information, see CA Fast Unload New Features.
Enhanced Data Collection For Recover Statistics in Automated Dropped Object Recovery (LU00165)
The Automated Dropped Object Recovery (ADOR) feature for
CA Log Analyzer™ for DB2 for z/OS
can now recover Db2 statistics for implicitly created tablespaces, tables, and indexes.
For more information, see CA Log Analyzer New Features.
Support for LISTDEF in RUNSTATS Action JCL (LU00145)
CA Database Analyzer™ for DB2 for z/OS
now supports the use of LISTDEF to execute RUNSTATS against a list of objects in
one
step. The generated action JCL contains a LIST keyword followed by the LISTDEF statement for each RUNSTATS control statement. A new model member (MJULDRS) and new automatic symbolics are provided to create action JCL to execute RUNSTATS on the objects defined in a LISTDEF. You can use LISTDEF to allow for greater concurrency during executions.
For more information, see CA Database Analyzer New Features.
Keep Recovery Simulation Shadow Data Sets (LU00135)
You can now choose to keep the shadow data sets that are created for a recovery simulation. By default, these data sets are deleted automatically after the simulation completes. However, the new KEEP-SIMULATION-SHADOWS keyword lets you preserve them. Keeping these data sets allows you to view the simulated recovery output and compare it to the active Db2 data sets. For more information, see CA Fast Recover New Features.
Bypass the Extract File (LU00131, LU00132, LU00133)
You can now bypass the extract file in the
CA Log Analyzer™ for DB2 for z/OS
reports and pass the data directly from the log extract process to the report generation process. Bypassing the extract file reduces EXCPs, reduces CPU time, and reduces elapsed time of the report generation process.
For more information, see CA Log Analyzer New Features.
Interval Delta Processing for IFCID 148 (SO16300)
CA SYSVIEW® Performance Management Option for DB2
adds interval delta processing support for IFCID 148.
A new IQL request THRDEXCP populates two new IQL-based exceptions, THDNOCMT and THRDLOOP.
For more information, see CA SYSVIEW for DB2 New Features.
Support for New Fast Index Traversal Metric (SO16270)
CA SYSVIEW® Performance Management Option for DB2
adds a new counter to IFCID 389 for the number of index traversals in the last interval.
For more information, see CA SYSVIEW for DB2 New Features.
Online Execution Mode is Discontinued in CA Database Analyzer (SO16205)
As previously announced,
CA Database Analyzer™ for DB2 for z/OS
extract, report, and execution procedures must now be submitted in batch mode.
For more information, see CA Database Analyzer New Features.
zIIP Support for Unloads from Image Copies (SO16194)
CA Fast Unload® for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from image copies. Previously, zIIP support was only available for INPUT-FORMAT TABLE. Now, zIIP support is provided for all INPUT-FORMAT values.
For more information, see CA Fast Unload New Features.
zIIP Support for Loads with OUTPUT-CONTROL ALL and REORG (SO16090)
CA Fast Load for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) with all OUTPUT-CONTROL values (ALL, BUILD, or REORG) when you specify DATA-AVAILABLE NORMAL or HIGH. Previously, zIIP support was only available for OUTPUT-FORMAT BUILD. Now, zIIP support is provided for all OUTPUT-CONTROL values.
For more information, see CA Fast Load New Features.
Increased Number of Intervals for CA Subsystem Analyzer Data Stores (SO16175)
You can now specify more intervals when creating a
CA Subsystem Analyzer for DB2 for z/OS
data store. Previously, you were limited to 999 intervals. This limit has been increased to 9,999. The ability to create a data store with more intervals lets you save smaller slices of data for more granular troubleshooting.
For more information, see CA Subsystem Analyzer New Features.
Increased Number of Intervals for CA Detector Data Stores (SO16173, SO16174)
You can now specify more intervals when creating a
CA Detector® for DB2 for z/OS
data store. Previously, you were limited to 999 intervals. This limit has been increased to 9,999. The ability to create a data store with more intervals lets you save smaller slices of data for more granular troubleshooting.
For more information, see CA Detector New Features.
VTAM Data Stream Compression Support (SO16116)
Support has been added in CA SYSVIEW for DB2 to specify the VTAM data stream compression option for the Remote Access Facility environment.
A new system parameter VTAM-COMPRESS controls the compression of the data that is sent from the data collector to the user interface.
For more information, see CA SYSVIEW for DB2 New Features.
DB2L Batch Execution Support (SO15980)
You can now execute the DB2L command in batch using the .CALL Batch Processor command. The DB2L command displays the continuous delivery (catalog and function) level runtime values. The command also shows the values that have been specified for a Db2 subsystem in the SETUP global parmlib member. These values must be in sync with the runtime values. You can use these values to identify mismatched SETUP and runtime values more easily and help prevent Db2 connection errors. DB2L is a global command that you can use from almost every product panel within the CA Database Management Solutions for DB2 for z/OS. With this enhancement, you can also now execute the DB2L command in batch using the Batch Processor interface. For example:
.CALL DB2L .DATA
ssid
ssid
.ENDDATA
If the .DATA and .ENDDATA statements are not specified, the
ssid
value from the .CONNECT statement is used. For example:
.CONNECT
ssid
.CALL DB2L
For more information about the Batch Processor interface, see Use the Batch Processor.
Enhanced IUIBATCH Support (SO15952)
The CA SYSVIEW for DB2 Batch User Interface program IUIBATCH now supports commands CHECK and UNLOAD.
For more information, see CA SYSVIEW for DB2 New Features.
New Features (Winter 2020)
The following list summarizes the enhancements that we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
from fall to winter 2020:
  • CREATE TABLESPACE INSERT ALGORITHM Support (SO15804, SO15805, SO15806, SO15807)
  • Detect IBM Utility Usage During a Copy (SO15709, SO15710, SO15711)
  • Support for New Remote Location Fields (SO15647)
  • Support for PBR RPN (PBR2) Tablespaces (SO15482)
  • Recovery Estimator Support (SO15312, SO15313, SO15314, SO15311)
  • Support for Db2 V12R1M508 (SO15031, SO15235, SO15236, SO15237, SO15238)
  • Alter KEYLABEL in DDL report (SO15220)
  • DSNZPARM Support (SO15132, SO15868)
  • Support for New Disk Cache Fields (SO15070)
CREATE TABLESPACE INSERT ALGORITHM Support (SO15804, SO15805, SO15806, SO15807)
Support has been added in
CA RC/Migrator™ for DB2 for z/OS
(CA RC/Migrator),
CA RC/Compare™ for DB2 for z/OS
(CA RC/Compare), and
CA RC/Update™ for DB2 for z/OS
(CA RC/Update) to generate the INSERT ALGORITHM clause in CREATE TABLESPACE DDL on Db2 12 subsystems V12R1M500 or higher.
For more information about this feature, see New Features in the CA RC/Migrator and CA RC/Compare, and CA RC/Update documentation.
Detect IBM Utility Usage During a Copy (SO15709, SO15710, SO15711)
CA Quick Copy for DB2 for z/OS
can now detect whether an IBM utility is processing an object before it creates an image copy of that object. This functionality is supported by all SHRLEVEL settings. The new functionality is available through the new PQC-IBM-UTILITY-DETECTION parameter in
hlq
.CDBAPARM(UTIL). When you execute a copy job, CA Quick Copy can check to see whether IBM LOAD or IBM REORG is processing the selected objects. If any of those objects are being processed, the job terminates and a list of the objects in use is written to the job log. Using the PQC-IBM-UTILITY-DETECTION parameter helps you avoid potential conflicts, such as incorrect RBA values. For more information, see CA Quick Copy New Features.
Support for New Remote Location Fields (SO15647)
CA SYSVIEW® Performance Management Option for DB2
now supports new Db2 12 remote location fields. New fields were added to the trace records (001) STATS1, (1001) CURR-STATS1, and (365) RECORD-LOCATION. New fields were also added to the exception system. Reports have been updated. For more information, see CA SYSVIEW for DB2 New Features.
Support for PBR RPN (PBR2) Tablespaces (SO15482)
CA Fast Load for DB2 for z/OS
now supports partition-by-range relative page numbering (PBR RPN). IBM Db2 12 introduced PBR RPN (known as PBR2) to separate the partition number from the page number. This separation provides greater flexibility in partition processing. For more information, see CA Fast Load New Features.
Recovery Estimator Support (SO15312, SO15313, SO15314, SO15311)
CA Database Management Solutions for DB2 for z/OS
can now estimate the recovery time for Db2 objects. With the recovery estimator, you can verify that your recovery service level agreements (SLAs) can be met, as well as fine-tune your recovery strategies. To use the recovery estimator, use the new control statement RECOVER-TOOL ESTIMATE-RECOVERY in your batch jobs. For more information about this feature, see Use the Recovery Estimator.
Support for Db2 V12R1M508 (SO15031, SO15235, SO15236, SO15237, SO15238)
Db2 12 function level and catalog level V12R1M508 support is now available. The
CA Database Management Solutions for DB2 for z/OS
are usable on Db2 12 subsystems with the function level activated and with an updated catalog (maintenance applied).
However
, you may not be able to use the new features in the function level. For feature support in each function level, see the product-specific enhancement documentation. For more information about the supported function levels, see Db2 Version Support.
Alter KEYLABEL in DDL report (SO15220)
The
CA Log Analyzer™ for DB2 for z/OS
(CA Log Analyzer) DDL Report can now report changes that come from ALTER statements that modify the KEYLABEL values of Db2 tables and storage groups. ALTER statements that modify KEYLABEL values are introduced with IBM Db2 for z/OS function level V12R1M502. For more information about this feature, see the CA Log Analyzer documentation.
DSNZPARM Support (SO15132, SO15868)
The Thread Termination\Dynamic DSNZPARM value pack component has added support for various Db2 12 and Db2 11 DSNZPARMs. For more information, see Value Pack Enhancements.
Support for New Disk Cache Fields (SO15070)
CA SYSVIEW for DB2 has added support for the following new fields in the (003) ACCT, (148) THREAD-STATS, (369) CONNECTION-STATS, and (1044) APM-APPL-SUM trace records: DISK-CACHE-IO-WAIT and DISK-CACHE-IO-COUNT. For more information, see CA SYSVIEW for DB2 New Features.
New Features (Fall 2020)
The following list summarizes the enhancements that we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
from summer to fall 2020:
  • Control Frequency of SQL Statistics Collection (SO14923)
  • Support for CICS Transaction Server (CTS) (SO14864)
  • zIIP support for OUTPUT-CONTROL BUILD (SO14771)
  • ALTER support for PAGENUM RELATIVE (SO14832)
  • Support for new system parameters (SO14754)
  • Support for unload from remote Db2 (LUW) RDBMS (SO14381)
  • SQLCODE reporting and chart support (SO14491)
  • Zowe API Mediation Layer conformance (SO14401)
  • Capture Threshold Values (CTV) of objects selected by RTOS (SO14174)
  • Post-install enhancement to support non-Db2 for z/OS binds (SO14028)
  • GENERATED ALWAYS non-deterministic expression column support (SO14125)
  • CA Mainframe Operational Intelligence instance identifier (SO14164)
  • Export to CSV support in Mainframe Team Center (SO14168)
  • Support for Huffman Compression (SO14029)
  • Support for new Db2 IFCID changes (SO14099)
  • New trace records for Db2 Accelerator Version 7 (SO13891)
  • DevOps for Db2 schema management enhancements (SO13807)
  • Enhanced support for TEMPLATE statements (SO13764)
  • Support for Db2 V12R1M507 (SO13706, SO13574)
  • PREVIEW SIMULATE keyword enhancements (SO13586)
  • Support for Recovering Identity Column Sequence Values in Automated Dropped Object Recovery (SO14613)
  • Enhanced Automated Dropped Object Recovery (SO14137)
  • Enhanced Data Collection For Recover Statistics in Automated Dropped Object Recovery (SO14865)
Control Frequency of SQL Statistics Collection (SO14923)
A new CA SYSVIEW for DB2 system parameter HIST-SQL-MULTIPLE allows you to decrease the collection frequency of SQL statistics in relation to subsystem statistics collection. The SQL statistics are based on IFCIDs 316/1043 and 401/1041. You can now size the interval according to the needs of your environment, collect SQL statistics less often, and therefore optimize the resource consumption.
More information:
Support for CICS Transaction Server 5.6 (SO14864)
CA SYSVIEW for DB2 now supports the CICS Transaction Server (CTS) 5.6.
More information:
zIIP Support for OUTPUT-CONTROL BUILD (SO14771)
CA Fast Load now supports the use of the IBM System z Integrated Information Processor (zIIP) when you specify OUTPUT-CONTROL BUILD. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs. zIIP functionality is enabled by default and controlled when you specify ZIIP {YES|NO} in the SYSIN DD statement or PFL-ZIIP {YES|NO} in
hlq
.CDBAPARM(UTIL).
More information:
ALTER Support for PAGENUM RELATIVE (SO14832)
In CA RC/Migrator, CA RC/Compare, and CA RC/Update, you can now generate DDL on a Db2 12 subsystem that contains the PAGENUM RELATIVE clause in ALTER TABLESPACE statements for partition-by-range tablespaces using relative page numbering (PBR2 tablespaces). The PAGENUM option specifies the type of page numbering to use for a range-partitioned tablespace. Valid values are A (absolute) or R (relative). Relative page numbering provides more flexibility and availability and higher limits in partition growth.
More information:
Support for New System Parameters (SO14754)
CA SYSVIEW for DB2 has added support for the new Db2 system parameters: STATIME_MAIN, DISALLOW_SSARAUTH, and UTILS_BLOCK_FOR_CDC. New options were added for the system parameters QUERY_ACCEL_OPTIONS and INDEX_MEMORY_CONTROL. Reports have been updated.
More information:
Support for Unload from Remote Db2 (LUW) RDBMS (SO14381)
You can now unload data from a Db2 (LUW) Relational Database Management System (RDBMS) with
CA Fast Unload® for DB2 for z/OS
under Distributed Relational Database Architecture (DRDA). The DRDA protocol supports seamless integration of distributed relational DBMS systems. You must configure CA Fast Unload to unload data from a remote Db2 (LUW) RDBMS by defining the remote system in the communications database (CDB). You must also bind the product packages using the DRDA protocol.
More information:
SQLCODE Reporting and Chart Support (SO14491)
In the Mainframe Team Center - Database Management for Db2 for z/OS, you can now view the SQL return code (SQLCODE) that Db2 sets after each SQL statement is executed. Viewing this data lets you quickly determine which SQL errors are occurring most frequently and why you may be experiencing poor query performance. If needed, you can export the related SQL, SQLCA details, and SQL execution statistics to CSV format for further analysis.
Using this feature helps you:
  • Identify SQL performance degradations before they are moved into a production subsystem.
  • Review SQL errors as they are captured in real-time and share with the Database Administrator to find a solution.
  • Analyze the execution flow of your applications.
More information:
Zowe API Mediation Layer Conformance (SO14401)
The Database Management Data Service (DBM Data Service) has been updated to meet Zowe API Mediation Layer conformance criteria for the following product RESTful APIs:
  • CA Detector® for DB2 for z/OS
    (CA Detector)
  • CA SYSVIEW for DB2
The Zowe Conformance Program gives users confidence that when they use a product, application, or distribution that uses Zowe, they can expect a high level of common functionality, interoperability, and user experience. The Zowe API Mediation Layer consolidates mainframe RESTful API services into a single, secure point of access. To enable SSO, update the DBM Data Service configuration file to include the new APICAT_AUTH_SCHEME and APICAT_AUTH_APPLID parameters.
More information:
Capture Threshold Values (CTV) with RTOS (SO14174)
CA Database Analyzer™ for DB2 for z/OS
can now capture the threshold (condition) values of database objects that trigger actions based on the conditions in your Real Time Object Selection (RTOS) extract procedures. You can generate a Capture Threshold Values (CTV) report of the condition values that are met by your extract procedures. You can then tune your selection criteria to avoid unnecessary actions on objects and reduce your maintenance time. See CA Database Analyzer New Features
Post-Install Enhancement to Support Non-Db2 for z/OS Binds (SO14028)
The
CA Database Management Solutions for DB2 for z/OS
post-install tailoring process has been enhanced to let you specify remote DRDA locations for remote binds.
More information:
GENERATED ALWAYS Non-Deterministic Expression Column Support (SO14125)
CA RC/Migrator, CA RC/Compare, and CA RC/Update can now recognize non-deterministic expression clauses for GENERATED ALWAYS columns when migrating, altering, and comparing tables. A new option A, GENERATED ALWAYS AS (non-deterministic-expression), has been added to the Default indicator column attribute field on the table panels.
More information:
CA Mainframe Operational Intelligence Instance Identifier Change (SO14164)
CA SYSVIEW for DB2 has introduced a new system parameter, ZDM-PREFIX, which specifies the first four characters of the CA Common Services for z/OS (CCS) Data Mover instance identifier. This identifier uniquely identifies the CA SYSVIEW for DB2 data collector in the CA Mainframe Operational Intelligence infrastructure.
More information:
Export to CSV Support in Mainframe Team Center (SO14168)
You can now export Db2 object information or application performance data in CSV format by row, displayed table rows, or all rows. Doing so is useful for reviewing the table results offline or for providing the results to others. You can also import data into other applications such as Microsoft Excel.
More information:
Support for Huffman Compression (SO14029)
CA Database Management Solutions for DB2 for z/OS
tools now provide the following support for Huffman data compression:
  • CA Database Analyzer™ for DB2 for z/OS
    lets you collect statistics and view data pages with the Page Display Facility on Huffman encoded objects.
  • CA Fast Load for DB2 for z/OS
    can load Huffman encoded objects when the compression dictionary exists and KEEPDICTIONARY is specified.
  • CA Fast Recover™ for DB2 for z/OS
    can recover Huffman encoded objects.
  • CA Fast Unload® for DB2 for z/OS
    can unload from tables and image copies that contain Huffman encoded objects.
  • CA Log Analyzer™ for DB2 for z/OS
    can report Huffman encoded objects.
  • CA Rapid Reorg® for DB2 for z/OS
    can reorganize Huffman encoded objects when the compression dictionary exists and KEEPDICTIONARY is specified.
Support for New Db2 IFCID Changes (SO14099)
The following enhancements have been made in CA SYSVIEW for DB2:
  • New CA Mainframe Operational Intelligence instance identifier, ZDM-PREFIX
  • Support for new Db2 insert algorithm (IAG2) fields in the STATS2 (IFCID2), CURR-STATS2 (IFCID 1002), ACCT (IFCID 3), and THREAD-STATS (IFCID 148) Db2 trace records
  • Support for new RID list fields in the STATS2 (IFCID2), CURR-STATS2 (IFCID 1002), ACCT (IFCID 3), and THREAD-STATS (IFCID 148) Db2 trace records
  • Asynchronous cross-invalidation fields support in IFCID (0002) group buffer pool details and IFCID (0003)
  • Updated real-time and history online reports tutorial help
More information:
Added Trace Records for Db2 Accelerator Version 7 (SO13891)
Support has been added in CA SYSVIEW for DB2 Accelerator Version 7. New fields include details, such as replication with delay protocol that is reported on all monitoring levels.
More information:
DevOps for Db2 Schema Management Enhancements (SO13807)
New JCL templates, sample JCL, and a new PROC are now available in CA RC/Migrator and CA RC/Compare to let you perform DevOps for Db2 schema management.
The templates serve as building blocks for creating a DevOps pipeline and can be used as input to an Apache Velocity-compatible template engine. In a DevOps environment, Db2 teams can use the JCL templates to enable application developers to provision Db2 object changes without leaving the Integrated Development Environment (IDE) of choice.
The sample PROC and JCL are provided as an example JCL pipeline to promote Db2 objects from a source environment to a target environment. Db2 teams can also trigger Continuous Integration (CI) and Continuous Delivery (CD) pipelines for promoting Db2 schema changes across subsystems while preserving the database administrator's control over implemented changes.
More information:
Enhanced Support for TEMPLATE statements (SO13764)
CA Fast Load now supports the use of the TEMPLATE control statement and INDDN keyword to dynamically allocate SYSULD data sets without static JCL DD statements. You can use variables to define data set names, and set allocation parameters to automate, simplify, and standardize your load process. You can take advantage of a z/OS UNIX System Services (USS) pipe for improved performance by defining a USS file PATH name and associated parameters.
CA Fast Unload now supports the use of the TEMPLATE control statement PATH option to dynamically allocate the SYSREC, SYSDDL, and SYSCTL data sets without static JCL DD statements. You can take advantage of a z/OS UNIX System Services (USS) pipe for improved performance by defining a USS file PATH name and associated parameters.
More information:
Support for Db2 V12R1M507 (SO13706, SO13574)
Db2 12 function level and catalog level V12R1M507 support is now available. The
CA Database Management Solutions for DB2 for z/OS
are usable on Db2 12 subsystems with the function level activated and with an updated catalog (maintenance applied).
However
, you may not be able to use the new features in the function level. For feature support in each function level, see the product-specific enhancement documentation.
More information:
PREVIEW SIMULATE Keyword Enhancements (SO13586)
The PREVIEW SIMULATE keyword for CA Fast Recover has been enhanced to support FlashCopies and Concurrent Copies. You can now use these image copies in recovery simulation.
More information:
Support for Recovering Identity Column Sequence Values in Automated Dropped Object Recovery (SO14613)
The Automated Dropped Object Recovery (ADOR) feature for CA Log Analyzer can now recover the sequence of the identity column for a dropped object. If the object contains an identity column, ADOR attempts to recover the identity column to the value that was in use at the time of the drop.
Enhanced Automated Dropped Object Recovery (SO14137)
The following enhancements have been made to the Automated Dropped Object Recovery (ADOR) feature for CA Log Analyzer:
  • Taking an image copy after recovery is now optional. To take an image copy of the object after it is recovered, set the
    Image Copy After Recovery
    option to Y.
  • You can now take partition image copies by specifying the variable &PART in the
    Image Copy DSNAME
    option.
  • The ADOR job now returns 0 instead of 4 after the job successfully completes.
Enhanced Data Collection For Recover Statistics in Automated Dropped Object Recovery (SO14865)
The Automated Dropped Object Recovery feature (ADOR) job now collects the recovered Db2 statistics data in the UNDODDL step. The extra step CLCSTATS that read the Db2 log has been removed from the ADOR job.
New Features (Summer 2020)
The following list summarizes the enhancements that we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
from spring to summer 2020:
  • New administration capabilities in Mainframe Team Center (SO13484)
  • CA SYSVIEW for DB2 Omnibus enhancements (SO13557)
  • Cancel a Db2 thread by its thread token (SO13508)
  • BIND SERVICE statement support (SO13307)
  • Huffman compression detection support (SO13071)
  • Post-install tailoring enhancements (SO12851)
  • Enhanced automated dropped object recovery support (SO14137)
  • ON DELETE ADD EXTRA ROW support for ALTER TABLE (SO12933)
  • New quick migration batch only keywords (SO12904)
  • CA SYSVIEW for DB2 Omnibus enhancements (SO12769)
  • Real-time statistics report enhancements (SO12783)
  • Support for Db2 12 built-in scalar functions and alternate built-in function names (SO12650)
  • PROGAUTH support in plan reports (SO12367)
  • COMPRESS clause support for LOB tablespaces (SO12361)
  • New DISCARD-LIMIT-RESUME keyword (SO12525)
  • Mainframe Team Center ICSF key ring support (SO12323)
  • APPLCOMPAT support in future explains (SO12267)
New Administration Capabilities in Mainframe Team Center (SO13484)
The
Mainframe Team Center - Database Management for Db2 for z/OS
user interface has been enhanced to now retrieve information from the Db2 catalog and display it in the new Administration tab. From this tab, you can view Db2 object information for your active Db2 subsystems and environments. For example, database administrators, application developers, and other users can obtain information about Db2 objects they are writing SQL statements against such as table columns, available indexes, and associated views.
Application performance data is also now displayed under Performance in a single tab for the performance category you select. Select a row of data and drill down for more information. This action initiates a breadcrumbs list that you can use to navigate the data.
More information:
CA SYSVIEW for Db2 Omnibus Enhancements
The Omnibus solution contains the following enhancements:
  • Support for new and updated Db2 12 Resource Limit Facility (RLF) codes in the ACCT (IFCID 3) and THREAD-STATS (IFCID 148) Db2 trace records.
  • zHyperLink support
    Data set I/O and log activity reports were previously updated to show zHyperLink workload use. CA SYSVIEW for DB2 has now been further enhanced to fully support zHyperLink monitoring based on the most up-to-date version of related IFCID fields. You are now able to monitor and analyze zHyperLink exploitation, or estimate the potential benefits of zHyperLink workload use.
  • New FTP Statistics reports
  • Stabilized Dynamic SQL Display
More information:
Cancel Thread by Token Support (SO13508)
CA SYSVIEW for DB2 now supports thread cancellation using the thread token. Cancellation by token allows inactive threads to be canceled. If a thread token is available, the existing cancellation process now uses the thread token automatically.
The Thread Termination\Dynamic DSNZPARM value pack component now lets you specify a thread token to select a thread for cancellation. The ability to cancel a thread by its token is useful in situations where the thread token is the only unique identification for a Db2 thread.
This functionality is enabled through the new TOKEN parameter in the SET CANCEL and SET DB2CAN commands.
More information:
BIND SERVICE Statement Support (SO13307)
The CA Endevor® Software Change Manager Interface for DB2 for z/OS BIND batch processing now supports the BIND SERVICE statement. The BIND SERVICE (DSN) subcommand builds an application package that represents a Db2 REST service.
More information:
Huffman Compression Detection Support (SO13071)
During an RC/Merger MOVE analysis in CA RC/Migrator, we can now detect when Huffman compression is being used.
More information:
Enhanced DDL Activity Report Parameters
The DDL Activity report parameters in CA Log Analyzer can now generate only GRANT and REVOKE statements or BIND and REBIND statements. The ONLY option lets you generate reports that contain only BIND, REBIND, and FREE statements, or only GRANT and REVOKE statements.
More information:
Post-Install Tailoring Enhancements (SO12851)
The CA Database Management Solutions for Db2 for z/OS post-install tailoring process has been enhanced to ensure consistency when making edits and executing changes. New sort and find/locate commands enable you to quickly find and update subsystems when you are editing the SETUP global parmlib member.
More information:
Enhanced Automated Dropped Object Recovery Support (SO14137)
The Automated Dropped Object Recovery (ADOR) feature in CA Log Analyzer can now recover a LOB tablespace from image copies that are taken with the SHRLEVEL CHANGE parameter.
More information:
ON DELETE ADD EXTRA ROW Support for ALTER TABLE (SO12933)
CA RC/Migrator, CA RC/Compare, and CA RC/Update can now recognize the ON DELETE ADD EXTRA ROW clause when migrating, altering, and comparing temporal and history tables. Generated DDL includes the clause with the ADD VERSIONING statement when required for migrate, alter, and compare strategies on Db2 subsystems.
More information:
New Quick Migration Batch Only Keywords (SO12904)
You can now simplify the inclusion of related objects and global change specifications in a quick migration job in CA RC/Migrator. This simplification is provided through the new keywords QUICKME (explode all), QUICKMI (implode all), QUICKMIE (explode and implode all), and READGCS (use global change set).
More information:
CA SYSVIEW for Db2 Omnibus Enhancements (SO12769)
The following enhancements have been made to CA SYSVIEW for DB2:
  • New fields that are related to secondary latch contentions in the CURR-STATS2 (1002 IFCID) record.
  • New fields that are related to zHyperLink support in the STATS1 (IFCID 1) and CURR-STATS1 (IFCID 1001) Db2 trace records.
  • Support for new fields in the STATS1 (IFCID 1) and CURR-STATS1 (IFCID 1001) Db2 trace records.
  • Support for new command counts in the STATS1 (IFCID 1) and CURR-STATS1 (IFCID 1001) Db2 trace records for the DISPLAY, START, and STOP SERVICE commands, START and STOP CDDS commands, and DISPLAY, START, and STOP ML commands.
  • Dynamic SQL plan stability
  • New real-time and history reports showing Fast Traversal Block activity on the system.
  • RESTFUL API enhancement to display status of the request.
More information:
Real-Time Statistics Report Enhancements (SO12783)
The Tablespace Real-Time Statistics Report and Indexspace Real-Time Statistics Report in
CA RC/Query® for DB2 for z/OS
(CA RC/Query) have been updated to include the following columns respectively: UPDATESIZE, LASTDATCHANGE, GETPAGES, SYS_START, SYS_END, and TRANS_START (TS-RT) and GETPAGES, SYS_START, SYS_END, and TRANS_START (IX-RT).
More information:
Support for New Db2 12 Built-In Scalar Functions and Alternate Built-In Function Names (SO12650)
CA Bind Analyzer™ for DB2 for z/OS
,
CA Plan Analyzer® for DB2 for z/OS
, and
CA SQL-Ease® for DB2 for z/OS
now support several new scalar functions that were introduced in function level V12R1M505. These products also support the alternate names that were introduced for several preexisting built-in functions in function level V12R1M506.
More information:
PROGAUTH Support in Plan Reports (SO12367)
CA Plan Analyzer now supports the PROGAUTH column in the SYSPLAN table. The Plan List, Plan Detail, Plan/Package Utilities, and Identify Problem Plan/Packages reports have been updated. The values in this column indicate whether Db2 performs program authorization checking to determine whether it can execute a plan.
More information:
COMPRESS Clause Support for LOB Tablespaces (SO12361)
Support has been added in CA RC/Migrator, CA RC/Compare, and CA RC/Update to generate the COMPRESS clause for LOB tablespaces. Generated DDL includes the clause when required for migrate, alter, and compare strategies.
More information:
New DISCARD-LIMIT-RESUME Keyword (SO12525)
CA Fast Load for DB2 for z/OS
now gives you greater flexibility in managing discard processing when the DISCARDS limit is reached. The new DISCARD-LIMIT-RESUME keyword lets you specify whether the database object data and associated pageset status change when you specify RESUME YES. The new DISCARD-LIMIT-STATUS keyword lets you set a restrictive status on the tablespace and indexspace pagesets.
More information:
Mainframe Team Center ICSF Key Ring Support (SO12323)
The Mainframe Team Center user interface now supports the use of SSL certificates whose private keys are stored using the Integrated Cryptographic Services Facility (ICSF).
More information:
APPLCOMPAT Support in Future Explains (SO12267)
A new enhanced explain card, APPLCOMPAT, lets you specify application compatibility behavior for catalog or non-catalog SQL during a future explain.
More information:
New Features (Spring 2020)
The following list summarizes the enhancements that we have made to Version 20.0 since March 2019 when we transitioned from an incremental release to a continuous delivery release:
  • Explain Report enhancements for Db2 12 columns in DSN_STATEMNT_TABLE (SO12067)
  • Support for new Db2 12 UNLOAD privilege (SO12106)
  • IMPLICITLY HIDDEN ROWID column support (SO11966)
  • DISALLOW_SSARAUTH ZPARM support (SO11684)
  • Improved automatic calculation of ESTIMATED-INPUT (SO11848)
  • New Db2 Analytics Accelerator bind options (SO11807)
  • CA SYSVIEW for Db2 miscellaneous enhancements (SO11616)
  • Edit support for PXNPARM during Post-Install Customization (SO11608)
  • Swagger format support for RESTful APIs (SO11373)
  • REBIND phase-in package copy support (SO11129)
  • Incremental and FlashCopy image copy support in ADOR (SO11112)
  • Test Data Manager integration for data masking (SO11078)
  • Support for new format of DSVOLSER column (SO10817)
  • Function level M506 and M505 support (SO10662, SO11107)
  • Advanced trigger packages and CONCENTRATESTMT support (SO10712)
  • SHRLEVEL CHANGE and Partition Image Copy support in ADOR (SO10676)
Explain Report Enhancements for Db2 12 Columns in DSN_STATEMNT_TABLE (SO12067)
The Access Path reports, SQL Detail report, and historical database reports in CA Plan Analyzer now include more detail about APREUSE, APCOMPARE, and EXPLAIN_TYPE in the DSN_STATEMNT_TABLE explain table. Also, a new APREUSE Fail access path filter has been added to the explain option access path filters and to the identify problem SQL explain facility. This filter lets you eliminate SQL statements that do not meet the criteria of unsuccessful access path reuse.
More information:
Support for New Db2 12 UNLOAD Privilege (SO12106)
CA Fast Unload is now compatible with the new UNLOAD privilege that is introduced in Db2 12 function level V12R1M500.
More information:
IMPLICITLY HIDDEN ROWID Column Support (SO11966)
Support has been added in CA RC/Migrator, CA RC/Compare, and CA RC/Update to recognize the IMPLICITLY HIDDEN clause for explicitly hidden ROWID columns. DDL generates the clause when required for migrate, alter, and compare strategies on Db2 subsystems running at least function level V12R1M503.
More information:
DISALLOW_SSARAUTH ZPARM Support (SO11684)
IBM APAR PH01725/PTF UI66853 enables a new online Db2 12 for z/OS subsystem parameter (ZPARM) DISALLOW_SSARAUTH. This ZPARM controls the authorization of allied address spaces that are connecting to Db2. The default setting is NO, which preserves the existing behavior and requires no changes for allied address spaces. When set to YES, Db2 prevents the user address spaces from setting a Db2 address space as a secondary address space.
Version 20.0 of the CA Database Management Solutions for Db2 for z/OS is compatible with DISALLOW_SSARAUTH YES. However, you must apply the following maintenance
before
you change DISALLOW_SSARAUTH to YES:
  • SO10107 (CA Fast Unload)
  • SO10906 (CA SYSVIEW for Db2)
  • SO10907 and SO11684 (CA Database Management Solutions for Db2 for z/OS)
  • SO10908 (CA Detector)
  • SO11323 (CA Merge/Modify)
Improved Automatic Calculation of ESTIMATED-INPUT (SO11848)
CA Fast Load for DB2 for z/OS
now provides improved accuracy in the automatic calculation of the size of your input data sets.
More information:
New Db2 Analytics Accelerator Bind Options (SO11807)
You can now specify how long an IBM Db2 Analytics Accelerator for z/OS delays a static SQL query while waiting for the replication of committed Db2 data changes that occurred before Db2 ran the query. You can also specify the preferred target accelerator to use for queries that are accelerated. The new bind parameters are ACCELERATOR and ACCELERATIONWAITFORDATA.
More information:
Miscellaneous CA SYSVIEW for DB2 Enhancements (SO11616)
The following miscellaneous enhancements for are now provided in this solution:
  • Support for new Db2 11 and Db2 12 fields in IFCID 199.
  • Archive table migration utility (NSIGMIGA) enhancement to generate LOAD statements and IQL requests for all archive tables.
  • Support for asynchronous invocation of the Global Subsystem (GSS) CA Common Services component IMOD to write exceptions to the ILOG and the System Condition Monitor (SCM). A new option, CALL-GSS=AYSNC is used to activate this functionality.
  • Support for SWAP and SPLIT commands in the ISPF command line interface.
  • Support for new Db2 12 fields and a new system parameter in IFCID 106.
More information:
Edit Support for PXNPARM during Post-Install Customization (SO11608)
The post-install customization panels have been enhanced to allow editing of the Xnet startup parameters (PXNPARM) during customization of the Xnet Communications Server.
More information:
Swagger Format Support for RESTful APIs (SO11373)
The Database Management Data Service (DBM Data Service) RESTful APIs have been enhanced to use the latest version of Zowe when integrating with the API Mediation Layer. Also, the parameters in the DBM Data Service REST APIs have also been updated to remove redundancies, clarify use, and ensure consistency.
You can also now integrate the CA Detector REST APIs with the API Mediation Layer.
More information:
REBIND Phase-in Package Copy Support (SO11129)
CA Plan Analyzer now supports the rebind phase-in function, which allows Db2 to rebind and execute the same package concurrently.
More information:
Incremental and FlashCopy Image Copy Support in ADOR (SO11112)
The Automated Dropped Object Recovery (ADOR) feature in CA Log Analyzer has been enhanced to recover data from incremental image copies and FlashCopy image copies.
More information:
Test Data Manager Integration for Data Masking (SO11078)
You can now integrate
CA RC/Extract™ for DB2 for z/OS
(CA RC/Extract) with CA Test Data Manager (TDM) to mask data during an extraction while maintaining relational integrity and complex relationships. Data masking hides or obfuscates sensitive and classified data so that you can use the protected data without exposure during development, testing, and QA processes. To use this feature, you must be a licensed user of CA Test Data Manager.
More information:
Function Level M506 and M505 Support (SO10662, SO11107)
Db2 12 function level V12R1M506 and V12R1M505 support is now available. The
CA Database Management Solutions for DB2 for z/OS
are usable on Db2 12 subsystems with the function level activated and with an updated catalog (maintenance applied).
However
, you may not be able to use the new features in the function level. For feature support in each function level, see the product-specific enhancement documentation.
More information:
IQL Support for THRDACTV Thread Type Parameter (SO10739)
You can now use CA SYSVIEW for DB2 to write an IQL request that returns filtered threads. For example, all inactive threads. Previously, this task was only possible through an online request.
More information:
Advanced Trigger Packages and CONCENTRATESTMT Support (SO10712)
CA Plan Analyzer has implemented REBIND and FREE support for packages containing advanced triggers. Support is also provided for the new Db2 12 CONCENTRATESTMT BIND option.
More information:
SHRLEVEL CHANGE and Partition Image Copy Support in ADOR (SO10676)
In CA Log Analyzer, the automated dropped object recovery (ADOR) feature now lets you recover from partition image copies and from image copies that are taken with the SHRLEVEL CHANGE parameter. You can also recover from implicitly created objects.
More information:
New Customized Metrics Selection for CA Mainframe Operational Intelligence (SO10716)
CA Detector has been enhanced to let you select the metrics that you want to send to CA Mainframe Operational Intelligence from each Db2 subsystem.
More information:
Support for New Format of DSVOLSER Column (SO10626)
You can now unload from an image copy of a tablespace that uses the new DSVOLSER column format in the SYSIBM.SYSCOPY catalog table.
More information:
Use SYSLGRNX to Limit DDL Report Log Reading (SO10641)
You can use the SYSIBM.SYSLGRNX table information in CA Log Analyzer DDL reporting to limit log reading during initial log extraction for data sharing environments.alog table.
More information:
New Global Primary Command DB2L (SO10173)
When connecting to a Db2 subsystem, the SSIDVER and SSIDMODE values (or SSIDVERF and SSIDVERC values) in the SETUPxx parmlib member must match the run-time Db2 values. If they do not match, the connection fails.
A new global primary command DB2L has been added to display the DB2 12 continuous delivery levels (catalog level, function level, and previous highest level) of a subsystem. This command also displays the SSIDVERC/SSIDVERF or SSIDVER/SSIDMODE values as defined in the SETUPxx parmlib member.
Enhanced Support for Unload from Archive Tables (SO10174)
You can now use CA Fast Unload to unload archive tables from Db2 tablespaces and image copies when you specify SQL-ACCESS NONE or EXTENSION.
More information:
CA Plan Analyzer Support for Db2 12 SYSPACKAGE and SYSPLAN Columns (SO12067)
CA Plan Analyzer now supports the APREUSE_NO_FL, APREUSE_NO_TS, CONC_STMT, FUNCTION_LVL, and ORIGIN columns in the SYSPACKAGE table.
More information:
CA Plan Analyzer Support for Db2 11 SYSPACKAGE Columns
CA Plan Analyzer now supports the ARCHIVESENSITIVE, BUSTIMESENSITIVE, DESCSTAT, and SYSTIMESENSITIVE columns in the SYSPACKAGE table.
More information:
CA RC/Query Utility Execution Performance Improvements
CA RC/Query® for DB2 for z/OS
(CA RC/Query) has been enhanced with performance-related improvements to help reduce CPU consumption during utility execution. Enhancements include:
  • A new profile option, Utility Object Count in 1 Step, that lets you specify how many utility statements you want to include in each JCL execution step. This option can improve system performance when multiple objects are being processed.
  • The UNLOAD line command has been enhanced to now generate DSNUTILB to unload data instead of DSNTIAUL. You can also specify the DSNTIAUL line command to unload data using the DSNTIAUL utility.
More information:
RTOS Selection Improvements in CA Database Analyzer
The following
CA Database Analyzer™ for DB2 for z/OS
enhancements are now available:
  • Support for Persistent Read Only (PRO) status
    . You can now exclude PRO restricted status objects from your database management recommendations. Select the
    (TS) check for one or more Db2 statuses
    action condition and specify 'NOT PRO' for the condition value to exclude PRO objects.
  • Improved Action Conditions for reorg of Active Pages
    . You can now select objects with no active pages and with a specific number (or range) of active pages for reorg using IBM Db2 Real-Time Statistics (RTS). Select the (TS) RTS reorg number of active pages* or (IX) RTS reorg number of active pages* action condition to specify the condition value.
More information:
CA RC/Migrator REBIND Enhancement to Resolve Invalid SPROCS
CA RC/Migrator™ for DB2 for z/OS
(CA RC/Migrator) and
CA RC/Compare™ for DB2 for z/OS
(CA RC/Compare) can now resolve invalid SPROCs during REBIND processing. SPROCs can become invalid when upgrading Db2 and can impact performance. A REBIND, even when the package has not been invalidated, cleans up the invalid SPROCs.
More information:
Batch Processor Displays Db2 12 Function Level
The Batch Processor now displays the current Db2 12 function level during execution of the
CA Database Management Solutions for DB2 for z/OS
. When connected to Db2 12 subsystems, the Batch Processor now displays the current function level during analysis execution.
Partition Level DSSIZE Support for PBR2 Indexes
On Db2 12 subsystems, you can now generate DDL that contains the DSSIZE clause in CREATE INDEX statements. DSSIZE is valid for an index at the global and partition level on a tablespace with relative page numbering (PBR2). CA RC/Migrator, CA RC/Compare, and
CA RC/Update™ for DB2 for z/OS
(CA RC/Update) now support a DSSIZE value from 1 GB to 1024 GB for PBR2 indexes. Global-level and partition-level support is controlled by the Generate common partition specifications at global level option in the OFS parmlib member.
More information:
Support for Unloads with PBR RPN (PBR2)
CA Fast Unload now supports unload from a tablespace or image copy that uses partition-by-range relation page numbering (PBR RPN), known as PBR2. To use PBR2, specify SQL-ACCESS NONE.
More information:
Mainframe Team Center Enhancements
The Mainframe Team Center user interface has been enhanced to improve the look and feel of the UI. More enhancements have been made to the Db2 subsystem selection process.
More information:
CA Fast Unload New Capability to Unload from Catalog Image Copy
You can now unload from a full image copy of a catalog tablespace when you specify INPUT-FORMAT IMAGECOPY and SQL-ACCESS ONLY or EXTENSION with CA Fast Unload.
More information:
HDDL Support on Nested Routines
CA RC/Query now generates DDL when executing the HDDL line command on any Db2 object that has a relationship with a routine (stored procedure or function (UDF)). All stored procedure and function types are supported. DDL is extracted based on HDDL panel preferences for all referred and related routines, which lets you create a mirror image of the object on a target subsystem.
More information:
CA Detector Collection Overhead Reduction
Collection improvements have been made in
CA Detector® for DB2 for z/OS
to help reduce overhead during statistics collection and SQL activity data collection.
More information:
CA Fast Unload Enhancement to Use Same Value for COMMA and QUOTE
When using OUTPUT-FORMAT COMMA-DELIMITED in CA Fast Unload, you can now select the same value for COMMA and QUOTE or specify a blank for COMMA and QUOTE NONE.
More information:
Recovery Simulation
The
CA Fast Recover™ for DB2 for z/OS
PREVIEW keyword has been enhanced with the ability to simulate the recovery process so you can validate that the recovery is possible. An estimate of the run time for the recovery job is provided as part of the simulation. During the simulation, the image copy is recovered to a shadow data set. The recovered database objects remain untouched. For more information, see the description of the PREVIEW keyword in the
CA Fast Recover™ for DB2 for z/OS
documentation.
Support for REBUILD INDEX with SHRLEVEL CHANGE
In
CA Fast Recover™ for DB2 for z/OS
, you can now specify the SHRLEVEL keyword to control what object state indexes and tablespaces are set to when you use REBUILD INDEX. The following keywords have been updated to call
CA Rapid Reorg® for DB2 for z/OS
in support of this feature:
  • SORTSIZE
  • ESTIMATED-KEYS
  • SORTNUM
CA SYSVIEW for DB2 Enhancements
The following
CA SYSVIEW® Performance Management Option for DB2
(CA SYSVIEW for DB2) enhancements are now available:
  • Support for custom HTML templates for email alerts. You can create multiple HTML templates and then assign them to different destination groups.
  • The Batch Report Writer uses new parameter MBCCSID to support translation of SQL text encoded using a mixed byte CCSID.
  • The PassTicket configuration steps now explain how to log in to the VTAM user interface without having to type your password on the VTAM UI logon screen.
  • Support for new Db2 system parameters. The (106) DSNZPARM and (1006) CURR-PARMS trace records were updated to support new Db2 system parameters: TS_COMPRESSION_TYPE, ENCRYPTION_KEYLABEL, FLASHCOPY_XRCP, CDDS_MODE, CDDS_PREFIX, and REORG_TS_NOPAD_DEFAULT. The following reports were updated to include new values: ARCISDZ, BTSYSPRM, DSQPARMS, SYSPARMS, HSPARMS, and SYSPRLOG
  • Support for multiple application exception fields: QWAC_WORKFILE_CURR, QWAC_WORKFILE_MAX, QWAX_PIPE_WAIT, QWAX_PIPEWAIT_COUNT, QWAX_LOBCOMP, QWAX_LOBCOMP_COUNT, and QXSTSFND.
  • Support for multiple subsystem exception fields, in buffer pools statistics, log manager statistics, and EDM pool statistics.
  • Supports a new REST API call for canceling threads.
More information: