Db2 Tools

 View Only

Db2 Tools 20.0 IR 4 Availability

By Andrew Badgley posted Apr 23, 2018 02:47 PM

  

CA Database Management Solutions 20.0 for z/OS Incremental Release update DBM 20 GA IR 4 was made available April 23, 2018.  PTF #SO01396.

 

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

 

  • Common and post-install related enhancements:
    • The APPLCOMPAT BIND option is now always used to bind packages when executing the Bind Product Plans and Packages post-installation configuration task.
    • and more…
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Intelligent REBIND exclusion is now provided when the BIND/REBIND analysis options are specified in CA RC/Migrator.
    • 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.
    • and more…
  • CA RC/Query report enhancements:
    • All catalog table columns are now included in the following list reports: Routine List (R-L), Permission and Mask (PM-L), Table Column (T-C), Table View (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).
    • and more…
  • 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.
  • CA SYSVIEW for DB2 enhancements:
    • The new IFCID 406 (system profile monitor) is now supported.
    • A new SYSPARM HSTSQLDB-DSN for a separate SQL history file has been added.
    • EXCP0376 IQL exception performance has been improved.
    • New SQL incompatibility batch reports on IFCID 376 are now supported.
    • A new dynamic SQL history file is now available. This enhancement includes new IQL functions: STMT-CAPTURE and STMT-EXTRACT.
    • New DB2 12 fields added to IFCID 006 (READ-IO-ST) and IFCID 007 (READ-IO).
    • and more…
  • CA Detector enhancements:
    • A new Database Management Data Service is now available. This service hosts a RESTful API that enables access to the DB2 data and metrics that CA Detector collects. Applications, including the new Mainframe Team Center – DB2 Performance Analysis user interface, can use the DBM Data Service to read the collected data.
    • A new Mainframe Team Center – DB2 Performance Analysis (MTC-DPA) user interface is now available. MTC-DPA lets you use a web browser to view and explore the DB2 application performance data that CA Detector collects.
    • and more…
  • CA Subsystem Analyzer has been enhanced to now enable collection abend restarting automatically following abnormal termination of data collection.
  • CA Log Analyzer enhancements:
    • The ability to format data rows of versioned tables in DML reporting is now provided when using the Dropped Object Tracking function.
  • CA Merge/Modify has been enhanced with two new keywords (MINIMUM-COPIES and MINIMUM-FULLCOPIES) to check the number of image copies and/or full image copies remaining for the objects.
  • CA Fast Unload has been enhanced with a NULL-FILL option that fills data parts of null fields in the output records with specified data.
  • CA Database Analyzer has been enhanced to support the use of new DSNACCOX (PDA) conditions for action procedures that are performed on partitioned tablespaces and indexspaces.
  • CA Report Facility has been enhanced to allow creator IDs and object names that are up to 128 characters long (257 characters total including the dot separator).

 

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.

3 comments
9 views

Permalink