Create DB2 table

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.

About this task

This task explains how to create the DB2 table for an HDB 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                                                     
                                                                                
 Create Options                                                                 
 _  Create Database                                                             
 _  Create Storage Group                                                        
                                                                                
 DB2 Settings:                                                                  
  DB2 Subsystem ID . . . ____                                                   
  DSNTIAD Plan Name  . . ________                                               
  DB2 Load Library . . . ______________________________________________         
  DB2 Exit Library . . . ______________________________________________         
  DB2 RUNLIB Library . . ______________________________________________         
  Database . . . . . . . ________  Storage Group  . . ________                  
  VCAT Catalog name  . . ________  Volume . . . . . . ______                    
  Allocation: Primary    ________  Secondary  . . . . ______                    

 Include Clock Field Components          Summary Options           
 1  1. Time and Count                    _  Include Sums of Squares
    2. Time only                                                   
    3. Count only                                                  
  F1=Help      F3=Exit      F7=Backward  F8=Forward  F10=Actions  F12=Cancel    

Procedure

  1. Specify settings for exporting data from historical databases (HDBs) to DB2. For details of how to specify the Create Options, DB2 Settings, Include Clock Field Components, and Summary Options fields, see Creating DDL to define a DB2 table.
  2. Review the JCL and then submit it to create the DB2 table.
  3. 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.

Task Task

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//db2create.htm