Configuring IBM Z Performance and Capacity Analytics for loading the data

You must configure IBM Z® Performance and Capacity Analytics in preparation for loading the z/OS® operational data in batch mode from Z Common Data Provider to IBM® Db2® Analytics Accelerator for z/OS.

To configure IBM Z Performance and Capacity Analytics for loading the data, complete the following steps:

1. Bind the Db2 plan that is used by IBM Z Performance and Capacity Analytics by specifying one of the following BIND options:
   • QUERYACCELERATION(ELIGIBLE)
   • QUERYACCELERATION(ENABLE)

   For example, if you use the default plan name DRLPLAN, the following BIND PACKAGE is used to set the query acceleration register as eligible:

   
   //SYSTSIN  DD  *                                            
    DSN SYSTEM(DSN)                                            
      BIND PACKAGE(DRLPLAN) OWNER(authid) MEMBER(DRLPSQLX) -   
        ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)            -
                QUERYACCELERATION(ELIGIBLE)         
      BIND PLAN(DRLPLAN) OWNER(authid) PKLIST(*.DRLPLAN.*) -   
        ACTION(REPLACE) RETAIN                                 
                                                               
      RUN PROGRAM(DSNTIAD) PLAN(DSNTIAxx) -                    
        LIB('xxxx.RUNLIB.LOAD')                              
    END
   

   The SDRLCNTL(DRLJDBIN) job includes sample instructions for binding the plan with QUERYACCELERATION specified.

2. Modify DRLFPROF, which is the IBM Z Performance and Capacity Analytics data set that contains user-modified parameters, to reflect the settings to apply when installing new analytics components. The following parameters in DRLFPROF provide support for the IBM Db2 Analytics Accelerator for z/OS:

   def_useaot = "YES" | "NO"

   "YES"

   Means that the table is created as an Accelerator Only table.

   "NO"

   Means that the table is created in Db2 and can be used either as a Db2 table or as an IDAA_ONLY table. The default value is "NO".

   def_accelerator = "xxxxxxxx"

   "xxxxxxxx"

   The name of the accelerator where the table resides.

   def_timeint = "H" | "S" | "T"

   "H"

   The timestamp for tables is rounded to an hourly interval (similar to tables with a suffix of _H in other components).

   "S"

   The timestamp for tables is rounded to a seconds interval (similar to tables with a time field rather than a timestamp in other components).

   "T"

   The timestamp for tables is the actual timestamp in the SMF record (similar to tables with suffix _T). The default value is "T".

3. If you are using IBM Z Performance and Capacity Analytics to collect and populate the component tables in Db2 for z/OS, or if you are using IBM Z Performance and Capacity Analytics reporting, customize each new lookup table in the IBM Z Performance and Capacity Analytics analytics components to reflect the contents of any existing lookup tables in IBM Z Performance and Capacity Analytics.
   For example, insert the same rows that are currently in the DB2_APPLICATION table into the A_DB2_APPLICATION table.
   Table 1 lists the lookup table members to customize.
   Tip: If you are collecting data only into IBM Db2 Analytics Accelerator for z/OS rather than having the data reside in Db2 for z/OS, the lookup tables are configured in Z Common Data Provider, as described in Running the System Data Engine to write data in Db2 UNLOAD format.

   Table 1. IBM Z Performance and Capacity Analytics lookup table members to customize

   Member	Base component table	Analytics component table
   DRLTA2AP	DB2_APPLICATION	A_DB2_APPLICATION
   DRLTA2AC	DB2_ACCUMAC	A_DB2_ACCUMAC
   DRLTALUG	USER_GROUP	A_USER_GROUP
   DRLTALKP	KPM_THRESHOLDS	A_KPM_THRESHOLDS_L
   DRLTALW2	MVS_WORKLOAD2_TYPE	A_WORKLOAD2_L
   DRLTALDA	MVSPM_DEVICE_ADDR	A_DEVICE_ADDR_L
   DRLTALUT	MVSPM_UNIT_TYPE	A_UNIT_TYPE_L
   DRLTALMI	MVS_MIPS_T	A_MIPS_L
   DRLTALSP	MVS_SYSPLEX	A_SYSPLEX_L
   DRLTALWL	MVS_WORKLOAD_TYPE	A_WORKLOAD_L
   DRLTALW2	MVS_WORKLOAD2_TYPE	A_WORKLOAD2_L
   DRLTALTR	MVSPM_TIME_RES	A_TIME_RES_L

4. Install the IBM Z Performance and Capacity Analytics analytics components that you want to use into IBM Z Performance and Capacity Analytics.
   For information about how to install components into IBM Z Performance and Capacity Analytics, see the IBM Z Performance and Capacity Analytics administration documentation in the IBM Documentation.
5. After the IBM Z Performance and Capacity Analytics analytics components and their associated tables are created in IBM Z Performance and Capacity Analytics, add them to IBM Db2 Analytics Accelerator for z/OS by using the Data Studio Eclipse application or by using stored procedures.
   Table 2 lists sample jobs for adding tables to IBM Db2 Analytics Accelerator for z/OS.

   Table 2. Sample jobs for adding tables to IBM Db2 Analytics Accelerator for z/OS

   Analytics component	SDRLCNTL member
   Analytics - z/OS Performance	DRLJAPMA
   Analytics – Db2	DRLJA2DA
   Analytics - KPM CICS®	DRLJAKCA
   Analytics - KPM Db2	DRLJAKDA
   Analytics - KPM z/OS	DRLJAKZA

6. To move the contents of the lookup tables into the IBM Db2 Analytics Accelerator for z/OS, modify and submit the SDRLCNTL members that are listed in Table 3.

   Table 3. Sample jobs for moving lookup table contents to IBM Db2 Analytics Accelerator for z/OS

   Analytics component	SDRLCNTL member
   Analytics - z/OS Performance	DRLJAPMK
   Analytics - KPM Db2	DRLJAKDK
   Analytics - KPM z/OS	DRLJAKZK