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.

Before you begin

Apply the following updates for the following prerequisite software:
IBM Tivoli® Decision Support for z/OS 1.8.2
APAR PI70968
IBM Db2 Analytics Accelerator for z/OS 5.1
One of the following two sets of PTFs are required (either PTF-2 level or PTF-3 level), as indicated:
  • PTF-2 level with the following PTFs applied:
    • UI30285
    • UI30337
    • UI30740
    • UI31021
    • UI31148
    • UI31287
    • UI31302
    • UI31507
    • UI31571
    • UI31739
    • UI32368
    • UI32588
    • UI32707
    • UI32810
    • UI35006
    • UI35007
    • UI35008
    • UI35009
    • UI35010
    • UI35011
    • UI35012
    • UI37271
    • UI37783
    • UI37784
    • UI37785
    • UI37786
    • UI37793
    • UI37794
    • UI37795
    • UI37796
    • UI38702
  • PTF-3 level with the following PTFs applied:
    • UI33493
    • UI33603
    • UI33797
    • UI35501
    • UI36461
    • UI37053
    • UI37534
    • UI39653
    • UI39921
    • UI40892
    • UI41378
    • UI42327
    • UI42328
    • UI42329
IBM Db2 Analytics Accelerator Loader for z/OS 2.1
The following PTFs are required:
  • UI18415
  • UI20963
  • UI21883
  • UI22759
  • UI23712
  • UI26834
  • UI27815
  • UI33956
  • UI35108
  • UI36231
  • UI36343
  • UI38008
  • UI38201
  • UI38202
  • UI38810
  • UI38811
  • UI38939
  • UI38943
  • UI38973
  • UI39437
  • UI39451
  • UI39454

About this task

IBM Z Performance and Capacity Analytics includes an analytics component for each set of tables that are supported in IBM Db2 Analytics Accelerator for z/OS. IBM Z Performance and Capacity Analytics analytics components that can be loaded by the System Data Engine lists these analytics components with their subcomponents and the names of the corresponding base components in IBM Z Performance and Capacity Analytics.

Procedure

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