Implementation examples

The following describes how to implement Db2® Query Monitor for several different LPAR configurations.

Implementation example 1

Objective
To monitor one Db2 subsystem on a single LPAR.
Solution
To monitor one Db2 subsystem on a single LPAR in a non-data sharing environment, the following are required:
  • A Query Monitor subsystem
  • One master address space

Additionally, if you want to use the CAE browser client, you must also install and configure the following CAE components:

  • CAE agent
  • CAE server

Implementation example 2

Objective
To monitor two Db2 subsystems across two LPARs in a non-data sharing environment.
Solution
To monitor two Db2 subsystems across two LPARs in a non-data sharing environment, the following are required:
  • One Query Monitor subsystem installed on each LPAR
  • One master address space installed on each LPAR

Additionally, if you want to use the CAE browser client, you must also install and configure the following CAE components:

  • One CAE agent installed on each LPAR
  • One CAE server installed on one of the LPARs

Implementation example 3

Objective
To monitor two LPARs in a data sharing environment.
Solution
To monitor two LPARs in a data sharing environment, the following are required:
  • One Query Monitor subsystem installed on each LPAR
  • One master address space installed on each LPAR

Additionally, if you want to have ISPF view of data sharing or use the CAE browser client, you must also install and configure the following CAE components:

  • One CAE agent installed on each LPAR
  • One CAE server installed on one of the LPARs