zOs/SQL/TSLARGE
------------------------------------------------------------------------
-- --
-- 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:42 --
-- --
-- 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=A019A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS
-- Tablespace=DA540769.A019A
------------------------------------------------------------------------
--
--drop TABLESPACE DA540769 . A019A;
commit;
CREATE TABLESPACE A019A
IN DA540769
USING STOGROUP GSMS
PRIQTY 720 SECQTY 720000
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 64G
NUMPARTS 2
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=A540769.TWK019A In DA540769.A019A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TWK019A
(WK019CH20 CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
WK019CH4 CHAR(4) FOR SBCS DATA WITH DEFAULT NULL,
WK019CH2 TIMESTAMP WITH DEFAULT NULL,
WK019TST CHAR(2) FOR SBCS DATA WITH DEFAULT NULL)
IN DA540769.A019A
partition by(wk019ch4)
(
partition 1 ending ('XX') ,
partition 2 ending ('99')
)
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IWK019A0 On A540769.TWK019A
------------------------------------------------------------------------
--
CREATE INDEX A540769.IWK019A0
ON A540769.TWK019A
(WK019CH20 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.TWK019A FOR A540769.TWK019A ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--