zOs/TX/XC200DDL
set current sqlid='S100447';
CREATE TABLESPACE A200A00
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407690.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A00
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407690.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 0';
COMMIT;
GRANT USE OF STOGROUP GSMS TO "PUBLIC";
CREATE UNIQUE INDEX A5407690.IXC200A10
ON A5407690.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A01
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407691.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A01
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407691.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 1';
COMMIT;
CREATE UNIQUE INDEX A5407691.IXC200A10
ON A5407691.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A02
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407692.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A02
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407692.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 0';
COMMIT;
CREATE UNIQUE INDEX A5407692.IXC200A10
ON A5407692.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A03
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407693.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A03
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407693.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 3';
COMMIT;
CREATE UNIQUE INDEX A5407693.IXC200A10
ON A5407693.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A04
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407694.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A04
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407694.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 4';
COMMIT;
CREATE UNIQUE INDEX A5407694.IXC200A10
ON A5407694.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A05
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407695.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A05
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407695.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 5';
COMMIT;
CREATE UNIQUE INDEX A5407695.IXC200A10
ON A5407695.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A06
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407696.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A06
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407696.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 6';
COMMIT;
CREATE UNIQUE INDEX A5407696.IXC200A10
ON A5407696.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A07
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407697.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A07
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407697.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 7';
COMMIT;
CREATE UNIQUE INDEX A5407697.IXC200A10
ON A5407697.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A08
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407698.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A08
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407698.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 8';
COMMIT;
CREATE UNIQUE INDEX A5407698.IXC200A10
ON A5407698.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;
CREATE TABLESPACE A200A09
IN DA540769
USING STOGROUP GSMS
FREEPAGE 0 PCTFREE 0
DSSIZE 16 G
NUMPARTS 254
BUFFERPOOL BP32K
LOCKSIZE ANY
CLOSE NO
LOCKPART YES;
COMMIT;
CREATE TABLE A5407699.TXC200A1
(XC200_DOC_PART_NO CHAR(4) NOT NULL,
XC200_UUID_DOC_B CHAR(16) FOR BIT DATA NOT NULL,
XC200_DOC_FRMT CHAR(3) NOT NULL,
XC200_DOC_CONT_TYP INTEGER NOT NULL,
XC200_DOC_SEGM_SEQ INTEGER NOT NULL,
XC200_DOC_SEGM VARCHAR(32000) FOR BIT DATA NOT NULL,
CONSTRAINT XC200_DOC_PART_NO
PRIMARY KEY (XC200_DOC_PART_NO,
XC200_UUID_DOC_B,
XC200_DOC_FRMT,
XC200_DOC_CONT_TYP,
XC200_DOC_SEGM_SEQ))
IN DA540769.A200A09
PARTITION BY (XC200_DOC_PART_NO ASC)
(PART 1 VALUES('0001'),
PART 2 VALUES('0002'),
PART 3 VALUES('0003'),
PART 4 VALUES('0004'),
PART 5 VALUES('0005'),
PART 6 VALUES('0006'),
PART 7 VALUES('0007'),
PART 8 VALUES('0008'),
PART 9 VALUES('0009'),
PART 10 VALUES('0010'),
PART 11 VALUES('0011'),
PART 12 VALUES('0012'),
PART 13 VALUES('0013'),
PART 14 VALUES('0014'),
PART 15 VALUES('0015'),
PART 16 VALUES('0016'),
PART 17 VALUES('0017'),
PART 18 VALUES('0018'),
PART 19 VALUES('0019'),
PART 20 VALUES('0020'),
PART 21 VALUES('0021'),
PART 22 VALUES('0022'),
PART 23 VALUES('0023'),
PART 24 VALUES('0024'),
PART 25 VALUES('0025'),
PART 26 VALUES('0026'),
PART 27 VALUES('0027'),
PART 28 VALUES('0028'),
PART 29 VALUES('0029'),
PART 30 VALUES('0030'),
PART 31 VALUES('0031'),
PART 32 VALUES('0032'),
PART 33 VALUES('0033'),
PART 34 VALUES('0034'),
PART 35 VALUES('0035'),
PART 36 VALUES('0036'),
PART 37 VALUES('0037'),
PART 38 VALUES('0038'),
PART 39 VALUES('0039'),
PART 40 VALUES('0040'),
PART 41 VALUES('0041'),
PART 42 VALUES('0042'),
PART 43 VALUES('0043'),
PART 44 VALUES('0044'),
PART 45 VALUES('0045'),
PART 46 VALUES('0046'),
PART 47 VALUES('0047'),
PART 48 VALUES('0048'),
PART 49 VALUES('0049'),
PART 50 VALUES('0050'),
PART 51 VALUES('0051'),
PART 52 VALUES('0052'),
PART 53 VALUES('0053'),
PART 54 VALUES('0054'),
PART 55 VALUES('0055'),
PART 56 VALUES('0056'),
PART 57 VALUES('0057'),
PART 58 VALUES('0058'),
PART 59 VALUES('0059'),
PART 60 VALUES('0060'),
PART 61 VALUES('0061'),
PART 62 VALUES('0062'),
PART 63 VALUES('0063'),
PART 64 VALUES('0064'),
PART 65 VALUES('0065'),
PART 66 VALUES('0066'),
PART 67 VALUES('0067'),
PART 68 VALUES('0068'),
PART 69 VALUES('0069'),
PART 70 VALUES('0070'),
PART 71 VALUES('0071'),
PART 72 VALUES('0072'),
PART 73 VALUES('0073'),
PART 74 VALUES('0074'),
PART 75 VALUES('0075'),
PART 76 VALUES('0076'),
PART 77 VALUES('0077'),
PART 78 VALUES('0078'),
PART 79 VALUES('0079'),
PART 80 VALUES('0080'),
PART 81 VALUES('0081'),
PART 82 VALUES('0082'),
PART 83 VALUES('0083'),
PART 84 VALUES('0084'),
PART 85 VALUES('0085'),
PART 86 VALUES('0086'),
PART 87 VALUES('0087'),
PART 88 VALUES('0088'),
PART 89 VALUES('0089'),
PART 90 VALUES('0090'),
PART 91 VALUES('0091'),
PART 92 VALUES('0092'),
PART 93 VALUES('0093'),
PART 94 VALUES('0094'),
PART 95 VALUES('0095'),
PART 96 VALUES('0096'),
PART 97 VALUES('0097'),
PART 98 VALUES('0098'),
PART 99 VALUES('0099'),
PART 100 VALUES('0100'),
PART 101 VALUES('0101'),
PART 102 VALUES('0102'),
PART 103 VALUES('0103'),
PART 104 VALUES('0104'),
PART 105 VALUES('0105'),
PART 106 VALUES('0106'),
PART 107 VALUES('0107'),
PART 108 VALUES('0108'),
PART 109 VALUES('0109'),
PART 110 VALUES('0110'),
PART 111 VALUES('0111'),
PART 112 VALUES('0112'),
PART 113 VALUES('0113'),
PART 114 VALUES('0114'),
PART 115 VALUES('0115'),
PART 116 VALUES('0116'),
PART 117 VALUES('0117'),
PART 118 VALUES('0118'),
PART 119 VALUES('0119'),
PART 120 VALUES('0120'),
PART 121 VALUES('0121'),
PART 122 VALUES('0122'),
PART 123 VALUES('0123'),
PART 124 VALUES('0124'),
PART 125 VALUES('0125'),
PART 126 VALUES('0126'),
PART 127 VALUES('0127'),
PART 128 VALUES('0128'),
PART 129 VALUES('0129'),
PART 130 VALUES('0130'),
PART 131 VALUES('0131'),
PART 132 VALUES('0132'),
PART 133 VALUES('0133'),
PART 134 VALUES('0134'),
PART 135 VALUES('0135'),
PART 136 VALUES('0136'),
PART 137 VALUES('0137'),
PART 138 VALUES('0138'),
PART 139 VALUES('0139'),
PART 140 VALUES('0140'),
PART 141 VALUES('0141'),
PART 142 VALUES('0142'),
PART 143 VALUES('0143'),
PART 144 VALUES('0144'),
PART 145 VALUES('0145'),
PART 146 VALUES('0146'),
PART 147 VALUES('0147'),
PART 148 VALUES('0148'),
PART 149 VALUES('0149'),
PART 150 VALUES('0150'),
PART 151 VALUES('0151'),
PART 152 VALUES('0152'),
PART 153 VALUES('0153'),
PART 154 VALUES('0154'),
PART 155 VALUES('0155'),
PART 156 VALUES('0156'),
PART 157 VALUES('0157'),
PART 158 VALUES('0158'),
PART 159 VALUES('0159'),
PART 160 VALUES('0160'),
PART 161 VALUES('0161'),
PART 162 VALUES('0162'),
PART 163 VALUES('0163'),
PART 164 VALUES('0164'),
PART 165 VALUES('0165'),
PART 166 VALUES('0166'),
PART 167 VALUES('0167'),
PART 168 VALUES('0168'),
PART 169 VALUES('0169'),
PART 170 VALUES('0170'),
PART 171 VALUES('0171'),
PART 172 VALUES('0172'),
PART 173 VALUES('0173'),
PART 174 VALUES('0174'),
PART 175 VALUES('0175'),
PART 176 VALUES('0176'),
PART 177 VALUES('0177'),
PART 178 VALUES('0178'),
PART 179 VALUES('0179'),
PART 180 VALUES('0180'),
PART 181 VALUES('0181'),
PART 182 VALUES('0182'),
PART 183 VALUES('0183'),
PART 184 VALUES('0184'),
PART 185 VALUES('0185'),
PART 186 VALUES('0186'),
PART 187 VALUES('0187'),
PART 188 VALUES('0188'),
PART 189 VALUES('0189'),
PART 190 VALUES('0190'),
PART 191 VALUES('0191'),
PART 192 VALUES('0192'),
PART 193 VALUES('0193'),
PART 194 VALUES('0194'),
PART 195 VALUES('0195'),
PART 196 VALUES('0196'),
PART 197 VALUES('0197'),
PART 198 VALUES('0198'),
PART 199 VALUES('0199'),
PART 200 VALUES('0200'),
PART 201 VALUES('0201'),
PART 202 VALUES('0202'),
PART 203 VALUES('0203'),
PART 204 VALUES('0204'),
PART 205 VALUES('0205'),
PART 206 VALUES('0206'),
PART 207 VALUES('0207'),
PART 208 VALUES('0208'),
PART 209 VALUES('0209'),
PART 210 VALUES('0210'),
PART 211 VALUES('0211'),
PART 212 VALUES('0212'),
PART 213 VALUES('0213'),
PART 214 VALUES('0214'),
PART 215 VALUES('0215'),
PART 216 VALUES('0216'),
PART 217 VALUES('0217'),
PART 218 VALUES('0218'),
PART 219 VALUES('0219'),
PART 220 VALUES('0220'),
PART 221 VALUES('0221'),
PART 222 VALUES('0222'),
PART 223 VALUES('0223'),
PART 224 VALUES('0224'),
PART 225 VALUES('0225'),
PART 226 VALUES('0226'),
PART 227 VALUES('0227'),
PART 228 VALUES('0228'),
PART 229 VALUES('0229'),
PART 230 VALUES('0230'),
PART 231 VALUES('0231'),
PART 232 VALUES('0232'),
PART 233 VALUES('0233'),
PART 234 VALUES('0234'),
PART 235 VALUES('0235'),
PART 236 VALUES('0236'),
PART 237 VALUES('0237'),
PART 238 VALUES('0238'),
PART 239 VALUES('0239'),
PART 240 VALUES('0240'),
PART 241 VALUES('0241'),
PART 242 VALUES('0242'),
PART 243 VALUES('0243'),
PART 244 VALUES('0244'),
PART 245 VALUES('0245'),
PART 246 VALUES('0246'),
PART 247 VALUES('0247'),
PART 248 VALUES('0248'),
PART 249 VALUES('0249'),
PART 250 VALUES('0250'),
PART 251 VALUES('0251'),
PART 252 VALUES('0252'),
PART 253 VALUES('0253'),
PART 254 VALUES('0254'));
COMMENT ON TABLE A5407699.TXC200A1 IS 'EOS REPOSITORY:DOC CONTENT# 9';
COMMIT;
CREATE UNIQUE INDEX A5407699.IXC200A10
ON A5407699.TXC200A1
(XC200_DOC_PART_NO ASC,
XC200_UUID_DOC_B ASC,
XC200_DOC_FRMT ASC,
XC200_DOC_CONT_TYP ASC,
XC200_DOC_SEGM_SEQ ASC)
PARTITIONED
USING STOGROUP GSMS
FREEPAGE 50 PCTFREE 10
CLUSTER
(PART 1,
PART 2,
PART 3,
PART 4,
PART 5,
PART 6,
PART 7,
PART 8,
PART 9,
PART 10,
PART 11,
PART 12,
PART 13,
PART 14,
PART 15,
PART 16,
PART 17,
PART 18,
PART 19,
PART 20,
PART 21,
PART 22,
PART 23,
PART 24,
PART 25,
PART 26,
PART 27,
PART 28,
PART 29,
PART 30,
PART 31,
PART 32,
PART 33,
PART 34,
PART 35,
PART 36,
PART 37,
PART 38,
PART 39,
PART 40,
PART 41,
PART 42,
PART 43,
PART 44,
PART 45,
PART 46,
PART 47,
PART 48,
PART 49,
PART 50,
PART 51,
PART 52,
PART 53,
PART 54,
PART 55,
PART 56,
PART 57,
PART 58,
PART 59,
PART 60,
PART 61,
PART 62,
PART 63,
PART 64,
PART 65,
PART 66,
PART 67,
PART 68,
PART 69,
PART 70,
PART 71,
PART 72,
PART 73,
PART 74,
PART 75,
PART 76,
PART 77,
PART 78,
PART 79,
PART 80,
PART 81,
PART 82,
PART 83,
PART 84,
PART 85,
PART 86,
PART 87,
PART 88,
PART 89,
PART 90,
PART 91,
PART 92,
PART 93,
PART 94,
PART 95,
PART 96,
PART 97,
PART 98,
PART 99,
PART 100,
PART 101,
PART 102,
PART 103,
PART 104,
PART 105,
PART 106,
PART 107,
PART 108,
PART 109,
PART 110,
PART 111,
PART 112,
PART 113,
PART 114,
PART 115,
PART 116,
PART 117,
PART 118,
PART 119,
PART 120,
PART 121,
PART 122,
PART 123,
PART 124,
PART 125,
PART 126,
PART 127,
PART 128,
PART 129,
PART 130,
PART 131,
PART 132,
PART 133,
PART 134,
PART 135,
PART 136,
PART 137,
PART 138,
PART 139,
PART 140,
PART 141,
PART 142,
PART 143,
PART 144,
PART 145,
PART 146,
PART 147,
PART 148,
PART 149,
PART 150,
PART 151,
PART 152,
PART 153,
PART 154,
PART 155,
PART 156,
PART 157,
PART 158,
PART 159,
PART 160,
PART 161,
PART 162,
PART 163,
PART 164,
PART 165,
PART 166,
PART 167,
PART 168,
PART 169,
PART 170,
PART 171,
PART 172,
PART 173,
PART 174,
PART 175,
PART 176,
PART 177,
PART 178,
PART 179,
PART 180,
PART 181,
PART 182,
PART 183,
PART 184,
PART 185,
PART 186,
PART 187,
PART 188,
PART 189,
PART 190,
PART 191,
PART 192,
PART 193,
PART 194,
PART 195,
PART 196,
PART 197,
PART 198,
PART 199,
PART 200,
PART 201,
PART 202,
PART 203,
PART 204,
PART 205,
PART 206,
PART 207,
PART 208,
PART 209,
PART 210,
PART 211,
PART 212,
PART 213,
PART 214,
PART 215,
PART 216,
PART 217,
PART 218,
PART 219,
PART 220,
PART 221,
PART 222,
PART 223,
PART 224,
PART 225,
PART 226,
PART 227,
PART 228,
PART 229,
PART 230,
PART 231,
PART 232,
PART 233,
PART 234,
PART 235,
PART 236,
PART 237,
PART 238,
PART 239,
PART 240,
PART 241,
PART 242,
PART 243,
PART 244,
PART 245,
PART 246,
PART 247,
PART 248,
PART 249,
PART 250,
PART 251,
PART 252,
PART 253,
PART 254)
BUFFERPOOL BP1
CLOSE NO;
COMMIT;