zOs/SQL/TXBH111X

  SET CURRENT SQLID='S100447';
  CREATE INDEX BUA.IXBH1111_L
    ON BUA.TXBH111
     (EAUUIDMQ ASC, EAUUIDHT ASC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
  COMMIT;
  CREATE INDEX BUA.IXBH1113_L
    ON BUA.TXBH111
     (ESSTATE ASC, ESTYPE ASC, EZCOUNT ASC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
  COMMIT;
  CREATE INDEX BUA.IXBH1112_L
    ON BUA.TXBH111
     (EATABNAM              ASC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
  COMMIT;