What's new in previous editions

This topic summarizes significant enhancements and changes to previous editions of Db2 Query Monitor documentation.

Note: For a list of the most recent updates, see New and changed functions.

Previous updates - 2021

Description Related APARs
The CAE Server and the CAE Agent perform the handshakes using the default SSL protocol, which can include SSL3.0, TLS1, TLS1.1, or TLS1.2. For more information, see Configuring SSL handshakes to use TLS 1.2. -
Adds the WPSIZE parameter. -
Adds the ADETECT_ALPHA_SMOOTHING and ADETECT_MIN_GETPAGES_DELTA_FOR_ANOMALY parameters. -

Previous updates - 2020

Description Related APARs
The Db2 tables spaces that Db2 Query Monitor uses for Performance History Database tables, statement type tables, and staging tables have been converted from segmented Db2 table spaces to partition-by-growth (UTS) table spaces. To support this change, three new migration jobs have been created: CQMUTS1, CQMUTS2, and CQMUTS3. For more information, see Sample library members. PH13449
Passphrase support has been added to Db2 Query Monitor. For more information, see Passphrase support and restrictions - CAE Browser Client. -
Adds the Last Group Analyzed Time field to the Reorganization Recommendation Monitor. For more information, see Using the Reorganization Recommendation Monitor. -
Adds information about AT-TLS support. For more information, see Configuring AT-TLS security. -
Adds information about the MAX_VOLUME_COUNT parameter. -
Adds information about Db2 12 function level support. For more information, see Db2 function level support. -
Clarifies the recommended values of SMEM_SIZE and MAXIMUM_ALLOCATIONS parameters. -
Clarifies how to offload data from Db2 Query Monitor. For more information, see Offloading data to the Performance History Database and Offloading data to Analytics Accelerator. -
Clarifies the dispatching priorities. For more information, see Dispatch priority requirements. -
Clarifies the restrictions for the offload processes. For more information, see Running the offload to the Performance History Database. -
Clarifies the SUMMARY_VARIATION parameter description for use in a data sharing environment. -
Adds new messages: -
Adds information about the CQM_AGRP and CQM_ADDRESS parameters that are specified in CQMCAEWD for use used in a High-Availability Fault-Tolerance (HAFT) environment. For more information, see CQM_AGRP and CQM_ADDRESS. -
Clarifies that Db2 Query Monitor Performance History Database indexes not unique. -
Replaces the term Db2 QM Subsystem with QM Subsystem or Query Monitor Subsystem to avoid it being confused with a Db2 subsystem. PI97589
Adds information about the new SCQMSAMP library member CQMIDAM3. For more information, see SCQMSAMP members for loading data to Analytics Accelerator. PH17340
Adds the following CQMPARMS parameters: PH17340

Previous updates - 2019

Description Related APARs
Adds new messages: PI97589
Adds a new message: PH17340
Adds new messages: PH12338
Adds a new message: PH01452
Adds a new message: PI98407
Adds a new message: -
Adds new columns to the following panels: PH17340
Updates the following topics: PH17340
Updates summaries and exceptions displays in the ISPF Client and the CAE Browser Client to include fields that report Db2 AI related statistics for Elapsed Time, CPU, and GETPAGES. PH17340
Updates Performance History Database tables to include the fields that report Db2 AI related statistics for Elapsed Time, CPU, and GETPAGES.Db2 Query Monitor uses assembler instructions from zSeries-6 (support for the zEC12 instructions). For more information, see Mainframe prerequisites PH17340
Db2 Query Monitor uses assembler instructions from zSeries-6 (support for the zEC12 instructions). Mainframe requirements have been updated to reflect this. For more information, see Mainframe prerequisites. PH17340
Updates the description of the CORRID_TRANSLATION parameter. PH12612, PH14891
Updates the description of CQM@WDB2 to reflect new behavior. For more information, see Configuring the offload to the Performance History Database. PH09705, PH12338
Updates the descriptions of the DB2_SQLCODE_DUPLICATES, DB2_SQLCODE_DUPLICATES_TIME, THREAD_SQLCODE_DUPLICATES, and THREAD_SQLCODE_DUPLICATES_TIME parameters to reflect the calculation of SQLCODE occurrences. PH03715
The definition of absolute threshold has been updated in the description of the CQM_REORG_METRICS and com.rocketsoft.nm.qm.reorg.metrics parameters. For more information, see CAE Server parameters (USS) and CAE Server properties (Windows). PH13425
The explicit specification of a CAE Server local host address is now supported. The new parameters for such a specification include CQM_CAE_LOCAL_ADDRESS (for the CAE Server on USS) and com.rocketsoft.kbm.explicitLocalHost (for the CAE Server on windows). For more information, see CAE Server parameters (USS) and CAE Server properties (Windows). PH02399
Adds the following CAE Agent parameters, which can be defined in CQMCPRMS: PI98407
Adds information about how Db2 Query Monitor creates, clears, and overrides baseline performance windows when performing reorganization recommendations. For more information, see How Db2 Query Monitor creates a baseline performance window and How Db2 Query Monitor clears or overrides a baseline performance window. -
Adds a description of the Paused status for the Next Performance Window column in the Reorganization Recommendation Monitor. For more information, see Using the Reorganization Recommendation Monitor. -
Adds the Consistency Token and Text Token columns to the Db2 QM SQL Code Detail Display panel and updates the description of the Occurrences column. For more information, see SQLCODEs - columns (ISPF). PH03715
When creating monitoring profiles, you can now specify both positive and negative SQLCODEs to include or exclude specific workloads for alert or summary processing. For more information, see Adding a monitoring profile line. PH01452
Clarifies the CAE requirements. See For more information, see. -
Updates the descriptions of CQM_REORG_METRICS and com.rocketsoft.nm.qm.reorg.metrics. -