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

  1. Select option 5 Export or option 7 Maintenance from the HDB menu to list the defined HDBs.
  2. 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                                                     
                                                                                    
    
     Start of changeSelect option                                                  
     1  1. Create DDL to define table      2. Upgrade table to current versionEnd of change
     
     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                                                  
    
     Start of changeUpgrade 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)                        
     End of change
  3. 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: Start of changeYou can change the default DB2 settings from the CICS PA Profile Options Menu or the Options action bar menu.End of change
  4. Review the JCL and then submit it to create the DB2 table.
  5. Review the job output in SDSF to verify that the table was created successfully.

What to do next

Once the HDB data has been exported you can access it using the CICS® PA plug-in or through DB2 SQL.