zOs/SQL/WM005PRO

  SET CURRENT SQLID='S100447';
--
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005A2 On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005A2
    ON gdb0153.TWM005A1
     (NCIF                  ASC,
      NDEP                  ASC,
      CKAT                  ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005A5 On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005A5
    ON gdb0153.TWM005A1
     (NDEP                  ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005A7 On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005A7
    ON gdb0153.TWM005A1
     (CKAT                  ASC,
      NKTO                  ASC,
      CSTAT                 ASC,
      CDEFAULT              ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005A8 On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005A8
    ON gdb0153.TWM005A1
     (NVALOR                ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005AA On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005AA
    ON gdb0153.TWM005A1
     (NBU                   ASC,
      CKAT                  ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005AC On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005AC
    ON gdb0153.TWM005A1
     (CGA                   ASC,
      CGAPH                 ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005AE On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005AE
    ON gdb0153.TWM005A1
     (CTYP                  ASC,
      TWMD1                 ASC,
      TWMD2                 ASC,
      TWMD3                 ASC,
      TWMD4                 ASC,
      TWMD5                 ASC,
      TWMD6                 ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005AF On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005AF
    ON gdb0153.TWM005A1
     (TWMD1                 ASC,
      CGA                   ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
--    Index=gdb0153.IWM005AG On gdb0153.TWM005A1
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005AG
    ON gdb0153.TWM005A1
     (TWMD2                 ASC,
      TWMD3                 ASC,
      TWMD4                 ASC,
      TWMD5                 ASC,
      CTYP                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
sdf;
------------------------------------------------------------------------
  drop INDEX gdb0153.IWM005AQ ;
  drop INDEX gdb0153.IWM005AE ;
  drop INDEX gdb0153.IWM005AA ;
  drop INDEX gdb0153.IWM005AC ;
  drop INDEX gdb0153.IWM005AF ;
  drop INDEX gdb0153.IWM005AG ;
  drop INDEX gdb0153.IWM005A5 ;
  drop INDEX gdb0153.IWM005A8 ;
  drop INDEX gdb0153.IWM005A2 ;
  drop INDEX gdb0153.IWM005A7 ;
  commit;
------------------------------------------------------------------------
--
  CREATE INDEX gdb0153.IWM005AQ
    ON gdb0153.TWM005A1
     (CTYP                  ASC,
      NKTO                  ASC,
      NCIF2                  ASC,
      D$GUEB                DESC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    defer no
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;