New Features

New features summary for Version 20.0 of the Database Management Solutions for Db2 for z/OS.
dm20
The following list provides a high-level summary of the new features and enhancements that have been delivered to date in Version 20.0 of the
Database Management Solutions for Db2
:
To ensure availability of all features and fixes, ensure that your products are current on maintenance. To download and receive maintenance automatically, Configure
SMP/E Internet Service Retrieval
. To view a list of available solutions and fixes, select the link for PTFs since GA on the
Database Management Solutions for Db2
Maintenance Grid
(login required).
To request product enhancements, contact a product manager or post your request in the "Ideas" section of the Db2 Tools community.
To review the Version 20.0 features that were introduced in 2020 and under the Incremental Release model, see New Features Introduced in 2020 and New Features Introduced under Incremental Release.
2
2
Support for Physically Closed Data Sets Fields (LU04374)
The
SYSVIEW for Db2
adds support for two new fields in the trace records (002) STATS2 and (1002) CURR-STATS2. These fields specify the number of infrequently accessed and the number of utility-access-only data sets that are physically closed. For more information, see New Features in the
SYSVIEW for Db2
documentation.
Unique Names for Exceptions (LU04287)
The
SYSVIEW for Db2
exception system has been enhanced with Exception Name. Every exception gets a name value to simplify its future identification and maintenance. During the startup, the data collector upgrades the exception file and assigns a unique exception name to every existing exception definition. For more information, see New Features in the
SYSVIEW for Db2
documentation.
DDL_MATERIALIZATION zPARM Support (LU04149)
RC/Migrator
and
RC/Update
now support the DDL_MATERIALIZATION zPARM. This zPARM is checked when an ALTER TABLE... ALTER COLUMN... SET DATA TYPE statement is used to change the precision, size, length, scale, or data type of a table column. Based on the zPARM setting,
RC/Migrator
and
RC/Update
generate the appropriate DDL and utility statements during analysis. When the DDL contains pending changes for listed table column attributes, and tablespace REORGs are not requested during analysis, a warning message indicates that a REORG is needed to materialize the pending changes.
UPMPARM Parmlib Member and Xmanager Options (LU02151)
Support for the UPMPARM parmlib member and new parameters have been added to the execution manager (Xmanager) address space. The IRLMRWT and RESTOPOBJ parameters let you specify whether the Utility Process Manager (UPM) temporarily overrides the IRLMRWT and RETRY_STOPPED_OBJECTS subsystem parameters in the IBM DSNZPARM. UPM overrides these parameters to prevent SQL -904 errors during critical online processing of objects that are accessed by other applications. This feature provides greater flexibility in managing your Db2 subsystems by allowing you to manually set these parameters or use the values in the IBM DSNZPARM.
CREATE OR REPLACE PROCEDURE Support (LU03926)
Db2 12 M507 CREATE OR REPLACE PROCEDURE syntax is now supported by Object Framework Services. After M507 is activated, you can generate DDL that includes the CREATE PROCEDURE statement with the OR REPLACE clause without having to drop and recreate the statement.
For native SQL procedures, you can replace an existing procedure version or add a new procedure version using the OR REPLACE clause with a VERSION clause on the CREATE PROCEDURE statement. You can use this feature to change or add native SQL procedure versions.
This feature makes it easier to manage stored procedures in application environments.
For information about using the DDL and HDDL commands in
RC/Query
to generate this syntax, see the
RC/Query
documentation.
Db2 12 M508 Support for Multi-Table Tablespaces Migrated to UTS PBG in Fast Recover and Merge/Modify (LU03859)
Fast Recover
and
Merge/Modify
now support multi-table tablespaces that have been migrated to partition-by-growth universal tablespaces through an ALTER TABLESPACE MOVE. This migration capability was introduced in function level V12R1M508.
Fast Recover
and
Merge/Modify
can process these migrated tablespaces.
Fast Recover
and
Merge/Modify
also check the IBM.SYSCOPY table before performing a point-in-time (PIT) recovery or accumulation and do not allow recovery or accumulation to a PIT that precedes the migration.
For more information about this feature, see New Features in the
Fast Recover
documentation
and New Features in the
Merge/Modify
documentation
.
Support for Db2 Functions (LU03664)
In response to customer requests for further support of Db2 functions, support of routines in
RC/Migrator
,
RC/Compare
, and
RC/Update
has been expanded to include Db2 user functions in addition to support for stored procedures. A Db2 object type of User Function (UF) has been added to the objects that can be accessed from the online, interactive panels. From these panels, you can create, alter, template, and drop functions. Db2 routines now refer to both Db2 object types, Stored Procedures (PR) and User Functions (UF).
For more information about this feature, see New Features in the
RC/Migrator
and
RC/Compare
documentation
, and New Features in the
RC/Update
documentation
.
For more information, see the
RC/Migrator
/
RC/Compare
and
RC/Update
documentation.
zIIP Support for Collection Externalization (LU03709)
Detector
now uses a zIIP processor to externalize collected standard activity data to a data store when a zIIP processor is available. The use of zIIP processors for this CPU-intensive processing can improve performance and can reduce costs.
For more information about this feature, see New Features in the
Detector
documentation.
Db2 12 M508 Support for Multi-Table Tablespaces Migrated to UTS PBG in Recovery Analyzer (LU03706)
Recovery Analyzer
now supports multi-table tablespaces that have been migrated to partition-by-growth universal tablespaces through an ALTER TABLESPACE MOVE. This migration capability was introduced in function level V12R1M508.
Recovery Analyzer
can process these migrated tablespaces.
Recovery Analyzer
also checks the IBM.SYSCOPY table before performing a point-in-time (PIT) recovery and does not allow you to recover to a PIT that precedes the migration.
For more information about this feature, see the
Recovery Analyzer
documentation.
New Features (Winter 2021 - Level Set PTF 20.0.02)
The following list summarizes the enhancements that are included in Level Set PTF 20.0.02 (LU03712):
  • Db2 12 M508 Support for multi-table tablespaces that are migrated to universal tablespaces (LU03520)
  • Multi-row selection and hyperlinks in MTC-DBM (LU03417)
  • Advanced triggers support (LU03318)
  • Archiving SQL incompatibilities and extending IFCID 376 with dynamic SQL text (LU03348)
  • Dynamic allocation of sort work data sets using real-time statistics (LU03264)
  • Extended profile monitoring statistics support for IFCID 402 (LU03286)
  • LUWID information displayed in the DML and DDL reports (LU03250)
  • Elapsed time messaging in recovery simulation (LU03234)
  • Autonomic optimization of DFSORT (LU03190)
  • CSV output option for the Db2 Commands report (LU03228)
  • Support for new I/O interrupt processing metric (LU03091)
  • Support for IN FILE syntax in WHERE clause for unloads (LU02726)
  • Support for new QMDA fields (LU02646)
