zOs/SQL/MF202
set current sqlid = 'S100447' ;
------------------------------------------------------------------------
-- --
-- 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-08-31 13:18 --
-- --
-- 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=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=A202A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS
-- Tablespace=DA540769.A202A
------------------------------------------------------------------------
--
CREATE TABLESPACE A202A
IN DA540769
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=A540769.TWK202A1 In DA540769.A202A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TWK202A1
(BUID CHAR(4) FOR SBCS DATA NOT NULL,
SELCD CHAR(20) FOR SBCS DATA NOT NULL,
GUELTIGAB TIMESTAMP NOT NULL,
GUELTIGBIS TIMESTAMP NOT NULL,
SPRACHE SMALLINT NOT NULL,
LETZTEMUT TIMESTAMP NOT NULL,
LETZTEMUTPID CHAR(7) FOR SBCS DATA NOT NULL,
"PARAMETER" VARCHAR(2048) FOR SBCS DATA NOT NULL,
CONSTRAINT BUID
PRIMARY KEY (BUID,
SELCD,
GUELTIGAB))
IN DA540769.A202A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IWK202A0 On A540769.TWK202A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX A540769.IWK202A0
ON A540769.TWK202A1
(BUID ASC,
SELCD ASC,
GUELTIGAB ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--