New Features

caidb220
The following new product features and enhancements to existing features are now available in Version 20.0 of the
CA SYSVIEW® Performance Management Option for DB2 for z/OS
:
3
Extended Support for Global Contentions (LU01175)
CA SYSVIEW for DB2
adds support for the following new global contention fields in the trace record (002) STATS:
  • ACTIVE-LATCH—Number of active IRLM control block latch contentions
  • GLOBAL-DEADLOCK—Number of global deadlocks
  • LOCAL-CONT—Number of local resource contentions
  • GLOBAL-CONT—Number of global resource contentions
  • CONT-GRANTED—Number of visits to the contention exit in which IRLM granted access
  • CONT-FALSE—Number of visits to the contention exit in which IRLM did not grant access due to a false contention
  • PLOCK-EXIT—Number of visits to the plock exit
  • NOTIFY-EXIT—Number of visits to the notify exit
The following reports were updated to include the new global contention statistics:
  • Batch reports: BTSTASM2, BTSTATR1
  • Real-time reports: DSQHIST, DSQSTATS, SYSGLOCK, SYSLOCKS, LACONT2
  • History reports: HSLOCK, HSGLOCK, HSTLACO2, HSUGLOCK, HSULOCK, HSULACO2
Archive Tables Update (LU01030)
CA SYSVIEW for DB2
updates the existing and adds two new archive tables.
The following archive tables now include the new Db2 12 statistics, such as new Db2 command counts, remote location details, FTB usage, Db2 Accelerator version 7 and zHyperlink details, and new Db2 ZPARMs:
  • SUBSYSTEM_DAILY and SUBSYSTEM_DETAIL
  • APPLICATION_DAILY and APPLICATION_DETAIL
  • SUBSYS_DDF_DAILY and SUBSYS_DDF_DETAIL
  • SUBSYS_BP_DAILY and SUBSYS_BP_DETAIL
  • SUBSYS_GBP_DAILY and SUBSYS_GBP_DETAIL
  • SUBSYS_ACCEL_DAILY and SUBSYS_ACCEL_DETAIL
  • SUBSYS_ACCEL_DAILY and SUBSYS_ACCEL_DETAIL
  • SUBSYS_SQL_DETAIL_DYNAMIC_ACCEL
  • SUBSYS_SQL_DETAIL_STATIC_ACCEL
  • SUBSYS_ZPARMS
The following two new archive tables store accounting data aggregated by the connection type. The source of data is trace record (369) CONNECTION-STATS.
  • SUBSYS_ACCT_BY_CONN_DETAIL
  • SUBSYS_ACCT_BY_CONN_DAILY
Use this data to monitor overall application activity and tune the workload.
Storage Statistics Added to USERS Command (LU00881)
CA 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 time interval specified by the HISTORY-MESSAGE-TIME system parameter.
Interval Delta Processing for IFCID 148 (SO16300)
CA SYSVIEW for DB2
now supports interval delta processing for IFCID 148 (THREAD-STATS).
A new IQL request THRDEXCP is based on IFCID 148 delta processing. This request populates the following two new IQL-based exceptions:
  • THDNOCMT—Captures the threads that do not commit.
  • THRDLOOP—Captures the threads that consume much CPU and do not access any data (zero getpages). These threads might be looping.
To start the THRDEXCP request with the data collector, customize its contents and update the STARTUP member.
Support for New Fast Index Traversal Metric (SO16270)
CA SYSVIEW for DB2
adds a new counter to record INDEX-WITH-FTB (IFCID 389) for the number of index traversals in the last interval.
VTAM Data Stream Compression Option (SO16116)
You can now specify the VTAM data stream compression option for the Remote Access Facility environment.
A new data collector system parameter VTAM-COMPRESS controls the compression of the data that is sent from the data collector to the user interface through the following options:
  • COMPAT—Uses simple software compression, which achieves a much lower compression rate, but requires slightly less CPU.
  • YES—Uses hardware compression to achieve a higher compression rate, but requires slightly more CPU.
  • NO—Does not compress data. This option may be best if VTAM does your data compression.
COMPAT is the default value and represents no change to existing processing of VTAM SEND/RECEIVE traffic.
Enhanced IUIBATCH Support (SO15952)
The
CA SYSVIEW for DB2
Batch User Interface program IUIBATCH now supports commands CHECK and UNLOAD.
For the complete list of supported commands, see Batch User Interface (UI).
Support for New Remote Location Fields (SO15647)
CA SYSVIEW for DB2
has added support for the new Db2 12 remote location fields. New fields were added to the trace records (001) STATS1, (1001) CURR-STATS1, and (365) RECORD-LOCATION.
The following reports were updated to include the new Db2 12 QLST statistics:
  • Batch reports: BTSTASM1, BTSTASM3, BTSTATR1, and BTSTATR3.
  • Real-time reports: DSQHIST, DSQSTATS, DSQSTLOC, SYSRMDTL, and SYSRMOTE.
  • History reports: HSRLOCS, HSRMOTE, HSRMTDT2, HSRMTDTL, HSURLOCS, HSURMOTE, HSURMTD, and HSURMTD2.
Section DISTRIBUTED DATA FACILITY in the batch reports was restructured.
Support for New Disk Cache Fields (SO15070)
CA SYSVIEW for DB2
has added support for the following new fields in the (003) ACCT, (148) THREAD-STATS, (369) CONNECTION-STATS, and (1044) APM-APPL-SUM trace records:
  • DISK-CACHE-IO-WAIT—Accumulated wait time for synchronous read I/O operations that resulted in disk cache hits.
  • DISK-CACHE-IO-COUNT—The number of synchronous read I/O operations which hit disk cache, but did not use zHyperLink.
Sample Queries for Archive Tables (SO15049)
The Sample Queries for Archive Tables were added to this documentation to explain how to exploit the data in your archive tables. A member in the SOURCE library, ARCSQL, contains the same sample queries. Change these queries according to your needs and write them against your archive tables to get the most out of your archival data.
Control Frequency of SQL Statistics Collection (SO14923)
A new data collector system parameter HIST-SQL-MULTIPLE allows you to decrease the collection frequency of SQL statistics in relation to subsystem statistics collection. The SQL statistics are based on IFCIDs 316/1043 and 401/1041. To determine the frequency of SQL statistics collection, multiply the values of HIST-SQL-MULTIPLE and HISTORY-STATS-TIME parameters. For example, if HISTORY-STATS-TIME=1 and HIST-SQL-MULTIPLE=15, the SQL statistics are collected every 15 minutes.
The amount of data for SQL statistics is typically larger than for subsystem statistics. You can now size the interval according to the needs of your environment, collect SQL statistics less often, and therefore optimize the resource consumption.
Updated Support for CICS Transaction Server (CTS) (SO14864)
The CICS Transaction Server 5.6 is now supported.
Support for New System Parameters (SO14754)
CA SYSVIEW for DB2
has added support for the following new Db2 system parameters:
New options were added for the following system parameters:
The following reports were updated: BTSYSPRM, DSQPARMS, SYSPARMS, HSPARMS.
A Required Xmanager Started Task (SO14389)
CA SYSVIEW for DB2
has introduced a required active Xmanager started task. During initialization, the
CA SYSVIEW for DB2
data collector attempts to connect to the Xmanager instance, which is specified by the PARMLIB XMANID parameter, to check the required maintenance level.
A new system parameter, XMANAGER-CHECK, specifies the data collector action (WARN, FAIL, or QUIET) when the connection cannot be established. For FAIL action, the data collector terminates. Else, processing continues. The default is WARN.
In the future, this setting will be overridden and default to FAIL to enforce the requirement for the data collector and Xmanager connection.
MOI Instance Identifier Change (SO14164)
CA SYSVIEW for DB2
has introduced a new system parameter ZDM-PREFIX, which specifies the first four characters of the CCS Data Mover instance identifier. This identifier uniquely identifies the
CA SYSVIEW for DB2
data collector in the CA MOI infrastructure and consists of ZDM-PREFIX value appended with Db2 subsystem name. A duplicate data collector instance is not allowed to connect to the CSS Data Mover.
You can now change the instance identifier to a value that is consistent across the data collector restarts.
Support for New Group Buffer Pool Metrics (SO14099)
Support for the following trace records was added:
  • The following new field reports GBP metrics on the system level:
    • IXLAXISN-SUSPENDS-XI—The number of suspensions of coupling facility asynchronous cross-invalidation service sync-up calls while waiting for the asynchronous cross-invalidation to finish.
    The following reports were updated to include a new field: BTACTSML, BTACTTRL, DSQTHD, DSQTHDGB, HPRACCT, HPRACCTS, HTGBPL, HTUGBPL, THRDGBP, and THRDTRAC.
  • (1002) CURR-STATS2 - Group Buffer Pool Statistics
    The following new fields report GBP metrics on the thread level:
    • IXLCACHE-REQS-XI—The number of coupling facility cache requests with asynchronous cross-invalidation (XI).
    • IXLAXISN-SVCS-CALLS—The number of coupling facility asynchronous cross-invalidation service sync-up calls to determine whether all outstanding cross-invalidation (XI) notifications have been delivered.
    • IXLAXISN-SUSPENDS-XI—The number of suspensions of coupling facility asynchronous cross-invalidation service sync-up calls that occurred while waiting for the asynchronous cross-invalidation to finish.
    The following reports were updated to include new fields: BTSTASM2, BTSTATR1, DSQHIST, DSQSTATS, DSQSTGBP, HSGBUFD, HSUGBUFD, and SYSGBUFD.
Support for New Db2 12 Insert Algorithm and RID List Fields (SO14099)
Support for the following trace records was added:
  • (002) STATS2, (003) ACCT, (148) THREAD-STATS, and (1002) CURR-STATS2
    The following fields were added:
    • IAG2-PIPE-ATTEMPTED-RNBL—The number of attempted Insert Algorithm 2 (IAG2) pipes reenablements since the last Db2 restart.
    • IAG2-PIPE-SUCCESSFUL-RNBL—The number of successful Insert Algorithm 2 (IAG2) pipes reenablements since the last Db2 restart.
    • IAG1-USED—The number of times basic Insert Algorithm (IAG1) is used.
    • IAG2-USED—The number of times fast Insert Algorithm (IAG2) is used.
    • MIAP-NOT-USED—The number of times RID list processing is not used or terminated for the whole query.
    The following reports were updated to include new statistics.
    • Batch reports: BTACTSML, BTACTTRL, BTSTASM2, and BTSTATR1.
    • Real-time reports: DSQHIST, DSQSTATS, DSQTHD, PRLMISC, SQLCOUNT, SYSLPRF, THRDLPRF, and THRDPRMS.
    • History reports: HSLPRF, HSTPRLMS, HSULPRF, HSUPRLMS, HTHDPRMS, HTLSTPRF, HTSQL, HTUDPRMS, HTULPRF, and HTUSQL
Support for Db2 Accelerator Version 7 (SO13891)
CA SYSVIEW for DB2
has added trace record support for Db2 Accelerator version 7. New fields include details, such as replication with delay protocol, and are reported on all monitoring levels:
  • Subsystem level statistics
    The following new fields are introduced in (002) STATS2 and (1002) CURR-STATS2: ACCEL-USER-MEM-MB, ACCEL-SQL-MEM-MB, ACCEL-QUEUE-LENGTH, ACCEL-SORT-OVERFLOW, ACCEL-BP-HITRATIO, ACCEL-INBOUND, ACCEL-OUTBOUND, ACCEL-TMP-DATA-MB, ACCEL-LOG-DATA-MB, ACCEL-WFD-REQS-SSID, ACCEL-WFD-EXPIRED-SSID, ACCEL-WFD-REQS-ALL, ACCEL-WFD-EXPIRED-ALL, and ACCEL-WFD-REPL-VELOCITY.
  • Dynamic and static SQL level statistics
    New fields ACCEL-WAIT-TIME-REPL and ACCEL-TIMEOUTS-REPL are introduced in (316) DYNAMIC-SQL-STATS, (1043) DYNAMIC-CACHE-COLL, (401) EDM-POOL-STMTS, and (1041) EDM-STAT-STMT-COLL.
  • Thread level statistics
    New fields ACCEL-WAIT-TIME-REPL and ACCEL-TIMEOUTS-REPL are introduced in (003) ACCT and (148) THREAD-STATS.
Db2 Accelerator-related reports were updated to include the new statistics.
Support for New and Updated Trace Records (SO13557)
Support for the following trace records was added:
  • Support for new Db2 12 Resource Limit Facility (RLF) codes was added to the following fields: RLIMIT-TYPE, PKG-RLIMIT-TYPE, RLF-DERIVED, and PKG-RLF-DERIVED.
    The following reports were updated: BTACTSML, BTACTTRL, THRDLOCK, HTLOCKS, HTULOCKS, HTPKGLK, HTUPKGRL, HTURLF, and HTUPKGLK.
    The following new reports were added:
    • THRDRLF—Thread Resource Limit Facility request
    • HTHRLF—Thread Resource Limit Facility History request
zHyperLink Support (SO13557)
Dataset I/O and log activity reports were previously updated to show the zHyperLink workload use.
CA SYSVIEW for DB2
has now been further enhanced to 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 usage.
CA SYSVIEW for DB2
now reports on the following metrics:
  • I/O workload that used zHyperLink
  • I/O workload that did not use zHyperLink
  • Percentage of the workload with potential to use zHyperlink
  • Percentage of the workload that used zHyperlink
  • Whether a read request was zHyperlink eligible (Disk Cache Hit)
  • Whether a read request used zHyperlink
The following new fields were added to IFCIDs (003) ACCT, (007) READ-IO, (1002) CURR-STATS2, (1012) IO, and (1026) STATS-BUFFER-SIZES:
  • ZHYPERLINK-READS—Number of synchronous read I/O operations which used zHyperLink.
  • DISK-CACHE-READS—Number of synchronous read I/O operations which hit disk cache, but did not use zHyperLink.
  • ZHLINK-READ-CPU—CPU time used for successful zHyperLink reads.
  • ZHLINK-READ-CPU-INT—Derived field from QBACSYIT (ZHLINK-READ-CPU).
  • DISK-CACHE-HIT—Read success of disk cache hit.
The following reports were updated: BTACTSML, BTACTTRL, BTSTASM2 BTSTATR1, BUFRDWRS, DSQHIST, DSQSTATS, DSQSTBP, DSQTHD, DSQTHDBP, HSBRDWR, HSSNAP, HSUBRDWR, HSUSNAP, HTBUFRS, HTPKGBP, HTRESP, HTUBUFRS, HTURESP, SYSSTATA, SYSSTATS, THRDBUFD, and THRDRESP.
Improved Documentation of IQL Fields Calculations
CA SYSVIEW for DB2
IQL field values are often calculated from Db2 fields. For better understanding of the listed IQLs, the documentation of elapsed time and wait time fields has been enhanced with the exact calculations.
The following sections have been updated: (003) DB2 Accounting Record, (148) THREAD-STATS, and (369) Repeating Fields.
The documentation of the metrics which send
CA SYSVIEW for DB2
data to
CA Mainframe Operational Intelligence
has also been enhanced with exact calculations.
Cancel by Token Support (SO13508)
The
CA SYSVIEW for DB2
user interface now supports thread cancellation using the thread token. Cancellation by token allows INACTIVE threads to be canceled. The existing process of canceling a thread now automatically uses the thread token, when it is available.
Two new fields have been added to IFCID 1017: HOLDER-THREAD-TOKEN and WAITER-THREAD-TOKEN
Support for New and Updated Trace Records (SO12769)
Support for the following trace records was added:
  • (001) STATS1 and (1001) CURR-STATS1 - Log Manager Statistics
    The following new Db2 11 field was added related to Compression Dictionary Data Set (CDDS):
    • CDDS-ACCESS-REQS—Total number of CDDS access requests.
    The following new Db2 12 fields were added related to zHyperLink:
    • ZHLINK-LOGW-REQS-SUCC—Total number of eligible LOG WRITE I/O requests with successful zHyperLink processing.
    • ZHLINK-LOGW-REQS-UNSUCC—Total number of eligible LOG WRITE I/O requests with unsuccessful zHyperLink processing.
    The following reports were updated: BTSTASM1, BTSTATR1, DSQHIST, DSQSTATS, HSLOG, HSULOG, and LOGSTATS.
    The real time and history reports were redesigned. Log Manager Statistics section was reorganized, so that metrics are easier to understand.
  • (001) STATS1 and (1001) CURR-STATS1 - New Command Counts
    The following new Db2 11 command count fields were added: DISPLAY-SERVICE, START-SERVICE, STOP-SERVICE, START-CDDS, STOP-CDDS.
    The following new Db2 12 command count fields were added: DISPLAY-ML, START-ML, STOP-ML.
    The following reports were updated: BTSTASM1, BTSTATR1, DSQHIST, DSQSTATS, HSCMD, HSUCMD, and ICMDS.
  • (1002) CURR-STATS2 - Secondary Latch Contentions
    New Db2 12 fields related to secondary latch contentions were added.
    The following reports use new fields for improved monitoring of latch contentions:
    • BTSTASM2 and BTSTATR1—Batch requests
    • HSTLACO2 and HSULACO2—New history interval and summary requests
    • LACONT2—New real-time subsystem secondary latch contentions request
New FTB Statistics Reports (SO12769)
A new real-time and history reports show Fast Traversal Block (FTB) activity on the system. Batch reports BTSTASM2 and BTSTATR1 provide new metrics in the Miscellaneous section. Navigation was improved. You can now better monitor and tune the fast traverse index access activity.
Stabilized Dynamic SQL Display (SO12769)
SQL Exec Current Stats and SQL Exec History (option 10 and 11 from the menu) now display a new column 'Catlg Stblz'. This column indicates whether the dynamic SQL statement is stabilized using dynamic SQL plan stability and its access path is stored in the Db2 catalog. You can now quickly find stabilized and non-stabilized statements. Previously, this information was only available in details.
FULLDUMP=YES Option Deprecated (SO12769)
SYSPARM option FULLDUMP=YES has been deprecated. FULLDUMP=YES is now processed as FULLDUMP=SVC. This enhancement improves our support, as we can immediately process dumps in SVC format.
Improved Help Panels Descriptions (SO12769)
The online help panels descriptions have been reviewed and updated. CLEAR and COLIND command descriptions have been improved in the following panels: DBGHCCLR, DBGHSOR, and DBGTCMD.
Support for New and Updated Trace Records (SO11616)
Support for the following trace records was added:
  • (106) DSNZPARM
    A new Db2 12 system parameter STATPGSAMP specifies whether the runstats utility uses page-level sampling.
    The field QWP4QACO (QUERY_ACCEL_OPTIONS) now supports the following new options:
    • Offload with uncertainty cost enabled
    • Offload favors new accelerator type
    SU-CONV-FACTOR was added to the required IQL requests.
    The following reports were updated: ARCISDZ, BTSYSPRM, DSQPARMS, SYSPARMS, and HSPARMS.
  • (199) DATASET-IO-STATS
    The following new fields provide support for IBM zHyperLink for z/OS, which is supported by Db2 12: ZHLINK-AVG-IO-DELAY-MIL, ZHLINK-MAX-IO-DELAY-MIL, ZHLINK-TOTAL-IO-PAGES, ZHLINK-AVG-IO-DELAY-MIC, ZHLINK-MAX-IO-DELAY-MIC, ZHLINK-AVG-IO-DELAY-INT, and ZHLINK-MAX-IO-DELAY-INT.
    The following reports were enhanced to use new fields: DSIOSTAT, HSDSIO, and HSUDSIO.
Support for SWAP and SPLIT Commands (SO11616)
To ensure consistency between different environments, the
CA SYSVIEW for DB2
now supports SWAP and SPLIT commands in the User Interface command line. The following ISPF commands are now supported: SPLIT, SWAP, SWAP LIST, SWAP PREV, SWAP NEXT, SWAP n (where 'n' is a session number), and SWAP screen_name.
IQL Support for the THRDACTV Thread Type Parameter (SO10739)
It is now possible to write an IQL request that returns filtered threads, for example all inactive threads. Before that was only possible through the Active Threads screen request. In the IQL requests for the record THREAD-STATS, you can now code "thread type" filter that mimics a specific thread type selection, such as Inactive or Indb2, on the Active Threads Screen.
If you write IQLs to collect thread stats, this added support allows you to apply the same filtering that is available in the user interface. The result set may then be analyzed and passed to automation (OPS/MVS) or to the
CA SYSVIEW for DB2
Exception System.
New and Updated Metrics for MOI (SO10716)
Support for sending additional Db2 subsystem metrics to CA Mainframe Operational Intelligence was added. Use this link to view the complete list of metrics. One existing metric has been changed, IDBBREAD now includes all read I/O counts, both synchronous and prefetch.
A new MOIHWM IQL-DEFINE variable was introduced to control a couple metrics in IQLMSTAT. When enabled,
CA SYSVIEW for DB2
sends interval high-water mark values instead of classic active threads counts.
Indoubt Thread Monitoring (SO10160)
CA SYSVIEW for DB2
now reports the number of indoubt threads in (1001) CURR-STATS. The following IQL requests were updated to include a new field INDOUBT-THREAD: SYSSTATA, SYSSTATS, and DSQSTATS.
New Thread Summary History (Application Throughput) (SO10160)
A new Application Interval Summary Report (HTUAPRF) helps you identify which Db2 threads used excessive amount of resources in the specified time interval. This request is grouped by interval and one of the following fields: AUTH-ID, CONN-NAME, CORR-ID, or PLAN-NAME. The IQL-DEFINE statement controls the grouping.
Added Support for IBM Utility Monitoring (SO10160)
CA SYSVIEW for DB2
has added support for displaying the status of Db2 utility jobs. A new Utility Status panel (UTLEXE) has been added to the System Statistics menu. A new internal IFCID (1050) UTILITY-EXEC reports the utility information.
Updated Exception Report DBGEXRPT (SO10160)
The Exception File Contents Report (DBGEXRPT) prints the contents of the Exception File, which indicates active and inactive exceptions. The Exception File Reporting Utility was updated to display new Exception Definition fields.
Improved ABEND Reporting (SO10160)
The user ABEND codes were standardized based on component. Forced S0C1/S0C3 were changed to user ABEND codes. Reason codes were introduced to provide more information about the ABEND condition.
Support for New and Updated Trace Records (SO08846)
Support for the following Db2 system parameters was added to the trace records (106) DSNZPARM and (1006) CURR-PARMS:
  • Specifies the type of compression algorithm to use with compressed table spaces.
  • Specifies the name of an ICSF key label to provide to DFSMS when using z/OS DFSMS data set encryption support to define encrypted data sets for the Db2 catalog, directories, and archive logs.
  • Specifies whether a data set level FlashCopy operation is allowed to a primary volume in an XRC relationship.
  • Specifies a Db2 data sharing group participation in a GDPS Continuous Availability with zero data loss environment.
  • Specifies the prefix for the name of the compression dictionary data set (CDDS).
  • Specifies the default setting for the NOPAD option of the UNLOAD EXTERNAL specification or the DISCARD specification of the REORG TABLESPACE utility.
The following reports were updated to include new values: ARCISDZ, BTSYSPRM, DSQPARMS, SYSPARMS, HSPARMS, SYSPRLOG.
Updated Exception Fields (SO08846)
Support for the following exception fields was added.
Custom HTML Templates for Email Alerts (SO08846)
Support for multiple custom HTML templates for email alerts was added. You can create multiple HTML templates and assign them to different destination groups. A new keyword TEMPLATE in the destination group defines a PDS member that contains the HTML template. The partitioned data set specified in the SMTP-TEMPLATE-DSN parameter is used to find the HTML template member.
Batch Report Writer Update (SO08846)
The
CA SYSVIEW for DB2
Batch Report Writer uses new parameter MBCCSID to support translation of SQL text encoded using a mixed byte CCSID.
Documented PassTicket Configuration
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. The PassTicket is a one-time password substitute that is supported by ACF2, Top Secret, and RACF. PassTickets enable the z/OS components and products to authenticate a user ID without transmitting the password across the networks.
REST API: Cancel Thread Function (SO08825)
A new REST API call supports thread cancellation.
Incremental Release 8 (SO07806)
The following enhancements are now available in IR 8.
Improved Reports
Multiple IQL reports were enhanced in reporting computation of the aggregated wait Db2 service time, detailed statistics, and event counts:
  • THRDRESP, HTRESP, HTURESP
    Thread response time
  • CSACCTD, HSTCSAD, HSUCSAD
    Accounting statistics
  • THRDTRAC
    Application probe
  • HPRACCT, HPRACCTS, HPRSTLST, HPRSTSML
    Hierarchical application probe
  • DSQCONN, DSQHIST, DSQTACT, DSQTHD
    DSQ requests
  • ARCIACD, ARCIACS
    Application archive table requests
  • BTACTSML, BTACTTRL, BTDSQSMS, BTRCSASL, BTRCSATL, BTSSQSMS
    Batch reports
  • Z316LST, Z316LSTS, Z401LST, Z401LSTS
    SQL analysis reports
  • DYNSQLCI, DYNSQLST, STASQLCI, STASQLST
    SQL statistics
  • HSDYNSQL, HSUDYNSQ, HSSTAPGM, HSSTAPGS, HSSTASQL, HSUSTAPG, HSUSTAPS, HSUSTASQ
    SQL history statistics
The following remote location reports were enhanced to use metrics CONVERSATIONS-SENT (QLSTCNVS) and CONVERSATIONS-RECEIVED (QLSTCNVR):
  • SYSRMOTE—System Remote Locations
  • THRDLOCS—Thread Remote Location List
  • HTRMOTE—Thread Remote Location History List
  • HTURMOTE—Thread Remote Location History Summary List
  • BTSTATR3—Distributed Activity by Remote Location Report
  • BTSTASM3—Summary of Remote Activity Report
Support for Updated Trace Records
Support for the following trace record was updated:
  • (003) ACCT
    The field PKG-RLIMIT-TYPE now supports new value:
    • 16 Limit was obtained from a row in the RLMT table
Improved Analysis of Authorization Issues
CA SYSVIEW for DB2
now prints additional authorization error messages (DBG55096W) into the data collector job log for simplified analysis of authorization issues.
Mapping of User ABEND Codes
The list of user ABEND codes for
CA SYSVIEW for DB2
was added to the product documentation.
DBM Data Service REST API (SO06977)
The Database Management Data Service (DBM Data Service) hosts a RESTful API that enables access to Db2 data and metrics that are collected by the
CA Database Management Solutions for DB2 for z/OS
. The DBM Data Service allows mainframe and non-mainframe applications to use the API hosted by the service to access the data collected by
CA SYSVIEW for DB2
. For more information, see Configure REST API and Using the REST API.
You can integrate
CA SYSVIEW for DB2
REST API service with the API Mediation Layer. This integration provides the following benefits:
  • Makes your service details, such as availability status and API documentation, available through the API Catalog.
  • Enables you to run multiple service instances to ensure high-availability.
  • Lets you change the service IP location without affecting the REST API client communication.
Incremental Release 7 (SO06863)
The following enhancements are now available in IR 7.
IQL Editor
CA SYSVIEW for DB2
has introduced an IQL Editor (Windows application) that helps you to edit IQL files more easily. You can modify IQLs, design new IQL requests, and create custom IQL reports. IQL Editor supports multiple open files in a single window. Snippets with ready pre-defined code parts are included for easy creation of new content.
Support for New and Updated Trace Records
Support for the following trace records was added:
  • (225) STMG-POOL-SUMRY
    The following fields related to discarded pages were added: DISCARDED-PAGES, DISCARDED-64BIT-SHR-DB2, DISCRD-64BIT-SHR-STK-DB2, and DISCARDED-64BIT-COM-DB2.
  • (337) LOCK-ESCALATION
    A new field THREAD-TOKEN was added. This field contains the token of the thread responsible for the lock escalation.
  • (376) APPL-SQL-INCOMPAT
    The field SYSIBM-CHAR-FUNC now supports new function codes:
    • 1215031—Temporal table
    • 1215032—CALL Stored Procedure for replications
New Audit Request for Secondary ID Utilization
A new secondary ID utilization trace report (AUDCLKRB) shows the usage of Kerberos Principal Name. This report is based on records (055) SET-SQLID, (083) IDENTIFY, (087) SIGNON, and (319) SECURITY-AUDIT (audit trace class 7).
Allow De-activation of Db2 Message Collection in GSS
Db2 message collection in GSS can now be deactivated. If you do not want certain items sent to the ILOG, you can disable them. Previously the
CA SYSVIEW for DB2
data collector was directing GSS to capture all WTO messages from the Db2 subsystem address space to the ILOG file.
Active Thread Type Filter Usage Expanded
The active thread type filter can now be used for any request whose name begins with the characters THRDACT. Previously this filter was only available to the THRDACTV request.
Autonomous Stored Procedures Marked in Thread History
In the thread history, Autonomous Stored Procedure accounting records are now marked with value A. Previously they were indicated as child summary records.
Incremental Release 6 (SO06112)
The following enhancements are now available in IR 6.
Support for New and Updated Trace Records
Support for the following trace record was added:
  • The following fields were updated to include new security mechanism types: FLAGS, SECURITY-TYPE, and SECURITY-MECHANISM. The BTSQLTRL and BTRECTRC reports were updated to include new values.
NISGHTRW Automatic Daylight Savings Time Switching
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.
New Exception Variable &TTOKNXX
The new exception variable &TTOKNXX was added to contain the value of thread tokens. The thread token value is a unique value for the life of the Db2 subsystem. This variable can be used in both application-based exceptions and IQL-based exceptions. In the application-based exceptions, &TTOKNXX can be used as the exception message text.
Dynamic SQL Text Database Runtime Statistics
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.
Increased Storage Collection Limits for IDB2ACCT
The available storage for the collection of details about the activity of Db2 threads was increased to 128 MB. The increased amount of storage prevents data loss on busy subsystems that are monitored by a data collector.
Exception Task Performance Improvement
The IQL exception EXCP0376 was modified to display only the statement ID and the statement number. This change of default behavior decreases CPU overhead and storage shortages.
Incremental Release 5 (SO04455)
The following enhancements are now available in IR 5.
Support for New and Updated Trace Records
Support for the following trace records was added:
  • New Db2 11 fields were added to support new WAITFORDATA system statistics (for Accelerator V5 and V6): ACCEL-USER-MEM-MB, ACCEL-SQL-MEM-MB, ACCEL-QUEUE-LENGTH, ACCEL-SORT-OVERFLOW, ACCEL-BP-HITRATIO, ACCEL-INBOUND, ACCEL-OUTBOUND, ACCEL-TMP-DATA-MB, ACCEL-LOG-DATA-MB, ACCEL-WFD-REQS-SSID, ACCEL-WFD-EXPIRED-SSID, ACCEL-WFD-REQS-ALL, ACCEL-WFD-EXPIRED-ALL, and ACCEL-WFD-REPL-VELOCITY.
  • New Db2 12 fields were added: FTB-CANDIDATE-COUNT, FTB-INDEX-COUNT, FTB-LAST-INTERVAL-COUNT, FTB-MEMORY-USAGE, FTB-THRESHOLD, and FTB-CUR-INTERVAL-COUNT.
  • New Db2 11 fields were added: STATCLGSRT and QUERY-ACCEL-WAITFORDATA.
    New Db2 12 field was added: ZHYPERLINK.
    The columns STATCLGSRT, ZHYPERLINK, and QUERY_ACCEL_WAITFORDATA were added to the SUBSYS_ZPARM archive table.
Leveraging Dynamic SQL Text Database in IQL Reports
Multiple IQL reports were enhanced to use the Dynamic SQL Text Database:
  • V9CHRFUN, INCOMPTD, HSTINCMD
    SQL incompatibilities
  • THRDTRAC, HPRACCT, HPRACCTS, HPRSTDTL
    Hierarchical application probe
  • PRTRCDTL, RTNSTSUM
    Stored procedure/user-defined functions
  • Detail trace of DDF activity
  • SQL statements that scan many pages
  • Profile of rows processed by a statement
  • Detail trace of Db2 activity
  • Trace all SQL Statements
  • Rows processed for each SQL statement
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.
  • For static statements
    The SQL text is retrieved from the Db2 catalog using the statement ID as before.
The
C-Cache
line command was added to these reports. This command preserves the original functionality for displaying the detailed statement statistics retrieved from the dynamic cache or EDM pool.
Updated Exception Action to Send an SNMP Trap and Email
In the exception action to send an SNMP trap and email, you can now use the following three variables as a destination group name: &AUTHIDX, &PLANNAM, and &CONNNAM.
F MSGTRAP to Create a Dump on Specific Message
A new MSGTRAP command allows you to create a dump when a specific message is issued.
Updated Support for CICS Transaction Server (CTS)
The CICS Transaction Server 5.5 is now supported.
Pervasive Encryption
IBM system z Pervasive Encryption support is now provided.
Incremental Release 4 (SO01395)
The following enhancements are now available in IR 4.
Support for New and Updated Trace Records
Support for the following trace records was added:
  • A new field STMT-TYPE-FLAG was added.
  • Traces the system profile monitor (captures THREAD-INFO details of the DSNT773I or DSNT774I messages). New with Db2 11. The RECTRACE and BTRECTRC reports were updated to include this record.
Starting a Request Outside the STARTUP Member
A new behavior occurs when you select an option from the SYSTEM or THREAD menu, but the underlying request was not included in the STARTUP member. The start panel is now shown instead of DBG55036W (request not found) and the request may be started.
Redesign of the (151) IDB2ACCT Reports
The IDB2ACCT reports were redesigned to aggregate and report SQL details based also on statement ID (STMT-ID):
  • The new option "C=Cache" was added to the IDB2ACCT reports (THRDIDSQ, HTIDBSQL, HTUIDSQL) to show detailed statistics from the dynamic or static SQL cache.
  • The new dynamic #IF statement "#IF IQL-EXCLUDE-ACCEL" was added to the IDB2ACCT reports to exclude accelerator fields ("AccelReq" and "AccelElapse") when the accelerator is not used.
    To suppress the "AccelReq" and "AccelElapse" fields, add IQL-DEFINE=(IQL-EXCLUDE-ACCEL=YES) to the SYSPARM.
Support for New SQL Incompatibility (376) APPL-SQL-INCOMPAT Batch Reports
Support for the following new batch reports was added:
  • BTRINCMT—SQL Incompatibility Trace
  • BTRINCMS—SQL Incompatibility Summary (aggregated by incompatibility reason)
Storing and Reloading Thread History Selection
Use the Thread History Selection Presets panel to store the current thread selection criteria into a PDS member and later reload it.
Previously, only values on the first screen of the thread history filters were saved to your profile. Now, you can use the PRESETS function (PF4) to save the contents of all five thread history filter screens, including Dynamic WHERE statements that you have composed. Each unique set of filters can be named and stored as a PDS member in the PDS specified on the PRESETS screen. You can then reload these preset screen values on any subsequent session.
Dynamic SQL History File
A new history VSAM data set is utilized for storage and retrieval of Dynamic SQL texts. This feature is a major expansion of the functionality that allows Dynamic SQL statistics (IFCID 316) and Dynamic SQL text (IFCID 317) to be saved in the STATS history file.
The IQL functions STMT-CAPTURE and STMT-EXTRACT were introduced with this feature. By implementing the capture of dynamic SQL (STMT-CAPTURE) strategically into certain IQL requests, the dynamic SQL text is captured while executed and saved to the new Dynamic SQL Text Database (HSTSQLDB). IQL reports can then use the Statement Extract (STMT-EXTRACT) function to display these statements.
To activate this feature, set HISTORY-SQLTEXT=YES. The VSAM linear data set must be defined using IDCAMS and specified in the HSTSQLDB-DSN SYSPARM.
Leveraging Dynamic SQL Text Database in SQL History Reports
The dynamic SQL history reports (option 11 in the main menu) were enhanced to use the Dynamic SQL Text Database:
  • HSDYNSQD—Selected Dynamic SQL Detail - History
  • HSUDYNST—Selected Dynamic SQL Text - History Sum
Both reports display the text of the selected dynamic statement. The text is retrieved from the Dynamic SQL Text Database when the system parameter HISTORY-SQLTEXT is set to YES. When this parameter is disabled, the text retrieval is attempted from the HISTSTAT online history file. That retrieval is based on IFCID 317 capture.
Dynamic SQL Text Database typically includes the text of statements that are captured with different criteria. This option increases the chances for statement text to be stored and retrieved.
Incremental Release 3 (RO99552)
The following enhancements are now available in IR 3.
Support for New and Updated Trace Records
Support for the following trace records was added:
  • (1001) CURR-STATS1
    The Latch Manager Statistics fields were updated with the new alias names:
    • GBL-AUTH-LTCH-2 for UNASSN-LTCH-2
    • DDF-DISC-LTCH-3 for UNASSN-LTCH-3
    • SYSSTR-CACHE-LTCH-4 for UNASSN-LTCH-4
    • DS-IDX-SPLIT-LTCH-6 for UNASSN-LTCH-6
    • IDX-OBD-ALLOC-LTCH-7 for UNASSN-LTCH-7
    • QRY-PAR-LTCH-8 for UNASSN-LTCH-8
    • UT-SP-URIDS-LTCH-9 for UNASSN-LTCH-9
    • DDF-RESYNCH-LTCH-18 for UNASSN-LTCH-18
    • SYS-CKPT-LTCH-20 for UNASSN-LTCH-20
    • INTR-CKPT-LTCH-22 for UNASSN-LTCH-22
    • EDM-PREFETCH-LTCH-24 for UNASSN-LTCH-24
  • (021) LOCK
    The fields LOCK-TYPE and LOCK-RESOURCE now include new Db2 12 lock types. Row and Datapage locks were updated to use relative page numbers.
  • (044) LOCK-SUSPEND-ST
    The fields LOCK-TYPE and LOCK-RESOURCE now include new Db2 12 lock types. Row and Datapage locks were updated to use relative page numbers.
  • (045) LOCK-SUSPEND
    The fields LOCK-TYPE and LOCK-RESOURCE now include new Db2 12 lock types. Row and Datapage locks were updated to use relative page numbers.
  • (150) LOCKS-HELD
    The fields LOCK-TYPE and LOCK-RESOURCE now include new Db2 12 lock types. Row and Datapage locks were updated to use relative page numbers.
  • (172) DEADLOCK
    The fields LOCK-TYPE and LOCK-RESOURCE now include new Db2 12 lock types. Row and Datapage locks were updated to use relative page numbers.
  • (196) LOCK-TO-DETAIL
    The fields LOCK-TYPE and LOCK-RESOURCE now include new Db2 12 lock types. Row and Datapage locks were updated to use relative page numbers. Values RS (Resultant state) and CBS (Count By State) from HELD-LOCK-TYPE field were moved into the new field HELD-LOCK-IRLM.
  • (366) PREV10-CHAR-FUNC
    and
    (376) APPL-SQL-INCOMPAT
    New Db2 11 fields were added: SCHEMA-NAME-OFFSET, SCHEMA-NAME-VAR, SCHEMA-NAME-LEN, SCHEMA-NAME-LONG, SPECIFIC-NAME-OFFSET, SPECIFIC-NAME-VAR, SPECIFIC-NAME-LEN, SPECIFIC-NAME-LONG, INCOMPAT-PARMS-OFFSET, INCOMPAT-PARMS-VAR, INCOMPAT-PARMS-LEN, INCOMPAT-PARMS-LONG, SQL-TEXT-OFFSET, SQL-TEXT-VAR, SQL-TEXT-LEN, SQL-TEXT-LONG, ORDINAL-NUMBER, SOURCE-TYPE, and TARGET-TYPE.
    The field SYSIBM-CHAR-FUNC now include new Db2 11 and 12 types of incompatible change.
User Interface Changes
  • Column filters saved using the
    FILTER SAVE n
    online commands are now stored in the second profile dataset (DDname INSRPROF). These filters can be reloaded even after the user session is started again.
  • A new operator command
    F jobname,z ZDM
    was added to control the data feed to the CA CCS Data Mover.
Extended Latch Manager Statistics
A new OLATCH real-time report for Latches Manager statistics was added. The report is available in the Additional Systems Statistics menu (=1.6), the renamed submenu "
Locks and Latches
" (=1.6.10), the top submenu item 3 "
Latches
" (=1.6.10.3).
The archive tables SUBSYSTEM_DAILY and SUBSYSTEM_DETAIL were expanded to include latch manager statistics.
Use the Archive Table Migration Utility (NSIGMIGA) to upgrade the affected archive table definitions and related load utility control statements and IQL requests.
Extended IQL Syntax
Support for New Db2 12 Lock Types
The multiple new lock types that were introduced in Db2 12 are now supported:
  • Utility Commit lock
  • Add Partition serialization lock
  • SYSIBM.SYSENVIRONMENT serialization lock
  • Compress Dictionary Build lock
  • Compress Dictionary Load lock
  • Hash Value lock
  • Utility Object lock with Hash
  • SYSIBM.SYSDYNQRY Hash ID lock
  • SYSIBM.SYSDYNQRY Stabilization Group lock
  • SYSIBM.SYSDYNQRY Object Dependency lock
  • SYSIBM.SYSDYNQRY Authorization ID Dependency lock
  • In-memory Fast Traverse Block (FTB) lock
All relevant IFCID trace records now include the new lock types. For example, (021) LOCK, (044) LOCK-SUSPEND-ST, and (150) LOCKS-HELD.
SQL Incompatibility Data in History
Several new types of incompatible changes are now supported:
  • Illegal SELECT INTO with a set operator is being bound (Db2 11 and 12).
  • Pre Db2 12 POWER BIF returned SQLCODE = -802 for out of range (Db2 12).
The new HSTINCMP history and HSUINCMP history Summary Reports for SQL incompatibilities were added.
To accommodate the new report, the System History Statistics Menus were changed:
  • Old "Deadlock and Timeout" menu option was combined with "Long URs at Checkpoint (IFCID 313)", the renamed menu "Long URs / Deadlock / Timeouts" (...6.20). The "Timeouts and Deadlocks" report is available in the top submenu item 2 "Deadlock/Timeout" (...6.20.2).
  • New menu option "SQL Incompatibilities (IFCID 376)" is now available (...6.17).
Enhanced Thread Buffer Pool Statistics
The buffer pool hit ratio is now available in both real-time and history for Thread Buffer Detail, Package BP Detail panels, and multiple statistics batch reports. The buffer pool hit ratio indicates the percentage of time the page was found in the buffer pool. This functionality helps you improve buffer pool tuning.
Eight-character User ID Support
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.
Simplified Archive Table Creation and Configuration
The creation and configuration of Archive tables is now a post-installation step. For more information, see Archiving Component Configuration.
Support for GBP Reclaim Statistics
SUBSYS_GBP_DAILY and SUBSYS_GBP_DETAIL now support GRP-DIRENT-RECLAIM, GRP-DATENT-RECLAIM, and GRP-XIDIR-RECLAIM from IFCID 230.
CA Mainframe Operational Intelligence Solution
CA Mainframe Operational Intelligence
lets your mainframe management team visualize and explore current and historical performance data, from across your mainframe, from one location.
CA Mainframe Operational Intelligence
also uses machine learning to predict future performance. Data-science algorithms provide the team with embedded and predictive analytics.
CA Mainframe Operational Intelligence
models your data and provides multiple tools to analyze it in your Web browser.
CA Mainframe Operational Intelligence
tools include alerts, dashboards, metrics, and reports.
With the historical, current, and predicted data, the team can:
  • Predict incidents
  • Remediate faster
  • Improve collaboration among the mainframe management team
  • Continuously optimize performance
CA Mainframe Operational Intelligence
combines multi-domain data, machine learning, predictive analytics, and a domain-agnostic web application to help your site maintain optimal mainframe performance.
CA SYSVIEW for DB2
sends data to
CA Mainframe Operational Intelligence
that describes bufferpool activities, connection time intervals, CPU usage, and the overall subsystem health.
To learn more about the challenge that
CA Mainframe Operational Intelligence
addresses, see this video:

For detailed information about this solution, see the CA Mainframe Operational Intelligence documentation.
Incremental Release 2 (RO97703)
The following enhancements are now available in IR 2.
Support for New and Updated Trace Records
Support for the following trace record was added:
  • (350) SQL-STATEMENT
    As of Db2 12, the field HOST-LANG2 contains new values. The RECTRACE and SQLTRACE reports were updated to include the STMT-ID, HOST-LANG2, and PARSER-OPTIONS fields.
Correlate Db2 Thread with Batch Job Step
The new Db2 12 common field JOB-STEP was added to multiple reports to help correlate the Db2 thread with a given batch job step:
  • Online audit (AUDCLAS3, AUDCLASA, and so on)
  • Online thread details (THRDACTV, THRDID*, and so on)
  • Hierarchical application probe (HPRAPLST, HSDLKTO, and so on)
  • Batch reports (BTACTTRL, BTAUDPOL, BTRECTRC, and so on)
Incremental Release 1 (RO96575)
The following enhancements are now available in IR 1.
Configuration Changes
  • New data collector system parameter IFI-PLAN now allows you to specify a custom plan name for the data collector threads used to collect IFI trace records. If you do not specify a custom plan for collecting IFI trace records, the Explain plan is used.
  • DEBUG-LEVEL data collector processing parameter now also controls messages related to the Xnet processing. Setting the parameter to value 1 suppresses most of these messages.
Archiving of SQL Statement Statistics
The following archive tables were added to record details of static and dynamic SQL statement statistics, running on or off the Db2 accelerator:
Archiving of Application IDB2 Accounting Extension Statistics
The following archive tables were added to record application IDB2 accounting (151) details:
Archiving of Auditing Details
The following archive tables were added to record Db2 auditing details:
Archive Tables Update
The APPLICATION_DETAIL archive tables were expanded to include a new JOB_STEP column. This column is populated with the Db2 12 common field JOB-STEP, which contains a step name of the thread batch job.
Use the Archive Table Migration Utility (NSIGMIGA) to upgrade the affected archive table definition and related load utility control statements and IQL requests.
Support for New and Updated Trace Records
Support for the following trace records was added:
  • New Db2 12 fields were added: RDI-SECTNO, WAIT-GLB-CH-LLCK, WAIT-GLB-LLCK, WAIT-GLB-PP-LLCK, WAIT-GLB-PG-PLCK, WAIT-GLB-PLCK, WAIT-PIPE, WAIT-PQSYNC
  • New fields were added: CMD-TXT-VAR, CMD-TXT-LEN, CMD-TXT-LONG. These fields derive from the start record (090) COMMAND-ST.
  • Field STMT-IO-WAIT was updated to include Db2 12 pipe wait time and exclude unit switch wait time.
    Field STMT-LOCK-WAIT was updated to include Db2 12 global lock wait times, Db2 12 wait time for parallel query synchronization between parent and child tasks, and unit switch wait time.
    New fields were added: THD-START, THD-END, IO-DBNAME, IO-PSNAME, LKSUM-DBNAME, LKSUM-PSNAME, LKSUM-ACE-ADDR, STMT-ID.
  • Traces the usage of Db2 variables for SQL PL advanced triggers. New with Db2 12. The BTRECTRC and BTSQLTRL reports were updated to include this record.
  • Traces the block fetching. New with Db2 12. The BTRECTRC and BTSQLTRL reports were updated to include this record.
  • Traces the authorization compatibility. New with Db2 12. A new ATHUCOMP report ("Authorization Compatibility Summary") built on this record was added to the available Auditor reports. The BTRECTRC and BTSQLTRL reports were also updated to include this record.
  • Traces allocation and deallocation of fast index traversal structures. New with Db2 12. The BTRECTRC report was updated to include this record.
Support for New SQL Statistics
The following fields were added to (058) SQL-STMT. These fields support the collection of accumulated wait times for execution in Db2 12.
  • WAIT-GLB-CH-LLCK
  • WAIT-GLB-LLCK
  • WAIT-GLB-PP-LLCK
  • WAIT-GLB-PG-PLCK
  • WAIT-GLB-PLCK
  • WAIT-PIPE
  • WAIT-PQSYNC
This support is also now reflected in the fields STM-IO-WAIT and STM-LOCK-WAIT in (151) SQL Statement Summary.
In addition, the Db2 12 field RDI-SECTNO was added to (058) SQL-STMT to specify the section number of the SQL statement. Multiple IQL requests built upon the SQL-STMT record (APPLPROF, DISTRIB, EXPSQL, and probes) now report the SQL section number.
Enhanced CA SYSVIEW Integration Documentation
The CA SYSVIEW® Performance Management integration documentation was enhanced to provide Quick Configuration Steps. These steps summarize the required configuration steps to set up the connection between
CA SYSVIEW
and
CA SYSVIEW for DB2
.
Extended IQL Syntax
Support for Variable Load (OF=VLnnn) IQL field output format ("field attribute") was added to generate data suitable for loading into VARCHAR columns using the DB2 LOAD utility.
Re-grouping of Wait Time for SQL Statistics
Wait times are now grouped to match each other. The following changes were done:
  • Hierarchical probe requests: HPRSTLST, HPRSTSML
    • 'OthrWait' group removed:
      • ACCUM-WAIT-SYNC-EX moved to 'LockLtch'.
      • WAIT-LOG-WRITER moved to 'I/O Wait'.
  • Accumulated SQL statistics reports (based on IFCID 1041/1043):
    • 'Accum Other' group removed:
      • ACCUM-WAIT-SYNC-EX and WAIT-PARA-SYNC moved to 'Accum Lock'.
      • WAIT-LOG-WRITER and WAIT-PIPE fields moved to the 'Accum I/O' group.
  • IFCID (151) IDB2ACCT changes:
    • STMT-IO-WAIT now includes Db2 12 pipe wait time.
    • STMT-LOCK-WAIT now includes Db2 12 global lock wait times and wait time for parallel query synchronization between parent and child tasks.
    • Execute unit switch wait time moved from STMT-IO-WAIT to STMT-LOCK-WAIT.
  • IFCID (003) ACCT, (148) THREAD-STATS, and (369) CONNECTION-STATS:
    • Db2 12 wait time for parallel query synchronization between parent and child tasks moved from DECL-WAIT-OTHERS to DECL-WAIT-LOCK.
    • Db2 12 wait time for a pipe moved from DECL-WAIT-OTHERS to DECL-WAIT-DB2-IO.
    • Unit switch wait time moved from DECL-WAIT-SERVICES to DECL-WAIT-LOCK.
Initial GA Release (INC00)
The following changes reflect new architecture in the initial increment of Version 20:
Configuration Changes
Menu Changes
  • Fix Level
    was removed from the Help menu in the Drop-down menu bar.
  • DBRM references were removed in multiple menu titles and requests:
    • Active Threads (main menu item 5), Thread Detail Menu, and package-related statistics reports.
    • Thread History (main menu item 6), Thread History Detail Menu, Thread History Summary Menu, and package-related statistics reports.
    • Explain Facility (main menu item 7), Explain Menu Options, Plan/Package Selection Criteria.