For more information about these features, see the product-specific or component documentation.
Db2 12 M508 Support for Multi-Table Tablespaces Migrated to UTS PBG in Recovery Estimator (LU03520)
The Recovery Estimator now supports multi-table tablespaces that have been migrated to partition-by-growth universal tablespaces through an ALTER TABLESPACE MOVE. This migration capability was introduced in function level V12R1M508. The Recovery Estimator checks the IBM.SYSCOPY table to determine whether your specified tablespaces have been migrated. If you try to estimate a recovery to a point in time that precedes the tablespace migration, the Recovery Estimator reports these tablespaces as unrecoverable.
Multi-row Selection and Hyperlinks Added to MTC-DBM (LU03417)
The
Mainframe Team Center - Database Management for Db2
user interface has been enhanced to enable multi-row selection of table data in the Performance function, provide breadcrumbs to associated data in the Administration function, and new SQL Detail and Dynamic SQL Detail reports in tab format to ensure consistency with other categories.
Advanced Triggers Support (LU03318)
All basic trigger and advanced trigger clauses in Db2 12 are now supported by
RC/Query
. You can now generate DDL and HDDL that includes the ADD VERSION clause or the CREATE TRIGGER statement with the OR REPLACE clause. You can use triggers to enforce data integrity rules.
Archiving SQL Incompatibilities and Extending IFCID 376 with Dynamic SQL Text (LU03348)
The
SYSVIEW for Db2
archive tables have been enhanced to improve exploitation of IFCID 376. History Unload Utility (IDB2UIFI REQ=UNLDHIST) now populates IFCID 376 records with SQL text from the Dynamic SQL Text Database (HSTSQLDB) when the text is in the database, but not in the original trace record. A new IQL variable SQL-INCOMPAT-TEXT supports capturing of SQL text for statements that are potentially incompatible with the current version of Db2. Two new archive tables (APPL_SQL_INCOMPAT_DETAIL and APPL_SQL_INCOMPAT_PARMS) store execution details about these statements.
Dynamic Allocation of Sort Work Data Sets using RTS (LU03265)
Fast Unload
now supports the dynamic allocation of sort work data sets using IBM Real-Time Statistics (RTS) when you specify the ORDER BY or ORDER CLUSTERED clause. Previously, you could only use RTS to allocate the space requirements of the SYSREC data set. Now, you can use RTS to calculate the number of rows to be unloaded for each SELECT statement when you dynamically allocate sort work data sets.
Extended Profile Monitoring Statistics Support for IFCID 402 (LU03286)
SYSVIEW for Db2
can now collect the (402) PROFILE EXCEPTIONS records at a fixed time interval. Enhanced profile monitoring statistics reports let you detect anomalies and measure workload against the thresholds that are defined in system profiles. New batch and online reports were introduced. A new menu option provides access to reports. The PROFILES report was updated. A new IQL-based exception system IDSXC402 supports delta between two intervals. Capturing the delta allows you to track profile exceptions and warnings that are triggered in specific intervals.
LUWID Information Displayed in the DML and DDL Reports (LU03250)
Log Analyzer
DML and DDL reports now display the logical unit of work ID (LUWID) in the UR header. This information helps you identify activities that were performed by concurrent threads, locate activity from a particular CICS terminal in a highly executed transaction, or locate activity from a particular DDF thread.
Elapsed Time Messaging in Recovery Simulation (LU03234)
Fast Recover
now provides precise calculations of the time it would take to recover your objects when you perform a recovery simulation. The simulation output displays the elapsed time for the individual utility statements and for the recovery job as a whole. These calculations help you verify that you can meet your recovery service level agreements (SLAs).
Autonomic Optimization of DFSORT (LU03190)
Fast Load
now optimizes the execution of DFSORT based on the availability of real or virtual storage. Previously, the real and virtual storage profiles for DFSORT were not autonomically calculated. Now, Fast Load calculates the sort parameters for you. The new SORT-OPTIMIZE keyword lets you specify whether to allow the autonomic calculation of these parameters. The default setting is SORT-OPTIMIZE YES. Specify SORT-OPTIMIZE NO in
hlq
.CDBAPARM(UTIL) or your SYSIN syntax to override this feature.
CSV Output Option for the Db2 Commands Report (LU03228)
Log Analyzer
can now provide the output of the Db2 Commands report in a comma-separated values (CSV) format. This option offers a convenient way to combine the Db2 data with data from other sources, for example, when using external auditing tools.
Support for New I/O Interrupt Processing Metric (LU03091)
SYSVIEW for Db2
adds support for a new field CPU-IO-INTERRUPT in the trace records (001) STATS1 and (1001) CURR-STATS1. This field specifies the CPU time that is spent in I/O interrupt processing for each Db2 address space in the record.
Support for IN FILE Syntax in WHERE Clause for Unloads (LU02726)
Fast Unload
now supports the use of IN FILE syntax in WHERE clauses to filter the rows to be unloaded based on an external data set. You can dynamically filter unloads by specifying the values for the IN predicate in an external data set and including IN FILE in the WHERE clause of the unload job.
Support for New QMDA Fields (LU02646)
SYSVIEW for Db2
adds new fields to the QMDA section of IFCIDs 003 and 148. New fields provide more identification details to improve the analysis of native Db2 REST API service threads.
New Features (Fall 2021)
The following list summarizes the enhancements that we have made from summer 2021 to fall 2021:
  • New Security Sample Profile for REST API Access
  • New DDL Validation Check in the SETUP Member (LU02471)
  • Autonomous Native Stored Procedure Support (LU02554)
  • LISTDEF for Multiple Action Procedures and Utility Codes (LU02455)
  • New History-Only Data Collector Mode (LU02118)
  • Aggregated Accounting for a Data Sharing Group (LU02303)
  • Object Filter Options in the DDL Activity Report (LU02229, LU02230, LU02231)
  • Support for Online Load of LOB Columns (LU02243)
  • Enhanced zIIP Support for Unloads (LU02005)
  • DEBUG Option in the Recovery Estimator (LU02197)
  • New Level Set 20.0.01 PTF Now Available (LU01290)
  • Reporting of Migrated Resources (LU02117)
  • Reading Db2 Log for Compression Dictionaries (ICTYPE=J) (LU01949, LU01950)
  • Select a Strategy HVersion for Comparison (LU01891)
  • GRANT and REVOKE improvements in the DDL Activity Report (LU01869)
  • CPU Optimization in Data Shareable Environment (LU01750)
  • GRANT UNLOAD Table Authority Support (LU01706)
