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.
- 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
- This option is available for Performance List and Summary HDBs only. 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
- This option is available for Performance HDBs only. Specify Include Sums
of Squares to load sum-of-square values into the DB2 table
of a Summary HDB. 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.
- CICS versions (VRM)
- This option is available for Statistics HDBs only. This section displays the version of your CICS system as a CICS Transaction Server VRM and CICS Transaction Gateway VRM. The version of CICS determines the fields in the CREATE TABLE statement. You can change the VRMs at the Historical Database menu.
The VRMs also determine the names of the DB2 tables in the CREATE TABLE statement. This is because the name of each DB2 table includes the STID of the corresponding statistics data record, and some STID names changed between versions of CICS TS and TG. For example, with Transaction Server VRM set to 670, and Dispatcher Overview selected, you will generate the statement CREATE TABLE <dbname>.CPA_HST060A, but with Transaction Server VRM set to 680 or a later version, you will generate the statement CREATE TABLE <dbname>.CPA_HST062A.
For more information about STID names, see:- Statistics categories and reports
- The information about CICS Statistics Data Section in the CICS Transaction Server for z/OS® documentation
When you have specified the options, press Enter to
generate the JCL and display it in an ISPF Edit session.
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.