New Features

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 CA 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
CA Database Management Solutions for DB2 for z/OS
:
To ensure availability of all features and fixes, we recommend that you install all available maintenance. To download and receive maintenance automatically, Configure CA SMP/E Internet Service Retrieval. To view a list of available solutions and fixes, select the link for PTFs since GA on the CA Database Management Solutions for DB2 for z/OS Maintenance Grid (login required).
To request product enhancements, contact a product manager or post your request in the "Ideation" section of the Db2 Tools community.
2
2
DSNZPARM Support (SO15132)
The Thread Termination\Dynamic DSNZPARM value pack component has added support for various Db2 12 and Db2 11 DSNZPARMs. For more information, see Value Pack Enhancements.
Recovery Estimator (SO15312, SO15313, SO15314, SO15311)
CA Database Management Solutions for DB2 for z/OS
now has the ability to estimate the recovery time for Db2 objects. With the recovery estimator, you can verify that your recovery service level agreements (SLAs) can be met, as well as fine tune your recovery strategies. To use the recovery estimator, use the new control statement RECOVER-TOOL ESTIMATE-RECOVERY in your batch jobs. For more information, see Use the Recovery Estimator.
Support for Db2 V12R1M508 (SO15031, SO15235, SO15236, SO15237, SO15238)
Db2 12 function level and catalog level V12R1M508 support is now available. This support means that the products 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.
More information:
Alter KEYLABEL in DDL report (SO15220)
The
CA Log Analyzer™ for DB2 for z/OS
(CA Log Analyzer) DDL Report can now report changes that come from ALTER statements that modify the KEYLABEL values of Db2 tables and storage groups. ALTER statements that modify KEYLABEL values are introduced with IBM Db2 for z/OS function level V12R1M502.
New Features (Fall 2020)
Following is a summarized list of the enhancements we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
from summer to fall 2020:
  • Support for CICS Transaction Server (CTS) (SO14864)
  • zIIP support for OUTPUT-CONTROL BUILD (SO14773)
  • ALTER support for PAGENUM RELATIVE (SO14832)
  • Support for new system parameters (SO14754)
  • Support for unload from remote Db2 (LUW) RDBMS (SO14382)
  • SQLCODE reporting and chart support (SO14491)
  • Zowe API Mediation Layer conformance (SO14401)
  • Capture Threshold Values (CTV) of objects selected by RTOS (SO14174)
  • Post-install enhancement to support non-Db2 for z/OS binds (SO14028)
  • GENERATED ALWAYS non-deterministic expression column support (SO14125)
  • CA Mainframe Operational Intelligence instance identifier (SO14164)
  • Export to CSV support in Mainframe Team Center (SO14168)
  • Support for Huffman Compression (SO14029)
  • Support for new Db2 IFCID changes (SO14099)
  • New trace records for Db2 Accelerator Version 7 (SO13891)
  • DevOps for Db2 schema management enhancements (SO13807)
  • Enhanced support for TEMPLATE statements (SO13764)
  • Support for Db2 V12R1M507 (SO13706, SO13574)
  • PREVIEW SIMULATE keyword enhancements (SO13586)
  • Support for Recovering Identity Column Sequence Values in Automated Dropped Object Recovery (SO14613)
  • Enhanced Automated Dropped Object Recovery (SO14137)
  • Enhanced Data Collection For Recover Statistics in Automated Dropped Object Recovery (ADOR) (SO14865)
Support for CICS Transaction Server 5.6 (SO14864)
CA SYSVIEW® Performance Management Option for DB2
(CA SYSVIEW for DB2) now supports the CICS Transaction Server (CTS) 5.6.
More information:
zIIP Support for OUTPUT-CONTROL BUILD (SO14773)
CA Fast Load for DB2 for z/OS
now supports the use of the IBM System z Integrated Information Processor (zIIP) when you specify OUTPUT-CONTROL BUILD. Offloading zIIP-eligible workloads to zIIP processors can reduce the processing load on your general CPUs. zIIP functionality is enabled by default and controlled when you specify ZIIP {YES|NO} in the SYSIN DD statement or PFL-ZIIP {YES|NO} in
hlq
.CDBAPARM(UTIL).
More information:
ALTER Support for PAGENUM RELATIVE (SO14832)
In
CA RC/Migrator™ for DB2 for z/OS
(CA RC/Migrator),
CA RC/Compare™ for DB2 for z/OS
(CA RC/Compare), and
CA RC/Update™ for DB2 for z/OS
(CA RC/Update), you can now generate DDL on a Db2 12 subsystem that contains the PAGENUM RELATIVE clause in ALTER TABLESPACE statements for partition-by-range tablespaces using relative page numbering (PBR2 tablespaces). The PAGENUM option specifies the type of page numbering that is used for a range-partitioned tablespace. Valid values are A (absolute) or R (relative). Relative page numbering provides more flexibility and availability and higher limits in partition growth.
More information:
Support for New System Parameters (SO14754)
CA SYSVIEW® Performance Management Option for DB2
(CA SYSVIEW for DB2) has added support for the new Db2 system parameters: STATIME_MAIN, DISALLOW_SSARAUTH, and UTILS_BLOCK_FOR_CDC. New options were added for the system parameters QUERY_ACCEL_OPTIONS and INDEX_MEMORY_CONTROL. Reports have been updated.
More information:
Support for Unload from Remote Db2 (LUW) RDBMS (SO14382)
You can now unload data from a Db2 (LUW) Relational Database Management System (RDBMS) with
CA Fast Unload® for DB2 for z/OS
(CA Fast Unload) under Distributed Relational Database Architecture (DRDA). The DRDA protocol supports seamless integration of distributed relational DBMS systems. You must configure CA Fast Unload to unload data from a remote Db2 (LUW) RDBMS by defining the remote system in the communications database (CDB) and binding the product packages using the DRDA protocol.
More information:
SQLCODE Reporting and Chart Support (SO14491)
You can now view application performance data in Mainframe Team Center - Database Management for Db2 for z/OS that includes the SQL return code (SQLCODE) that is set by Db2 after each SQL statement is executed. Viewing this data lets you quickly determine which SQL errors are occurring most frequently to help explain why you may be experiencing poor query performance. If needed, you can export the related SQL, SQLCA details, and SQL execution statistics to CSV format for further analysis.
Using this feature helps you:
  • Identify SQL performance degradations before they are moved into a production subsystem.
  • Review SQL errors as they are captured in real-time and share with the Database Administrator to find a solution.
  • Analyze the execution flow of your applications.
More information:
Zowe API Mediation Layer Conformance (SO14401)
The Database Management Data Service (DBM Data Service) has been updated to meet Zowe API Mediation Layer conformance criteria for the following product RESTful APIs:
  • CA Detector
  • CA SYSVIEW for DB2
The Zowe Conformance Program gives users confidence that when they use a product, application, or distribution that leverages Zowe, they can expect a high level of common functionality, interoperability, and user experience. The Zowe API Mediation Layer consolidates mainframe RESTful API services into a single, secure point of access. To enable SSO, update the DBM Data Service configuration file to include the new APICAT_AUTH_SCHEME and APICAT_AUTH_APPLID parameters.
More information:
Capture Threshold Values (CTV) with RTOS (SO14174)
CA Database Analyzer™ for DB2 for z/OS
(CA Database Analyzer) now gives you the ability to capture the threshold (or condition) values of database objects that trigger actions based on the conditions in your Real Time Object Selection (RTOS) extract procedures. You can generate a Capture Threshold Values (CTV) report of the condition values that are met by your extract procedures and tune your selection criteria to avoid unnecessary actions on objects and reduce your maintenance time.
More information:
Post-Install Enhancement to Support Non-Db2 for z/OS Binds (SO14028)
The
CA Database Management Solutions for DB2 for z/OS
post-install tailoring process has been enhanced to let you specify remote DRDA locations for remote binds.
More information:
GENERATED ALWAYS Non-Deterministic Expression Column Support (SO14125)
Support has been added to CA RC/Migrator, CA RC/Compare, and CA RC/Update to recognize non-deterministic expression clauses for GENERATED ALWAYS columns, when migrating, altering, and comparing tables. A new option A, GENERATED ALWAYS AS (non-deterministic-expression), has been added to the Default indicator column attribute field on the table panels.
More information:
CA Mainframe Operational Intelligence Instance Identifier Change (SO14164)
CA SYSVIEW for DB2 has introduced a new system parameter, ZDM-PREFIX, which specifies the first four characters of the CA Common Services for z/OS (CCS) Data Mover instance identifier. This identifier uniquely identifies the CA SYSVIEW for DB2 data collector in the CA Mainframe Operational Intelligence infrastructure.
More information:
Export to CSV Support in Mainframe Team Center (SO14168)
You can now export Db2 object information or application performance data in CSV format by row, displayed table rows, or all rows. Doing so is useful for reviewing the table results offline or for providing the results to others. You can also import data into other applications such as Microsoft Excel.
More information:
Support for Huffman Compression (SO14029)
CA Database Management Solutions for DB2 for z/OS
tools now provide the following support for Huffman data compression:
  • CA Database Analyzer™ for DB2 for z/OS
    (CA Database Analyzer) lets you collect statistics and view data pages with the Page Display Facility on Huffman encoded objects.
  • CA Fast Load for DB2 for z/OS
    (CA Fast Load) can load Huffman encoded objects when the compression dictionary exists and KEEPDICTIONARY is specified.
  • CA Fast Recover™ for DB2 for z/OS
    (CA Fast Recover) can recover Huffman encoded objects.
  • CA Fast Unload® for DB2 for z/OS
    (CA Fast Unload) can unload from tables and image copies that contain Huffman encoded objects.
  • CA Log Analyzer™ for DB2 for z/OS
    (CA Log Analyzer) can report Huffman encoded objects.
  • CA Rapid Reorg® for DB2 for z/OS
    (CA Rapid Reorg) can reorganize Huffman encoded objects when the compression dictionary exists and KEEPDICTIONARY is specified.
