zOs/SQL/DGMK

set current sqlid = 'S100447';
drop index         OA1P.IDG122A2;
-- I - OA1P.TDG210A0         OA1P.IDG210A1
-- I - OA1P.TDG210A0         OA1P.IDG210A2
-- D - OA1P.TDG210A0         OA1P.IDG210A1
rename index       OA1P.IDG210A1 to      IDG210A2;
CREATE  INDEX OA1P.IDG210A1 ON OA1P.TDG210A0
        ( DG21001J ASC
        , DG21001I ASC
        , DG21001B ASC
        , DG21001S ASC
        , DG21001P ASC
        , DG21001G ASC
        , DG21001L ASC
        , DG21002 ASC
        , DG21003 ASC
          )
           DEFINE YES
        USING STOGROUP GSMS
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP1
           CLOSE YES
           DEFER YES
           PIECESIZE 2G
    ;

-- I - OA1P.TDG310A0         OA1P.IDG310A3
-- I - OA1P.TDG310A0         OA1P.IDG310A4
-- D - OA1P.TDG310A0         OA1P.IDG310A3
rename index       OA1P.IDG310A3 to      IDG310A4;
CREATE  INDEX OA1P.IDG310A3 ON OA1P.TDG310A0
        ( DG31001Y ASC
        , DG31027 ASC
          )
           DEFINE NO
        USING STOGROUP GSMS
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP1
           CLOSE YES
           DEFER YES
           PIECESIZE 2G
    ;
rollback
;