zOs/SQL/XCR321D2
SET CURRENT SQLID='S100447';
--
CREATE UNIQUE INDEX A540769.IXCR3210
ON A540769.TXCR321
(ENDOC ASC,
ENDOCVIEW ASC,
ENSEGMENT ASC,
ENPAGE ASC,
ENSPAGE ASC)
USING STOGROUP GSMS
PRIQTY 720 SECQTY 72000
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES('DO00'),
PART 2 VALUES('DO01'),
PART 3 VALUES('DO02'),
PART 4 VALUES('DO03'),
PART 5 VALUES('DO04'),
PART 6 VALUES('DO05'),
PART 7 VALUES('DO06'),
PART 8 VALUES('DO07'),
PART 9 VALUES('DO08'),
PART 10 VALUES('DO09'),
PART 11 VALUES('DO10'),
PART 12 VALUES('DO11'),
PART 13 VALUES('DO12'),
PART 14 VALUES('DO13'),
PART 15 VALUES('DO14'),
PART 16 VALUES('DO15'),
PART 17 VALUES('DO16'),
PART 18 VALUES('DO17'),
PART 19 VALUES('DO18'),
PART 20 VALUES('DO19'),
PART 21 VALUES('DO20'),
PART 22 VALUES('DO21'),
PART 23 VALUES('DO22'),
PART 24 VALUES('DO23'),
PART 25 VALUES('DO24'),
PART 26 VALUES('DO25'),
PART 27 VALUES('DO26'),
PART 28 VALUES('DO27'),
PART 29 VALUES('DO28'),
PART 30 VALUES('DO29'),
PART 31 VALUES('DO30'),
PART 32 VALUES('DO31'),
PART 33 VALUES('DO32'),
PART 34 VALUES('DO33'),
PART 35 VALUES('DO34'),
PART 36 VALUES('DO35'),
PART 37 VALUES('DO36'),
PART 38 VALUES('DO37'),
PART 39 VALUES('DO38'),
PART 40 VALUES('DO39'),
PART 41 VALUES('DO40'),
PART 42 VALUES('DO41'),
PART 43 VALUES('DO42'),
PART 44 VALUES('DO43'),
PART 45 VALUES('DO44'),
PART 46 VALUES('DO45'),
PART 47 VALUES('DO46'),
PART 48 VALUES('DO47'),
PART 49 VALUES('DO48'),
PART 50 VALUES('DO49'),
PART 51 VALUES('DO50'),
PART 52 VALUES('DO51'),
PART 53 VALUES('DO52'),
PART 54 VALUES('DO53'),
PART 55 VALUES('DO54'),
PART 56 VALUES('DO55'),
PART 57 VALUES('DO56'),
PART 58 VALUES('DO57'),
PART 59 VALUES('DO58'),
PART 60 VALUES('DO59'),
PART 61 VALUES('DO60'),
PART 62 VALUES('DO61'),
PART 63 VALUES('DO62'),
PART 64 VALUES('DO63'),
PART 65 VALUES('DO64'),
PART 66 VALUES('DO65'),
PART 67 VALUES('DO66'),
PART 68 VALUES('DO67'),
PART 69 VALUES('DO68'),
PART 70 VALUES('DO69'),
PART 71 VALUES('DO70'),
PART 72 VALUES('DO71'),
PART 73 VALUES('DO72'),
PART 74 VALUES('DO73'),
PART 75 VALUES('DO74'),
PART 76 VALUES('DO75'),
PART 77 VALUES('DO76'),
PART 78 VALUES('DO77'),
PART 79 VALUES('DO78'),
PART 80 VALUES('DO79'),
PART 81 VALUES('DO80'),
PART 82 VALUES('DO81'),
PART 83 VALUES('DO82'),
PART 84 VALUES('DO83'),
PART 85 VALUES('DO84'),
PART 86 VALUES('DO85'),
PART 87 VALUES('DO86'),
PART 88 VALUES('DO87'),
PART 89 VALUES('DO88'),
PART 90 VALUES('DO89'),
PART 91 VALUES('DO90'),
PART 92 VALUES('DO91'),
PART 93 VALUES('DO92'),
PART 94 VALUES('DO93'),
PART 95 VALUES('DO94'),
PART 96 VALUES('DO95'),
PART 97 VALUES('DO96'),
PART 98 VALUES('DO97'),
PART 99 VALUES('DO98'),
PART 100 VALUES('DO99'))
BUFFERPOOL BP2
CLOSE YES
COPY NO
DEFINE YES;
--
COMMIT;
--
CREATE TABLESPACE SXCR321
IN DA540769
USING STOGROUP GSMS
PRIQTY 736 SECQTY 14400
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
TRACKMOD NO
DSSIZE 16 G
NUMPARTS 100
(PART 28 USING STOGROUP GSMS PRIQTY 736 SECQTY 102240)
BUFFERPOOL BP32K
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 1;
COMMIT;
CREATE TABLE A540769.TXCR321
(ENDOC CHAR(20) FOR SBCS DATA NOT NULL,
ENDOCVIEW INTEGER NOT NULL,
ENSEGMENT INTEGER NOT NULL,
ENPAGE INTEGER NOT NULL,
ENSPAGE INTEGER NOT NULL,
EAPOOL VARCHAR(32000) FOR SBCS DATA NOT NULL,
CONSTRAINT ENDOC
PRIMARY KEY (ENDOC,
ENDOCVIEW,
ENSEGMENT,
ENPAGE,
ENSPAGE))
IN DA540769.SXCR321
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMENT ON TABLE A540769.TXCR321
IS 'DOCUMENT REPOSITORY: DOCUMENT CONTENTS POOL 3';
--
COMMIT;
--
CREATE UNIQUE INDEX A540769.IXCR3210
ON A540769.TXCR321
(ENDOC ASC,
ENDOCVIEW ASC,
ENSEGMENT ASC,
ENPAGE ASC,
ENSPAGE ASC)
USING STOGROUP GSMS
PRIQTY 720 SECQTY 72000
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES('DO00'),
PART 2 VALUES('DO01'),
PART 3 VALUES('DO02'),
PART 4 VALUES('DO03'),
PART 5 VALUES('DO04'),
PART 6 VALUES('DO05'),
PART 7 VALUES('DO06'),
PART 8 VALUES('DO07'),
PART 9 VALUES('DO08'),
PART 10 VALUES('DO09'),
PART 11 VALUES('DO10'),
PART 12 VALUES('DO11'),
PART 13 VALUES('DO12'),
PART 14 VALUES('DO13'),
PART 15 VALUES('DO14'),
PART 16 VALUES('DO15'),
PART 17 VALUES('DO16'),
PART 18 VALUES('DO17'),
PART 19 VALUES('DO18'),
PART 20 VALUES('DO19'),
PART 21 VALUES('DO20'),
PART 22 VALUES('DO21'),
PART 23 VALUES('DO22'),
PART 24 VALUES('DO23'),
PART 25 VALUES('DO24'),
PART 26 VALUES('DO25'),
PART 27 VALUES('DO26'),
PART 28 VALUES('DO27'),
PART 29 VALUES('DO28'),
PART 30 VALUES('DO29'),
PART 31 VALUES('DO30'),
PART 32 VALUES('DO31'),
PART 33 VALUES('DO32'),
PART 34 VALUES('DO33'),
PART 35 VALUES('DO34'),
PART 36 VALUES('DO35'),
PART 37 VALUES('DO36'),
PART 38 VALUES('DO37'),
PART 39 VALUES('DO38'),
PART 40 VALUES('DO39'),
PART 41 VALUES('DO40'),
PART 42 VALUES('DO41'),
PART 43 VALUES('DO42'),
PART 44 VALUES('DO43'),
PART 45 VALUES('DO44'),
PART 46 VALUES('DO45'),
PART 47 VALUES('DO46'),
PART 48 VALUES('DO47'),
PART 49 VALUES('DO48'),
PART 50 VALUES('DO49'),
PART 51 VALUES('DO50'),
PART 52 VALUES('DO51'),
PART 53 VALUES('DO52'),
PART 54 VALUES('DO53'),
PART 55 VALUES('DO54'),
PART 56 VALUES('DO55'),
PART 57 VALUES('DO56'),
PART 58 VALUES('DO57'),
PART 59 VALUES('DO58'),
PART 60 VALUES('DO59'),
PART 61 VALUES('DO60'),
PART 62 VALUES('DO61'),
PART 63 VALUES('DO62'),
PART 64 VALUES('DO63'),
PART 65 VALUES('DO64'),
PART 66 VALUES('DO65'),
PART 67 VALUES('DO66'),
PART 68 VALUES('DO67'),
PART 69 VALUES('DO68'),
PART 70 VALUES('DO69'),
PART 71 VALUES('DO70'),
PART 72 VALUES('DO71'),
PART 73 VALUES('DO72'),
PART 74 VALUES('DO73'),
PART 75 VALUES('DO74'),
PART 76 VALUES('DO75'),
PART 77 VALUES('DO76'),
PART 78 VALUES('DO77'),
PART 79 VALUES('DO78'),
PART 80 VALUES('DO79'),
PART 81 VALUES('DO80'),
PART 82 VALUES('DO81'),
PART 83 VALUES('DO82'),
PART 84 VALUES('DO83'),
PART 85 VALUES('DO84'),
PART 86 VALUES('DO85'),
PART 87 VALUES('DO86'),
PART 88 VALUES('DO87'),
PART 89 VALUES('DO88'),
PART 90 VALUES('DO89'),
PART 91 VALUES('DO90'),
PART 92 VALUES('DO91'),
PART 93 VALUES('DO92'),
PART 94 VALUES('DO93'),
PART 95 VALUES('DO94'),
PART 96 VALUES('DO95'),
PART 97 VALUES('DO96'),
PART 98 VALUES('DO97'),
PART 99 VALUES('DO98'),
PART 100 VALUES('DO99'))
BUFFERPOOL BP2
CLOSE YES
COPY NO
DEFINE YES;
--
COMMIT;
--