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:
-
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.
-
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".
-
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.
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 |
-
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.
-
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 |
-
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 |