Resetting the Database Transaction Log for ERSSD

If Replication Agent is running and there are existing routes, you can reset the database transaction log for the ERSSD after you recover from media failure on the log.

ERSSD is an SQL Anywhere database and you must execute the dblog, dbeng11, and dbstop SQL Anywhere commands at the system prompt in this procedure. See the SQL Anywhere documentation.

  1. Shut down Replication Server using shut down.
  2. Reset the ERSSD database log at a system prompt:
    dblog -il erssd_name.db
  3. Start the ERSSD database server at the system prompt:
    dbeng11 erssd_name.db
  4. Reset the ERSSD database locator value to 0:
    1. Start isql.
    2. Execute rs_zeroltm on the ERSSD database:
      rs_zeroltm erssd_name, erssd_name
    3. Exit isql.
  5. Stop the ERSSD database at the system prompt:
    dbstop -c
    “eng=erssd_name;uid=primary_user_name;
    pwd=primary_user_password
  6. Start Replication Server.
Related tasks
Starting Replication Server
Stopping a Replication Server Using isql