Db2 Tools

 View Only

Db2 Tools 20.0 IR 5 Availability

By Andrew Badgley posted Jul 24, 2018 08:32 PM

  

CA Database Management Solutions 20.0 for z/OS Incremental Release update DBM 20 GA IR 5 was made available July 24, 2018.  PTF #SO04455.

 

Here is a list of some of the enhancements included in this update:

 

  • Post-install and common enhancements:
    • The Object List Manager utility now supports the selection of objects by packages.
    • and more…
  • CA Log Analyzer™ for DB2 for z/OS (CA Log Analyzer) enhancements:
    • FlashCopy image copies are now supported for reporting purposes.
    • and more…
  • CA Plan Analyzer® for DB2 for z/OS (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.
  • CA RC/Query® for DB2 for z/OS (CA RC/Query) has enhanced the ALL command to support the generation of utilities based on object type.
  • CA RC/Compare™ for DB2 for z/OS (CA RC/Compare) and CA RC/Migrator™ for DB2 for z/OS (CA RC/Migrator) 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.


  • CA Report Facility (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.
  • CA SQL-Ease® for DB2 for z/OS (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 column FUNCTION_LEVEL column is supported when CA Plan Analyzer creates the DSN_STATEMNT_TABLE.
  • CA SYSVIEW® Performance Management Option for DB2 (CA SYSVIEW for DB2) enhancements:
    • New Db2 11 and Db2 12 fields have been added to IFCID (106) DSNZPARM.
    • The columns STATCLGSRT, ZHYPERLINK, and QUERY_ACCEL_WAITFORDATA have been added to SUBSYS_ZPARM archive table.
    • Multiple IQL reports now utilize 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 first attempted to be 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.
    • A new MSGTRAP command allows to create a dump when a specific message is issued.

 

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
3 views

Permalink