Db2 function level support

When you activate new Db2 function levels in a Db2 subsystem or data sharing group, enhancements might become available that impact IBM Db2 Query Monitor for z/OS.

The levels of function level support are defined as follows:
Tolerated
The product works as it did on a previous release or function level of Db2 for z/OS, but it does not support the new features of this function level.
Supported
The product supports most, but not necessarily all, of the new function-level features that IBM deems the most significant for this product.

General considerations

Query Monitor uses FMID HCQC110 to install monitoring agents in Db2. Hence, when Db2 is stopped and restarted, Query Monitor detects whether Db2 startup and its monitoring agents are installed. It is recommended to follow these best practices for Query Monitor and Db2 maintenance, or when activating a Function Level:
  • When applying service levels for Db2, apply the same to Query Monitor.
  • When stopping Db2, stop Query Monitor as well. This can clean up the Query Monitor-started task memory that is associated with the previously running Db2.
  • For a new function level or version of Db2, it is recommended to stop CQM and CQMMSTR.
  • For CQM-only service upgrades, it is recommended to stop both CQM and CQMMSTR. After maintenance, recycle both CQM and CQMMSTR to avoid missing the CQMMSTR restart when it is required.
  • When applying service levels to z/OS, the current service levels of Query Monitor should be installed.
Table 1. Db2 Query Monitor for z/OS PTFs in support of Db2 13 function levels
Db2 13 function level Toleration PTF Support PTF
FL504 No PTF required No PTF required
FL503 No PTF required No PTF required
FL502 No PTF required No PTF required
FL501 No PTF required No PTF required
FL500 No PTF required No PTF required
FL 100 Db2 Query Monitor: UI80707
Db2 Data Access Common Collector:
  • UI79607
  • UI80706
  • Db2 Query Monitor: No PTF required (or list UI80707)
  • Db2 Data Access Common Collector: No PTF required
Table 2. Db2 Query Monitor for z/OS PTFs in support of Db2 12 function levels
Db2 12 function level Toleration PTF Support PTF
FL509 Db2 Query Monitor:
  • UI68764 + UI68765
  • UI69691
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL508 Db2 Query Monitor:
  • UI68764 + UI68765
  • UI69691
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL507 Db2 Query Monitor:
  • UI68764 + UI68765
  • UI69691
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL506 Db2 Query Monitor:
  • UI68764 + UI68765
  • UI69691
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL505 Db2 Query Monitor:
  • UI69691
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL504 Db2 Query Monitor:
  • UI69691
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL503 Db2 Query Monitor:
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL502 Db2 Query Monitor:
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL501 Db2 Query Monitor:
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required
FL500 Db2 Query Monitor:
  • UI68947 + UI68948

Db2 Data Access Common Collector: No PTF required

No PTF required