JCL is built that contains the CREATE TABLE statement required
to define the DB2® table for
this HDB data set. The HDB name is used as the table name, however
you can change this by editing the JCL.
The options are:
- Create Options
- Select Create Database if you want the CREATE TABLE statement
to be preceded by a CREATE DATABASE statement to define the DB2 database. You might need to
ask your DB2 administrator to
do this for you if you do not have sufficient authority.
Select Create
Storage Group if you want the CREATE TABLE statement to be preceded
by a CREATE STOGROUP statement to define the DB2 Storage Group.
- DB2 Settings
- Specify the required DB2 settings
for your environment. CICS PA only
provides a basic facility to load data into DB2. It does not provide any management or reporting
capabilities once the data is in DB2.
If you omit any DB2 settings, CICS PA will
insert parameter markers such as <setting> in the JCL
stream.
CICS PA uses
DSNTIAD, the sample Dynamic SQL program to run the DDL that defines
the table.
The options are:
- DB2 Subsystem ID
- The DB2 Subsystem ID to
be used to for the Export function.
- DSNTIAD Plan Name
- The Plan name for the dynamic SQL program (DSNTIAD), for example
DSNTIA91.
- DB2 Load Library
- The DB2 SDSNLOAD Load Library
data set name.
- DB2 Exit Library
- The DB2 SDSNEXIT Exit Library
data set name.
- DB2 RUNLIB Library
- The DB2 RUNLIB.LOAD Application
Load Library data set name.
- Database
- The DB2 Database name that
is to contain the tables.
Note: The Database name will be
replaced by the qualifier if a Qualifier has been specified in the
HDB definition.
- Storage Group
- The DB2 Storage Group name
for the DB2 Table Spaces.
- VCAT Catalog name
- Identifies the integrated catalog facility catalog for the storage
group.
- Volume
- Defines the volume of the storage group.
- Primary Allocation
- Specifies the minimum primary space allocation (PRIQTY) for DB2-managed
data sets.
- Secondary Allocation
- Specifies the minimum secondary space allocation (SECQTY) for
DB2-managed data sets.
- Include Clock Field Components
- CMF performance class Clock fields accumulate data for both their
count and time components in the HDB. You have a choice as to which
components to load into DB2.
For example, selecting Time only will load the time component
but not the count component. Time only is sufficient for most analysis
requirements.
For an HDB that is intended to be used
in the CICS PA plug-in for CICS Explorer®,
this option must be set to "1. Time and Count".
- Summary Options
- Specify Include Sums of Squares to load sum-of-square values
into the DB2 Table. CICS PA always
loads the Total. This allows you to calculate averages. Sums of Squares
are required to calculate standard deviation and peak percentiles.
Totals (and not Sums of Squares) is sufficient for most analysis requirements.
This option must not be selected for an HDB that is intended
to be used in the CICS PA plug-in.
Review the JCL and then submit it to create the DB2 table.
Review the job output in SDSF to verify that the table was created
successfully.