zOs/SQL/TADM31
------------------------------------------------------------------------
-- --
-- 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 DA267167 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA267167 Stogroup=GSMS
-- Tablespace=DA267167.A031A
------------------------------------------------------------------------
--
DROP TABLESPACE DA267167.A031A;
commit;
CREATE TABLESPACE A031A
IN DA267167
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=A267167.TADM31A1 In DA267167.A031A
------------------------------------------------------------------------
--
CREATE TABLE A267167.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,
HI_ALLOC2 DECIMAL(15, 0) ,
BLKSIZE INTEGER NOT NULL WITH DEFAULT,
IFREESPC DECIMAL(15, 0),
IFREESPCP DECIMAL(10, 2),
EFREESPC DECIMAL(15, 0),
EFREESPCP DECIMAL(10, 2),
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,
SPC_SEC INTEGER ,
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 DA267167.A031A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE A267167.TADM31A1 IS 'SPACEWERTE IMS AUS PCP';
--
LABEL ON A267167.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=DA267167
-- Index=A267167.IADM31A1 On A267167.TADM31A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A267167.IADM31A1
ON A267167.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 --
------------------------------------------------------------------------
--