Upgrading

When you upgrade Db2® Query Monitor 3.3.0 to version 3.4.0, ensure that you review all documented considerations and requirements. 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.

If 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 fetchs the old name that is already saved in the individual CQMPROFS data set and display message CQM195E.