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 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.