For more information about these features, see the product-specific or component documentation.
A New Security Sample Profile for REST API Access (LU02841)
A new
SYSVIEW for Db2
security profile RESTAPI provides minimally required rights to use the REST API. The RESTAPI profile grants a user ID enough-only access to perform functions through /api/v1/idb2/ endpoints of the DBM Data Service. By default, this profile grants access to data retrieval endpoints only (GET function of the REST API).
New DDL Validation Check in the SETUP Member (LU02471)
A new validation check is now performed to verify DDL values that have been specified in the SETUP global parmlib member for a Db2 subsystem during post-install tailoring of the DBM Solutions for Db2 for z/OS. This check ensures that you cannot proceed with the post-install tailoring process when invalid DDL values are specified. For information, see Installation and Configuration Enhancements.
Autonomous Native Stored Procedure Support (LU02554)
Detector
now supports autonomous native stored procedures (ANSPs). The inclusion of ANSP data in your collection gives you more details about the SQL performance in your Db2 subsystems.
LISTDEF for Multiple Action Procedures and Utility Codes (LU02455)
Database Analyzer
now supports the use of LISTDEF to generate JCL to execute multiple utilities in the order that you specify. Each utility uses one or more steps in the generated action JCL to process the specified list (or lists) of objects. Previously, you could only select one utility code and tie one action procedure to an extract procedure to take advantage of LISTDEF statements. Now, you can select multiple utility codes in one action procedure, or can tie multiple action procedures (that include multiple utility codes) to an extract procedure. LISTDEF statements allow for increased concurrency during executions, greater flexibility, and time-savings.
New History-Only Data Collector Mode (LU02118)
SYSVIEW for Db2
now provides easier access and analysis of long-term Db2 statistics with a data collector running in History-Only mode.
A new system parameter DC-HISTORY-MODE lets you designate a data collector for history access only. In this mode, only history reports are available. You can dynamically switch between the allocated
SYSVIEW for Db2
history files, without having to restart the data collector.
The History-Only mode can be an online alternative to batch reports. To get started, submit a job that allocates new history files, loads them with Db2 statistics from an SMF file, and starts the data collector. New sample JCLs that are available in the SOURCE library include these steps. Submit IDB2HDCJ (job) or IDB2HDCS (started task) to start the data collector in History-Only mode.
Aggregated Accounting for a Data Sharing Group (LU02303)
SYSVIEW for Db2
adds the following real-time reports that show accounting statistics aggregated by connection type (IFCID 369) for a data sharing group: CSACCTSG, CSACCTDG, and CSACCTSL. You can access these reports in the "
Db2
Group Members" SYSPLEX report.
The existing CSACCTS report has been enhanced to include a new "DB2" column. This column indicates what member of a data sharing group provides the data. You can use it as a filter to limit the displayed information.
Object Filter Options in the DDL Activity Report (LU02229, LU02230, LU02231)
Log Analyzer
now lets you narrow the scope of the DDL Activity Report to individual databases, tablespaces, and their related objects (cascaded to lower hierarchies) that are registered in the Db2 catalog. Use the Object Filter Options in the DDL Activity Report to enter the database or tablespace names directly or using the mask characters.
Support for Online Load of LOB Columns (LU02243)
Fast Load
now supports online loads of LOB columns when you specify DATA-AVAILABLE CRITICAL in the SYSIN syntax and SWITCH-TO-IBM YES in
hlq
.CDBAPARM(UTIL). Previously, only DATA-AVAILABLE NORMAL and DATA-AVAILABLE HIGH were supported for LOB columns. Now, you can maintain availability in read/write (RW) mode when you perform an online load of a LOB column.
Enhanced zIIP Support for Unloads (LU02005)
Fast Unload
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data and you specify any of the following options:
  • SQL-ACCESS ONLY
  • Multiple SELECT statements
  • SELECT statement that includes an INTO clause that specifies a literal
  • DECFLOAT in the SELECT statement
Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
DEBUG Option in the Recovery Estimator (LU02197)
The Recovery Estimator has a new DEBUG option that generates extra log messages during processing for troubleshooting purposes. For more information about this option, see RECOVER-TOOL ESTIMATE-RECOVERY Control Statement.
New Level Set 20.0.01 PTF Now Available (LU01290)
A new Level Set PTF 20.0.01 is now available. This Level Set PTF PREREQs all previously published PTFs. The Level Set PTF makes it easy to receive and apply all maintenance and feature PTFs up to a specific modification level. This PTF also helps you know what features are installed and available for use at your site.
Activating this Level Set allows you to access the following new features:
  • Collection of Compare History Records by the Compare Reports
    In
    Plan Analyzer
    , the Compare Explain Version and Compare Versions Cost Compare reports now collect and save the comparison data. This data helps you identify statement access paths with performance degradation, and access paths with improved performance that can benefit from a rebind. For more information, see Plan Analyzer New Features.
  • Maintenance Rollout Independence
    Future maintenance can be rolled out to each Xmanager individually, instead of to all Xmanagers at once. This feature allows you to control when new features are activated while ensuring that incompatible code changes are not introduced into your environment. For more information, see Xmanager Requirements.
For more information about managing Level Sets, see Activate a Level Set.
Reporting of Migrated Resources (LU02117)
The Recovery Estimator can now detect whether any data sets that are required to recover your objects have been migrated. When you run a Recovery Estimator job to analyze the recoverability of your objects, the resulting report displays which image copies are required to recover the objects. The report also shows the size of the required logs. The report identifies any image copy data sets that have been migrated from disk or tape and adjusts the estimated recovery time accordingly. The report also indicates whether any log data sets have been migrated. The identification of migrated data sets gives you a clearer picture of where the necessary resources are located and how long a recovery would take.
Reading Db2 Log for Compression Dictionaries (ICTYPE=J) (LU01949, LU01950)
Log Analyzer
can now seamlessly expand compressed data when the compression dictionary was changed by the REORG TABLESPACE or LOAD REPLACE utilities.
These utilities remove old compression dictionaries from the tablespace VSAM and write them to the Db2 log. The SYSIBM.SYSCOPY catalog table marks these log dictionaries as ICTYPE=J entries.
If the compression dictionary cannot be found in other sources, such as an image copy or a tablespace VSAM,
Log Analyzer
triggers precise log reading to obtain the dictionary record from the Db2 log.
Old compression dictionaries are written to the Db2 log only if the utilized tablespace contains a table with DATA CAPTURE CHANGES.
Select a Strategy HVersion for Comparison (LU01891)
Plan Analyzer
now allows you to choose which historical strategy version of an explain strategy to compare against your SQL source version. Previously, you could only compare a SQL source version against the last hversion that had been created for that strategy.
More Information about Grants and Revokes Added to the DDL Activity Report (LU01869)
Log Analyzer
provides more detailed information about privilege grants and revokes that were performed on selected objects during a specified period. The DDL Activity Report with the Object level of detail now includes the ID of users who changed the privilege and who had their privilege changed.
CPU Optimization in Data Shareable Environment (LU01750)
SYSVIEW for Db2
has been enhanced to optimize the use of CPU for unsorted Cross-system Coupling Facility (XCF) messages.
GRANT UNLOAD Table Authority Support (LU01706)
The Db2 12 GRANT UNLOAD privilege is now supported. The UNLOAD privilege prevents unauthorized users from reading table data during unload processing. In
RC/Migrator
,
RC/Compare
, and
RC/Update
, GRANT UNLOAD statements are generated during a strategy analysis on a Db2 12 subsystem when needed. To enable this feature, the SECURITY analysis option must not be set to N. For information about strategy analysis, see the RC/Migrator documentation.
In
RC/Query
, the user authorization reports have been updated to now include the UNLOAD privilege. For information about user authorization reports, see the RC/Query documentation.
New Features (Summer 2021)
The following list summarizes the enhancements that we have made from spring 2021 to summer 2021:
  • Support for OPTIONS Statements in Recovery Simulation (LU01717)
  • Support for New Prometheus Generic Endpoint (LU01166, LU01610)
  • Db2
    Command Processor Enhancements (LU01575)
  • DB2L Command Code Level Support (LU01526)
  • Db2 12 FL507 SQL DML Syntax Support (LU01432)
  • Improvement to the DDL Report Performance (LU01384, LU01385)
  • SORTLOG NO Support for FlashCopies (LU01291)
  • New Recovery Estimator Option (LU01178)
  • Extended Support for Global Contentions (LU01175)
  • Alternate Catalog Mapping History Table Support (LU01106)
  • Support for LISTDEF in REORG Action JCL (LU01089)
  • Support of COMMENT, LABEL, and ALTER SEQUENCE Statements in DDL Report (LU01043)
  • New Option to Verify Environment (LU01039, LU01040, LU01053)
  • Archive Tables Update (LU01030)
  • Filter Detector Collection Data by Connection Type (LU01002)
  • New XML Column Data Panel Option in DML Reports (LU00940)
  • Support for LISTDEF in Image Copy Action JCL (LU00890)
  • zIIP Unloads from LOB Columns and with ORDER BY (LU00887)
  • Storage Statistics Added to USERS Command (LU00881)
  • Post-install Data Sharing Group Enhancements (LU00847)
  • MTC-DBM UI and DBM Data Service Post-Install Improvement (LU00839)
  • Sample JCL for Recovery Simulation (LU00795)
  • Table Mapping in DML Redo/Undo SQL Report (LU01415)
  • Support for COBOL Version 6.2 (LU00581)
  • PTLLPARM Support Removal Phase 1 (LU00592)
For more information about these features, see the product-specific or component documentation.
Support for OPTIONS Statements in Recovery Simulation (LU01717)
Fast Recover
now supports the use of the IBM OPTIONS control statement for recovery simulations.
Support for New Prometheus Generic Endpoint (LU01166, LU01610)
The Database Management Data Service has been enhanced to support a new generic endpoint (/api/v1/idb2/prometheus/generic). This endpoint lets you produce Db2 performance metrics in the Prometheus exposition format.
SYSVIEW for Db2
introduces new IQL requests to exploit the new endpoint.
You can feed
SYSVIEW for Db2
data to the Prometheus open-source monitoring system and use the Grafana open-source visualization tool with Prometheus to visualize the data.
Db2
Command Processor Enhancements (LU01575)
The
Db2
Command Processor has been enhanced to support the following Db2 12 commands: DISPLAY BLOCKERS, DISPLAY LOG, DISPLAY PROFILE, DISPLAY RESTSVC, START PROFILE, START RESTSVC, STOP PROFILE, and STOP RESTSVC.
DB2L Command Code Level Support (LU01526)
You can now use the DB2L primary command online and in batch to view the code (maintenance) level of a Db2 subsystem. This command also shows the function level, catalog level, and previous highest function level. You can use these values to identify mismatched SETUP global parmlib values and runtime values more easily to help prevent Db2 connection errors.
Db2 12 FL507 SQL DML Syntax Support (LU01432)
Bind Analyzer
,
Plan Analyzer
, and
SQL-Ease
now support new global options and IDAA expressions that were introduced in function level V12R1M507.
Improvement to the DDL Report Performance (LU01384, LU01385)
Log Analyzer
now excludes log records that are not required from the DDL report processing. This update improves the performance of the report.
SORTLOG NO Support for FlashCopies (LU01291)
In
Fast Recover
, the SORTLOG NO option has been enhanced to support FlashCopies.
New Recovery Estimator Option (LU01178)
The Recovery Estimator has a new VERIFY-DATASETS option that verifies that the data sets that are required to recover your objects are cataloged in the z/OS ICF catalogs. When you run a Recovery Estimator job to analyze the recoverability of your objects, the resulting report displays which image copies are required to recover the objects. The report also shows the size of the required logs. If you include VERIFY-DATASETS in your job, the report also flags any image copy data sets or log data sets that could not be found in the catalog. Identifying the missing data sets lets you resolve this problem proactively to ensure the recoverability of your objects.
Extended Support for Global Contentions (LU01175)
SYSVIEW for Db2
adds support for the new global contention fields in the trace record (002) STATS. Reports have been updated.
Alternate Catalog Mapping History Table Support (LU01106)
The SYSTABSPACESTATS_H and SYSIXSPACESTATS_H history tables are now supported by the Alternate Catalog Mapping (ACM) value pack component of the
Database Management Solutions for Db2
. These history tables are associated with the Db2 catalog tables SYSTABLESPACESTATS and SYSINDEXSPACESTATS for system-period temporal versioning.
Support for LISTDEF in REORG Action JCL (LU01089)
Database Analyzer
now supports the use of LISTDEF to execute REORG (RO) against a list of objects. Previously, you could only execute Image Copy or RUNSTATS against the objects in a LISTDEF in one step. A new model member (MJULDRO) is provided to generate action JCL to execute REORG with a LISTDEF statement. You can use the LISTDEF_STEP_LIMIT parameter in the PDA parmlib member or model members to control the number of objects that are processed per step. LISTDEF statements allow for greater concurrency during executions.
Support of COMMENT, LABEL, and ALTER SEQUENCE Statements in DDL Report (LU01043)
Log Analyzer
adds support for reporting on the ALTER SEQUENCE SQL statements and includes the number of encountered COMMENT and LABEL statements in the DDL Activity - Summary Report Comments field.
New Option to Verify Environment (LU01039, LU01040, LU01053)
Log Analyzer
adds a new option to verify the parmlib values for their optimal settings.
Archive Tables Update (LU01030)
SYSVIEW for Db2
updates the existing archive tables with the new Db2 12 statistics and adds two new archive tables: SUBSYS_ACCT_BY_CONN_DETAIL and SUBSYS_ACCT_BY_CONN_DAILY. The new tables are built on IFCID 369 data and store the accounting data aggregated by the connection type.
Filter Detector Collection Data by Connection Type (LU01002)
When you run
Detector
collections, you can now filter the collected data by connection type. The ability to filter by connection type gives you more granular control over the collection of your Db2 application statistics, which helps you optimize the use of system resources.
New XML Column Data Panel Option in DML Reports (LU00940)
Log Analyzer
adds support for serialized XML record data in a readable format in the DML Detail Report.
Support for LISTDEF in Image Copy Action JCL (LU00890)
Database Analyzer
now supports the use of LISTDEF to execute Image Copy (IC) against a list of objects in
one step
. Previously, you could only execute RUNSTATS against the objects in a LISTDEF in one step. A new model member (MJULDIC) is provided to create action JCL to execute Image Copy with a LISTDEF statement. You can use the LISTDEF_STEP_LIMIT parameter in the PDA parmlib member or model members to control the number of objects that are processed per step. LISTDEF statements allow for greater concurrency during executions.
zIIP Unloads from LOB Columns and with ORDER BY (LU00887)
Fast Unload
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from a LOB column or with an ORDER BY clause. zIIP support is provided when you unload LOB data with INPUT-FORMAT TABLE or order by a specified column. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
Storage Statistics Added to USERS Command (LU00881)
SYSVIEW for Db2
command USERS has been enhanced to report the amount of storage allocated in the data collector for every connected user. The command output is now logged to DBGPRINT at the regular time interval.
Post-install Data Sharing Group Enhancements (LU00847)
The post-installation tailoring process for the
Database Management Solutions for Db2
has been enhanced so that you can change group-wide options for all data sharing group members at the same time. This enhancement lets you apply group-wide changes in the SETUP global parmlib member simultaneously instead of editing each member individually. The group-wide changes are reflected into the corresponding members of the data sharing group immediately, saving time, and reducing potential errors. When selecting Db2 subsystems to process, you can also now sort by data sharing group.
MTC-DBM UI and DBM Data Service Post-Install Improvement (LU00839)
The post-installation tailoring process for the
Database Management Solutions for Db2
has been enhanced to enable configuration of the
Mainframe Team Center - Database Management for Db2
(MTC-DBM) user interface and the Database Management Data Service (DBM Data Service). You can now select MTC during post-install tailoring and then configure these components using the Database Management for Db2 for z/OS (DBM for Db2) ISPF-based Configuration Utility. Previously, this configuration was performed by editing JCL manually.
The Configuration Utility:
  • Integrates with existing post-installation tailoring steps.
  • Tracks, reports, and saves your progress throughout the configuration process.
  • Lets you pause the configuration process and then resume it later as needed.
  • Simplifies configuration of the DBM Data Service and MTC-DBM user interface by soliciting, validating, and saving the required configuration parameter values.
After all required parameter values have been entered and saved, the Configuration Utility guides you through the process of generating and submitting the jobs to complete the configuration process.
Sample JCL for Recovery Estimator (LU00794)
Sample JCL is now provided for the Recovery Estimator. This batch utility analyzes the recoverability of a Db2 object or group of objects and estimates the time it would take to recover them. Database administrators can use this batch utility to verify that recovery service level agreements (SLAs) are met.
The sample JCL can be found in the FRECOEST member of
hlq
.CDBAJCL. The JCL provides instructions and sample syntax to estimate a recovery to various points in time.
Sample JCL for Recovery Simulation (LU00795)
Sample JCL is now provided for the recovery simulation option in
Fast Recover
. The sample JCL can be found in the FRECOSIM member of
hlq
.CDBAJCL.
Table Mapping in DML Redo/Undo SQL Report (LU01415)
Log Analyzer
now supports mapping source and target tables in the DML Redo/Undo SQL report.
Support for COBOL Version 6.2 (LU00581)
The COBOL source code in Report Facility has been migrated to COBOL version 6.2. The CDBACICS and CDBAIMS load libraries have also been converted from PDS to PDSE to support this maintenance.
PTLLPARM Support Removal Phase 1 (LU00592)
Support for PTLLPARM will be removed in the future. To prepare for this change, a new JCL member, PTAMIGLP, is now provided in
hlq
.CDBAJCL. Use this member to convert PTLLPARM into the PTIPARM data set. A new message, PT806W, is generated online and in batch when the PTLLPARM load module is present in the load library.
New Features (Spring 2021)
The following list summarizes the enhancements that we have made from winter 2020 to spring 2021:
  • Improved Performance for Batch Unloads (LU00565)
  • Monitor ECSA Storage Availability (LU00523)
  • Support for Db2 V12R1M509 (LU00277, LU00304)
  • Partition-Level DSSIZE PBR2 Alteration Support (LU00446)
  • Compare Summary Reporting in Explain Strategies (LU00440)
  • Capture Threshold Values (CTV) for Action Procedures (LU00314)
  • zIIP Support for Unloads from Versioned Tables (LU00216)
  • Enhanced Data Collection for Recover Statistics in Automated Dropped Object Recovery (LU00165)
  • Support for LISTDEF in RUNSTATS Action JCL (LU00145)
  • Keep Recovery Simulation Shadow Data Sets (LU00135)
  • Bypass the Extract File (LU00131, LU00132, LU00133)
  • Interval Delta Processing for IFCID 148 (SO16300)
  • Support for New Fast Index Traversal Metric (SO16270)
  • Online Execution Mode is Discontinued in Database Analyzer(SO16205)
  • zIIP Support for Unloads from Image Copies (SO16194)
  • zIIP Support for Loads with OUTPUT-CONTROL ALL and REORG (SO16090)
  • Increased Number of Intervals for Data Stores (SO16175 for Subsystem Analyzer, and SO16173, SO16174 for Detector)
  • VTAM Data Stream Compression Support (SO16116)
  • DB2L Batch Execution Support (SO15980)
  • Enhanced IUIBATCH Support (SO15952)
