**********************************************************************
*
* 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            *
*-********************************************************************
*-*                                                                  *
*-*  DO NOT CHANGE ALIAS NAMES                                       *
*-*                                                                  *
*-********************************************************************
*
-AUTH 000100 &DVAUTHP
*
-SQL  000200 CREATE ALIAS ARM121.BMC_BMCUTIL
                    FOR BMCUTIL.CMN_BMCUTIL
-SQL  000300 CREATE ALIAS ARM121.BMC_BMCSYNC
                    FOR BMCUTIL.CMN_BMCSYNC
-SQL  000400 CREATE ALIAS ARM121.BMC_BMCXCOPY
                    FOR BMCUTIL.CMN_BMCXCOPY
-SQL  000600 CREATE ALIAS ARM121.BMCSCC_OBJSETS
                    FOR BMCUTIL.CMN_OS
-SQL  000700 CREATE ALIAS ARM121.BMCSCC_OBJSET_DEF
                    FOR BMCUTIL.CMN_OS_DEF
-SQL  000800 CREATE ALIAS ARM121.BMCSCC_OBJSET_SQL
                    FOR BMCUTIL.CMN_OS_SQL
-SQL  000900 CREATE ALIAS ARM121.BMCSCC_GRPOPTS
                    FOR BMCUTIL.CMN_OS_OPTS
-SQL  001000 CREATE ALIAS ARM121.BMCSCC_PRODREG
                    FOR BMCUTIL.CMN_OS_PREG
-SQL  001100 CREATE ALIAS ARM121.BMCSCC_GROUPAUTH
                    FOR BMCUTIL.CMN_OS_GAUTH
-SQL  002100 CREATE ALIAS ARM121.BMCARM_CRRDRPT
                    FOR BMCARM.ARM_CRRDRPT
*
*---------------------------------------------------------------------
*-  CREATE THE ALIASES FOR THE RECOVERY ESTIMATION TABLES
*-  FOR RECOVERY MANAGER USAGE
*---------------------------------------------------------------------
*
-SQL  002200 CREATE ALIAS ARM121.BMCARM_UTILITY_RUN
                    FOR BMCARM.BMCRMD_UTIL_RUN
-SQL  002300 CREATE ALIAS ARM121.BMCARM_JOB
                    FOR BMCARM.BMCRMD_JOB
-SQL  002400 CREATE ALIAS ARM121.BMCARM_PHASE
                    FOR BMCARM.BMCRMD_PHASE
-SQL  002500 CREATE ALIAS ARM121.BMCARM_TS
                    FOR BMCARM.BMCRMD_TS
-SQL  002600 CREATE ALIAS ARM121.BMCARM_TS_PART
                    FOR BMCARM.BMCRMD_TS_PART
-SQL  002700 CREATE ALIAS ARM121.BMCARM_KEYSORT
                    FOR BMCARM.BMCRMD_KEYSORT
-SQL  002800 CREATE ALIAS ARM121.BMCARM_TSP_SORT
                    FOR BMCARM.BMCRMD_TSP_SORT
-SQL  002900 CREATE ALIAS ARM121.BMCARM_IX_PART
                    FOR BMCARM.BMCRMD_IX_PART
-SQL  003000 CREATE ALIAS ARM121.BMCARM_IXP_SORT
                    FOR BMCARM.BMCRMD_IXP_SORT
-SQL  003100 CREATE ALIAS ARM121.BMCARM_JOB_RESTART
                    FOR BMCARM.BMCRMD_JOB_RESTART
-SQL  003200 CREATE ALIAS ARM121.BMCARM_RECOVERY_EXCEPTIONS
                    FOR BMCARM.BMCRMD_RECOVERY_EXCEPTIONS
*
*
-SQL  003210 CREATE ALIAS ARM121.BMCARM_TRANSACT
                    FOR BMCUTIL.CMN_BMCTRANS
*
*-------------------------------------------------------------------
*-  CREATE THE ALIASES FOR THE CHANGE ACCUM REPOSITORY TABLES
*-------------------------------------------------------------------
*
-SQL  003220 CREATE ALIAS ARM121.BMCARM_CAFILE
                    FOR BMCACA.AFR_CAFILE
-SQL  003300 CREATE ALIAS ARM121.BMCARM_CAFILECP
                    FOR BMCACA.AFR_CAFILECP
-SQL  003400 CREATE ALIAS ARM121.BMCARM_CALGRNG
                    FOR BMCACA.AFR_CALGRNG
*---------------------------------------------------------------------
*-  BMC COMMON STATS ALIASES FOR RECOVERY MANAGER
*---------------------------------------------------------------------
*
*-SQL  003410 CREATE ALIAS ARM121.BMCARM_BMCXTBPT
*                    FOR .RS_TABLEPART
*-SQL  003420 CREATE ALIAS ARM121.BMCARM_BMCXTBLS
*                    FOR .RS_TABLES
*-SQL  003430 CREATE ALIAS ARM121.BMCARM_BMCXTBSP
*                    FOR .RS_TABLESPACE
*-SQL  003500 CREATE ALIAS ARM121.BMCARM_BMCXIXPT
*                    FOR .RS_INDEXPART
*-SQL  003600 CREATE ALIAS ARM121.BMCARM_BMCXINDX
*                    FOR .RS_INDEXES
*
*---------------------------------------------------------------------
*-  CREATE THE ALIASES FOR THE RECOVERY ESTIMATION TABLES
*-  FOR NGT RECOVER USAGE
*---------------------------------------------------------------------
*
-SQL  003800 CREATE ALIAS AFR121.BMCAFR_UTILITY_RUN
                    FOR BMCARM.BMCRMD_UTIL_RUN
-SQL  003900 CREATE ALIAS AFR121.BMCAFR_JOB
                    FOR BMCARM.BMCRMD_JOB
-SQL  004000 CREATE ALIAS AFR121.BMCAFR_PHASE
                    FOR BMCARM.BMCRMD_PHASE
-SQL  004100 CREATE ALIAS AFR121.BMCAFR_TS
                    FOR BMCARM.BMCRMD_TS
-SQL  004200 CREATE ALIAS AFR121.BMCAFR_TS_PART
                    FOR BMCARM.BMCRMD_TS_PART
-SQL  004300 CREATE ALIAS AFR121.BMCAFR_KEYSORT
                    FOR BMCARM.BMCRMD_KEYSORT
-SQL  004400 CREATE ALIAS AFR121.BMCAFR_TSP_SORT
                    FOR BMCARM.BMCRMD_TSP_SORT
-SQL  004500 CREATE ALIAS AFR121.BMCAFR_IX_PART
                    FOR BMCARM.BMCRMD_IX_PART
-SQL  004600 CREATE ALIAS AFR121.BMCAFR_IXP_SORT
                    FOR BMCARM.BMCRMD_IXP_SORT
*
*---------------------------------------------------------------------
*
*---------------------------------------------------------------------
*-  RETURN SQLID BACK TO PREVIOUS
*---------------------------------------------------------------------
*
-SETS 009900 SET CURRENT SQLID = USER
*