--  There is no statement for index ESRJMS.SYS_C00189550.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189545.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189295.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189290.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189285.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189280.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189275.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189270.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189265.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189260.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189255.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189250.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00189245.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00188828.
--  The object is created when the parent object is created.
--  There is no statement for index ESRJMS.SYS_C00188823.
--  The object is created when the parent object is created.
DROP INDEX ESRJMS.MS9_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS9_JMSSTORE_X ON ESRJMS.MS9JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS9_JMSSTATE_X;

CREATE INDEX ESRJMS.MS9_JMSSTATE_X ON ESRJMS.MS9JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS8_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS8_JMSSTORE_X ON ESRJMS.MS8JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS8_JMSSTATE_X;

CREATE INDEX ESRJMS.MS8_JMSSTATE_X ON ESRJMS.MS8JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS7_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS7_JMSSTORE_X ON ESRJMS.MS7JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS7_JMSSTATE_X;

CREATE INDEX ESRJMS.MS7_JMSSTATE_X ON ESRJMS.MS7JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS6_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS6_JMSSTORE_X ON ESRJMS.MS6JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS6_JMSSTATE_X;

CREATE INDEX ESRJMS.MS6_JMSSTATE_X ON ESRJMS.MS6JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS5_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS5_JMSSTORE_X ON ESRJMS.MS5JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS5_JMSSTATE_X;

CREATE INDEX ESRJMS.MS5_JMSSTATE_X ON ESRJMS.MS5JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS4_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS4_JMSSTORE_X ON ESRJMS.MS4JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS4_JMSSTATE_X;

CREATE INDEX ESRJMS.MS4_JMSSTATE_X ON ESRJMS.MS4JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS3_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS3_JMSSTORE_X ON ESRJMS.MS3JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS3_JMSSTATE_X;

CREATE INDEX ESRJMS.MS3_JMSSTATE_X ON ESRJMS.MS3JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS2_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS2_JMSSTORE_X ON ESRJMS.MS2JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS2_JMSSTATE_X;

CREATE INDEX ESRJMS.MS2_JMSSTATE_X ON ESRJMS.MS2JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS1_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS1_JMSSTORE_X ON ESRJMS.MS1JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS1_JMSSTATE_X;

CREATE INDEX ESRJMS.MS1_JMSSTATE_X ON ESRJMS.MS1JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS15_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS15_JMSSTORE_X ON ESRJMS.MS15JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS15_JMSSTATE_X;

CREATE INDEX ESRJMS.MS15_JMSSTATE_X ON ESRJMS.MS15JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS14_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS14_JMSSTORE_X ON ESRJMS.MS14JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS14_JMSSTATE_X;

CREATE INDEX ESRJMS.MS14_JMSSTATE_X ON ESRJMS.MS14JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS13_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS13_JMSSTORE_X ON ESRJMS.MS13JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS13_JMSSTATE_X;

CREATE INDEX ESRJMS.MS13_JMSSTATE_X ON ESRJMS.MS13JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          4M
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS12_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS12_JMSSTORE_X ON ESRJMS.MS12JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS12_JMSSTATE_X;

CREATE INDEX ESRJMS.MS12_JMSSTATE_X ON ESRJMS.MS12JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS11_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS11_JMSSTORE_X ON ESRJMS.MS11JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS11_JMSSTATE_X;

CREATE INDEX ESRJMS.MS11_JMSSTATE_X ON ESRJMS.MS11JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS10_JMSSTORE_X;

CREATE UNIQUE INDEX ESRJMS.MS10_JMSSTORE_X ON ESRJMS.MS10JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX ESRJMS.MS10_JMSSTATE_X;

CREATE INDEX ESRJMS.MS10_JMSSTATE_X ON ESRJMS.MS10JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
