zOs/SQL/XXRTCXG
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBTF (810) Extract time : 2006-10-20 10:44 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=N UF=N SP=N SQ=N --
-- Grants : SG=N DB=Y TS=Y TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=A031A In Database DB2ADMIN --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DB2ADMIN Stogroup=GSMS
-- Tablespace=DB2ADMIN.A031A
------------------------------------------------------------------------
--
CREATE TABLESPACE A031A
IN DB2ADMIN
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=OA1T.TADM31A1 In DB2ADMIN.A031A
------------------------------------------------------------------------
--
CREATE TABLE OA1T.TADM31A1
(DB_NAME CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
DD_NAME CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
RUNTIME TIMESTAMP NOT NULL WITH DEFAULT,
RNMNAME CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
HI_ALLOC DECIMAL(15, 0) NOT NULL WITH DEFAULT,
BLKSIZE INTEGER NOT NULL WITH DEFAULT,
FREESPC DECIMAL(15, 0) NOT NULL WITH DEFAULT,
FREESPCP DECIMAL(10, 2) NOT NULL WITH DEFAULT,
TRK_PRIM INTEGER NOT NULL WITH DEFAULT,
TRK_SEC INTEGER NOT NULL WITH DEFAULT,
EXTENTS SMALLINT NOT NULL WITH DEFAULT,
HI_CISPLIT INTEGER NOT NULL WITH DEFAULT,
HI_CASPLIT INTEGER NOT NULL WITH DEFAULT,
DB_TYP CHAR(6) FOR SBCS DATA NOT NULL
WITH DEFAULT,
DB_ACCESS CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
DB_USE CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT)
IN DB2ADMIN.A031A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1T.TADM31A1 IS 'SPACEWERTE IMS AUS PCP';
--
LABEL ON OA1T.TADM31A1
(DB_USE IS 'VERWENDUNG',
DB_ACCESS IS 'DB-ACCESS',
DB_TYP IS 'DATENBANKTYP',
HI_CASPLIT IS 'ANZAHL CA-SPLITS',
HI_CISPLIT IS 'ANZAHL CI-SPLITS',
EXTENTS IS 'ANZAHL EXTENTS',
TRK_SEC IS 'SECONDARY ALLOCATED TRACKS',
TRK_PRIM IS 'PRIMARY ALLOCATED TRACKS',
FREESPCP IS 'TOTAL FREESPACE IN %',
FREESPC IS 'TOTAL BYTES FREESPACE',
BLKSIZE IS 'BLOCKSIZE',
HI_ALLOC IS 'HIGH ALLOCATED BYTES',
RNMNAME IS 'RANDOMIZER NAME',
RUNTIME IS 'RUNTIME',
DD_NAME IS 'DD NAME',
DB_NAME IS 'DB NAME');
--
------------------------------------------------------------------------
-- Database=DB2ADMIN
-- Index=OA1T.IADM31A1 On OA1T.TADM31A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1T.IADM31A1
ON OA1T.TADM31A1
(DB_NAME ASC,
DD_NAME ASC,
RUNTIME ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--