Resetting the Truncation Point in the ERSSD Transaction Log

You can only reset the truncation point if the Replication Agent for an SAP SQL Anywhere is running and there are existing routes.

ERSSD is an SAP SQL Anywhere database and you must execute the dblog, dbsrv, and dbstop SQL Anywhere commands at the system prompt. See the SAP SQL Anywhere documentation for the command syntax and to set the environment for the commands. SAP SQL Anywhere 16 is the current ERSSD used in Replication Server.

Warning! Only reset the secondary truncation point if the Replication Agent for SQL Anywhere Log Transfer Manager (LTM) is running and there are existing routes. Resetting removes the current secondary truncation point and moves the point to the most newly created spot in the database transaction log.

Shut down Replication Server using shut down.
Reset the ERSSD database log at a system prompt:
```
dblog -il <fully_qualified_directory>erssd_name.db
```
Use dblog -il <fully_qualified_directory>erssd_name.db to reset the Log Transfer Manager log offset that is kept for the SQL Anywhere delete_old_logs option, allowing transactions from the transaction log to be deleted when the transactions are not required. The dblog -il <fully_qualified_directory>erssd_name.db command performs on SAP SQL Anywhere databases, such as ERSSD, the same function that dbcc settrunc( 'ltm', 'ignore' ) performs on Adaptive Server databases.
Move the current database log file from the translog directory in Replication Server to another location.
Retain the current log file for a few days in case you encounter problems with the new log file.

Start a new database log file.

For example, in UNIX enter:

dblog -t $SYBASE/REP_15-5/ASA16/translog/erssd_name.log $SYBASE/REP_15-5/ASA16/dbfile/errsd_name.db

Start the ERSSD database server at the system prompt:

ERSSD start command: /sybase/REP-15_5/ASA16/bin/dbspawn
-f -q /sybase/REP-15_5/ASA16/bin/dbsrv16
-s none -ti 0 -x "tcpip(PORT=15501;DOBROAD=NO;BLISTENER=NO)"
-o /sybase/REP-15_5/errorlog/rs157_prs_ERSSD.out
/sybase/REP-15_5/dbfile/rs157_prs_ERSSD.db

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.

Stop the ERSSD database at the system prompt:

dbstop -c
“eng=erssd_name;uid=primary_user_name;
pwd=primary_user_password”

Start Replication Server.