Create DB2 table
To create a DB2® table to store the data from an HDB, JCL is built that defines the DB2 table. If the selected HDB definition contains a qualifier, it will be used instead of the Database value to prefix the table name.
Procedure
- Select option 5 Export or option 7 Maintenance from the HDB menu to list the defined HDBs.
- Specify the T line action against one of the HDBs to specify
the DB2 Table details: Figure 1. Create DB2 Table
File Options Help ------------------------------------------------------------------------------ Create DB2 Table Command ===> _________________________________________________________________ HDB Name . . . : HDB4CEXP
Select option 1 1. Create DDL to define table 2. Upgrade table to current version
Create Options _ Create Database _ Create Storage Group Include Clock Field Components Summary Options 1 1. Time and Count _ Include Sums of Squares 2. Time only 3. Count only
Upgrade Settings: Management class . . . ________ (Blank for default management class) Storage class . . . . ________ (Blank for default storage class) Volume serial . . . . ______ (Blank for system default volume) Device type . . . . . ________ (Generic unit or device address) Data class . . . . . . ________ (Blank for default data class) Space Units . . . . . ________ (TRKS, CYLS) Primary quantity . . ________ (In above units) Secondary quantity ________ (In above units)
- Specify settings for exporting data from historical databases
(HDBs) to DB2. For
details of how to specify the Create Options, Include Clock Field
Components, and Summary Options fields, see Creating DDL to define a DB2 table. For details of how to specify
the Upgrade Settings fields, see "Data Set Allocation Settings" in Define a Performance HDB. Tip:
You can change the default DB2 settings from the CICS PA Profile Options Menu or the Options action bar menu.
- 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.
What to do next
Parent topic: HDB Maintenance