zOs/SQL/RUSCHIX
SET CURRENT SQLID = 'S100447';
CREATE UNIQUE INDEX OA1A.ISV132B0
ON OA1A.TSV132B1
( SV13201T ASC ,
SV13201N ASC ,
SV13201B ASC ,
SV13201I ASC ,
SV13201E ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B1
ON OA1A.TSV132B1
( SV13214 ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B2
ON OA1A.TSV132B1
( SV13216 ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B3
ON OA1A.TSV132B1
( SV13211 ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B4
ON OA1A.TSV132B1
( SV13201B ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B5
ON OA1A.TSV132B1
( SV13201I ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B6
ON OA1A.TSV132B1
( SV13201E ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;
CREATE INDEX OA1A.ISV132B7
ON OA1A.TSV132B1
( SV13213 ASC )
USING STOGROUP GSMS
PRIQTY 48
SECQTY 7200
ERASE NO
FREEPAGE 10
PCTFREE 10
GBPCACHE CHANGED
BUFFERPOOL BP1
CLOSE YES
PIECESIZE 2 G
COPY NO
;