get truncation

The get truncation command returns a 36-byte binary value called the origin queue ID. The format of the origin queue ID is described in the next section.

RepAgent uses the origin queue ID to:

The data server log must be truncated periodically to make room for more log records. RepAgent uses the origin queue ID to update the truncation point and to allow the data server to truncate the log records already received by Replication Server.

Use this syntax for the get truncation command:

get truncation data_server.database

where data_server and database identify the database whose log is being forwarded by the Replication Agent.

Replication Server returns a single row with one 36-byte column that contains the origin queue ID of the last command saved in its inbound queue. The first 32 bytes of the ID are generated by the Replication Agent. The last 4 bytes are appended by Replication Server for its own use and are ignored by the Replication Agent.