New Features Introduced under Incremental Release

The following features were delivered with Version 20.0 of the CA Database Management Solutions for Db2 for z/OS under the Incremental Release model. The solution suite has transitioned to the Continuous Delivery (CD) release model. For a list of new features delivered in the CD model, see New Features.
2
2
Transition to Continuous Delivery
After DBM 20 GA IR 8, we have transitioned from an Incremental Release model to a Continuous Delivery (CD) release model. The CD model provides new product features as individual PTFs, separate from product fixes providing more flexibility to select which service stream elements you want to apply (see new features above). You are not required to apply all new features in the CD release model; however, we strongly recommend that you stay current with new features and maintenance. SMP/E dependencies still apply when selectively applying maintenance.
More information:
DBM 20 GA IR 8 (March 2019)
The following enhancements are now available in solution DBM 20 GA IR 8:
  • Post-install and common enhancements:
    • Snapshot General Services has improved performance and provided CPU time reduction when using z/OS DFSMSdss services as a copy method. To benefit from this enhancement, enable the DFSMSdss copy method by specifying USEDFDSS(YES) in the TG10INIT subsystem initialization job.
      More information:
    • CREATE DDL, generated by the
      CA Database Management Solutions for DB2 for z/OS
      , is still executable for the following deprecated objects on a Db2 12 subsystem running V12R1M504:
      • Simple tablespaces (SEGSIZE=0, PARTITIONS=0)
      • Segmented tablespaces (SEGSIZE greater than 0, PARTITIONS=0)
      • Traditional index controlled partitioned tablespace (ICP) (SEGSIZE=0, PARTITIONS greater than 0)
      • Traditional table controlled partitioned tablespace (TCP) (SEGSIZE=0, PARTITIONS greater than 0)
      • Synonyms
      Affected products include
      CA Log Analyzer™ for DB2 for z/OS
      (CA Log Analyzer),
      CA RC/Compare™ for DB2 for z/OS
      (CA RC/Compare),
      CA RC/Migrator™ for DB2 for z/OS
      (CA RC/Migrator),
      CA RC/Query® for DB2 for z/OS
      (CA RC/Query), and
      CA RC/Update™ for DB2 for z/OS
      (CA RC/Update).
  • CA Fast Unload enhancements:
    • Support for common table expressions has been added when you specify SQL-ACCESS ONLY or EXTENSION. Common table expressions are specified by a WITH clause that precedes the SELECT statement.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Multiple IQL reports were enhanced to report the computation of the aggregated DB2 service wait time, detailed statistics, and event counts.
    • Multiple remote location reports were enhanced to use metrics CONVERSATIONS-SENT (QLSTCNVS) and CONVERSATIONS-RECEIVED (QLSTCNVR).
    • The PKG-RLIMIT-TYPE field in the (003) ACCT trace record was updated to support the new value 16 Limit.
    • Additional authorization error messages are now printed into the data collector job log for simplified analysis of authorization issues.
    • The list of user ABEND codes was added to the product documentation.
    More information:
KEY LABEL Clause Support (February 2019)
You can now generate DDL that contains the KEY LABEL or NO KEY LABEL clauses on DB2 subsystems running at DB2 12 function level M502 (V12R1M502) or higher:
  • CREATE STOGROUP
  • CREATE TABLE
This support is provided in CA RC/Migrator, CA RC/Compare, and CA RC/Update.
Two new utility models are provided:
  • OREORGKL (KEY LABEL online IBM REORG)
  • OREORGKR (KEY LABEL online IBM REORG for Recovery)
