Preparing for Installation › Configure CA Insight DPM for Use with CA Cross-Enterprise APM › Set Up Xmanager, Xnet, and Required IQL Queries

Set Up Xmanager, Xnet, and Required IQL Queries

To retrieve metric data from one or more DB2 subsystems on a single LPAR, install and configure CA Insight DPM on the same LPAR running Cross-Enterprise APM Agent. As part of the installation and configuration of this software, also install and configure the Xmanager and Xnet components.

Note: For the available guides to help in this task, see the CA Insight DPM core documentation set.

Specify the XNETAGT=YES CA Insight DPM data collector initialization parameter for each DB2 subsystem in your configuration. The data collector initialization parameters reside in the insight_hlq.SOURCE(IDDCPRMS) member.

CA Insight DPM includes many Insight Query Language (IQL) queries that can be used to gather information about either itself or the DB2 subsystems currently being monitored. The Cross-Enterprise APM Agent uses several of these IQL queries through the Xmanager/Xnet interface to gather metric data. Specifically, the following IQL queries must be available and started in each CA Insight DPM instance that the Cross-Enterprise APM Agent monitors:

• DSQAPMGS is used to monitor the DB2 Data Sharing Group metrics. The query is included and only available since CA Insight DPM Version 17.0. Earlier releases do not monitor DB2 Data Sharing Group metrics.
• DSQAPMSS is used to monitor the DB2 subsystem metrics. The query is included since CA Insight DPM Version 17.0. Earlier releases have the following PTF requirements:
  • Version 16.0 requires RO52880 and RO52881.
  • r15 requires RO52873 and RO52874.
  • r14.5 requires RO52871 and RO52872.
  • r14 requires RO52869 and RO52870.
• DSQPARMS

If multiple CA Insight DPM instances are monitoring the same DB2 subsystem, each instance must have these IQL queries started for the Cross-Enterprise APM Agent to retrieve metrics.