zOs/TX/PER21DD2

-- testcase tnz240 repartitionierung -------------------------
set current sqlid = 'S100447';
  CREATE INDEX $creator.iper21A1
    ON $creator.tper21A1
     (NZ240001              ASC,
      NZ240005              ASC,
      NZ240034              ASC,
      NZ240006              ASC,
      NZ240008              ASC,
      NZ240009              ASC)
    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 yes
    DEFINE YES
    PIECESIZE 2 G;
--
  CREATE INDEX $creator.iper21A2
    ON $creator.tper21A1
     (NZ240010              ASC,
      NZ240012              ASC,
      NZ240014              ASC,
      NZ240005              ASC,
      NZ240034              ASC)
    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 yes
    DEFINE YES
    PIECESIZE 2 G;
--
  CREATE INDEX $creator.iper21A3
    ON $creator.tper21A1
     (NZ240006              ASC,
      NZ240012              ASC,
      NZ240014              ASC,
      NZ240005              ASC,
      NZ240034              ASC)
    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 yes
    DEFINE YES
    PIECESIZE 2 G;
--
  CREATE INDEX $creator.iper21A4
    ON $creator.tper21A1
     (NZ240028              ASC,
      NZ240007              ASC)
    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 yes
    DEFINE YES
    PIECESIZE 4 G;
--
  CREATE INDEX $creator.iper21A5
    ON $creator.tper21A1
     (NZ240022              ASC,
      NZ240012              ASC,
      NZ240014              ASC,
      NZ240005              ASC,
      NZ240034              ASC)
    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 yes
    DEFINE YES
    PIECESIZE 2 G;
    commit;