Support for New Db2 IFCID Changes (SO14099)
The following enhancements have been made in CA SYSVIEW for DB2:
  • New CA Mainframe Operational Intelligence instance identifier, ZDM-PREFIX.
  • Support for new Db2 insert algorithm (IAG2) fields in the STATS2 (IFCID2), CURR-STATS2 (IFCID 1002), ACCT (IFCID 3), and THREAD-STATS (IFCID 148) Db2 trace records.
  • Support for new RID list fields in the STATS2 (IFCID2), CURR-STATS2 (IFCID 1002), ACCT (IFCID 3), and THREAD-STATS (IFCID 148) Db2 trace records.
  • Asynchronous cross-invalidation fields support in IFCID (0002) group buffer pool details and IFCID (0003).
  • Updated real-time and history online reports tutorial help.
More information:
Added Trace Records for Db2 Accelerator Version 7 (SO13891)
Support has been added in CA SYSVIEW for DB2 Accelerator Version 7. New fields include details, such as replication with delay protocol that are reported on all monitoring levels.
More information:
DevOps for Db2 Schema Management Enhancements (SO13807)
New JCL templates, sample JCL, and a new PROC are now available in CA RC/Migrator and CA RC/Compare to let you perform DevOps for Db2 schema management.
The templates serve as building blocks for creating a DevOps pipeline and can be used as input to an Apache Velocity-compatible template engine. In a DevOps environment, Db2 teams can use the JCL templates to enable application developers to provision Db2 object changes without leaving the Integrated Development Environment (IDE) of choice.
The sample PROC and JCL are provided as an example JCL pipeline to promote Db2 objects from a source environment to a target environment. Db2 teams can also trigger Continuous Integration (CI) and Continuous Delivery (CD) pipelines for promoting Db2 schema changes across multiple subsystems while preserving the database administrator's control over implemented changes.
More information:
Enhanced Support for TEMPLATE statements (SO13764)
CA Fast Load now supports the use of the TEMPLATE control statement and INDDN keyword to dynamically allocate SYSULD data sets without static JCL DD statements. You can use variables to define data set names, and set allocation parameters to automate, simplify, and standardize your load process. You can take advantage of a z/OS UNIX System Services (USS) pipe for improved performance by defining a USS file PATH name and associated parameters.
CA Fast Unload now supports the use of the TEMPLATE control statement PATH option to dynamically allocate the SYSREC, SYSDDL, and SYSCTL data sets without static JCL DD statements. You can take advantage of a z/OS UNIX System Services (USS) pipe for improved performance by defining a USS file PATH name and associated parameters.
More information:
Support for Db2 V12R1M507 (SO13706, SO13574)
Db2 12 function level and catalog level V12R1M507 support is now available. This support means that the products 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.
More information:
PREVIEW SIMULATE Keyword Enhancements (SO13586)
The PREVIEW SIMULATE keyword for CA Fast Recover has been enhanced to support FlashCopies and Concurrent Copies. You can now use these image copies in recovery simulation.
More information:
Support for Recovering Identity Column Sequence Values in Automated Dropped Object Recovery (SO14613)
The Automated Dropped Object Recovery (ADOR) feature for CA Log Analyzer can now recover the sequence of the identity column for a dropped object. If the object contains an identity column, ADOR will attempt to recover the identity column of the object to the value that was in use at the time of the drop.
Enhanced Automated Dropped Object Recovery (SO14137)
The following enhancements have been made to the Automated Dropped Object Recovery (ADOR) feature for CA Log Analyzer:
  • Taking an image copy after recovery is now optional. To take an image copy of the object after it is recovered, set the
    Image Copy After Recovery
    option to Y.
  • You can now take partition image copies by specifying the variable &PART in the
    Image Copy DSNAME
    option.
  • The ADOR job now returns 0 instead of 4 after the job successfully completes.
Enhanced Data Collection For Recover Statistics in Automated Dropped Object Recovery (ADOR) (SO14865)
The Automated Dropped Object Recovery feature (ADOR) job now collects the recovered Db2 statistics data in the UNDODDL step. The extra step CLCSTATS that read the Db2 log has been removed from the ADOR job.
New Features (Summer 2020)
Following is a summarized list of the enhancements we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
from spring to summer 2020:
  • New administration capabilities in Mainframe Team Center (SO13484)
  • CA SYSVIEW for DB2 Omnibus enhancements (SO13557)
  • Cancel a Db2 thread by its thread token (SO13508)
  • BIND SERVICE statement support (SO13307)
  • Huffman compression detection support (SO13071)
  • Post-install tailoring enhancements (SO12851)
  • Enhanced automated dropped object recovery support (SO14137)
  • ON DELETE ADD EXTRA ROW support for ALTER TABLE (SO12933)
  • New quick migration batch only keywords (SO12904)
  • CA SYSVIEW for DB2 Omnibus enhancements (SO12769)
  • Real-time statistics report enhancements (SO12783)
  • Support for Db2 12 built-in scalar functions and alternate built-in function names (SO12650)
  • PROGAUTH support in plan reports (SO12367)
  • COMPRESS clause support for LOB tablespaces (SO12361)
  • New DISCARD-LIMIT-RESUME keyword (SO12525)
  • Mainframe Team Center ICSF key ring support (SO12323)
  • APPLCOMPAT support in future explains (SO12267)
New Administration Capabilities in Mainframe Team Center (SO13484)
The
Mainframe Team Center - Database Management for Db2 for z/OS
user interface has been enhanced to now retrieve information from the Db2 catalog and display it in the new Administration tab. From this tab, you can view Db2 object information for your active Db2 subsystems and environments. For example, database administrators, application developers, and other users can obtain information about Db2 objects they are writing SQL statements against such as table columns, what indexes are available, associated views, and so on.
Application performance data is also now displayed under Performance in a single tab for the performance category you select. Select a row of data and drill down for more information. This action initiates a breadcrumbs list that you can use to navigate the data.
More information:
CA SYSVIEW for Db2 Omnibus Enhancements
The Omnibus solution contains the following enhancements:
  • Support for new and updated Db2 12 Resource Limit Facility (RLF) codes in the ACCT (IFCID 3) and THREAD-STATS (IFCID 148) Db2 trace records.
  • zHyperLink support
    Data set I/O and log activity reports were previously updated to show zHyperLink workload use. CA SYSVIEW for DB2 has now been further enhanced to fully support zHyperLink monitoring based on the most up-to-date version of related IFCID fields. You are now able to monitor and analyze zHyperLink exploitation, or estimate the potential benefits of zHyperLink workload use.
  • New FTP Statistics reports
  • Stabilized Dynamic SQL Display
More information:
Cancel Thread by Token Support (SO13508)
CA SYSVIEW for DB2 now supports thread cancellation using the thread token. Cancellation by token allows inactive threads to be canceled. If a thread token is available, the existing cancellation process now uses the thread token automatically.
The Thread Termination\Dynamic DSNZPARM value pack component now lets you specify a thread token to select a thread for cancellation. The ability to cancel a thread by its token is useful in situations where the thread token is the only unique identification for a Db2 thread.
This functionality is enabled through the new TOKEN parameter in the SET CANCEL and SET DB2CAN commands.
More information:
BIND SERVICE Statement Support (SO13307)
The BIND SERVICE statement is now supported in CA Endevor® Software Change Manager Interface for DB2 for z/OS BIND batch processing. The BIND SERVICE (DSN) subcommand builds an application package that represents a Db2 REST service.
More information:
Huffman Compression Detection Support (SO13071)
During an RC/Merger MOVE analysis in CA RC/Migrator, we can now detect when Huffman compression is being used.
More information:
Enhanced DDL Activity Report Parameters
The DDL Activity report parameters in CA Log Analyzer have been enhanced with an option to generate only GRANT and REVOKE statements or BIND and REBIND statements. The ONLY option lets you generate reports that contain only BIND, REBIND, and FREE statements, or GRANT and REVOKE statements exclusively.
More information:
Post-Install Tailoring Enhancements (SO12851)
The CA Database Management Solutions for Db2 for z/OS post-install tailoring process has been enhanced to ensure consistency when making edits and executing changes. New sort and find/locate commands enable you to quickly find and update subsystems when you are editing the SETUP global parmlib member.
More information:
Enhanced Automated Dropped Object Recovery Support (SO14137)
The Automated Dropped Object Recovery (ADOR) feature in CA Log Analyzer has been enhanced to recover a LOB tablespace from image copies that are taken with the SHRLEVEL CHANGE parameter.
More information:
ON DELETE ADD EXTRA ROW Support for ALTER TABLE (SO12933)
Support has been added to CA RC/Migrator, CA RC/Compare, and CA RC/Update to recognize the ON DELETE ADD EXTRA ROW clause when migrating, altering, and comparing temporal and history tables. Generated DDL will include the clause with the ADD VERSIONING statement when required for migrate, alter, and compare strategies on Db2 subsystems.
More information:
New Quick Migration Batch Only Keywords (SO12904)
You can now simplify the inclusion of related objects and global change specifications in a quick migration job in CA RC/Migrator by using the following new keywords QUICKME (explode all), QUICKMI (implode all), and QUICKMIE (explode and implode all), and READGCS (use global change set).
More information:
CA SYSVIEW for Db2 Omnibus Enhancements (SO12769)
The following enhancements have been made to CA SYSVIEW for DB2:
  • New fields related to secondary latch contentions in the CURR-STATS2 (1002 IFCID) record.
  • New fields related to zHyperLink support in the STATS1 (IFCID 1) and CURR-STATS1 (IFCID 1001) Db2 trace records.
  • Support for new fields in the STATS1 (IFCID 1) and CURR-STATS1 (IFCID 1001) Db2 trace records.
  • Support for new command counts in the STATS1 (IFCID 1) and CURR-STATS1 (IFCID 1001) Db2 trace records for the DISPLAY, START, and STOP SERVICE commands, START and STOP CDDS commands, and DISPLAY, START, and STOP ML commands.
  • Dynamic SQL plan stability
  • New real-time and history reports showing Fast Traversal Block activity on the system.
  • RESTFUL API enhancement to display status of the request.
