analytics/informix/bin/hdrmkpri.bat

@echo off
REM : '
REM : ************************************************************************
REM :
REM :   Licensed Material - Property Of IBM
REM :
REM :   "Restricted Materials of IBM"
REM :
REM :   IBM Informix Dynamic Server
REM :   (c) Copyright IBM Corporation 1996, 2008 All rights reserved.
REM :
REM :   Title      : hdrmkpri.bat
REM :   Description: This script changes the type of the Data replication
REM :                server to Primary.
REM :                This script must be run with appropriate DBA privileges.
REM :
REM : ************************************************************************
REM : '     

SET WINROOT=%SystemRoot%
IF "x%WINROOT%" == "x" SET WINROOT=C:\WINNT

SET IBIN=%INFORMIXDIR%\bin
SET ONSTAT=%IBIN%\onstat
SET ONMODE=%IBIN%\onmode

echo.
echo This script changes the type of the Data replication server to Primary,
echo and must be run with appropriate Database Administrator privileges.
echo. 
echo Steps to switch server types in an HDR pair:
echo. 
echo   Instance A (currently Primary)          Instance B (currently Secondary)
echo   ------------------------------          --------------------------------
echo   1] onmode -ky                              (server should be up)
echo                                           2] hdrmkpri.bat {primary_server_name}
echo   3] hdrmksec.bat {secondary_server_name}
echo                                           4] starts %%INFORMIXSERVER%% 
echo      (now a Secondary server)                (now a Primary server)

REM # Check usage
if not "%1" == "" goto USAGE_CORRECT
    echo.
    echo Usage: %0 {paired server name}
    echo.
    exit 1

: USAGE_CORRECT

SET PAIRED_SERVER=%1

echo.
echo WARNING: Please ensure the following before proceeding further:
echo.
echo            1] the paired  database server is OFFLINE,
echo            2] the current database server is up, and
echo            3] the current database server has Data replication turned OFF.
echo.
echo          Not doing so, shall make the two database servers in the
echo          Data replication pair out-of-sync, and shall require
echo          re-establishing the pair.
echo.

PAUSE

echo.
echo Changing to Standard type via:
echo 	onmode -d standard
onmode -d standard

sleep 2

echo.
echo Changing to Primary type via: (could take a couple of minutes)
echo 	onmode -d primary %PAIRED_SERVER%
onmode -d primary %PAIRED_SERVER%

sleep 2

echo.
echo Shutting down the database server via:
echo 	onmode -ky
echo.
echo NOTE: Shutting down the database server now is MANDATORY, because
echo       if the two database servers in a Data replication pair
echo       are brought up as Primary/Standard type OR,
echo       if one database server is up and the mode of the paired server
echo       is changed, then the database servers in the pair could
echo       become out-of-sync, leading to establishing the pair again.
onmode -ky

echo.
echo Run %%INFORMIXDIR%%\bin\hdrmksec.bat on the paired server.
echo After the run OR if it has already been run, then WITHOUT bringing the
echo paired (now Secondary) server down, start the current (now Primary)
echo database server, to make the Data replication pair operational.
echo.