Subsequent initialization

Use the following procedure only if you have already initialized the primary data server, as described in “First-time initialization”, and you want to create another Replication Agent instance. This procedure creates and initializes only the Replication Agent instance, not the primary data server.

StepsCreating and initializing a Replication Agent instance

  1. Execute the resource file to create the Replication Agent instance.

    1. After the resource file has been validated as described in “Configuring and validating the Replication Agent resource file”, use the ra_admin utility to create the Replication Agent instance using the -r parameter, for example:

      %SYBASE%\RAX-15_2\bin\ra_admin -r myra.rs
      

      Execution results are returned as one of the following:

      • Response-file processing completed

      • Response-file processing completed with errors

      See the Replication Agent Administration Guide.

  2. If your resource file set initialize_instance to no, start the Replication Agent instance.

    1. Change to the directory containing your Replication Agent instance RUN file, for example:

    2. To start the Replication Agent instance, execute the RUN file, for example:

      RUN_myra
      
  3. Use the dsedit utility to update the Replication Server sql.ini file with the Replication Agent location, and verify the connection to the Replication Agent.

    1. Open a command window in the SYBASE directory of your Replication Agent installation.

    2. Set the environment variables by executing the SYBASE.bat file.

    3. Log in to Replication Agent:

      isql -Usa -P -Smyra
      

      Here, myra is the name of Replication Agent.

  4. If your resource file set initialize_instance to no, open a new command window, log in to the Replication Agent instance, and initialize the Replication Agent instance and the primary Microsoft SQL Server database using the following Replication Agent command:

    pdb_xlog init
    

Your Replication Agent instance is now running and has been initialized. Continue with “Verifying the Replication Agent replicating state”.