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
Select option 1 Create DDL to define table. File Options Help
-----------------------------------------------------------------------
Export HDB Data Set
Command ===> __________________________________________________________
Select option
1 1. Create DDL to define table
3. Upgrade table to current version
2. Load data into table
Create Options Load Options
_ Create Database 1 1. Resume
_ Create Storage Group 2. Replace
Upgrade Settings:
Old VRM TS: . . . . . Current VRM TS . : 700
TG: . . . . . TG . : 910
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)

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