zOs/SQL/WI800
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5655-W34 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBAF (915 ) Extract time : 2011-09-15 21:52 --
-- --
-- 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 RO=N TC=N --
-- Grants : SG=N DB=N TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A800A In Database DGDB0112 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DGDB0112 Stogroup=GSMS (for partition 1)
-- Table space=DGDB0112.A800A
------------------------------------------------------------------------
--
SET CURRENT SQLID='GDB0112';
--
CREATE TABLESPACE A800A
IN DGDB0112
USING STOGROUP GSMS
PRIQTY 360000 SECQTY 360000
FREEPAGE 5 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
DSSIZE 16 G
NUMPARTS 100
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE NO
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=GDB0112.TWI800A1 In DGDB0112.A800A
------------------------------------------------------------------------
--
CREATE TABLE GDB0112.TWI800A1
(WI800_ORDER_T CHAR(4) FOR SBCS DATA NOT NULL,
WI800_ORDER_D CHAR(8) FOR SBCS DATA NOT NULL,
WI800_ORDER_L CHAR(5) FOR SBCS DATA NOT NULL,
WI800_ORDER_G CHAR(2) FOR SBCS DATA NOT NULL,
WI800_SPLIT SMALLINT NOT NULL,
WI800_PARTITION SMALLINT NOT NULL,
WI800_INSERT TIMESTAMP NOT NULL,
CONSTRAINT WI800_ORDER_T
PRIMARY KEY (WI800_ORDER_T,
WI800_ORDER_D,
WI800_ORDER_L,
WI800_ORDER_G))
IN DGDB0112.A800A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
LABEL ON TABLE GDB0112.TWI800A1 IS 'P90 ARCHIVE INDEX';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0112
-- Index=GDB0112.IWI800A1 On GDB0112.TWI800A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GDB0112.IWI800A1
ON GDB0112.TWI800A1
(WI800_ORDER_T ASC,
WI800_ORDER_D ASC,
WI800_ORDER_L ASC,
WI800_ORDER_G ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 5 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 4 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0112
-- Index=GDB0112.IWI800A2 On GDB0112.TWI800A1
------------------------------------------------------------------------
--
CREATE INDEX GDB0112.IWI800A2
ON GDB0112.TWI800A1
(WI800_INSERT ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 4 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A801A001 In Database DGDB0112--
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DGDB0112 Stogroup=GSMS (for partition 1)
-- Table space=DGDB0112.A801A001
------------------------------------------------------------------------
--
CREATE TABLESPACE A801A001
IN DGDB0112
USING STOGROUP GSMS
PRIQTY 360000 SECQTY 360000
FREEPAGE 5 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
DSSIZE 16 G
NUMPARTS 100
BUFFERPOOL BP16K0
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE NO
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=GDB0112.TWI801A1001 In DGDB0112.A801A001
------------------------------------------------------------------------
--
CREATE TABLE GDB0112.TWI801A1001
(WI801_ORDER_T CHAR(4) FOR SBCS DATA NOT NULL,
WI801_ORDER_D CHAR(8) FOR SBCS DATA NOT NULL,
WI801_ORDER_L CHAR(5) FOR SBCS DATA NOT NULL,
WI801_SI2 SMALLINT NOT NULL,
WI801_GA CHAR(21) FOR SBCS DATA NOT NULL,
WI801_SI3 SMALLINT NOT NULL,
WI801_VV CHAR(7) FOR SBCS DATA NOT NULL,
WI801_SI4 SMALLINT NOT NULL,
WI801_VB CHAR(2) FOR SBCS DATA NOT NULL,
WI801_SI5 SMALLINT NOT NULL,
WI801_TN CHAR(7) FOR SBCS DATA NOT NULL,
WI801_PARTKEY SMALLINT NOT NULL,
WI801_INSERT TIMESTAMP NOT NULL,
WI801_DATA VARCHAR(8192) FOR SBCS DATA NOT NULL,
CONSTRAINT WI801_ORDER_T
PRIMARY KEY (WI801_ORDER_T,
WI801_ORDER_D,
WI801_ORDER_L,
WI801_SI2,
WI801_GA,
WI801_SI3,
WI801_VV,
WI801_SI4,
WI801_VB,
WI801_SI5,
WI801_TN,
WI801_PARTKEY))
IN DGDB0112.A801A001
PARTITION BY (WI801_PARTKEY ASC)
(PARTITION 1 ENDING AT (1),
PARTITION 2 ENDING AT (2),
PARTITION 3 ENDING AT (3),
PARTITION 4 ENDING AT (4),
PARTITION 5 ENDING AT (5),
PARTITION 6 ENDING AT (6),
PARTITION 7 ENDING AT (7),
PARTITION 8 ENDING AT (8),
PARTITION 9 ENDING AT (9),
PARTITION 10 ENDING AT (10),
PARTITION 11 ENDING AT (11),
PARTITION 12 ENDING AT (12),
PARTITION 13 ENDING AT (13),
PARTITION 14 ENDING AT (14),
PARTITION 15 ENDING AT (15),
PARTITION 16 ENDING AT (16),
PARTITION 17 ENDING AT (17),
PARTITION 18 ENDING AT (18),
PARTITION 19 ENDING AT (19),
PARTITION 20 ENDING AT (20),
PARTITION 21 ENDING AT (21),
PARTITION 22 ENDING AT (22),
PARTITION 23 ENDING AT (23),
PARTITION 24 ENDING AT (24),
PARTITION 25 ENDING AT (25),
PARTITION 26 ENDING AT (26),
PARTITION 27 ENDING AT (27),
PARTITION 28 ENDING AT (28),
PARTITION 29 ENDING AT (29),
PARTITION 30 ENDING AT (30),
PARTITION 31 ENDING AT (31),
PARTITION 32 ENDING AT (32),
PARTITION 33 ENDING AT (33),
PARTITION 34 ENDING AT (34),
PARTITION 35 ENDING AT (35),
PARTITION 36 ENDING AT (36),
PARTITION 37 ENDING AT (37),
PARTITION 38 ENDING AT (38),
PARTITION 39 ENDING AT (39),
PARTITION 40 ENDING AT (40),
PARTITION 41 ENDING AT (41),
PARTITION 42 ENDING AT (42),
PARTITION 43 ENDING AT (43),
PARTITION 44 ENDING AT (44),
PARTITION 45 ENDING AT (45),
PARTITION 46 ENDING AT (46),
PARTITION 47 ENDING AT (47),
PARTITION 48 ENDING AT (48),
PARTITION 49 ENDING AT (49),
PARTITION 50 ENDING AT (50),
PARTITION 51 ENDING AT (51),
PARTITION 52 ENDING AT (52),
PARTITION 53 ENDING AT (53),
PARTITION 54 ENDING AT (54),
PARTITION 55 ENDING AT (55),
PARTITION 56 ENDING AT (56),
PARTITION 57 ENDING AT (57),
PARTITION 58 ENDING AT (58),
PARTITION 59 ENDING AT (59),
PARTITION 60 ENDING AT (60),
PARTITION 61 ENDING AT (61),
PARTITION 62 ENDING AT (62),
PARTITION 63 ENDING AT (63),
PARTITION 64 ENDING AT (64),
PARTITION 65 ENDING AT (65),
PARTITION 66 ENDING AT (66),
PARTITION 67 ENDING AT (67),
PARTITION 68 ENDING AT (68),
PARTITION 69 ENDING AT (69),
PARTITION 70 ENDING AT (70),
PARTITION 71 ENDING AT (71),
PARTITION 72 ENDING AT (72),
PARTITION 73 ENDING AT (73),
PARTITION 74 ENDING AT (74),
PARTITION 75 ENDING AT (75),
PARTITION 76 ENDING AT (76),
PARTITION 77 ENDING AT (77),
PARTITION 78 ENDING AT (78),
PARTITION 79 ENDING AT (79),
PARTITION 80 ENDING AT (80),
PARTITION 81 ENDING AT (81),
PARTITION 82 ENDING AT (82),
PARTITION 83 ENDING AT (83),
PARTITION 84 ENDING AT (84),
PARTITION 85 ENDING AT (85),
PARTITION 86 ENDING AT (86),
PARTITION 87 ENDING AT (87),
PARTITION 88 ENDING AT (88),
PARTITION 89 ENDING AT (89),
PARTITION 90 ENDING AT (90),
PARTITION 91 ENDING AT (91),
PARTITION 92 ENDING AT (92),
PARTITION 93 ENDING AT (93),
PARTITION 94 ENDING AT (94),
PARTITION 95 ENDING AT (95),
PARTITION 96 ENDING AT (96),
PARTITION 97 ENDING AT (97),
PARTITION 98 ENDING AT (98),
PARTITION 99 ENDING AT (99),
PARTITION 100 ENDING AT (100))
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
LABEL ON TABLE GDB0112.TWI801A1001 IS 'P90 ARCHIVE';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0112
-- Index=GDB0112.IWI801A1001 On GDB0112.TWI801A1001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GDB0112.IWI801A1001
ON GDB0112.TWI801A1001
(WI801_ORDER_T ASC,
WI801_ORDER_D ASC,
WI801_ORDER_L ASC,
WI801_SI2 ASC,
WI801_GA ASC,
WI801_SI3 ASC,
WI801_VV ASC,
WI801_SI4 ASC,
WI801_VB ASC,
WI801_SI5 ASC,
WI801_TN ASC,
WI801_PARTKEY ASC)
PARTITIONED
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 5 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
(PARTITION 1,
PARTITION 2,
PARTITION 3,
PARTITION 4,
PARTITION 5,
PARTITION 6,
PARTITION 7,
PARTITION 8,
PARTITION 9,
PARTITION 10,
PARTITION 11,
PARTITION 12,
PARTITION 13,
PARTITION 14,
PARTITION 15,
PARTITION 16,
PARTITION 17,
PARTITION 18,
PARTITION 19,
PARTITION 20,
PARTITION 21,
PARTITION 22,
PARTITION 23,
PARTITION 24,
PARTITION 25,
PARTITION 26,
PARTITION 27,
PARTITION 28,
PARTITION 29,
PARTITION 30,
PARTITION 31,
PARTITION 32,
PARTITION 33,
PARTITION 34,
PARTITION 35,
PARTITION 36,
PARTITION 37,
PARTITION 38,
PARTITION 39,
PARTITION 40,
PARTITION 41,
PARTITION 42,
PARTITION 43,
PARTITION 44,
PARTITION 45,
PARTITION 46,
PARTITION 47,
PARTITION 48,
PARTITION 49,
PARTITION 50,
PARTITION 51,
PARTITION 52,
PARTITION 53,
PARTITION 54,
PARTITION 55,
PARTITION 56,
PARTITION 57,
PARTITION 58,
PARTITION 59,
PARTITION 60,
PARTITION 61,
PARTITION 62,
PARTITION 63,
PARTITION 64,
PARTITION 65,
PARTITION 66,
PARTITION 67,
PARTITION 68,
PARTITION 69,
PARTITION 70,
PARTITION 71,
PARTITION 72,
PARTITION 73,
PARTITION 74,
PARTITION 75,
PARTITION 76,
PARTITION 77,
PARTITION 78,
PARTITION 79,
PARTITION 80,
PARTITION 81,
PARTITION 82,
PARTITION 83,
PARTITION 84,
PARTITION 85,
PARTITION 86,
PARTITION 87,
PARTITION 88,
PARTITION 89,
PARTITION 90,
PARTITION 91,
PARTITION 92,
PARTITION 93,
PARTITION 94,
PARTITION 95,
PARTITION 96,
PARTITION 97,
PARTITION 98,
PARTITION 99,
PARTITION 100)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0112
-- Index=GDB0112.IWI801A2001 On GDB0112.TWI801A1001
------------------------------------------------------------------------
--
CREATE INDEX GDB0112.IWI801A2001
ON GDB0112.TWI801A1001
(WI801_INSERT ASC,
WI801_PARTKEY ASC)
PARTITIONED
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
(PARTITION 1,
PARTITION 2,
PARTITION 3,
PARTITION 4,
PARTITION 5,
PARTITION 6,
PARTITION 7,
PARTITION 8,
PARTITION 9,
PARTITION 10,
PARTITION 11,
PARTITION 12,
PARTITION 13,
PARTITION 14,
PARTITION 15,
PARTITION 16,
PARTITION 17,
PARTITION 18,
PARTITION 19,
PARTITION 20,
PARTITION 21,
PARTITION 22,
PARTITION 23,
PARTITION 24,
PARTITION 25,
PARTITION 26,
PARTITION 27,
PARTITION 28,
PARTITION 29,
PARTITION 30,
PARTITION 31,
PARTITION 32,
PARTITION 33,
PARTITION 34,
PARTITION 35,
PARTITION 36,
PARTITION 37,
PARTITION 38,
PARTITION 39,
PARTITION 40,
PARTITION 41,
PARTITION 42,
PARTITION 43,
PARTITION 44,
PARTITION 45,
PARTITION 46,
PARTITION 47,
PARTITION 48,
PARTITION 49,
PARTITION 50,
PARTITION 51,
PARTITION 52,
PARTITION 53,
PARTITION 54,
PARTITION 55,
PARTITION 56,
PARTITION 57,
PARTITION 58,
PARTITION 59,
PARTITION 60,
PARTITION 61,
PARTITION 62,
PARTITION 63,
PARTITION 64,
PARTITION 65,
PARTITION 66,
PARTITION 67,
PARTITION 68,
PARTITION 69,
PARTITION 70,
PARTITION 71,
PARTITION 72,
PARTITION 73,
PARTITION 74,
PARTITION 75,
PARTITION 76,
PARTITION 77,
PARTITION 78,
PARTITION 79,
PARTITION 80,
PARTITION 81,
PARTITION 82,
PARTITION 83,
PARTITION 84,
PARTITION 85,
PARTITION 86,
PARTITION 87,
PARTITION 88,
PARTITION 89,
PARTITION 90,
PARTITION 91,
PARTITION 92,
PARTITION 93,
PARTITION 94,
PARTITION 95,
PARTITION 96,
PARTITION 97,
PARTITION 98,
PARTITION 99,
PARTITION 100)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A812A In Database DGDB0112 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DGDB0112 Stogroup=GSMS (for partition 1)
-- Table space=DGDB0112.A812A
------------------------------------------------------------------------
--
CREATE TABLESPACE A812A
IN DGDB0112
USING STOGROUP GSMS
PRIQTY 360000 SECQTY 360000
FREEPAGE 5 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
DSSIZE 16 G
NUMPARTS 100
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE NO
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=GDB0112.TWI812A1 In DGDB0112.A812A
------------------------------------------------------------------------
--
CREATE TABLE GDB0112.TWI812A1
(WI812_SPLIT SMALLINT NOT NULL,
WI812_PARTITION SMALLINT NOT NULL,
WI812_STATE CHAR(1) FOR SBCS DATA NOT NULL,
WI812_LASTUSE TIMESTAMP NOT NULL,
CONSTRAINT WI812_SPLIT
PRIMARY KEY (WI812_SPLIT,
WI812_PARTITION,
WI812_STATE))
IN DGDB0112.A812A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
LABEL ON TABLE GDB0112.TWI812A1 IS 'P90 ARCHIVE INDEX';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0112
-- Index=GDB0112.IWI812A1 On GDB0112.TWI812A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GDB0112.IWI812A1
ON GDB0112.TWI812A1
(WI812_SPLIT ASC,
WI812_PARTITION ASC,
WI812_STATE ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 5 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 4 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--