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____
The create table JCL is generated and displayed in an edit session for review and submission.
EDIT JCH.SPFTEMP3.CNTL Columns 00001 00072
Command ===> SUB_____________________________________________ Scroll ===> PAGE
****** ***************************** Top of Data ******************************
000001 //JCH#CPA JOB ,NOTIFY=&SYSUID
000002 //* CICSPA V3R2 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.