Loading data into the DB2 table
To load data into the DB2® table, select option 2 Load data into table.
JCL is built that contains the DB2 Load Utility statement required to load the HDB data set into the DB2 table that was defined in the previous step.
CICS PA uses the DB2 Load Utility to load data into the table.
- Load Option
- Select Resume if you want the DB2 Load
Utility to resume loading data into the table. Typically, this is
appropriate for Summary HDBs.
Select Replace if you want the DB2 Load Utility to replace data already loaded in the table. Typically, this is appropriate for List HDBs.
- 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, and has an effect for Performance
Summary HDBs only. 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.
- Statistics data VRMs to be loaded
This option is available for Statistics HDBs only. Statistics fields are often added or removed in a new release of CICS TS or CICS TG. If your site is running multiple releases of CICS, your Statistics HDB might contain data that was loaded from more than one version of CICS. Consequently some records in the HDB might have a particular field where other records do not. Only fields defined in the table are loaded and missing fields are ignored. Regardless, when you export that data to DB2, the data is loaded into a single DB2 table.
In the TS and TG fields, ensure you specify the versions of data that exist in the HDB and which you want loaded into the DB2 table. CICS PA generates JCL that is correct for these versions. The generated JCL has additional load statements and an IGNOREFIELDS YES operand that collectively enable the JCL to work without any more changes.
Notes:- As explained in Creating DDL to define a DB2 table, the CICS VRMs determine the names of the DB2 tables in the LOAD DATA statement in the JCL. Some STID names changed between versions of CICS, and so their corresponding DB2 table names are different depending on the CICS VRM used when loading data. Therefore, you can have data for the same type of statistics record in two different tables.
- In the situation where you have more than one table for the same type of statistics record (loaded from different VRMs), and you want to load data into each of the tables, run option 2 Load data into table multiple times, once for each VRM, changing the VRM each time. You can change the VRM at the Historical Database menu.
Review the JCL and then submit it to load the DB2 table.
Review the job output in SDSF to verify that the table was created successfully.