Level Set PTF 20.0.12 (LU13759) for the Database Management Solutions for Db2 for z/OS is now available. This Level Set PTF helps you identify your current level of maintenance and features that have been installed.
Features Applied with Level Set PTF 20.0.12
This list summarizes the features that are delivered by applying Level Set PTF 20.0.12 (LU13759).
The following feature in this Level Set PTF requires activation:
-
Quick Copy switches to the EXCP NO copy engine. To ensure optimal and stable performance, Quick Copy starts using only EXCP NO option (IBM Media Manager) to copy objects. The EXCP NO copy engine is faster, reduces multi-tasking overhead, and is zIIP-enabled.
The following features in this Level Set PTF do not require activation:
-
Db2 13 Function Level 505 support. The Database Management Solutions for Db2 have been enhanced to run with the functionality provided by Db2 function level V13R1M505. For supported function levels, see Db2 Version Support.
-
Post-installation processing enhancements. The following changes let you specify a user-defined high-level qualifier to use for allocating the configuration data sets:
These changes let you perform the post-installation configuration without modifying the SMP/E target data sets or deployment libraries.
-
REST API enhancements. Advanced trigger objects are now supported when using the devops/generate and devops/migrate REST API endpoints. You can now use these endpoints to include advanced trigger objects in generated DDL.
-
Detector Collection Status Display panel changes. This panel now displays parmlib, collection, and time options to help determine whether active collections are running with the same options.
-
Fast Recover support for OBIDXLAT index recovery. Object ID translation (OBIDXLAT) recovery is now supported for indexes that are created with the COPY YES attribute. Including COPY YES indexes in OBIDXLAT recovery can significantly save computational resources and shorten the processing time.
-
Plan Analyzer support for Db2 13 FL505 built-in scalar function INTERPRET. The new Db2 13 FL505 SQL DML built-in scalar function INTERPRET is now supported. The INTERPRET function converts an expression value to SMALLINT, INT, BIGINT, CHAR, or VARCHAR. SQL that contains the INTERPRET function syntax is processed successfully.
-
RC/Migrator syntax checker support for ALTER advanced trigger statements. You can now syntax check the following ALTER TRIGGER clauses: ACTIVATE VERSION, ADD VERSION, ALTER VERSION, DROP VERSION, REPLACE ACTIVE VERSION, and REPLACE VERSION.
CREATE TRIGGER and CREATE OR REPLACE TRIGGER statements are already supported.
-
RC/Query Quick Migration command support for advanced triggers. Advanced triggers are now supported when using the Quick Migrate (QM) command to generate the DDL. The QM command recognizes the version in the trigger reports. All primary reports now contain version information for advanced triggers.
-
Recovery Analyzer Recovery Estimator support for rebuild index estimation. You can use RECOVER-TOOL ESTIMATE-RECOVERY to estimate how much time it will take to rebuild indexes. The results include index recovery and rebuild times.
Also, the supported number of repeated groups for the QBGL group buffer pool record was reduced from 25 to 15 per Db2 guidance.
-
-
Support for new IFCID 319 records. The new MONITOR-CONN-PROF-ACTION and MONITOR-CONN-PROF-ID fields are now supported in IFCID 319. These new fields indicate whether a warning or exception message is triggered. IFCID 319 provides an audit trail for security processing.
-
Archive table enhancements. These enhancements include: new latch-related subsystem fields, new IFCID 411 and IFCID 412 tables, new IFCID 95 and IFCID 96 SORTL metrics, and the new TRUSTED-CONTEXT IQL field in IFCID 269. Use these enhancements to troubleshoot Db2 latch-related issues, subsystem performance by remote applications, advanced sorting techniques, and secondary role details.
- Support for New QLST Fields in IFCIDs 1 and 365. The new HPER-DBATS-TERM-POOLINAC and DBAT-TERM-TCPSOCK-CLOSED fields are now supported in IFCIDs 1 and 365. The new fields provide administrators with additional metrics for analyzing thread terminations.
For more information, see New Features in the Release Notes in the Database Management Solutions for Db2 for z/OS documentation.
Db2 Tools 20.0 Validation Project
What's cooking in the lab?
|
Join the Db2 Tools 20.0 Validation Project, where the Broadcom product teams reveal upcoming features and seek feedback. See what we are developing, as we develop it. Validation meetings are your best opportunity to influence the development of the Database Management Solutions for Db2 for z/OS products.
Register today at https://validate.broadcom.com/key/db2tools200.
|
Db2 Tools Modern User Experience Beta Program
Another reason to join our Db2 Tools 20.0 Validation Project is to participate in our Modern User Experience for Database Management Beta Program.
We are building a modern mainframe database user interface that provides an easy, intuitive user experience for database administrators and application developers, enabling them to be highly productive, reducing the learning curve. It is built on REST APIs and uses the Zowe open framework. We designed it from the ground up to be scalable and enable users to complement it with their existing and familiar toolings. It is uniquely designed with a task-oriented approach, making it intuitive and productive for the next generation of mainframe staff.
Joining the Db2 Tools 20.0 Validation Project entitles you to participate in the beta program. By participating in the beta program, you can:
-
Help shape and influence our next-generation user experience.
-
Have early access to the software.
-
Have direct interaction with our Database Management for Db2 subject matter experts.
In return, we ask that you provide us with regular feedback about the user experience that is provided through the capabilities of this new user interface.
To join, register for the Db2 Tools 20.0 Validation Project as noted earlier.