Other prerequisites These additional items are required to use Db2® Query Monitor. Conversion services requirementsDb2 Query Monitor requires the existence of CCSID conversion pairs for 500-1208 and 1208-500. At ISPF dialog startup, Db2 Query Monitor verifies that translations are available from CCSIDs 500 and 1208 and the CCSID of the user's terminal. If these translations do not exist, Db2 Query Monitor terminates with message CQM1153E, instructing you to add these necessary CCSID pairs.Requirements for displaying information about IBM Db2 Analytics Accelerator eligible SQLDb2 Query Monitor can evaluate static SQL statements to determine whether they are accelerator-eligible for IBM® Db2 Analytics Accelerator for z/OS® (IDAA). For this evaluation to occur, the ACCELMODEL zparm must be set to YES. Db2 traces requirements Db2 Query Monitor uses Db2 traces to record Db2 subsystem data and events for use in problem determination. Specifically, Db2 Query Monitor uses accounting trace classes 1 and 3 and statistics trace classes 1, 3, and 4. Port usage requirementsThe CAE agent, CAE server, backup CAE server, and CAE browser client use certain ports to communicate. Network traffic considerationsPlan for Db2 Query Monitor network traffic between the CAE agent, CAE server, and CAE browser client.Firewall requirementsYou must configure your firewall to provide cqmservice.exe (the Db2 Query Monitor Windows® service) full access to your network. High-Availability Fault-Tolerance requirementsWhen deploying CAE components using High-Availability Fault-Tolerance (HAFT), your environment must meet additional requirements.Passphrase support and restrictions - CAE browser clientThe Db2 Query Monitor web user interface, which includes the CAE browser client and the CAE server, supports passphrases. Certificates requirements - USS and WindowsCertificates are used by HTTPS-based websites to enable a web browser to validate that an SSL web server is authentic. This authentication provides the user with assurance that interaction with the website is secure and the website is what it claims to be.Certificates, keys, and keyrings - USSThe 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 - USSBefore you install the CAE server on USS, plan for memory usage.Capacity requirements - USSThe following are general guidelines regarding the real frames and aux storage slot usage of the CAE address spaces.SMP/E cross-zone requisite checking requirementsYour system might contain products that are packaged and installed separately but have service level or interface dependencies.Data sharing requirementsTo use Db2 Query Monitor to monitor data across a data sharing group, you must take additional actions for each member of the group.CORRID processing for compatibility with OMEGAMONDb2 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 readersIf 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