New Features

The following new product features and enhancements to existing features are now available in Version 20.0 of CA Database Analyzer:
cadadb220
The following new product features and enhancements to existing features are now available in Version 20.0 of
CA Database Analyzer™ for DB2 for z/OS
(CA Database Analyzer):
For a list of enhancements for all the
CA Database Management Solutions for DB2 for z/OS
, see New Features on the
CA Database Management Solutions for DB2 for z/OS
product documentation page. To request product enhancements, contact a product manager or post your request in the "Ideas" section of the Broadcom Mainframe Community.
Be sure to download all available maintenance to ensure availability of all features and fixes. Incremental updates cannot be installed selectively. Later increments have dependencies on earlier increments. For a list of available PTFs, access the Maintenance Grid (login required) on
Broadcom Support
Online. We recommend use of the CA SMP/E Internet Service Retrieval service to download maintenance and to keep current with all updates.
DBM 20 IR 8 is the last incremental update for Version 20.0. New features and fixes are no longer bundled in incremental PTFs. Instead, we have transitioned to a continuous delivery release model that provides individual PTFs for new product features and product fixes. For more information, see Transition to Continuous Delivery.
Support for LISTDEF in REORG Action JCL (LU01089)
CA Database Analyzer™ for DB2 for z/OS
now supports the use of LISTDEF to execute REORG (RO) against a list of objects. Previously, you could only execute Image Copy or RUNSTATS against the objects in a LISTDEF in one step. A new model member (MJULDRO) is provided to generate action JCL to execute REORG 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.
  • Reorgs of LOB tablespaces may be processed in separate steps.
  • The DISABLE_AUTO_IX_RO_SUPP parameter is ignored for this feature. Index REORGS are always suppressed when related tablespaces are selected. If one part of a partitioned table space is reorganized, then all corresponding NPIs are reorganized as part of the related tablespace REORG. Therefore, there is no need to generate a separate index REORG for NPIs.
To take advantage of this feature, specify
U
(Update) in the Job Generation Parms field on the Build Extract Procedures panel. Then specify
Y
(Yes) in the Order by Utility Codes field on the Job Generation Parms panel.
More information:
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.
To take advantage of this feature, specify
U
(Update) in the Job Generation Parms field on the Build Extract Procedures panel. Then specify
Y
(Yes) in the Order by Utility Codes field on the Job Generation Parms panel.
More information:
Capture Threshold Values (CTV) for Action Procedures (LU00314)
CA Database Analyzer now gives you the ability to capture the threshold (condition) values of database objects that are selected for actions based on the conditions in action procedures tied to an extract procedure with Real Time Object Selection (RTOS). Previously, you could only capture threshold values for objects selected by extract procedures. Now, you can capture threshold values that trigger action procedures tied to an extract procedure.
You can generate a CTV report of the condition values that are met by your RTOS extract procedures and the condition values that are met by action procedures tied to extract procedures. You can then tune your selection criteria to avoid unnecessary actions on objects and reduce your maintenance time. These statistics are maintained for a minimum of 13 months or a longer period that you specify.
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.
To take advantage of this feature, specify
U
(Update) in the Job Generation Parms field on the Build Extract Procedures panel. Then specify
Y
(Yes) in the Order by Utility Codes field on the Job Generation Parms panel. You can use the new LISTDEF_STEP_LIMIT parameter to control the number of objects that are processed per step when you execute RUNSTATS with a LISTDEF. The LISTDEF_STEP_LIMIT parameter can be specified in the PDA parmlib member or the MJULDRS model member.
More information:
Support for Online Execution Mode is Discontinued (SO16205)
As previously announced,
CA Database Analyzer™ for DB2 for z/OS
extract, report, and execution procedures must now be submitted in batch mode.
Capture Threshold Values (CTV) of objects selected by RTOS (SO14174)
CA Database Analyzer now gives you the ability to 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, then tune your selection criteria to avoid unnecessary actions on objects and reduce your maintenance time. For example, you can determine why a reorg is running too often, then update your criteria to reduce CPU time and the associated cost. These statistics are maintained for a minimum of 13 months, or a longer period that you specify.
Support for Huffman Compression (SO14029)
CA Database Analyzer™ for DB2 for z/OS
supports Huffman data compression that is introduced in IBM Db2 for z/OS function level V12R1M504. You can now collect statistics and view data pages with the Page Display Facility on Huffman encoded objects.
Support for Persistent Read Only (PRO) status (SO10041)
CA Database Analyzer now supports action conditions that are based on PRO restricted status. PRO status indicates that the object is in read-only status at the tablespace partition level.
You can exclude PRO objects by selecting the following tablespace action condition and specifying 'NOT PRO' for the condition value on the action conditions panel:
  • (TS) Check for one or more DB2 statuses
The exclusion of PRO objects can improve your recommendations for database management.
Improved Action Conditions for reorg of Active Pages (SO10041)
You now have greater flexibility in selecting objects for reorganizations based on the number of active pages using IBM Db2 Real-Time Statistics (RTS) and the default IBM settings for the DSNACCOX stored procedure. Previously, you could select objects with no active pages or you could select objects with a specific number (or range) of active pages, but not both. Now, you can do both.
The following tablespace and indexspace action conditions can be used to select objects for reorganizations based on the number of active pages:
  • (TS) RTS reorg number of active pages*
  • (IX) RTS reorg number of active pages*
For example, with the preceding conditions you can now select objects with no active pages with the predicate 'IS NULL)', select objects with more than five active pages with the predicate '> 5)', or select both with the predicate 'IS NULL OR NACTIVE > 5)' for the condition value.
We recommend that you copy the CA Extract Default Procedures (RTOS$R$C) to your
site
Extract Default Procedures (RTOS$_$S) to maintain any customization. The CA defaults can change in the future because of Db2 changes or user requested enhancements.
Db2 Version Support
IBM Db2 12 for z/OS function levels V12R1M100, V12R1M500, and V12R1M
nnn
are now supported.
Version 20.0 of CA Database Analyzer supports the IBM Db2 12 Continuous Delivery Model, which introduces new features in the maintenance stream for faster adoption. Customers who are moving to Db2 12 should upgrade to Version 20.0. In Version 19.0,
only
V12R1M100 for migration from Db2 11 and function level V12R1M500 are supported for Db2 12.
More information:
New Action Conditions for DSNACCOX
CA Database Analyzer now provides six new action conditions that use IBM Db2 Real-Time Statistics (RTS) to help you maintain your databases. These new action conditions use the default IBM settings for the DSNACCOX stored procedure. You can add these action conditions to your action procedures to provide improved recommendations for database maintenance.
The following tablespace conditions are now available and can be used at the partition level:
  • (TSP) RTS DSNACCOX full image copy
  • (TSP) RTS DSNACCOX incremental image cpy
  • (TSP) RTS DSNACCOX RUNSTATS recommended
The following indexspace conditions are now available and can be used at the partition level:
  • (IXP) RTS DSNACCOX full image copy
  • (IXP) RTS DSNACCOX REORG recommended
  • (IXP) RTS DSNACCOX RUNSTATS recommended