Blog Viewer

Db2 Tools 20.0 IR3 Feature List

By Andrew Badgley posted Jan 12, 2018 04:36 PM

  

CA Database Management Solutions 20.0 for z/OS Incremental Release update DBM 20 GA IR3 was made available Dec 21, 2017. 

 

The following enhancements are included in this update:

 

  • Db2 12 continuous delivery support for new function and catalog levels using new parameters, SSIDVERF and SSIDVERC in the SETUP global parmlib member
  • Toleration support for 8-byte user IDs with z/OS 2.3
  • Database Administration summary
    • Column mapping enhancements in CA RC/Extract
    • Utility model support for unique data set names in CA RC/Migrator and CA RC/Update
    • IBM utility models updated to support TEMPLATEs in CA RC/Migrator and CA RC/Update, and other general utility model updates.
    • Migration toleration of base/archive table sets and improved handling of base/clone and base/history table sets in CA RC/Migrator
    • Utility profile services support for alterations that are pending changes in CA RC/Migrator
    • Partition level DSSIZE support for PBR2 tablespaces in CA RC/Migrator
    • Db2 12 SYSTEM keyword support in CA RC/Migrator syntax checker
    • User and global control of the isolation level for dynamic SELECT statements in CA RC/Query and CA RC/Update
    • DDL generation for implicit objects as comments using DDL or HDDL commands in CA RC/Query
    • REPAIR utility enhancements in CA RC/Query
  • Performance summary for CA SYSVIEW for DB2
    • Archive table improvements and post-install changes
    • Integration with Mainframe Operational Intelligence
    • Custom IQL variable definition
    • Db2 12 support for new locks in IFCIDs 21, 44/45, 150, 172, 196
    • Db2 11 and 12 fields in IFCIDs 366 and 376
    • Thread statistics report improvements
  • Backup and Recovery summary
    • New option to generate application commits as part of DDL REDO reports in CA Log Analyzer
    • System level backup support in CA Fast Recover and CA Recovery Analyzer
    • Copy-image copy system level backup support in CA Merge/Modify
    • DSNUM Part Support added to MODIFY in CA Merge/Modify
    • MODIFY RECOVERY NEW OR-DSNNOTFOUND keyword in CA Merge/Modify
    • New QUOTE-EMBED-SINGLE keyword in CA Fast Unload
  • Utilities summary
    • Online Load Replace in CA Fast Load
    • Reorg Pending Changes in CA Rapid Reorg
  • And miscellaneous enhancements in CA Report Facility

 

If you would like to learn about what is being developed as it is being developed please join the CA Db2 Tools 20.0 Validation Project to participate in Sprint reviews and have access to early APARs for some enhancements.

0 comments
1 view