For more information about these features, see the product-specific or component documentation.
Improved Performance for Batch Unloads (LU00565)
Detector
now provides better performance when the PDTBATCH job is used with NORMALIZE=Y to unload collection data from the data store.
Monitor ECSA Storage Availability (LU00523)
Xmanager can now monitor the amount of ECSA storage that is in use. If the used storage exceeds your specified percentage, Xmanager terminates any active
Detector
data collections to free up storage space. For more information about this parameter, see Value Pack Enhancements.
Support for Db2 V12R1M509 (LU00277, LU00304)
Db2 12 function level and catalog level V12R1M509 support is now available. The
Database Management Solutions for Db2
are usable on Db2 12 subsystems with the function level activated and with an updated catalog (maintenance applied).
However
, you may not be able to use the new features in the function level. For feature support in each function level, see the product-specific enhancement documentation. For more information about the supported function levels, see Db2 Version Support.
Partition-Level DSSIZE PBR2 Alteration Support (LU00446)
RC/Migrator
,
RC/Compare
, and
RC/Update
have been enhanced to provide partition-level DSSIZE alteration support for PBR2 tablespaces and indexes. For PBR2 objects, the following statements are now also supported:
  • ALTER TABLESPACE PART DSSIZE
  • CREATE INDEX DSSIZE
  • ALTER INDEX DSSIZE
This support includes the syntax checker, compare rules, global changes, incremental change language (ICL), and recovery scenarios.
Compare Summary Reporting in Explain Strategies (LU00440)
Plan Analyzer
has a new Compare History function and Compare Summary report that enhances your ability to identify changes to access paths and SQL costs in your Db2 subsystems. When you use the new Compare History function in your explain strategies, the compare results are collected and saved. You can use the Explain Strategy Services to generate a Compare Summary report from the saved comparison data. This report helps you identify statement access paths with performance degradation, and access paths with improved performance that can benefit from a rebind.
Capture Threshold Values (CTV) for Action Procedures (LU00314)
Database Analyzer
now lets you capture the threshold (condition) values of database objects that are selected for actions, based on the conditions in action procedures that are tied to an extract procedure with Real Time Object Selection (RTOS). Previously, you could only capture threshold values for objects that are selected by extract procedures. Now, you can capture threshold values that trigger action procedures that are tied to an extract procedure.
zIIP Support for Unloads from Versioned Tables (LU00216)
Fast Unload
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from versioned tables. Previously, zIIP support was not available for unloads from rows in multiple tablespace versions. Now, zIIP support is provided for versioned tables. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs.
Enhanced Data Collection For Recover Statistics in Automated Dropped Object Recovery (LU00165)
The Automated Dropped Object Recovery (ADOR) feature for
Log Analyzer
can now recover Db2 statistics for implicitly created tablespaces, tables, and indexes.
Support for LISTDEF in RUNSTATS Action JCL (LU00145)
Database Analyzer
now supports the use of LISTDEF to execute RUNSTATS against a list of objects in
one
step. The generated action JCL contains a LIST keyword followed by the LISTDEF statement for each RUNSTATS control statement. A new model member (MJULDRS) and new automatic symbolics are provided to create action JCL to execute RUNSTATS on the objects defined in a LISTDEF. You can use LISTDEF to allow for greater concurrency during executions.
Keep Recovery Simulation Shadow Data Sets (LU00135)
You can now choose to keep the shadow data sets that are created for a recovery simulation. By default, these data sets are deleted automatically after the simulation completes. However, the new KEEP-SIMULATION-SHADOWS keyword lets you preserve them. Keeping these data sets allows you to view the simulated recovery output and compare it to the active Db2 data sets.
Bypass the Extract File (LU00131, LU00132, LU00133)
You can now bypass the extract file in the
Log Analyzer
reports and pass the data directly from the log extract process to the report generation process. Bypassing the extract file reduces EXCPs, reduces CPU time, and reduces elapsed time of the report generation process.
Interval Delta Processing for IFCID 148 (SO16300)
SYSVIEW for Db2
adds interval delta processing support for IFCID 148.
A new IQL request THRDEXCP populates two new IQL-based exceptions: THDNOCMT and THRDLOOP.
Support for New Fast Index Traversal Metric (SO16270)
SYSVIEW for Db2
adds a new counter to IFCID 389 for the number of index traversals in the last interval.
Online Execution Mode is Discontinued in Database Analyzer (SO16205)
As previously announced,
Database Analyzer
extract, report, and execution procedures must now be submitted in batch mode.
zIIP Support for Unloads from Image Copies (SO16194)
Fast Unload
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you unload data from image copies. Previously, zIIP support was only available for INPUT-FORMAT TABLE. Now, zIIP support is provided for all INPUT-FORMAT values.
zIIP Support for Loads with OUTPUT-CONTROL ALL and REORG (SO16090)
Fast Load
now supports the use of the IBM System z Integrated Information Processor (zIIP) with all OUTPUT-CONTROL values (ALL, BUILD, or REORG) when you specify DATA-AVAILABLE NORMAL or HIGH. Previously, zIIP support was only available for OUTPUT-FORMAT BUILD. Now, zIIP support is provided for all OUTPUT-CONTROL values.
Increased Number of Intervals for Subsystem Analyzer Data Stores (SO16175)
You can now specify more intervals when creating a
Subsystem Analyzer
data store. Previously, you were limited to 999 intervals. This limit has been increased to 9,999. The ability to create a data store with more intervals lets you save smaller slices of data for more granular troubleshooting.
Increased Number of Intervals for Detector Data Stores (SO16173, SO16174)
You can now specify more intervals when creating a
Detector
data store. Previously, you were limited to 999 intervals. This limit has been increased to 9,999. The ability to create a data store with more intervals lets you save smaller slices of data for more granular troubleshooting.
VTAM Data Stream Compression Support (SO16116)
Support has been added in
SYSVIEW for Db2
to specify the VTAM data stream compression option for the Remote Access Facility environment.
A new system parameter VTAM-COMPRESS controls the compression of the data that is sent from the data collector to the user interface.
DB2L Batch Execution Support (SO15980)
You can now execute the DB2L command in batch using the .CALL Batch Processor command. The DB2L command displays the continuous delivery (catalog and function) level runtime values. The command also shows the values that have been specified for a Db2 subsystem in the SETUP global parmlib member. These values must be in sync with the runtime values. You can use these values to identify mismatched SETUP and runtime values more easily and help prevent Db2 connection errors. DB2L is a global command that you can use from almost every product panel within the
Database Management Solutions for Db2
. With this enhancement, you can also now execute the DB2L command in batch using the Batch Processor interface. For example:
.CALL DB2L .DATA
ssid
ssid
.ENDDATA
If the .DATA and .ENDDATA statements are not specified, the
ssid
value from the .CONNECT statement is used. For example:
.CONNECT
ssid
.CALL DB2L
Enhanced IUIBATCH Support (SO15952)
The
SYSVIEW for Db2
Batch User Interface program IUIBATCH now supports commands CHECK and UNLOAD.