More information:
Real-Time Statistics Report Enhancements (SO12783)
The Tablespace Real-Time Statistics Report and Indexspace Real-Time Statistics Report in
CA RC/Query® for DB2 for z/OS
(CA RC/Query) have been updated to include the following columns respectively: UPDATESIZE, LASTDATCHANGE, GETPAGES, SYS_START, SYS_END, and TRANS_START (TS-RT) and GETPAGES, SYS_START, SYS_END, and TRANS_START (IX-RT).
More information:
Support for New Db2 12 Built-In Scalar Functions and Alternate Built-In Function Names (SO12650)
CA Bind Analyzer™ for DB2 for z/OS
(CA Bind Analyzer),
CA Plan Analyzer® for DB2 for z/OS
(CA Plan Analyzer), and
CA SQL-Ease® for DB2 for z/OS
(CA SQL-Ease) now support several new scalar functions that were introduced in function level V12R1M505 and the alternate names that were introduced for several preexisting built-in functions in function level V12R1M506.
More information:
PROGAUTH Support in Plan Reports (SO12367)
CA Plan Analyzer now supports the PROGAUTH column in the SYSPLAN table. The Plan List, Plan Detail, Plan/Package Utilities, and Identify Problem Plan/Packages reports have been updated. The values in this column indicate whether Db2 performs program authorization checking to determine whether it can execute a plan.
More information:
COMPRESS Clause Support for LOB Tablespaces (SO12361)
Support has been added in CA RC/Migrator, CA RC/Compare, and CA RC/Update to generate the COMPRESS clause for LOB tablespaces. Generated DDL will include the clause when required for migrate, alter, and compare strategies.
More information:
New DISCARD-LIMIT-RESUME Keyword (SO12525)
CA Fast Load for DB2 for z/OS
now gives you greater flexibility in managing discard processing when the DISCARDS limit is reached. The new DISCARD-LIMIT-RESUME keyword lets you specify whether the database object data and associated pageset status will change when you specify RESUME YES. The new DISCARD-LIMIT-STATUS keyword lets you set a restrictive status on the tablespace and indexspace pagesets.
More information:
Mainframe Team Center ICSF Key Ring Support (SO12323)
The Mainframe Team Center user interface for the CA Database Management Solutions for DB2 for z/OS now supports the use of SSL certificates whose private keys are stored using the Integrated Cryptographic Services Facility (ICSF).
More information:
APPLCOMPAT Support in Future Explains (SO12267)
You can now use a new enhanced explain card, APPLCOMPAT, to specify application compatibility behavior for catalog or non-catalog SQL during a Future Explain.
More information:
New Features (Spring 2020)
Following is a summarized list of the enhancements we have made to Version 20.0 of the
CA Database Management Solutions for DB2 for z/OS
since March 2019 when we transitioned from an incremental release to continuous delivery release:
  • Explain Report enhancements for Db2 12 columns in DSN_STATEMNT_TABLE (SO12067)
  • Support for new Db2 12 UNLOAD privilege (SO12106)
  • IMPLICITLY HIDDEN ROWID column support (SO11966)
  • DISALLOW_SSARAUTH ZPARM support (SO11684)
  • Improved automatic calculation of ESTIMATED-INPUT (SO11846)
  • New Db2 Analytics Accelerator bind options (SO11807)
  • CA SYSVIEW for Db2 miscellaneous enhancements (SO11616)
  • Edit support for PXNPARM during Post-Install Customization (SO11608)
  • Swagger format support for RESTful APIs (SO11373)
  • REBIND phase-in package copy support (SO11129)
  • Incremental and FlashCopy image copy support in ADOR (SO11112)
  • Test Data Manager integration for data masking (SO11078)
  • Support for new format of DSVOLSER column (SO10817)
  • Function level M506 and M505 support (SO10662, SO11107)
  • Advanced trigger packages and CONCENTRATESTMT support (SO10712)
  • SHRLEVEL CHANGE and Partition Image Copy support in ADOR (SO10676)
Explain Report Enhancements for Db2 12 Columns in DSN_STATEMNT_TABLE (SO12067)
The Access Path reports, SQL Detail report, and historical database reports in CA Plan Analyzer have been updated to include more detail about APREUSE, APCOMPARE, and EXPLAIN_TYPE in the DSN_STATEMNT_TABLE explain table. Additionally, a new APREUSE Fail access path filter has been added to the explain option access path filters and to the identify problem SQL explain facility. This filter lets you eliminate SQL statements that do not meet the criteria of unsuccessful access path reuse.
More information:
Support for New Db2 12 UNLOAD Privilege (SO12106)
CA Fast Unload is now compatible with the new UNLOAD privilege introduced in Db2 12 function level V12R1M500.
More information:
IMPLICITLY HIDDEN ROWID Column Support (SO11966)
Support has been added in CA RC/Migrator, CA RC/Compare, and CA RC/Update to recognize the IMPLICITLY HIDDEN clause for explicitly hidden ROWID columns. DDL will generate the clause when required for migrate, alter, and compare strategies on Db2 subsystems running at least function level V12R1M503.
More information:
DISALLOW_SSARAUTH ZPARM Support (SO11684)
IBM APAR PH01725/PTF UI66853 enables a new online Db2 12 for z/OS subsystem parameter (ZPARM) DISALLOW_SSARAUTH. This ZPARM controls the authorization of allied address spaces that are connecting to Db2. The default setting is NO, which preserves the existing behavior and there is no change required for allied address spaces. When set to YES, Db2 prevents the user address spaces from setting a Db2 address space as a secondary address space.
If you plan on setting DISALLOW_SSARAUTH to YES, Version 20.0 of the CA Database Management Solutions for Db2 for z/OS is compatible with this change. However, you must apply the following maintenance
before
you change DISALLOW_SSARAUTH to YES:
  • SO10107 (CA Fast Unload)
  • SO10906 (CA SYSVIEW for Db2)
  • SO10907 and SO11684 (CA Database Management Solutions for Db2 for z/OS)
  • SO10908 (CA Detector)
  • SO11323 (CA Merge/Modify)
Improved Automatic Calculation of ESTIMATED-INPUT (SO11846)
CA Fast Load for DB2 for z/OS
now provides improved accuracy in the automatic calculation of the size of your input data sets.
More information:
New Db2 Analytics Accelerator Bind Options (SO11807)
You can now specify how long an IBM Db2 Analytics Accelerator for z/OS will delay a static SQL query while it waits for the replication of committed Db2 data changes that occurred prior to Db2 running the query. You can also specify the preferred target accelerator to use for queries that are accelerated. The new bind parameters are ACCELERATOR and ACCELERATIONWAITFORDATA.
More information:
Miscellaneous CA SYSVIEW for DB2 Enhancements (SO11616)
The following miscellaneous enhancements for are now provided in this solution:
  • Support for new Db2 11 and Db2 12 fields in IFCID 199.
  • Archive table migration utility (NSIGMIGA) enhancement to generate LOAD statements and IQL requests for all archive tables.
  • Support for asynchronous invocation of the Global Subsystem (GSS) CA Common Services component IMOD to write exceptions to the ILOG and the System Condition Monitor (SCM). A new option, CALL-GSS=AYSNC is used to activate this functionality.
  • Support for SWAP and SPLIT commands in the ISPF command line interface.
  • Support for new Db2 12 fields and a new system parameter in IFCID 106.
More information:
Edit Support for PXNPARM during Post-Install Customization (SO11608)
The post-install customization panels have been enhanced to allow editing of the Xnet startup parameters (PXNPARM) during customization of the Xnet Communications Server.
More information:
Swagger Format Support for RESTful APIs (SO11373)
The Database Management Data Service (DBM Data Service) RESTful APIs have been enhanced to use the latest version of Zowe when integrating with the API Mediation Layer. Also, the parameters in the DBM Data Service REST APIs have also been updated to remove redundancies, clarify use, and ensure consistency.
You can also now integrate the CA Detector REST APIs with the API Mediation Layer.
More information:
REBIND Phase-in Package Copy Support (SO11129)
CA Plan Analyzer now supports the rebind phase-in function, which allows Db2 to rebind and execute the same package concurrently.
More information:
Incremental and FlashCopy Image Copy Support in ADOR (SO11112)
The Automated Dropped Object Recovery (ADOR) feature in CA Log Analyzer has been enhanced to recover data from incremental image copies and FlashCopy image copies.
More information:
Test Data Manager Integration for Data Masking (SO11078)
You can now integrate
CA RC/Extract™ for DB2 for z/OS
(CA RC/Extract) with CA Test Data Manager (TDM) to mask data during an extraction while maintaining relational integrity and complex relationships. Data masking hides or obfuscates sensitive and classified data so that you can use the protected data without exposure during development, testing, and QA processes. To use this feature, you must be a licensed user of CA Test Data Manager.
More information:
Function Level M506 and M505 Support (SO10662, SO11107)
Db2 12 function level V12R1M506 and V12R1M505 support is now available. This support means that the products 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.
More information:
IQL Support for THRDACTV Thread Type Parameter (SO10739)
You can now use CA SYSVIEW for DB2 to write an IQL request that returns filtered threads. For example, all inactive threads. Previously, this task was only possible through an online request.
More information:
Advanced Trigger Packages and CONCENTRATESTMT Support (SO10712)
CA Plan Analyzer has implemented REBIND and FREE support for packages containing advanced triggers. Support is also provided for the new Db2 12 CONCENTRATESTMT BIND option.
More information:
SHRLEVEL CHANGE and Partition Image Copy Support in ADOR (SO10676)
CA Log Analyzer has enhanced the automated dropped object recovery (ADOR) feature so that you can recover from partition image copies and from image copies that are taken with the SHRLEVEL CHANGE parameter. You can also recover from implicitly created objects.
More information:
New Customized Metrics Selection for CA Mainframe Operational Intelligence (SO10716)
CA Detector has been enhanced to let you select the metrics you want to send to CA Mainframe Operational Intelligence from each Db2 subsystem.
More information:
Support for New Format of DSVOLSER Column (SO10626)
You can now unload from an image copy of a tablespace that uses the new DSVOLSER column format in the SYSIBM.SYSCOPY catalog table.
More information:
Use SYSLGRNX to Limit DDL Report Log Reading (SO10641)
You can use the SYSIBM.SYSLGRNX table information in CA Log Analyzer DDL reporting to limit log reading during initial log extraction for data sharing environments.alog table.
More information:
New Global Primary Command DB2L (SO10173)
When connecting to a Db2 subsystem, the SSIDVER and SSIDMODE values (or SSIDVERF and SSIDVERC values) in the SETUPxx parmlib member must match the run-time Db2 values. If they do not match, the connection fails.
A new global primary command DB2L has been added to display the DB2 12 continuous delivery levels (catalog level, function level, and previous highest level) of a subsystem and the SSIDVERC/SSIDVERF or SSIDVER/SSIDMODE values as defined in the SETUPxx parmlib member.
Enhanced Support for Unload from Archive Tables (SO10174)
You can now use CA Fast Unload to unload archive tables from Db2 tablespaces and image copies when you specify SQL-ACCESS NONE or EXTENSION.
More information:
CA Plan Analyzer Support for Db2 12 SYSPACKAGE and SYSPLAN Columns (SO12067)
CA Plan Analyzer now supports the APREUSE_NO_FL, APREUSE_NO_TS, CONC_STMT, FUNCTION_LVL, and ORIGIN columns in the SYSPACKAGE table.
More information:
CA Plan Analyzer Support for Db2 11 SYSPACKAGE Columns
CA Plan Analyzer now supports the ARCHIVESENSITIVE, BUSTIMESENSITIVE, DESCSTAT, and SYSTIMESENSITIVE columns in the SYSPACKAGE table.
More information:
CA RC/Query Utility Execution Performance Improvements
CA RC/Query® for DB2 for z/OS
(CA RC/Query) has been enhanced with performance-related improvements to help reduce CPU consumption during utility execution. Enhancements include:
  • A new profile option, Utility Object Count in 1 Step, that lets you specify how many utility statements you want to include in each JCL execution step. This option can improve system performance when multiple objects are being processed.
  • The UNLOAD line command has been enhanced to now generate DSNUTILB to unload data instead of DSNTIAUL. You can also specify the DSNTIAUL line command to unload data using the DSNTIAUL utility
More information:
RTOS Selection Improvements in CA Database Analyzer
The following
CA Database Analyzer™ for DB2 for z/OS
(CA Database Analyzer) enhancements are now available:
  • Support for Persistent Read Only (PRO) status
    . You can now exclude PRO restricted status objects from your database management recommendations. Select the (TS) check for one or more Db2 statuses action condition and specify 'NOT PRO' for the condition value to exclude PRO objects.
  • Improved Action Conditions for reorg of Active Pages
    . You can now select objects with no active pages and with a specific number (or range) of active pages for reorg using IBM Db2 Real-Time Statistics (RTS). Select the (TS) RTS reorg number of active pages* or (IX) RTS reorg number of active pages* action condition to specify the condition value.
More information:
CA RC/Migrator REBIND Enhancement to Resolve Invalid SPROCS
CA RC/Migrator™ for DB2 for z/OS
(CA RC/Migrator) and
CA RC/Compare™ for DB2 for z/OS
(CA RC/Compare) can now resolve invalid SPROCs during REBIND processing. SPROCs can become invalid when upgrading Db2 and can impact performance. A REBIND, even when the package has not been invalidated, will cleanup invalid SPROCs.
More information:
Batch Processor Displays Db2 12 Function Level
The Batch Processor now displays the current Db2 12 function level during execution of the
CA Database Management Solutions for DB2 for z/OS
. When connected to Db2 12 subsystems, the Batch Processor now displays the current function level during analysis execution.
Partition Level DSSIZE Support for PBR2 Indexes
On Db2 12 subsystems, you can now generate DDL that contains the DSSIZE clause in CREATE INDEX statements. DSSIZE is valid for an index at the global and partition level on a tablespace with relative page numbering (PBR2). CA RC/Migrator, CA RC/Compare, and
CA RC/Update™ for DB2 for z/OS
(CA RC/Update) now support a DSSIZE value from 1 GB to 1024 GB for PBR2 indexes. Global-level and partition-level support is controlled by the Generate common partition specifications at global level option in the OFS parmlib member.
More information:
Support for Unloads with PBR RPN (PBR2)
CA Fast Unload now supports unload from a tablespace or image copy that uses partition-by-range relation page numbering (PBR RPN), known as PBR2. To use PBR2, specify SQL-ACCESS NONE.
More information:
Mainframe Team Center Enhancements
The Mainframe Team Center user interface has been enhanced to improve the look and feel of the UI. Additional enhancements have been made to the Db2 subsystem selection process.
More information:
CA Fast Unload New Capability to Unload from Catalog Image Copy
You can now unload from a full image copy of a catalog tablespace when you specify INPUT-FORMAT IMAGECOPY and SQL-ACCESS ONLY or EXTENSION with CA Fast Unload.
More information:
HDDL Support on Nested Routines
CA RC/Query now generates DDL when executing the HDDL line command on any Db2 object that has a relationship with a routine (stored procedure or function (UDF)). All stored procedure and function types are supported. DDL is extracted based on HDDL panel preferences for all referred and related routines, which lets you create a mirror image of the object on a target subsystem.
More information:
CA Detector Collection Overhead Reduction
Collection improvements have been made in
CA Detector® for DB2 for z/OS
to help reduce overhead during statistics collection and SQL activity data collection.
More information:
CA Fast Unload Enhancement to Use Same Value for COMMA and QUOTE
When using OUTPUT-FORMAT COMMA-DELIMITED in CA Fast Unload, you can now select the same value for COMMA and QUOTE or specify a blank for COMMA and QUOTE NONE.
More information:
Recovery Simulation
The
CA Fast Recover™ for DB2 for z/OS
PREVIEW keyword has been enhanced with the ability to simulate the recovery process so you can validate that the recovery is possible. An estimate of the run time for the recovery job is provided as part of the simulation. During the simulation, the image copy is recovered to a shadow data set. The recovered database objects remain untouched. For more information, see the description of the PREVIEW keyword in the
CA Fast Recover™ for DB2 for z/OS
documentation.
Support for REBUILD INDEX with SHRLEVEL CHANGE
With
CA Fast Recover™ for DB2 for z/OS
, you can now specify the SHRLEVEL keyword to control what object state indexes and tablespaces are set to when you use REBUILD INDEX. The following keywords have been updated to call
CA Rapid Reorg® for DB2 for z/OS
in support of this feature:
  • SORTSIZE
  • ESTIMATED-KEYS
  • SORTNUM
CA SYSVIEW for DB2 Enhancements
The following
CA SYSVIEW® Performance Management Option for DB2
(CA SYSVIEW for DB2) enhancements are now available:
  • Support for custom HTML templates for email alerts. You can create multiple HTML templates and assign them to different destination groups.
  • The Batch Report Writer uses new parameter MBCCSID to support translation of SQL text encoded using a mixed byte CCSID.
  • The PassTicket configuration steps now explain how to log in to the VTAM user interface without having to type your password on the VTAM UI logon screen.
  • Support for new Db2 system parameters. The (106) DSNZPARM and (1006) CURR-PARMS trace records were updated to support new Db2 system parameters: TS_COMPRESSION_TYPE, ENCRYPTION_KEYLABEL, FLASHCOPY_XRCP, CDDS_MODE, CDDS_PREFIX, and REORG_TS_NOPAD_DEFAULT. The following reports were updated to include new values: ARCISDZ, BTSYSPRM, DSQPARMS, SYSPARMS, HSPARMS, and SYSPRLOG
  • Support for multiple application exception fields: QWAC_WORKFILE_CURR, QWAC_WORKFILE_MAX, QWAX_PIPE_WAIT, QWAX_PIPEWAIT_COUNT, QWAX_LOBCOMP, QWAX_LOBCOMP_COUNT, and QXSTSFND.
  • Support for multiple subsystem exception fields, in buffer pools statistics, log manager statistics, and EDM pool statistics.
  • Supports a new REST API call for canceling threads.
More information:
Transition to Continuous Delivery
After DBM 20 GA IR 8, we have transitioned from an Incremental Release model to a Continuous Delivery (CD) release model. The CD model provides new product features as individual PTFs, separate from product fixes providing more flexibility to select which service stream elements you want to apply (see new features above). You are not required to apply all new features in the CD release model; however, we strongly recommend that you stay current with new features and maintenance. SMP/E dependencies still apply when selectively applying maintenance.
More information:
DBM 20 GA IR 8 (March 2019)
The following enhancements are now available in solution DBM 20 GA IR 8:
  • Post-install and common enhancements:
    • Snapshot General Services has improved performance and provided CPU time reduction when using z/OS DFSMSdss services as a copy method. To benefit from this enhancement, enable the DFSMSdss copy method by specifying USEDFDSS(YES) in the TG10INIT subsystem initialization job.
      More information:
    • CREATE DDL, generated by the
      CA Database Management Solutions for DB2 for z/OS
      , is still executable for the following deprecated objects on a Db2 12 subsystem running V12R1M504:
      • Simple tablespaces (SEGSIZE=0, PARTITIONS=0)
      • Segmented tablespaces (SEGSIZE greater than 0, PARTITIONS=0)
      • Traditional index controlled partitioned tablespace (ICP) (SEGSIZE=0, PARTITIONS greater than 0)
      • Traditional table controlled partitioned tablespace (TCP) (SEGSIZE=0, PARTITIONS greater than 0)
      • Synonyms
      Affected products include
      CA Log Analyzer™ for DB2 for z/OS
      (CA Log Analyzer), CA RC/Compare, CA RC/Migrator, CA RC/Query, and CA RC/Update.
  • CA Fast Unload enhancements:
    • Support for common table expressions has been added when you specify SQL-ACCESS ONLY or EXTENSION. Common table expressions are specified by a WITH clause that precedes the SELECT statement.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Multiple IQL reports were enhanced to report the computation of the aggregated DB2 service wait time, detailed statistics, and event counts.
    • Multiple remote location reports were enhanced to use metrics CONVERSATIONS-SENT (QLSTCNVS) and CONVERSATIONS-RECEIVED (QLSTCNVR).
    • The PKG-RLIMIT-TYPE field in the (003) ACCT trace record was updated to support the new value 16 Limit.
    • Additional authorization error messages are now printed into the data collector job log for simplified analysis of authorization issues.
    • The list of user ABEND codes was added to the product documentation.
    More information:
KEY LABEL Clause Support (February 2019)
You can now generate DDL that contains the KEY LABEL or NO KEY LABEL clauses on DB2 subsystems running at DB2 12 function level M502 (V12R1M502) or higher:
  • CREATE STOGROUP
  • CREATE TABLE
This support is provided in CA RC/Migrator, CA RC/Compare, and CA RC/Update.
Two new utility models are provided:
  • OREORGKL (KEY LABEL online IBM REORG)
  • OREORGKR (KEY LABEL online IBM REORG for Recovery)
Both utilities use a new automatic symbolic, CDSN, as the prefix of the image copy data set names in the respective TEMPLATE statements.
More information:
CA SYSVIEW for DB2 RESTful API (January 2019)
CA SYSVIEW for DB2 uses the Database Management Data Service (DBM Data Service) microservice to access DB2 data collected by CA Database Management Solutions for DB2 for z/OS through Xnet and Xmanager services. Mainframe and non-mainframe applications can use the DBM Data Service with the new CA SYSVIEW for DB2 RESTful API to access the collected data.
More information:
DBM 20 GA IR 7 (January 2019)
The following enhancements are now available in solution DBM 20 GA IR 7:
  • CA Fast Recover enhancements:
    Recoveries for objects with Db2 12 features will temporarily use the IBM RECOVER utility instead of the Log Apply phase. To ensure successful completion of your jobs, ensure that you use syntax compatible with IBM RECOVER.
    More information:
  • CA Fast Unload enhancements:
    • The new LONG-CHAR option has been added to the PFU parmlib member to allow unloading VARCHAR columns larger than 255 bytes into CHAR fields.
    • The enhanced LOAD-CONTROL keyword allows generation of free-form load control statements to reload data using
      CA Fast Load for DB2 for z/OS
      (CA Fast Load) or Db2 LOAD.
    More information:
  • CA Log Analyzer enhancements:
    • New PLA parmlib option PRE_ALLOCATE (E,x) that uses parallel tasks to reduce the elapsed processing time of your jobs when recalling archive log data sets.
      This enhancement is available as an individual PTF outside of the incremental update.
    • The behavior of SHRLEVEL (S)kip in the PLA parmlib member has been enhanced to process SHRLEVEL CHANGE image copies instead of skipping them when the PIT_RBA for the image copy in SYSIBM.SYSCOPY is lower than the log point of the first incomplete update within the same tablespace that the image copy was taken for.
    More information:
  • CA Quick Copy enhancements:
    • The EXCP NO copy engine has been enhanced to support PBR2 objects.
    • The new parmlib option PQC-SHRLEVEL-CHANGE-POLICY (
      NORMAL
      |STRICT) has been introduced to specify whether to continue processing SHRLEVEL CHANGE incremental image copies or to terminate with RC=8.
    More information:
  • CA RC/Migrator and CA RC/Update enhancements:
    • An RC/Merger move analysis now generates DATASET calls for groups of related objects, including implicitly created tablespaces, tables, and indexes in a single .CALL RCMERGER statement.
      This enhancement is available as an individual PTF outside of the incremental update.
    • The ON DELETE ADD EXTRA ROW clause is now supported when specified in the ALTER TABLE statement. When specified, an extra row is inserted into the history table when a row is deleted to record information about the delete operation itself.
    More information:
  • CA RC/Query enhancements:
    The encryption key (KEY LABEL clause value) is now displayed in the following reports:
    • Storage Group List (SG-L) and Storage Group Detail (SG-D)
    • Tablespace List (TS-L) and Tablespace Detail (TS-D)
    • Table List (T-L) and Table Detail (T-D)
    • Index List (I-L) and Index Detail (I-D)
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Introduces a new IQL Editor (Windows application) that helps you edit IQL files more easily.
    • The (225) STMG-POOL-SUMRY trace record was updated to include new fields related to discarded pages: DISCARDED-PAGES, DISCARDED-64BIT-SHR-DB2, DISCRD-64BIT-SHR-STK-DB2, and DISCARDED-64BIT-COM-DB2.
    • The (337) LOCK-ESCALATION trace record was updated with new field THREAD-TOKEN, which contains the token of the thread responsible for the lock escalation.
    • The (376) APPL-SQL-INCOMPAT trace record was updated. The field SYSIBM-CHAR-FUNC now supports new function codes: 1215031–Temporal table and 1215032–CALL Stored Procedure for replications.
    • A new secondary ID utilization trace report (AUDCLKRB) was introduced. This report shows the usage of Kerberos Principal Name.
    • DB2 message collection in GSS can now be deactivated.
    • The active thread type filter can now be used for any request whose name begins with the characters THRDACT.
    • In the thread history, Autonomous Stored Procedure accounting records are now marked with value A.
    More information:
DBM 20 GA IR 6 (November 2018)
The following enhancements are now available in solution DBM 20 GA IR 6:
  • CA Fast Recover has been enhanced to use 830 KB less main storage in the first 16 MB of the address space. This change allows more parallel tasks. To increase the number of parallel tasks, see MAXTASKS--Control the Number of Tasks in the CA Fast Recover documentation.
    More information:
  • CA Fast Unload has added a new LONG-CHAR option to allow unloading VARCHAR columns larger than 255 bytes into CHAR fields.
    More information:
  • CA Quick Copy has been enhanced with a new option for LARGE-TAPE-BLOCK keyword and UTIL parmlib option. The new AUTO option detects and uses the maximum block size available to a device. The YES option now functions the same as the AUTO option.
    More Information:
  • CA RC/Migrator enhancements:
    • Parallel unload/load support during recovery processing. The IBM UNLOAD recovery utility model (IBMULD_R) now generates a recover data set with &PART in it when &PART is added to &DATADSN. The LOAD_R utility model generates load data sets with &PART in the analysis file.
    • New RC/Merger move analysis videos that describe advantages and how to perform a data only copy.
    More information:
  • CA RC/Query can now generate DDL and HDDL that contains the KEY LABEL or NO KEY LABEL clauses in the CREATE/ALTER STOGROUP and CREATE/ALTER TABLE statements on DB2 subsystems running at DB2 12 function level M502 (V12R1M502).
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • The (319) SECURITY-AUDIT trace record was updated to include new security mechanism types for the following fields: FLAGS, SECURITY-TYPE, and SECURITY-MECHANISM. The BTSQLTRL and BTRECTRC reports were updated to include new values.
    • The batch report writer (NISGHTRW) now supports automatic switching for the Daylight Saving Time (DST). The new parameter SYSPARM DST-LOCATION decides if the time is summer or winter and whether one hour should be added or not.
    • The new exception variable &TTOKNXX was added to contain the value of thread tokens. In the application-based exceptions, &TTOKNXX can be used as the exception message text.
    • The data collector was enhanced to automatically display online history runtime statistics related to activity in the dynamic SQL text database when HISTORY-SQLTEXT YES is specified.
    • The amount of storage available for the collection of details about the activity of DB2 threads was increased to 128-MB to prevent data loss on busy subsystems that are monitored by a data collector.
    • The IQL exception EXCP0376 was modified to display only the statement ID and the statement number. To enable the tracking of individual statements by the statement ID, set the EXCP-LONG376 custom IQL variable to YES using IQL-DEFINE=(EXCP-LONG376=YES) in the system parameters.
    More information:
DBM 20 GA IR 5 (July 2018)
The following enhancements are now available in solution DBM 20 GA IR 5:
  • Post-install and common enhancements:
    • 8-byte TSO/E user IDs for z/OS 2.3 are now fully supported across all
      CA Database Management Solutions for DB2 for z/OS
      , including post-install processing.
    • The Object List Manager (OLM) utility now supports the base selection of objects by packages with
      PACKAGE
      collection.package.version
      .
    • Snapshot General Services now switch to DFSMSdss for encrypted data sets.
  • CA Bind Analyzer now supports Db2 12 SQL DML syntax FETCH NEXT and OFFSET in SUBSELECT, FULLSELECT, and SELECT INTO statements.
    More information:
  • CA Fast Unload enhancements:
    • New RECFM keyword is now provided to unload multiple tables into a single fixed-length, blocked (FB) data set.
    • The SHRLEVEL CHANGE keyword can now be used without Db2 authorization to quiesce or display tablespaces.
    More information:
  • CA Log Analyzer now supports FlashCopy image copies for reporting purposes.
    More information:
  • 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.
    More information:
  • CA Quick Copy now supports segmented tablespaces through the Consistent Point-in-Time Service (CPITS). To process segmented tablespaces, DSNUM ALL is required with the CONSISTENT keyword (login required).
    More Information:
  • CA RC/Query has enhanced the ALL command to support the generation of utilities based on object type. For example, you can generate a Tablespace Table Inquiry report (TS-T) and then specify ALL DDL TS in the command line to generate DDL for tablespaces in the report. When you press Enter, the DDL command appears as a line command only next to the tablespace objects in the report.
    More information:
  • CA RC/Migrator and CA RC/Compare 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.
    More information:
  • 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.
    More information:
  • 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 FUNCTION_LEVEL column is supported when CA SQL-Ease creates the DSN_STATEMNT_TABLE.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • New Db2 11 and Db2 12 fields have been added to IFCID 002 (STATS2) and IFCID 106 (DSNZPARM).
    • The columns STATCLGSRT, ZHYPERLINK, and QUERY_ACCEL_WAITFORDATA have been added to the SUBSYS_ZPARM archive table.
    • Multiple IQL reports now use 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 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: &AUTHIDX, &PLANNAM, and &CONNNAM.
    • A new MSGTRAP command allows you to create a dump when a specific message is issued.
    • The latest CICS transaction server levels are now supported.
    More information:
DBM 20 GA IR 4 (April 2018)
The following enhancements are now available in solution DBM 20 GA IR 4:
  • Common and post-install related enhancements:
    • The APPLCOMPAT BIND option setting in your Db2 environment is now always used to bind packages when executing the Bind Product Plans and Packages post-installation configuration task.
    • All SQL parser content has been moved from FMID CINSK00 to FMID CSQ2100 CA Common Services for DB2 for z/OS.
    • The common services Lexical Analysis and SQL parser now support Db2 12 syntax elements (FETCH FIRST clause, FETCH NEXT clause, OFFSET clause, LIMIT clause, and obfuscated statement in CREATE TRIGGER).
    More information:
  • CA Bind Analyzer, CA Plan Analyzer, and CA SQL-Ease enhancements:
    • More Db2 12 SQL DML syntax support is provided. SQL that contains this syntax can now be processed successfully.
    • Db2® Spatial Extender support is now provided.
    More information:
  • CA Database Analyzer support for new action conditions for DSNACCOX.
    This feature is enabled by adding the new action conditions to your action procedures to provide improved recommendations for database maintenance.
    More information:
  • CA Detector enhancements:
    • New Database Management Data Service (DBM Data Service) that enables access to the Db2 data and metrics that CA Detector collects.
    • New Mainframe Team Center - Db2 Performance Analysis user interface that lets you use a web browser to view and explore the Db2 application performance data that CA Detector collects. For implementation details, see the Mainframe Team Center documentation.
    • The oldest interval in a data store can now optionally be deleted when a new interval is to be recorded and the data store is full.
    • Collection restarting is now enabled automatically following abnormal termination of data collection.
    More information:
  • CA Fast Unload has added a new NULL-FILL option to fill data parts of null fields in the output records with specified data.
    This option applies to VARIABLE and DSNTIAUL output formats and all data types except for LOB and XML.
    More information:
  • CA Log Analyzer now supports tracking different versions of the same table with Dropped Object Tracking. You can report the tables with the DML Report.
    More information:
  • CA Merge/Modify has added the following new keywords to the MODIFY RECOVERY DELETE options to check the number of image copies and/or full image copies that are remaining for the objects:
    • MINIMUM-COPIES
    • MINIMUM-FULLCOPIES
    More information:
  • 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. When a match is not found for the source column, the value that is specified for default column is used for the load. The value for source column is used when this column is not specified. New syntax:
    LOOKUP(<tbcreator>,<tbname>,<srccol>,<trgincol>,<trgoutcol>,<default column>)
    This enhancement is available as an individual PTF outside of the incremental update.
    More information:
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Enhanced archive tables support.
    • An online reorg is now generated during analysis in CA RC/Migrator when limit key values are altered on partition tables.
    • The EXCLUDE/INCLUDE NULL KEYS clause is now supported for CREATE INDEX statements when using CA RC/Migrator, CA RC/Compare, and CA RC/Update. You can also use the Syntax Checker function in CA RC/Migrator to validate the CREATE INDEX syntax with these clauses.
    • Intelligent REBIND exclusion is now provided in CA RC/Migrator when an alteration occurs and the BIND/REBIND analysis options are specified (R, C, or V).
    • Additional archive table support is now provided in CA RC/Migrator, CA RC/Compare, and CA RC/Update.
    • 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.
    More information:
  • CA RC/Query report enhancements:
    • Aliases that are created on sequences are now listed in the Alias List (A-L) report.
    • All catalog table columns are now included in the following list reports: Routine List (R-L), Permission and Mask List (PM-L), Table Column List (T-C), Table View List (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).
    • The I-C report has been enhanced to show the column order of IOEs correctly.
    More information:
  • CA Report Facility now includes support for long object names.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Can now start inactive menu selections when you select an option from the SYSTEM or THREAD menu and the underlying request was not included in the STARTUP member. The start panel is now shown instead of DBG55036W request not found.
    • Adds support for a new Db2 11 IFCID 406 (SYSTEM-PROFILE-MON) that contains the profile ID and the specific thread that is related for the following new values:
      • WARNING_DIAGLEVEL3
      • EXCEPTION_DIALEVEL3
      This record is used to identify threads that exceed the profile thresholds. The following reports were updated: RECTRACE and BTRECTRC.
    • Adds a new SYSPARM HSTSQLDB-DSN for a separate SQL history file has been added. This parameter contains the name of the new separate history file for SQL related data.
    • Now correctly evaluates comparisons of variable length string fields in the IQL WHERE clause.
    • Improves performance by changing the behavior of IQL exception EXCP0376 to raise the exception only for unique combinations of the package name and reason type. The same type of application incompatibilities for different statements within the same package now produces only one exception record.
      You can force the old behavior, which raises the exception for each statement by coding IQL-DEFINE=(EXCP-LONG376=YES) in the system parameter input.
    • Adds common fields to the Dynamic Where Field Index help. The common fields (the fields that are common to all Db2 trace records) are now listed with the IFCID 3 and the IFCID 151 fields.
    • Adds support for new SQL incompatibility batch reports on IFCID 376. The following reports have been added:
      • BTRINCMT (SQL Incompatibility Trace)
      • BTRINCMS (SQL Incompatibility Summary)
    • Thread selection presets are now available that allow you to save thread history selection criteria (presets) into a PDS member and later reload it. A new panel has been introduced.
    • Adds a new dynamic SQL history file and IQL functions STMT-CAPTURE and STMT-EXTRACT.
    • New Db2 12 fields have been added to IFCID 006 (READ-IO-ST) and IFCID 007 (READ-IO).
    • The IDB2ACCT reports have been redesigned to aggregate and report SQL details based also on the statement ID (STMT-ID).
      • A new option C (cache) has also been added to THRDIDSQ, HTIDBSQL, and HTUIDSQL to display detailed statistics from the dynamic or static SQL cache.
      • A new dynamic #IF statement has also been added (IQL-EXCLUDE-ACCEL) to remove the accelerator fields (AccelReq and AccelElapse) if the accelerator is not used. To suppress these fields, add the sysparm IQL-DEFINE=(IQL-EXCLUDE-ACCEL=YES).
    • IFCID 317 performance has been enhanced by using a smaller return area in the Db2 IFI call.
    More information:
  • CA Subsystem Analyzer has been enhanced to allow automatic restarting of collection (abend restart) following abnormal termination of data collection. This feature is enabled automatically.
    More information:
DBM 20 GA IR 3 (December 2017)
The following enhancements are now available in solution DBM 20 GA IR 3:
  • Common and post-install related enhancements:
    • The IBM Db2 12 Continuous Delivery model is now supported in the
      CA Database Management Solutions for DB2 for z/OS
      . To enable specification of the Db2 12 function and catalog levels for Db2 12 subsystems, the following new parameters have been added to the SETUPxx global parmlib member:
      • SSIDVERF for function level
      • SSIDVERC for catalog level
      After these parameter values have been specified during post-install processing, the Db2 function level displays as V12R1M500 or 121M500 on the product panels.
    • Toleration support is now provided for 8-byte user IDs with z/OS 2.3.
    • A new line command, U (Update) is now provided in RI Manager on NRS objects.
  • CA Fast Load has been enhanced to support online load replace.
    More information:
  • CA Fast Recover enhancements:
    • Added system level backup support. You can now use a system level backup as source to recover a single object. A new PFR parmlib keyword, USE-SYSBACKUP(YES|NO) is now provided. When set to YES and SLB entries exist in the BSDS, the system level backup entries are included in the chain of possible available recover bases.
    • SORTLOG YES OBIDXLAT, IC Pages must be in ascending order.
      Implementation: New internal check is now included to make sure that all pages read from the FULLDD must be in ascending order based on object and partition.
    More information:
  • CA Fast Unload enhancements:
    • ONE-SYSREC to support SYSREC01/SYSCT01 as fallback ddname
    • System pages are now tolerated in copies of tablespaces that contain unversioned tables when unloading these tables (UNLOAD from COPY system page found non-versioned table error)
    • New QUOTE-EMBED-SINGLE keyword
    More information:
  • CA Log Analyzer has been enhanced with a new option to generate application commits as part of DDL REDO reports. You can now apply commits after each unit of recovery (UR) in the DML REDO and UNDO SQL output for the DML Activity report. A new option, App. Commits (Y|N) is provided on the DML Activity Report Options panel to enable this feature. You must also select Order Output by Unit of Recovery ID.
    More information:
  • CA Merge/Modify enhancements:
    • A new PMM parmlib option, LGRNX-IBM, has been added. If set to YES, MODIFY
      DELETE calls the IBM utility internally to delete SYSLGRNX rows instead of using the two-phase approach.
    • You can now detect and remove ICTYPE=F and ICTYPE=I SYSIBM.SYSCOPY rows that refer to a non-existing data set. Use the new OR-DSNOTFOUND keyword option when you use MODIFY RECOVERY with the DELETE AGE, DELETE DATE, or DELETE KEEP options. When specified, you can delete all rows from SYSIBM.SYSCOPY that reference cataloged image copy data sets that do not exist.
    • Added copy-image copy system level backup support. The MERGECOPY component has been enhanced to create a copy of an image copy from system-level backup (SLB).
    • DSNUM Part support added to MODIFY component
    • The MODIFY RECOVER component has been enhanced to accept wildcards for DBNAME and TSNAME for DELETE AGE, DATE, and KEEP commands.
    • The MERGECOPY component has been enhanced to accepted wildcards for DBNAME and TSNAME for COPY-IMAGE-COPY command.
    More information:
  • CA Rapid Reorg has been enhanced to now support Reorg Pending Changes.
    More information:
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Migration toleration of base/archive table sets and improved handling of base/clone and base/history table sets in CA RC/Migrator.
    • Associated tables support is now provided in CA RC/Migrator. You can control selection and processing of base and associated (clone, history, and archive) tables in CA RC/Migrator strategies.
    • Partition level DSSIZE support for PBR2 tablespaces has been added in CA RC/Migrator. DSSIZE toleration support has been added at the partition level for relative page numbering tablespaces. You can now specify a DSSIZE of 1 GB to 1024 GB for a tablespace using relative page numbering.
    • Utility profile services support has been added for alterations that are pending changes in CA RC/Migrator.
    • Utility model enhancements:
      • Added support for unique data set names in utility models using the new DTQUAL qualifier.
      • TEMPLATE support is now used by default by all IBM utilities for allocating data sets. Support was also added for TAPE data sets.
      • Mutual exclusivity is now enforced between CA and IBM utilities when including and excluding.
    • The Db2 12 SYSTEM keyword is now supported in the CA RC/Migrator Syntax Checker function and when importing DDL in CA RC/Compare.
    • Isolation level support is now provided for RC/Browse and RI/Browse in CA RC/Update. CS and UR isolation level support has been added for all SELECT queries in RC/Browse and RI/Browse functions. Implement using the new profile option, Isolation Level support, and a new global option.
    More information:
  • CA RC/Extract now provides column level mapping support when performing load functions. A new M line command is now provided on the RXPTEDT Target Mapping panel where you can edit target definitions. When specified, the new Target Mapping Services panel is displayed for you to map the columns and specify mapping expressions (literals, column names, and IBM expressions and functions). A new line command, U (update) is also provided in RI Manager on NRS objects.
    More information:
  • CA RC/Query enhancements:
    • New clauses, INSERTVERSIONPAGES and SETCURRENTVERSION, are now supported in the REPAIR utility
    • CS and UR isolation level support has been added for all SELECT queries. A new RCQ parmlib member is now provided to set this setting at the global level.
    • DDL generation for implicit objects as comments using DDL or HDDL commands.
    More information:
  • CA Recovery Analyzer enhancements:
    • Added system level backup support. You can now select a System Level Backup RBA as a Recovery Point in the Global Options panel.
    • Recover Using Converted to RBA timestamp value
    More information:
  • CA Report Facility enhancements:
    • Added a new DRAW command to the EDIT NON-QUERY SQL screen to select all columns of a Db2 table.
    • The KEEP command now allows a table to be saved to a remote Db2 location.
    • A timestamp is now displayed for all objects on the library screens. The timestamp is updated for recently used objects with the current date and time whenever the corresponding object is browsed, modified, or executed.
    • A new SORT feature has also been introduced on the library screens that you can use to sort objects by column name in ascending or descending order.
    • The FORM command can now be used on the Query Result screen, which opens a temporary default form that can be saved.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • New lock types for Db2 12 are now supported in IFCID 21, 44/45, 150, 172, and 196.
    • Data can now be sent through the CA Common Services for z/OS Data Mover.
    • Added support for new Db2 11 and 12 fields in IFCID 366 (PREV10-CHAR-FUNC) and 376 (APPL-SQL-INCOMPAT):
      • The following fields were added: schema name, specific name, incompatible parameters, and SQL text.
      • The following reports were added or updated: EXCP0366, EXCP0376, INCOMPTD, HSTINCMD, HSTINCMP, HSUINCMP, RECTRACE, SQLTRACE, BTRECTRC, BTSQLTRL, HISTREQ, DCL$A$D, and MGSYSHST.
    • Updated the post-install tailoring panels to now include the ability to configure archive tables.
    • The user interface column filtering setting can now be stored in the second user profile data set.
    • Added support for latch statistics to online reports and archive table:
      • The following reports were added or updated: OLATCH, BTSTATR1, BTSTASM1, HSLATCH, and HSULATCH.
      • The following archive tables were updated: SUBSYSTEM_DETAIL and SUBSYSTEM_DAILY.
    • The data collector and batch report writer now support definition of custom IQL variables that can be used in the IQL #IF clause.
    • Added support for integration with CA Mainframe Operational Intelligence.
    • Enhanced the following real-time, history, and batch thread statistics reports to include the buffer pool hit ratio metric (Hit Ratio, BP-HITRATIO): THRDBUFD, HTBUFRS, HTUBUFRS, HTPKGBP, HTUPKGBP, BTACTSML, and BTACTTRL.
    • Added group buffer reclaim statistics (GRP-DIRENT-RECLAIM, GRP-XIDIR-RECLAIM, and GRP-DATENT-RECLAIM) to the SUBSYS_GBP_DETAIL and SUBSYS_GBP_DAILY archive tables.
    More information:
DBM 20 GA IR 2 (September 2017)
The following enhancements are now available in solution DBM 20 GA IR 2:
  • Common and post-install related enhancements:
    • The Object List Manager utility has been enhanced to now provide LISTDEF support in object lists. Implement this feature in CA Fast Recover, CA Merge/Modify, and CA Quick Copy using new keywords for the type restriction criteria: BASE and NOCLONE.
      More information:
    • New FMID Common SQL Services for DB2 for z/OS (SQ2) is now included with the CA Plan Analyzer dependencies. This enhancement includes the installation of a new plan and packages for SQ2.
      More information:
  • CA Fast Load has been enhanced to support the DATA-AVAILABLE HIGH keyword. This support minimizes object outages by introducing FASTSWITCH capabilities using a shadow data set. FASTSWITCH allows RO access to the object while CA Fast Load loads data into a shadow data set. When the data load completes, the instance prefix (I/J) is switched so that the shadow data set becomes the primary object and the original primary data set is deleted.
    More information:
  • CA Log Analyzer has been enhanced to provide DML filter expression support in strategy services.
    More information:
  • CA RC/Migrator and CA RC/Compare enhancements:
    • Archive tables are now supported in CA RC/Migrator to migrate base tables and associated archive tables. Support has also been added to the online panels to view base and associated pairs for clone, history, and archive tables.
    • Other pending changes are now supported through the utility profile services component in CA RC/Migrator. A new row, OTHER PENDING CHANGE, is now provided for tablespace, table, and index alterations. When the supported pending change alteration does not have its own specific row, the new row is used to determine what utilities to generate. By default, an online reorg is generated after the corresponding object type DDL.
    • Enhanced support is also provided to generate utilities when they are requested and to generate warning messages when a utility is required, but has not been requested.
    More information:
  • CA RC/Query will now generate implicit object DDL as comments when you execute the HDDL or DDL command if the object (database, tablespace, table, and index) is implicitly created. The output DDL is appended with --.
    More information:
  • CA Report Facility enhancements:
    • Added support to the TSO product version to edit procedures in the ISPF editor. Implement this feature using the new E option on the Proc Library panel or the new EDIT command on the Build Proc screen. This feature is also available in Release 19.0.
    • Added a new option that lets you modify the default product reaction when an error in online processing of procedure commands is encountered. This enhancement is an optional change to online procedure commands. To change, contact CA Support who will provide the SQL that is necessary to alter the default reaction. This feature is also available in Release 19.0.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Added support for new Db2 12 common field JOB-STEP in the following reports: AMSTRACE, AUDCLAS3, AUDCLAS4, AUDCLAS5, AUDCLAS6, AUDCLASA, AUDCLASB, AUTHFAIL, BTACTTRL, BTAUDPOL, BTLKCONT, BTPRTRCE, BTRECTRC, BTSUSPTR, DB2CMDL, DB2CMDS, DSEXTEND, DSEXTNDS, EXPSQL, GRANTREV, HPRAPLST, HSDLKTO, HSUDLKTO, HTDETL, INCOMPTD, LOCKCONT, PLANXPCT, PRTRCDTL, PUTRACE, QURYPARA, RECTRACE, SECIDTR, SUSPNDTR, TBLCONDT, THRDACTV, THRDDETL, THRDIDIO, THRDIDLK, THRDIDLS, THRDIDSM, THRDIDSQ, THRDIDSS, THRDTRAC, and V9CHRFUN.
    • Improved the documentation for IFCID 314 (ACC-AUTH-EXIT).
    • Added support for SQLJ host language using a new value J. The following reports were updated: SQLTRACE, RECTRACE.
    • Added support for CICS transaction details in the THRDDETL screen for CTS 5.3 and CTS 5.4.
    More information:
DBM 20 GA IR 1 (July 2017)
The following enhancements are now available in solution DBM 20 GA IR 1:
  • Object Framework Services enhancements:
    • Updated the OFS parmlib member to include a new CREATE VIEW default option, GENERATE_COLUMN_NAMES_WITH SELECT(*). This new option lets you retrieve the original CREATE VIEW DDL statements in CA RC/Migrator. Option O retrieves original VIEW DDL that was defined when the view was created. Option Y always generates VIEW DDL with column definitions, regardless of the original VIEW DDL. N always suppresses VIEW DDL column definitions, regardless of the original VIEW DDL.
    • New OFS Health Check for VIEW DDL WITH SELECT(*)
      A new health check, DB2_OFS_CREATE_VIEW with CA_DB2 as the owner has been added. This new health check verifies the value of the GENERATE_COLUMN_NAMES_WITH SELECT(*) parmlib option in the OFS parmlib member.
    More information:
    More information:
  • CA Detector now uses a queued element limit for all collection task queues to handle peek workloads. Implement this feature using the new MAXQ parameter in the PDT parmlib member. This feature is also available in CA Detector Release 19.0.
    More information:
  • CA Fast Load Enhancements:
    • Added the following SYSIN syntax options to delete non-dynamically allocated data sets at job step termination:
      • DELETE-FILES YES|NO
      • DELETE-SYSDISC YES|NO
      SYSERR and SYSDISC data sets are only deleted if SYSDISC is empty and DELETESYSDISC YES is specified. DELETEFILES YES applies to SYSERR, SYSREC, SYSUT1, and SYSULD data sets.
      This feature is also available in CA Fast Load Version 19.0.
    • Adds a new method to establish default RECLUSTER keyword settings using the PFL-RECLUSTER-DEFAULT option in the UTIL parmlib member. PFL-RECLUSTER-DEFAULT specifies what to sort when you omit RECLUSTER from SYSIN.
      This enhancement adds the following new options in the UTIL parmlib member:
      • PFL-RECLUSTER-DEFAULT
      • PFL-RECLUSTER-NO
      • PFL-RECLUSTER-YES
      The existing RECLUSTER NO and YES keyword options in SYSIN now use the new UTIL parmlib settings. NO uses the PFL-RECLUSTER-NO value. YES uses the PFL-RECLUSTER-YES value.
      To override the parmlib settings, use the following RECLUSTER options in your SYSIN:
      • The existing NO SORT-CLINDX keyword option
      • NO SORT-NONE, YES SORT-CLINDX, and YES SORT-ALL.
      This feature is also available in CA Fast Load Version 18.0 and Version 19.0.
    More information:
  • CA Fast Unload has added a new NULL-FILL option to fill data parts of null fields in the output records with specified data.
    This option applies to VARIABLE and DSNTIAUL output formats and all data types except for LOB and XML.
    More information:
  • CA Log Analyzer now provides a new DML filter expression that you can customize in the DML report, DML REDO/UNDO SQL, and DML load file.
    More information:
  • CA RC/Migrator, CA RC/Compare, and CA RC/Update enhancements:
    • Bufferpool page size is now an alterable change in CA RC/Migrator, CA RC/Compare, and CA RC/Update instead of DROP/CREATE for universal tablespaces and LOB tablespaces. When an alteration of the bufferpool results in a pending change, a REORG of the entire tablespace is needed to apply the pending changes to the definition and data of the tablespace. The syntax checker function in CA RC/Migrator can also be used to validate this syntax.
    • CREATE TABLESPACE PAGENUM support has been added to CA RC/Migrator, CA RC/Compare, CA RC/Query, and CA RC/Update. The PAGENUM clause is now included while generating CREATE TABLESPACE statement syntax for partition-by-range tablespaces in Db2 12 subsystems. PAGENUM ABSOLUTE is now generated in the DDL for a migrated partition-by-range tablespace that has the PAGENUM attribute value as NULL. This clause is also supported by the syntax checker function in CA RC/Migrator.
    More information:
  • CA RC/Query now generates PAGENUM ABSOLUTE in the DDL for a migrated partition-by-range tablespaces that has the PAGENUM attribute value as NULL.
    More information:
  • CA SYSVIEW for DB2 enhancements:
    • Added support for new Db2 12 fields in IFCID 58 (SQL-STMT). This record is primarily used by probes and when the HIST-ACCT-DETAIL option specifies SQL.
    • Added support for new Db2 12 fields in IFCID 372 (ADV-TRIG-DB2VAR), IFCID 391 (BLOCK-FETCH), IFCID 404 (AUTH-COMPATIBILITY), and IFCID 477 (FTB-ALLOC). The following reports were added or updated: ATHUCOMP, AUDCLASB, AUTHFAIL, BTRECTRC, BTSQLTRL, DBGSTART, DCL$A$D, IDSFTBAL, MGSYSTEM, and PSEDOSUM.
    • Now allows a custom plan for IFI monitoring threads.
    • Now allows you to suppress WTO messages that are related to Xnet agent processing. Implement using AGENT-DEBUG=1 in the data collector system parameters. This feature is also available in Release 19.0.
    • Updated the new archive tables to now store Db2 audit records, IDB2 accounting records, and information about executed SQL statements.
    • Improved throughput when passing Db2 command text to GSS. This feature is available in Release 18.0 and Release 19.0.
    More information:
  • CA Fast Unload enhancements:
    • The new LONG-CHAR option has been added to the PFU parmlib member to allow unloading VARCHAR columns larger than 255 bytes into CHAR fields.
    • Enhanced LOAD-CONTROL keyword allows generation of free-form load-control statements to reload data using
      CA Fast Load for DB2 for z/OS
      or Db2 LOAD.
    More information: