Other prerequisites

These additional items are required to use Db2 Query Monitor.

Conversion services requirements
Db2 Query Monitor requires the existence of CCSID conversion pairs for 500-1208 and 1208-500. At ISPF dialog start-up, Db2 Query Monitor verifies that translations are available from the CCSIDs 500 and 1208 and the CCSID of the user's terminal. If these translations do not exist, Db2 Query Monitor will terminate with message CQM1153E, instructing you to add these necessary CCSID pairs.
Displaying information about IBM Db2 Analytics Accelerator eligible SQL
To evaluate static SQL statements to determine if they are accelerator-eligible, you must verify that you have the correct ZPARM settings. This includes setting the new ZPARM, ACCELMODEL to YES. Refer to the IBM® Db2 Analytics Accelerator for z/OS® documentation and the IBM Db2 Analytics Accelerator Modeling APAR PM90886 for additional information.
Db2 traces requirements
Db2 Query Monitor requires that you use several Db2 accounting and statistics traces to record Db2 subsystem data and events for use in problem determination.
Network and firewall requirements
The CAE requires certain network and firewall configurations in order for the CAE Agent, CAE Server, and CAE Browser Client to function properly.
High-Availability Fault-Tolerance requirements
The following requirements apply when deploying CAE components using High-Availability Fault-Tolerance.
Multi-factor authentication support
The Db2 Query Monitor ISPF user interface has multi-factor authentication (MFA) support through TSO logon processing. All authentication is done before Db2 Query Monitor is invoked and no additional MFA processing is necessary.
OMEGAMON Data Provider
OMEGAMON Data Provider (ODP) can stream data to external analytics platforms, such as IBM Instana, Splunk, Elastic, and Prometheus.
Passphrase support and restrictions - CAE Browser Client
The Db2 Query Monitor web user interface, which includes the CAE Browser Client and the CAE Server, supports passphrases.
Certificates requirements - USS and Windows
This topic provides information about certificates and how they are used by Db2 Query Monitor.
Certificates, keys, and keyrings - USS
The CAE Server, when installed on USS, can be configured to access certificates and keys from SAF keyrings instead of from .jks files in HFS.
Memory usage requirements - USS
This topic describes the memory usage considerations that apply to the operation of the CAE Server on USS.
Capacity requirements - USS
The following are general guidelines regarding the real frames and aux storage slot usage of the CAE address spaces.
SMP/E cross-zone requisite checking requirements
Your system may contain products that are packaged and installed separately, but that have service level or interface dependencies.
Dispatch priority requirements
The Db2 Query Monitor (CQMPROC) dispatching priority should be equal to or above DBM1. All other Db2 Query Monitor address spaces (such as CQMCAESV, CQMAGT) can have any dispatching priority.
Data sharing requirements
To use Db2 Query Monitor to monitor data from the perspective of a data sharing group, your site must meet the following requirements.
CORRID processing for compatibility with OMEGAMON
Db2 Query Monitor CORRID processing supports compatibility with IBM OMEGAMON for Db2 Performance Expert on z/OS (OMEGAMON) and allows related metrics to be queried between the Db2 Query Monitor Performance History Database and the OMEGAMON repository.
Disabling virtual PC cursor mode and protected mode when using screen readers
If you use a screen reader such as JAWS with the CAE Browser Client, you should disable virtual PC cursor mode and protected mode to avoid performance problems with the CAE Browser Client.

Parent topic: Prerequisites