Configuring InfoSphere Optim Performance Manager and Performance Expert Client

This scenario describes how to configure the InfoSphere® Optim™ Performance Manager in order to get end-to-end SQL monitoring (Extended Insight) and stored procedure monitoring. This feature is only for OMEGAMON® XE for DB2® PE only (not for OMEGAMON XE for DB2 PM).

Before you begin

As a prerequisite, you need a runtime environment having OMEGAMON XE for DB2 PE already configured.

Procedure

Start the Configuration and Installation Tools user interface by issuing the command ex on the TKANCUS library in your SMP/E installation.
ex ‘&trghlq.TKANCUS’
Use option 5 Configure to open the PARMGEN workflow user interface.
Enable the runtime environment where you want to configure InfoSphere Optim Performance Manager.
Use option 8 to open the PARMGEN profile selection menu.
Use option 1 to open the RTE LPAR configuration profile and adjust the following parameters:

Table 1. Parameter values of the RTE LPAR configuration profile
Parameter	Value	Description
KD2_OMPE_E2E_MON_SPRT	Y	Enables Extended Insight Dashboard (end-to-end SQL monitoring)
KD2_DBnn_DB2_PORT_NUM	<port>	Optional. This specifies the port that will be used to connect InfoSphere Optim Performance Manager to the OMEGAMON XE for DB2 PE server. You can keep the default port 2000. You need this port information for later.
KD2_PFnn_TRACES_318	Y	Enables the automatic start of IFCID 318.
KD2_PFnn_TRACES_400	Y	Enables the automatic start of IFCID 400. Set this parameter to Y only if you want to monitor DB2 10 and above.
KD2_PF01_READA_SPMON	Y	Enables stored procedure monitoring.

Use PF3 to get back to the main workflow panel KCIP@PG0.
Use option 10 $PARSESV to open the job panel KCIP@PRS.
Use option 1 to open the composite $PARSESV job and submit it. The expected return code is zero.
Use PF3 to get back to the main workflow panel KCIP@PG0.
Use option 11 to open the SUBMIT job panel KCIP@SUB.
Use option 13 to open the KCIJPW2R to copy the configuration from the work libraries to the runtime libraries. Submit the upcoming job. The expected return code is zero.

What to do next

For integration of the InfoSphere Optim Performance Manager into Tivoli Enterprise Portal find more information in section Enabling InfoSphere Optim Performance Manager integration in Completing the configuration for z/OS components.

Install InfoSphere Optim Performance Manager and configure it for the monitored database. For more information, see the IBM® InfoSphere Optim Performance Manager in the Knowledge Center.

Feedback