Both utilities use a new automatic symbolic, CDSN, as the prefix of the image copy data set names in the respective TEMPLATE statements.
More information:
CA SYSVIEW for DB2 RESTful API (January 2019)
CA SYSVIEW for DB2 uses the Database Management Data Service (DBM Data Service) microservice to access DB2 data collected by CA Database Management Solutions for DB2 for z/OS through Xnet and Xmanager services. Mainframe and non-mainframe applications can use the DBM Data Service with the new CA SYSVIEW for DB2 RESTful API to access the collected data.
More information:
DBM 20 GA IR 7 (January 2019)
The following enhancements are now available in solution DBM 20 GA IR 7:
  • CA Fast Recover enhancements:
    Recoveries for objects with Db2 12 features will temporarily use the IBM RECOVER utility instead of the Log Apply phase. To ensure successful completion of your jobs, ensure that you use syntax compatible with IBM RECOVER.
    More information:
  • CA Fast Unload enhancements:
    • The new LONG-CHAR option has been added to the PFU parmlib member to allow unloading VARCHAR columns larger than 255 bytes into CHAR fields.
    • The enhanced LOAD-CONTROL keyword allows generation of free-form load control statements to reload data using
      CA Fast Load for DB2 for z/OS
      (CA Fast Load) or Db2 LOAD.
    More information:
  • CA Log Analyzer enhancements:
    • New PLA parmlib option PRE_ALLOCATE (E,x) that uses parallel tasks to reduce the elapsed processing time of your jobs when recalling archive log data sets.
      This enhancement is available as an individual PTF outside of the incremental update.
    • The behavior of SHRLEVEL (S)kip in the PLA parmlib member has been enhanced to process SHRLEVEL CHANGE image copies instead of skipping them when the PIT_RBA for the image copy in SYSIBM.SYSCOPY is lower than the log point of the first incomplete update within the same tablespace that the image copy was taken for.
    More information:
  • CA Quick Copy enhancements:
    • The EXCP NO copy engine has been enhanced to support PBR2 objects.
    • The new parmlib option PQC-SHRLEVEL-CHANGE-POLICY (
      NORMAL
      |STRICT) has been introduced to specify whether to continue processing SHRLEVEL CHANGE incremental image copies or to terminate with RC=8.
    More information:
  • CA RC/Migrator and CA RC/Update enhancements:
    • An RC/Merger move analysis now generates DATASET calls for groups of related objects, including implicitly created tablespaces, tables, and indexes in a single .CALL RCMERGER statement.
      This enhancement is available as an individual PTF outside of the incremental update.
    • The ON DELETE ADD EXTRA ROW clause is now supported when specified in the ALTER TABLE statement. When specified, an extra row is inserted into the history table when a row is deleted to record information about the delete operation itself.
    More information:
  • CA RC/Query enhancements:
    The encryption key (KEY LABEL clause value) is now displayed in the following reports:
    • Storage Group List (SG-L) and Storage Group Detail (SG-D)
    • Tablespace List (TS-L) and Tablespace Detail (TS-D)
    • Table List (T-L) and Table Detail (T-D)
    • Index List (I-L) and Index Detail (I-D)
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Introduces a new IQL Editor (Windows application) that helps you edit IQL files more easily.
    • The (225) STMG-POOL-SUMRY trace record was updated to include new fields related to discarded pages: DISCARDED-PAGES, DISCARDED-64BIT-SHR-DB2, DISCRD-64BIT-SHR-STK-DB2, and DISCARDED-64BIT-COM-DB2.
    • The (337) LOCK-ESCALATION trace record was updated with new field THREAD-TOKEN, which contains the token of the thread responsible for the lock escalation.
    • The (376) APPL-SQL-INCOMPAT trace record was updated. The field SYSIBM-CHAR-FUNC now supports new function codes: 1215031–Temporal table and 1215032–CALL Stored Procedure for replications.
    • A new secondary ID utilization trace report (AUDCLKRB) was introduced. This report shows the usage of Kerberos Principal Name.
    • DB2 message collection in GSS can now be deactivated.
    • The active thread type filter can now be used for any request whose name begins with the characters THRDACT.
    • In the thread history, Autonomous Stored Procedure accounting records are now marked with value A.
    More information:
DBM 20 GA IR 6 (November 2018)
The following enhancements are now available in solution DBM 20 GA IR 6:
  • CA Fast Recover has been enhanced to use 830 KB less main storage in the first 16 MB of the address space. This change allows more parallel tasks. To increase the number of parallel tasks, see MAXTASKS--Control the Number of Tasks in the CA Fast Recover documentation.
    More information:
  • CA Fast Unload has added a new LONG-CHAR option to allow unloading VARCHAR columns larger than 255 bytes into CHAR fields.
    More information:
  • CA Quick Copy has been enhanced with a new option for LARGE-TAPE-BLOCK keyword and UTIL parmlib option. The new AUTO option detects and uses the maximum block size available to a device. The YES option now functions the same as the AUTO option.
    More Information:
  • CA RC/Migrator enhancements:
    • Parallel unload/load support during recovery processing. The IBM UNLOAD recovery utility model (IBMULD_R) now generates a recover data set with &PART in it when &PART is added to &DATADSN. The LOAD_R utility model generates load data sets with &PART in the analysis file.
    • New RC/Merger move analysis videos that describe advantages and how to perform a data only copy.
    More information:
  • CA RC/Query can now generate DDL and HDDL that contains the KEY LABEL or NO KEY LABEL clauses in the CREATE/ALTER STOGROUP and CREATE/ALTER TABLE statements on DB2 subsystems running at DB2 12 function level M502 (V12R1M502).
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • The (319) SECURITY-AUDIT trace record was updated to include new security mechanism types for the following fields: FLAGS, SECURITY-TYPE, and SECURITY-MECHANISM. The BTSQLTRL and BTRECTRC reports were updated to include new values.
    • The batch report writer (NISGHTRW) now supports automatic switching for the Daylight Saving Time (DST). The new parameter SYSPARM DST-LOCATION decides if the time is summer or winter and whether one hour should be added or not.
    • The new exception variable &TTOKNXX was added to contain the value of thread tokens. In the application-based exceptions, &TTOKNXX can be used as the exception message text.
    • The data collector was enhanced to automatically display online history runtime statistics related to activity in the dynamic SQL text database when HISTORY-SQLTEXT YES is specified.
    • The amount of storage available for the collection of details about the activity of DB2 threads was increased to 128-MB to prevent data loss on busy subsystems that are monitored by a data collector.
    • The IQL exception EXCP0376 was modified to display only the statement ID and the statement number. To enable the tracking of individual statements by the statement ID, set the EXCP-LONG376 custom IQL variable to YES using IQL-DEFINE=(EXCP-LONG376=YES) in the system parameters.
    More information:
DBM 20 GA IR 5 (July 2018)
The following enhancements are now available in solution DBM 20 GA IR 5:
  • Post-install and common enhancements:
    • 8-byte TSO/E user IDs for z/OS 2.3 are now fully supported across all
      CA Database Management Solutions for DB2 for z/OS
      , including post-install processing.
    • The Object List Manager (OLM) utility now supports the base selection of objects by packages with
      PACKAGE
      collection.package.version
      .
    • Snapshot General Services now switch to DFSMSdss for encrypted data sets.
  • CA Bind Analyzer now supports Db2 12 SQL DML syntax FETCH NEXT and OFFSET in SUBSELECT, FULLSELECT, and SELECT INTO statements.
    More information:
  • CA Fast Unload enhancements:
    • New RECFM keyword is now provided to unload multiple tables into a single fixed-length, blocked (FB) data set.
    • The SHRLEVEL CHANGE keyword can now be used without Db2 authorization to quiesce or display tablespaces.
    More information:
  • CA Log Analyzer now supports FlashCopy image copies for reporting purposes.
    More information:
  • CA Plan Analyzer enhancements:
    • Db2 12 SQL DML syntax support is now provided for FETCH NEXT and OFFSET in SUBSELECT, FULLSELECT, and SELECT INTO statements
    • Db2 12 values in the PLAN_TABLE PRIMARY_ACCESSTYPE, COLUMN_FN_EVAL, and QBLOCK_TYPE columns are supported in the long and short access path reports.
    • The Db2 12 FUNCTION_LEVEL column is supported when CA Plan Analyzer creates the DSN_STATEMNT_TABLE.
    More information:
  • CA Quick Copy now supports segmented tablespaces through the Consistent Point-in-Time Service (CPITS). To process segmented tablespaces, DSNUM ALL is required with the CONSISTENT keyword (login required).
    More Information:
  • CA RC/Query has enhanced the ALL command to support the generation of utilities based on object type. For example, you can generate a Tablespace Table Inquiry report (TS-T) and then specify ALL DDL TS in the command line to generate DDL for tablespaces in the report. When you press Enter, the DDL command appears as a line command only next to the tablespace objects in the report.
    More information:
  • CA RC/Migrator and CA RC/Compare enhancements:
    • New rules are now available in CA RC/Compare for comparing MQT text. The new rules provide more precise control of MQT text comparisons. You can now ignore referenced object creators, referenced object names, or both when comparing two MQT versions. Unnecessary DROP/CREATEs are no longer generated.
    • Option 8 (Catalog PDS unload) on the CA RC/Migrator Expert Profile panel has been removed.
    More information:
  • CA Report Facility enhancements:
    • User ID can now be switched to a secondary user ID.
    • A new EXPORT command enables export of a report from the Generate Report screen to a sequential data set.
    • A new EXPORT REPORT TO command can be used in a procedure, to export a report to a sequential data set.
    More information:
  • CA SQL-Ease enhancements:
    • Db2 12 SQL DML syntax support is now provided for FETCH NEXT and OFFSET in SUBSELECT, FULLSELECT, and SELECT INTO statements.
    • Db2 12 values in the PLAN_TABLE PRIMARY_ACCESSTYPE, COLUMN_FN_EVAL, and QBLOCK_TYPE columns are supported in the long and short access path reports.
    • The Db2 12 FUNCTION_LEVEL column is supported when CA SQL-Ease creates the DSN_STATEMNT_TABLE.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • New Db2 11 and Db2 12 fields have been added to IFCID 002 (STATS2) and IFCID 106 (DSNZPARM).
    • The columns STATCLGSRT, ZHYPERLINK, and QUERY_ACCEL_WAITFORDATA have been added to the SUBSYS_ZPARM archive table.
    • Multiple IQL reports now use the Dynamic SQL Text Database.
      The "T-Text" line command in these reports now uses the Dynamic SQL Text Database to retrieve the SQL text. For dynamic statements the SQL text is retrieved from the DB2 dynamic SQL statement cache. If the statement is not available in the cache, the text is retrieved from the Dynamic SQL Text Database.
    • The "C-Cache" line command have been added to these reports to preserve the original functionality.
    • The exception system now supports three variables, which can be used as a destination group name: &AUTHIDX, &PLANNAM, and &CONNNAM.
    • A new MSGTRAP command allows you to create a dump when a specific message is issued.
    • The latest CICS transaction server levels are now supported.
    More information:
DBM 20 GA IR 4 (April 2018)
The following enhancements are now available in solution DBM 20 GA IR 4:
  • Common and post-install related enhancements:
    • The APPLCOMPAT BIND option setting in your Db2 environment is now always used to bind packages when executing the Bind Product Plans and Packages post-installation configuration task.
    • All SQL parser content has been moved from FMID CINSK00 to FMID CSQ2100 CA Common Services for DB2 for z/OS.
    • The common services Lexical Analysis and SQL parser now support Db2 12 syntax elements (FETCH FIRST clause, FETCH NEXT clause, OFFSET clause, LIMIT clause, and obfuscated statement in CREATE TRIGGER).
    More information:
  • CA Bind Analyzer, CA Plan Analyzer, and CA SQL-Ease enhancements:
    • More Db2 12 SQL DML syntax support is provided. SQL that contains this syntax can now be processed successfully.
    • Db2® Spatial Extender support is now provided.
    More information:
  • CA Database Analyzer support for new action conditions for DSNACCOX.
    This feature is enabled by adding the new action conditions to your action procedures to provide improved recommendations for database maintenance.
    More information:
  • CA Detector enhancements:
    • New Database Management Data Service (DBM Data Service) that enables access to the Db2 data and metrics that CA Detector collects.
    • New Mainframe Team Center - Db2 Performance Analysis user interface that lets you use a web browser to view and explore the Db2 application performance data that CA Detector collects. For implementation details, see the Mainframe Team Center documentation.
    • The oldest interval in a data store can now optionally be deleted when a new interval is to be recorded and the data store is full.
    • Collection restarting is now enabled automatically following abnormal termination of data collection.
    More information:
  • CA Fast Unload has added a new NULL-FILL option to fill data parts of null fields in the output records with specified data.
    This option applies to VARIABLE and DSNTIAUL output formats and all data types except for LOB and XML.
    More information:
  • CA Log Analyzer now supports tracking different versions of the same table with Dropped Object Tracking. You can report the tables with the DML Report.
    More information:
  • CA Merge/Modify has added the following new keywords to the MODIFY RECOVERY DELETE options to check the number of image copies and/or full image copies that are remaining for the objects:
    • MINIMUM-COPIES
    • MINIMUM-FULLCOPIES
    More information:
  • CA RC/Extract LOOKUP syntax has been enhanced with a new parameter (default column) that enables you to specify a default column when extracting data for load functions. When a match is not found for the source column, the value that is specified for default column is used for the load. The value for source column is used when this column is not specified. New syntax:
    LOOKUP(<tbcreator>,<tbname>,<srccol>,<trgincol>,<trgoutcol>,<default column>)
    This enhancement is available as an individual PTF outside of the incremental update.
    More information:
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Enhanced archive tables support.
    • An online reorg is now generated during analysis in CA RC/Migrator when limit key values are altered on partition tables.
    • The EXCLUDE/INCLUDE NULL KEYS clause is now supported for CREATE INDEX statements when using CA RC/Migrator, CA RC/Compare, and CA RC/Update. You can also use the Syntax Checker function in CA RC/Migrator to validate the CREATE INDEX syntax with these clauses.
    • Intelligent REBIND exclusion is now provided in CA RC/Migrator when an alteration occurs and the BIND/REBIND analysis options are specified (R, C, or V).
    • Additional archive table support is now provided in CA RC/Migrator, CA RC/Compare, and CA RC/Update.
    • The IBM UNLOAD model (IBMULD) now supports data type conversion from SMALLINT/INTEGER/BIGINT to CHAR/VARCHAR and from CHAR/VARCHAR to SMALLINT/INTEGER/BIGINT.
    • The DDL formatting for routines has been improved in CA RC/Migrator and CA RC/Update.
    More information:
  • CA RC/Query report enhancements:
    • Aliases that are created on sequences are now listed in the Alias List (A-L) report.
    • All catalog table columns are now included in the following list reports: Routine List (R-L), Permission and Mask List (PM-L), Table Column List (T-C), Table View List (T-V), and Tablespace Partition (TS-PL).
    • All catalog table columns are now included in the following detail reports: Routine Detail (R-D), Permission and Mask Detail (PM-D), Table Detail (T-D), View Detail (V-D), Index Detail (I-D), Column Detail (C-D), System Image Copy Detail (SY-IC), Package Detail (PK-D), and Database Detail (DB-D).
    • The I-C report has been enhanced to show the column order of IOEs correctly.
    More information:
  • CA Report Facility now includes support for long object names.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Can now start inactive menu selections when you select an option from the SYSTEM or THREAD menu and the underlying request was not included in the STARTUP member. The start panel is now shown instead of DBG55036W request not found.
    • Adds support for a new Db2 11 IFCID 406 (SYSTEM-PROFILE-MON) that contains the profile ID and the specific thread that is related for the following new values:
      • WARNING_DIAGLEVEL3
      • EXCEPTION_DIALEVEL3
      This record is used to identify threads that exceed the profile thresholds. The following reports were updated: RECTRACE and BTRECTRC.
    • Adds a new SYSPARM HSTSQLDB-DSN for a separate SQL history file has been added. This parameter contains the name of the new separate history file for SQL related data.
    • Now correctly evaluates comparisons of variable length string fields in the IQL WHERE clause.
    • Improves performance by changing the behavior of IQL exception EXCP0376 to raise the exception only for unique combinations of the package name and reason type. The same type of application incompatibilities for different statements within the same package now produces only one exception record.
      You can force the old behavior, which raises the exception for each statement by coding IQL-DEFINE=(EXCP-LONG376=YES) in the system parameter input.
    • Adds common fields to the Dynamic Where Field Index help. The common fields (the fields that are common to all Db2 trace records) are now listed with the IFCID 3 and the IFCID 151 fields.
    • Adds support for new SQL incompatibility batch reports on IFCID 376. The following reports have been added:
      • BTRINCMT (SQL Incompatibility Trace)
      • BTRINCMS (SQL Incompatibility Summary)
    • Thread selection presets are now available that allow you to save thread history selection criteria (presets) into a PDS member and later reload it. A new panel has been introduced.
    • Adds a new dynamic SQL history file and IQL functions STMT-CAPTURE and STMT-EXTRACT.
    • New Db2 12 fields have been added to IFCID 006 (READ-IO-ST) and IFCID 007 (READ-IO).
    • The IDB2ACCT reports have been redesigned to aggregate and report SQL details based also on the statement ID (STMT-ID).
      • A new option C (cache) has also been added to THRDIDSQ, HTIDBSQL, and HTUIDSQL to display detailed statistics from the dynamic or static SQL cache.
      • A new dynamic #IF statement has also been added (IQL-EXCLUDE-ACCEL) to remove the accelerator fields (AccelReq and AccelElapse) if the accelerator is not used. To suppress these fields, add the sysparm IQL-DEFINE=(IQL-EXCLUDE-ACCEL=YES).
    • IFCID 317 performance has been enhanced by using a smaller return area in the Db2 IFI call.
    More information:
  • CA Subsystem Analyzer has been enhanced to allow automatic restarting of collection (abend restart) following abnormal termination of data collection. This feature is enabled automatically.
    More information:
DBM 20 GA IR 3 (December 2017)
The following enhancements are now available in solution DBM 20 GA IR 3:
  • Common and post-install related enhancements:
    • The IBM Db2 12 Continuous Delivery model is now supported in the
      CA Database Management Solutions for DB2 for z/OS
      . To enable specification of the Db2 12 function and catalog levels for Db2 12 subsystems, the following new parameters have been added to the SETUPxx global parmlib member:
      • SSIDVERF for function level
      • SSIDVERC for catalog level
      After these parameter values have been specified during post-install processing, the Db2 function level displays as V12R1M500 or 121M500 on the product panels.
    • Toleration support is now provided for 8-byte user IDs with z/OS 2.3.
    • A new line command, U (Update) is now provided in RI Manager on NRS objects.
  • CA Fast Load has been enhanced to support online load replace.
    More information:
  • CA Fast Recover enhancements:
    • Added system level backup support. You can now use a system level backup as source to recover a single object. A new PFR parmlib keyword, USE-SYSBACKUP(YES|NO) is now provided. When set to YES and SLB entries exist in the BSDS, the system level backup entries are included in the chain of possible available recover bases.
    • SORTLOG YES OBIDXLAT, IC Pages must be in ascending order.
      Implementation: New internal check is now included to make sure that all pages read from the FULLDD must be in ascending order based on object and partition.
    More information:
  • CA Fast Unload enhancements:
    • ONE-SYSREC to support SYSREC01/SYSCT01 as fallback ddname
    • System pages are now tolerated in copies of tablespaces that contain unversioned tables when unloading these tables (UNLOAD from COPY system page found non-versioned table error)
    • New QUOTE-EMBED-SINGLE keyword
    More information:
  • CA Log Analyzer has been enhanced with a new option to generate application commits as part of DDL REDO reports. You can now apply commits after each unit of recovery (UR) in the DML REDO and UNDO SQL output for the DML Activity report. A new option, App. Commits (Y|N) is provided on the DML Activity Report Options panel to enable this feature. You must also select Order Output by Unit of Recovery ID.
    More information:
  • CA Merge/Modify enhancements:
    • A new PMM parmlib option, LGRNX-IBM, has been added. If set to YES, MODIFY
      DELETE calls the IBM utility internally to delete SYSLGRNX rows instead of using the two-phase approach.
    • You can now detect and remove ICTYPE=F and ICTYPE=I SYSIBM.SYSCOPY rows that refer to a non-existing data set. Use the new OR-DSNOTFOUND keyword option when you use MODIFY RECOVERY with the DELETE AGE, DELETE DATE, or DELETE KEEP options. When specified, you can delete all rows from SYSIBM.SYSCOPY that reference cataloged image copy data sets that do not exist.
    • Added copy-image copy system level backup support. The MERGECOPY component has been enhanced to create a copy of an image copy from system-level backup (SLB).
    • DSNUM Part support added to MODIFY component
    • The MODIFY RECOVER component has been enhanced to accept wildcards for DBNAME and TSNAME for DELETE AGE, DATE, and KEEP commands.
    • The MERGECOPY component has been enhanced to accepted wildcards for DBNAME and TSNAME for COPY-IMAGE-COPY command.
    More information:
  • CA Rapid Reorg has been enhanced to now support Reorg Pending Changes.
    More information:
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Migration toleration of base/archive table sets and improved handling of base/clone and base/history table sets in CA RC/Migrator.
    • Associated tables support is now provided in CA RC/Migrator. You can control selection and processing of base and associated (clone, history, and archive) tables in CA RC/Migrator strategies.
    • Partition level DSSIZE support for PBR2 tablespaces has been added in CA RC/Migrator. DSSIZE toleration support has been added at the partition level for relative page numbering tablespaces. You can now specify a DSSIZE of 1 GB to 1024 GB for a tablespace using relative page numbering.
    • Utility profile services support has been added for alterations that are pending changes in CA RC/Migrator.
    • Utility model enhancements:
      • Added support for unique data set names in utility models using the new DTQUAL qualifier.
      • TEMPLATE support is now used by default by all IBM utilities for allocating data sets. Support was also added for TAPE data sets.
      • Mutual exclusivity is now enforced between CA and IBM utilities when including and excluding.
    • The Db2 12 SYSTEM keyword is now supported in the CA RC/Migrator Syntax Checker function and when importing DDL in CA RC/Compare.
    • Isolation level support is now provided for RC/Browse and RI/Browse in CA RC/Update. CS and UR isolation level support has been added for all SELECT queries in RC/Browse and RI/Browse functions. Implement using the new profile option, Isolation Level support, and a new global option.
    More information:
  • CA RC/Extract now provides column level mapping support when performing load functions. A new M line command is now provided on the RXPTEDT Target Mapping panel where you can edit target definitions. When specified, the new Target Mapping Services panel is displayed for you to map the columns and specify mapping expressions (literals, column names, and IBM expressions and functions). A new line command, U (update) is also provided in RI Manager on NRS objects.
    More information:
  • CA RC/Query enhancements:
    • New clauses, INSERTVERSIONPAGES and SETCURRENTVERSION, are now supported in the REPAIR utility
    • CS and UR isolation level support has been added for all SELECT queries. A new RCQ parmlib member is now provided to set this setting at the global level.
    • DDL generation for implicit objects as comments using DDL or HDDL commands.
    More information:
  • CA Recovery Analyzer enhancements:
    • Added system level backup support. You can now select a System Level Backup RBA as a Recovery Point in the Global Options panel.
    • Recover Using Converted to RBA timestamp value
    More information:
  • CA Report Facility enhancements:
    • Added a new DRAW command to the EDIT NON-QUERY SQL screen to select all columns of a Db2 table.
    • The KEEP command now allows a table to be saved to a remote Db2 location.
    • A timestamp is now displayed for all objects on the library screens. The timestamp is updated for recently used objects with the current date and time whenever the corresponding object is browsed, modified, or executed.
    • A new SORT feature has also been introduced on the library screens that you can use to sort objects by column name in ascending or descending order.
    • The FORM command can now be used on the Query Result screen, which opens a temporary default form that can be saved.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • New lock types for Db2 12 are now supported in IFCID 21, 44/45, 150, 172, and 196.
    • Data can now be sent through the CA Common Services for z/OS Data Mover.
    • Added support for new Db2 11 and 12 fields in IFCID 366 (PREV10-CHAR-FUNC) and 376 (APPL-SQL-INCOMPAT):
      • The following fields were added: schema name, specific name, incompatible parameters, and SQL text.
      • The following reports were added or updated: EXCP0366, EXCP0376, INCOMPTD, HSTINCMD, HSTINCMP, HSUINCMP, RECTRACE, SQLTRACE, BTRECTRC, BTSQLTRL, HISTREQ, DCL$A$D, and MGSYSHST.
    • Updated the post-install tailoring panels to now include the ability to configure archive tables.
    • The user interface column filtering setting can now be stored in the second user profile data set.
    • Added support for latch statistics to online reports and archive table:
      • The following reports were added or updated: OLATCH, BTSTATR1, BTSTASM1, HSLATCH, and HSULATCH.
      • The following archive tables were updated: SUBSYSTEM_DETAIL and SUBSYSTEM_DAILY.
    • The data collector and batch report writer now support definition of custom IQL variables that can be used in the IQL #IF clause.
    • Added support for integration with CA Mainframe Operational Intelligence.
    • Enhanced the following real-time, history, and batch thread statistics reports to include the buffer pool hit ratio metric (Hit Ratio, BP-HITRATIO): THRDBUFD, HTBUFRS, HTUBUFRS, HTPKGBP, HTUPKGBP, BTACTSML, and BTACTTRL.
    • Added group buffer reclaim statistics (GRP-DIRENT-RECLAIM, GRP-XIDIR-RECLAIM, and GRP-DATENT-RECLAIM) to the SUBSYS_GBP_DETAIL and SUBSYS_GBP_DAILY archive tables.
    More information:
DBM 20 GA IR 2 (September 2017)
The following enhancements are now available in solution DBM 20 GA IR 2:
  • Common and post-install related enhancements:
    • The Object List Manager utility has been enhanced to now provide LISTDEF support in object lists. Implement this feature in CA Fast Recover, CA Merge/Modify, and CA Quick Copy using new keywords for the type restriction criteria: BASE and NOCLONE.
      More information:
    • New FMID Common SQL Services for DB2 for z/OS (SQ2) is now included with the CA Plan Analyzer dependencies. This enhancement includes the installation of a new plan and packages for SQ2.
      More information:
  • CA Fast Load has been enhanced to support the DATA-AVAILABLE HIGH keyword. This support minimizes object outages by introducing FASTSWITCH capabilities using a shadow data set. FASTSWITCH allows RO access to the object while CA Fast Load loads data into a shadow data set. When the data load completes, the instance prefix (I/J) is switched so that the shadow data set becomes the primary object and the original primary data set is deleted.
    More information:
  • CA Log Analyzer has been enhanced to provide DML filter expression support in strategy services.
    More information:
  • CA RC/Migrator and CA RC/Compare enhancements:
    • Archive tables are now supported in CA RC/Migrator to migrate base tables and associated archive tables. Support has also been added to the online panels to view base and associated pairs for clone, history, and archive tables.
    • Other pending changes are now supported through the utility profile services component in CA RC/Migrator. A new row, OTHER PENDING CHANGE, is now provided for tablespace, table, and index alterations. When the supported pending change alteration does not have its own specific row, the new row is used to determine what utilities to generate. By default, an online reorg is generated after the corresponding object type DDL.
    • Enhanced support is also provided to generate utilities when they are requested and to generate warning messages when a utility is required, but has not been requested.
    More information:
  • CA RC/Query will now generate implicit object DDL as comments when you execute the HDDL or DDL command if the object (database, tablespace, table, and index) is implicitly created. The output DDL is appended with --.
    More information:
  • CA Report Facility enhancements:
    • Added support to the TSO product version to edit procedures in the ISPF editor. Implement this feature using the new E option on the Proc Library panel or the new EDIT command on the Build Proc screen. This feature is also available in Release 19.0.
    • Added a new option that lets you modify the default product reaction when an error in online processing of procedure commands is encountered. This enhancement is an optional change to online procedure commands. To change, contact CA Support who will provide the SQL that is necessary to alter the default reaction. This feature is also available in Release 19.0.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Added support for new Db2 12 common field JOB-STEP in the following reports: AMSTRACE, AUDCLAS3, AUDCLAS4, AUDCLAS5, AUDCLAS6, AUDCLASA, AUDCLASB, AUTHFAIL, BTACTTRL, BTAUDPOL, BTLKCONT, BTPRTRCE, BTRECTRC, BTSUSPTR, DB2CMDL, DB2CMDS, DSEXTEND, DSEXTNDS, EXPSQL, GRANTREV, HPRAPLST, HSDLKTO, HSUDLKTO, HTDETL, INCOMPTD, LOCKCONT, PLANXPCT, PRTRCDTL, PUTRACE, QURYPARA, RECTRACE, SECIDTR, SUSPNDTR, TBLCONDT, THRDACTV, THRDDETL, THRDIDIO, THRDIDLK, THRDIDLS, THRDIDSM, THRDIDSQ, THRDIDSS, THRDTRAC, and V9CHRFUN.
    • Improved the documentation for IFCID 314 (ACC-AUTH-EXIT).
    • Added support for SQLJ host language using a new value J. The following reports were updated: SQLTRACE, RECTRACE.
    • Added support for CICS transaction details in the THRDDETL screen for CTS 5.3 and CTS 5.4.
    More information:
DBM 20 GA IR 1 (July 2017)
The following enhancements are now available in solution DBM 20 GA IR 1:
  • Object Framework Services enhancements:
    • Updated the OFS parmlib member to include a new CREATE VIEW default option, GENERATE_COLUMN_NAMES_WITH SELECT(*). This new option lets you retrieve the original CREATE VIEW DDL statements in CA RC/Migrator. Option O retrieves original VIEW DDL that was defined when the view was created. Option Y always generates VIEW DDL with column definitions, regardless of the original VIEW DDL. N always suppresses VIEW DDL column definitions, regardless of the original VIEW DDL.
    • New OFS Health Check for VIEW DDL WITH SELECT(*)
      A new health check, DB2_OFS_CREATE_VIEW with CA_DB2 as the owner has been added. This new health check verifies the value of the GENERATE_COLUMN_NAMES_WITH SELECT(*) parmlib option in the OFS parmlib member.
    More information:
    More information:
  • CA Detector now uses a queued element limit for all collection task queues to handle peek workloads. Implement this feature using the new MAXQ parameter in the PDT parmlib member. This feature is also available in CA Detector Release 19.0.
    More information:
  • CA Fast Load Enhancements:
    • Added the following SYSIN syntax options to delete non-dynamically allocated data sets at job step termination:
      • DELETE-FILES YES|NO
      • DELETE-SYSDISC YES|NO
      SYSERR and SYSDISC data sets are only deleted if SYSDISC is empty and DELETESYSDISC YES is specified. DELETEFILES YES applies to SYSERR, SYSREC, SYSUT1, and SYSULD data sets.
      This feature is also available in CA Fast Load Version 19.0.
    • Adds a new method to establish default RECLUSTER keyword settings using the PFL-RECLUSTER-DEFAULT option in the UTIL parmlib member. PFL-RECLUSTER-DEFAULT specifies what to sort when you omit RECLUSTER from SYSIN.
      This enhancement adds the following new options in the UTIL parmlib member:
      • PFL-RECLUSTER-DEFAULT
      • PFL-RECLUSTER-NO
      • PFL-RECLUSTER-YES
      The existing RECLUSTER NO and YES keyword options in SYSIN now use the new UTIL parmlib settings. NO uses the PFL-RECLUSTER-NO value. YES uses the PFL-RECLUSTER-YES value.
      To override the parmlib settings, use the following RECLUSTER options in your SYSIN:
      • The existing NO SORT-CLINDX keyword option
      • NO SORT-NONE, YES SORT-CLINDX, and YES SORT-ALL.
      This feature is also available in CA Fast Load Version 18.0 and Version 19.0.
    More information:
  • CA Fast Unload has added a new NULL-FILL option to fill data parts of null fields in the output records with specified data.
    This option applies to VARIABLE and DSNTIAUL output formats and all data types except for LOB and XML.
    More information:
  • CA Log Analyzer now provides a new DML filter expression that you can customize in the DML report, DML REDO/UNDO SQL, and DML load file.
    More information:
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Bufferpool page size is now an alterable change in CA RC/Migrator, CA RC/Compare, and CA RC/Update instead of DROP/CREATE for universal tablespaces and LOB tablespaces. When an alteration of the bufferpool results in a pending change, a REORG of the entire tablespace is needed to apply the pending changes to the definition and data of the tablespace. The syntax checker function in CA RC/Migrator can also be used to validate this syntax.
    • CREATE TABLESPACE PAGENUM support has been added to CA RC/Migrator, CA RC/Compare, CA RC/Query, and CA RC/Update. The PAGENUM clause is now included while generating CREATE TABLESPACE statement syntax for partition-by-range tablespaces in Db2 12 subsystems. PAGENUM ABSOLUTE is now generated in the DDL for a migrated partition-by-range tablespace that has the PAGENUM attribute value as NULL. This clause is also supported by the syntax checker function in CA RC/Migrator.
    More information:
  • CA RC/Query now generates PAGENUM ABSOLUTE in the DDL for a migrated partition-by-range tablespaces that has the PAGENUM attribute value as NULL.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Added support for new Db2 12 fields in IFCID 58 (SQL-STMT). This record is primarily used by probes and when the HIST-ACCT-DETAIL option specifies SQL.
    • Added support for new Db2 12 fields in IFCID 372 (ADV-TRIG-DB2VAR), IFCID 391 (BLOCK-FETCH), IFCID 404 (AUTH-COMPATIBILITY), and IFCID 477 (FTB-ALLOC). The following reports were added or updated: ATHUCOMP, AUDCLASB, AUTHFAIL, BTRECTRC, BTSQLTRL, DBGSTART, DCL$A$D, IDSFTBAL, MGSYSTEM, and PSEDOSUM.
    • Now allows a custom plan for IFI monitoring threads.
    • Now allows you to suppress WTO messages that are related to Xnet agent processing. Implement using AGENT-DEBUG=1 in the data collector system parameters. This feature is also available in Release 19.0.
    • Updated the new archive tables to now store Db2 audit records, IDB2 accounting records, and information about executed SQL statements.
    • Improved throughput when passing Db2 command text to GSS. This feature is available in Release 18.0 and Release 19.0.
    More information:
  • CA Fast Unload enhancements:
    • The new LONG-CHAR option has been added to the PFU parmlib member to allow unloading VARCHAR columns larger than 255 bytes into CHAR fields.
    • Enhanced LOAD-CONTROL keyword allows generation of free-form load-control statements to reload data using
      CA Fast Load for DB2 for z/OS
      or Db2 LOAD.
    More information: