**********************************************************************
* RECOVERY MANAGER for DB2
* VERSION 12.1
* December 2016
* CREATE INDEXES
**********************************************************************
-AUTH 001000 &DVAUTHP
*
*---------------------------------------------------------------------
*- DEFINE RECOVERY MANAGER REPOSITORY INDEXES
*---------------------------------------------------------------------
*
*
-SQL  002700 CREATE
             UNIQUE INDEX BMCARM.CRX1
                       ON BMCARM.ARM_CRRDRPT
                       (MEMBER, CRRDR_POINT)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 12
                     SECQTY 1200
             BUFFERPOOL BP0
                     CLOSE NO
*
*
*---------------------------------------------------------------------
*- DEFINE RECOVERY MANAGER INDEXES FOR ESTIMATION TABLES
*---------------------------------------------------------------------
*
-SQL  002800 CREATE UNIQUE INDEX BMCARM.UTLRUNX
                       ON BMCARM.BMCRMD_UTIL_RUN
                       (UTILITY_RUN_ID)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  002900 CREATE INDEX BMCARM.PHASEX
                       ON BMCARM.BMCRMD_PHASE
                       (JOB_ID, STEPNAME, PHASENO)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003000 CREATE INDEX BMCARM.TSX
                       ON BMCARM.BMCRMD_TS
                       (JOB_ID, DBNAME, TSNAME)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003100 CREATE INDEX BMCARM.TSPARTX
                       ON BMCARM.BMCRMD_TS_PART
                       (JOB_ID, DBNAME, TSNAME, DSNUM)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003200 CREATE INDEX BMCARM.KEYSORTX
                       ON BMCARM.BMCRMD_KEYSORT
                       (JOB_ID, DBNAME, TSNAME, SORTID)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003300 CREATE INDEX BMCARM.TSPSORTX
                       ON BMCARM.BMCRMD_TSP_SORT
                       (JOB_ID, DBNAME, TSNAME, DSNUM, SORTID)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003400 CREATE INDEX BMCARM.IXPARTX
                       ON BMCARM.BMCRMD_IX_PART
                       (JOB_ID, DBNAME, TSNAME, IXSPNAME, PART)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003500 CREATE INDEX BMCARM.IXPSORTX
                       ON BMCARM.BMCRMD_IXP_SORT
                       (JOB_ID, DBNAME, TSNAME, IXSPNAME, PART, SORTID)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
*
-SQL  003600 CREATE UNIQUE INDEX BMCARM.JOBX
                       ON BMCARM.BMCRMD_JOB
                       (JOB_ID)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 150
                     SECQTY 150
             BUFFERPOOL BP0
                     CLOSE NO
*
*
-SQL  003700 CREATE UNIQUE INDEX BMCARM.JOBR
                   ON BMCARM.BMCRMD_JOB_RESTART
                  (IDENTIFIER, JOBNAME, STEPNAME, STATUS, EVENT)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 48
                     SECQTY 48
             BUFFERPOOL BP0
                     CLOSE NO
*
-SQL  003800 CREATE INDEX BMCARM.RECEX
                   ON BMCARM.BMCRMD_RECOVERY_EXCEPTIONS
                   (OSNAME,RECOVERY_POINT)
                     USING STOGROUP &DVD2STOG
                     PRIQTY 10
                     SECQTY 100
             BUFFERPOOL BP0
                     CLOSE NO
                     DEFINE NO