Step 1. Create the DB2 table

Exporting HDB data into DB2® is a two-step process. The first step creates the DB2 table.
Figure 1. Export Step 1. Create DB2 table
  File  Options  Help                                                      
-----------------------------------------------------------------------
                             Export HDB Data Set                           
Command ===> __________________________________________________________
                                                                           
Select option                                                              
1  1. Create DDL to define table        2. Load data into table            
                                                                           
Create Options                          Load Options                       
_  Create Database                      1  1. Resume                       
_  Create Storage Group                    2. Replace                      
                                                                           
DB2 Settings:                                                              
 DB2 Subsystem ID . . . DB2P                                               
 DSNTIAD Plan Name  . . DSNTIA91                                           
 DB2 Load Library . . . 'DB2.V910.SDSNLOAD'___________________________     
 DB2 Exit Library . . . 'DB2.V910.SDSNEXIT'___________________________     
 DB2 RUNLIB Library . . 'DB2.V910.RUNLIB.LOAD'________________________     
 Database . . . . . . . CICSPA__  Storage Group  . . PROD____              
 VCAT Catalog name  . . USER____                                           
 Allocation: Primary    20______  Secondary  . . . . 20____                
                                                                           
Select option 1 Create DDL to define table.

The create table JCL is generated and displayed in an edit session for review and submission.

Figure 2. Edit JCL to create DB2 table
EDIT       JCH.SPFTEMP3.CNTL                               Columns 00001 00072 
Command ===> SUB_____________________________________________ Scroll ===> PAGE 
****** ***************************** Top of Data ******************************
000001 //JCH#CPA JOB ,NOTIFY=&SYSUID                                           
000002 //* CICSPA V5R1 HDB - DDL TO DEFINE DB2 TABLE                           
000003 //RUNTIAD EXEC PGM=IKJEFT01,DYNAMNBR=20                                 
000004 //SYSTSPRT DD SYSOUT=*                                                  
000005 //SYSTSIN  DD *                                                         
000006  DSN SYSTEM(DB2P)                                                       
000007  RUN PROGRAM(DSNTIAD) LIB('DB2.V910.RUNLIB.LOAD') PLAN(DSNTIA91)        
000008 /*                                                                      
000009 //SYSPRINT DD SYSOUT=*                                                  
000010 //SYSUDUMP DD SYSOUT=*                                                  
000011 //SYSIN    DD *                                                         
000012    CREATE TABLESPACE #180203                                            
000013           IN         CICSPA                                             
000014           LOCKSIZE   ANY                                                
000015           BUFFERPOOL BP0                                                
000016           CLOSE      NO                                                 
000017           SEGSIZE    32                                                 
000018           USING      STOGROUP PROD                                      
000019           PRIQTY     20                                                 
000020           SECQTY     20                                                 
000021           ERASE      NO;                                                
000022                                                                         
000023    CREATE TABLE CICSPA.HST014B (                                        
000024       START_DATE             DATE,                                      
000025       START_TIME             TIME,                                      
000026       APPLID                 CHAR(8),                                   
000027       MVSID                  CHAR(4),                                   
000028       DSA_NAME               CHAR(8),                                   
000029       DSA_LOCATION           CHAR(8),                                   
000030       ACCESS                 CHAR(8),                                   
000031       DSA_INDEX              CHAR,                                       

Note the DB2 table name “CICSPA.HST014B”. This name reflects the statistics ID of the selected report, in this case 014 for DSAs. The B suffix is appended to distinguish this report from the Storage Overview report that shares the same 014 ID.

CICS PA exports CICS® Transaction Gateway statistics to DB2 table names ending with the SQL identifier "HSTGnnnn" (note the letter G). This distinguishes them from the "HSTnnnn" DB2 table names for CICS Transaction Server statistics.

You can change this name to something more meaningful to you, for example CICSPA.CICSP1_DSAS.

Submit the JCL to create the table.


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//guided-tours/cpaug293.htm