The Sybase Replication Agent transaction log table (ra_tran_log_) contains a column that identifies when a particular operation has occurred.
The following sample queries can help identify how these tables can be used to count the number of operations not yet processed by the Replication Agent:
For an Informix database, use:
select count(*) from ra_tran_log_ where process_seq < 1
For a Microsoft SQL Server database, use:
select count(*) from ra_tran_log_ (NOLOCK) WHERE tran_id NOT IN (SELECT ra_id FROM ra_proc_seq_ (NOLOCK))
For an Oracle database, use:
SELECT COUNT(*) from RA_TRAN_LOG_ where PROCESS_SEQ < 1
