**********************************************************************
*
* RECOVERY MANAGER
* VERSION 12.1
* December 2016
*
*-********************************************************************
*-*           T A I L O R I N G   I N S T R U C T I O N S            *
*-********************************************************************
*-*                                                                  *
*-*                                                                  *
*-* NOTES: DO NOT CHANGE ANY CLOSE RULES WITHOUT CONSULTING BMC      *
*-*               SOFTWARE, INC.                                     *
*-*                                                                  *
*-********************************************************************
*
-AUTH 001000 &DVAUTHP
*
*---------------------------------------------------------------------
*- DEFINE DATABASE
*---------------------------------------------------------------------
*
-SQL  002000 CREATE DATABASE BMCARM
                    STOGROUP SYSDEFLT
                    BUFFERPOOL BP0
                    INDEXBP BP0
                    CCSID EBCDIC
*
-SQL  003000 CREATE TABLESPACE BMCARMCR
                     SEGSIZE 64
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
*
*---------------------------------------------------------------------
*- CREATE ESTIMATION TABLESPACES
*---------------------------------------------------------------------
*
-SQL  003100 CREATE TABLESPACE BMCESTUR
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003110 CREATE TABLESPACE BMCESTJB
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003120 CREATE TABLESPACE BMCESTPH
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003130 CREATE TABLESPACE BMCESTTS
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003140 CREATE TABLESPACE BMCESTTP
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003150 CREATE TABLESPACE BMCESTKY
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003160 CREATE TABLESPACE BMCESTTR
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003170 CREATE TABLESPACE BMCESTIP
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
-SQL  003180 CREATE TABLESPACE BMCESTIS
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
*---------------------------------------------------------------------
*- CREATE JOB RESTART TABLESPACE
*---------------------------------------------------------------------
-SQL  003200 CREATE TABLESPACE BMCJOBRS
                     IN BMCARM
                     USING STOGROUP SYSDEFLT
                     PRIQTY -1
                     SECQTY -1
                     LOCKSIZE ROW
                     SEGSIZE 4
                     BUFFERPOOL BP0
                     MAXPARTITIONS 5
                     CLOSE NO
*
*---------------------------------------------------------------------
*- CREATE REPOSITORY TABLESPACE
*---------------------------------------------------------------------
-SQL  003310 CREATE TABLESPACE BMCRECEX
                    IN BMCARM
                    USING STOGROUP SYSDEFLT
                    PRIQTY -1
                    SECQTY -1
                    BUFFERPOOL BP0
                    MAXPARTITIONS 5
                    CLOSE NO
                    DEFINE NO