zOs/SQL/RP01DBLF
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBAF (810) Extract time : 2006-08-28 15:41 --
-- --
-- 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=A012A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS
-- Tablespace=DA540769.A012A
------------------------------------------------------------------------
--
CREATE TABLESPACE A012A
IN DA540769
USING STOGROUP GSMS
PRIQTY 48 SECQTY 100
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 8
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=A540769.TWK012A In DA540769.A012A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TWK012A
(WK012CH20 CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
WK012CH4 CHAR(4) FOR SBCS DATA WITH DEFAULT NULL,
WK012CH2 TIMESTAMP WITH DEFAULT NULL,
WK012TST CHAR(2) FOR SBCS DATA WITH DEFAULT NULL)
IN DA540769.A012A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IWK012A0 On A540769.TWK012A
------------------------------------------------------------------------
--
CREATE INDEX A540769.IWK012A0
ON A540769.TWK012A
(WK012CH20 ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 12
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
CREATE ALIAS A540769X.TWK012A FOR A540769.TWK012A ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--