Creating DDL to define a DB2 table

CICS PA builds the JCL 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.

DSNTIAD, the sample Dynamic SQL program, is used to run the DDL that defines the DB2 table. 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.

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.

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.

Start of changeUpgrade SettingsEnd of change
Start of changeFor details of the data set options you can specify when upgrading existing DB2 tables, see "Data Set Allocation Settings" in Define a Performance HDB.End of change
Note: Start of changeYou can change the default DB2 settings from the CICS PA Profile Options Menu or the Options action bar menu. If any required DB2 settings are not specified, CICS PA will insert parameter markers such as <setting> in the JCL stream. Replace these with the required values.End of change

Start of changeWhen you have specified the options, press Enter to generate the JCL and display it in an ISPF Edit session.End of change

Review the JCL and make any changes you require. When the JCL is complete, submit it to create the DB2 table.

Review the job output in SDSF to verify that the table was created successfully.