Components used by the CICS PA plug-in

To use the plug-in, you need at least one CICS® PA historical database (HDB), a DB2® database, and the CICS PA plug-in. This topic explains how these components relate to one another, and explains the critical settings that you need to set correctly to use the plug-in successfully.

In a DB2 system, a storage group can contain databases, which can contain tablespaces, which can contain tables. All of these terms appear in the CICS PA ISPF dialog so it is useful to understand the relationship between them.
Figure 1. DB2 components
DB2 components
To get data into DB2 so that the CICS PA plug-in can access the data, you export data from one or more HDBs. For the export and subsequent viewing to work, you must enter the following settings in the definition of each HDB:
  • Select the Explorer option to make the HDB eligible for inclusion in the manifest.

    The manifest is a DB2 table that is a catalog of all the tables the CICS PA plug-in will use. You rebuild the manifest after you make changes to the HDB settings: Qualifier, Explorer, or Template.

  • Enter a qualifier that you want to use as a DB2 tablespace name and as the DB2 schema name.
  • For a performance HDB only, set the HDB definition to use one of the templates that is designed for the CICS PA plug-in, and supplied with CICS PA.

    The EXPLST templates are used for performance list HDBs. The EXPLOR and APPLNM templates are used for performance summary HDBs (APPLNM templates are used specifically for application context data). Several versions of each template are provided to cater for different versions of CICS TS; for example the EXPLST53, EXPLOR53, and APPLNM53 templates are for CICS TS V5.3.

Figure 2. Exporting HDB Data to DB2
Exporting HDB data to DB2
IBM® CICS Explorer® uses the CICS PA plug-in to retrieve data from DB2. To make this work, you need a CICS PA connection defined in CICS Explorer. The DB2 Schema connection setting is the Qualifier defined on the HDB. Your DB2 administrator can provide the other connection settings.
Figure 3. CICS PA plug-in accessing DB2 data
CICS PA plug-in accessing DB2 data