Upgrading

You can upgrade Db2 Query Monitor 3.3.0 to version 3.4.0. You can also maintain multiple product versions concurrently.

General considerations

Data collected by Db2 Query Monitor 3.3.0 can be read by Db2 Query Monitor 3.4.0.

When using SMP/E to install 3.4.0 to the same consolidated software inventory (CSI) where 3.3.0 was installed, SMP/E deletes 3.3.0 files and replaces them with 3.4.0 files. For this reason, IBM® recommends that you do not change the USS file system paths in your CSI when upgrading from 3.3.0 to 3.4.0. You can rename existing paths, but those paths must contain the 3.3.0 files and data sets.

To maintain multiple product versions concurrently, they must be installed in separate CSI zones. Even if you install 3.3.0 into the same CSI as 3.4.0, you must still create a new CQM_VAR_HOME and use CQMCMGRT to import configurations from the 3.3.0 CQM_VAR_HOME.

Important: Do not run Db2 Query Monitor with similar SQL monitoring products against the same Db2 subsystem, because this setup might result in unpredictable results for Db2.

Start of changeIf you want to modify the subsystem name after the conversion of CQM3.3 to CQM3.4, you need to save the new name in the individual CQMPROFS data set. If you do not take this action, the ISPF panel will fetch the old name that is already saved in the individual CQMPROFS data set and display message CQM195E. End of change

CAE considerations

When upgrading CAE components to 3.4.0, plan for the following considerations:

  • Start of changeIf you specify CQM_JAVA in the STDENV DD statement for the JCL that launches the CAE Server, you must ensure that CQM_JAVA points to a valid 64-bit IBM Java™ 11 or Java 17 installation. The required minimum version of Java is 11.0.15.0.End of change
  • When you apply new maintenance, you must always update the CAE Server first to guarantee that the CAE Server is not older than the Query Monitor Subsystems and ISPF clients. Such a strategy avoids compatibility problems in situations where some LPARs are at one maintenance level and others at another maintenance level.