zOs/SQL/ELCOMA2
SET CURRENT SQLID='S100447';
--
CREATE INDEX OA1P.iElKs835A10c4
ON OA1P.telks835c4
(KS835030 ASC,
KS835040 ASC,
KS835010 ASC,
KS835080 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
--
CREATE INDEX OA1P.iElKs835A4c4
ON OA1P.telks835c4
(KS835020 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 8 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER YES
DEFINE YES;
--
COMMIT;
--
CREATE INDEX OA1P.iElKs835A9TEMPc4
ON OA1P.telks835c4
(KS835070 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 8 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
CREATE INDEX OA1P.iElKs838A2c4
ON OA1P.telks838c4
(KS838080 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 8 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER YES
DEFINE YES;
--
COMMIT;
--
CREATE INDEX OA1P.iElKs846A4c4
ON OA1P.telks846c4
(KS846006 ASC,
KS846003 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 2 PCTFREE 50
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER YES
DEFINE YES;
--
COMMIT;
--