Always On

Configuring Control-M/EM Always On

This procedure describes how to configure Control-M/EM with MSSQL Always On data replication.

The DBUbuild and Cold restore utilities are not supported in Always On mode.

Begin

  1. Install or upgrade Control-M/EM on a machine using the primary node of the Always On database cluster, as described in Installing Control-M/EM on Windows.

  2. Shut down Control-M/EM.

  3. Send a request to the site DBA to load the standalone database into the Availability Group.

    The database is now accessed by the global listener.

  4. Send a request to the site DBA to grant VIEW SERVER STATE permissions the new login.

  5. Verify that the site DBA sends you the Always On listener name and port number.

  6. Navigate to the following directory:

    <EM_Home>\bin\DBUtils\DBUData\scripts

  7. Configure Always On by running the following commands:

    • always_on_config set mode=y

    • always_on_config set server=<AlwaysOn listener name{,port}>

  8. Run the restore_host_config utility, as described in Reconfiguring the Database Server Connection Data.

    Control-M/EM is now working in Always On mode.

  9. Verify Always On connectivity, by running the following command:

    <EM_Home>\bin\DBUData\scripts\always_on_config list pass=<Control-M/EM password>

Configuring Control-M/Server with MSSQL Always On

This procedure describes how to configure Control-M/Server with MSSQL Always On data replication.

The DBUbuild and Cold restore utilities are not supported in Always On mode.

Begin

  1. Install or upgrade Control-M/Server on a machine using the primary node of the Always On database cluster, as described in Installing Control-M/Server on Windows.

  2. Shut down Control-M/Server.

  3. Send a request to the site DBA to load the standalone database into the Availability Group.

    The database is now accessed by the global listener.

  4. Send a request to the site DBA to grant VIEW SERVER STATE permissions the new login.

  5. Verify that the site DBA sends you the Always On listener name and port number.

  6. Run the following commands:

    • always_on_config set mode=Y

    • always_on_config set server=<listenername{,port}>

    The password for the database login remains the same.

  7. Start up Control-M/Server.

    Control-M/Server is now working in Always On mode.

  8. Verify Always On connectivity, by running the following command:

    <Control-M/Server_Home>\bin\DBUData\scriptsalways_on_config list pass=<Control-M/Server password>