For monitoring a sybase disaster recovery site I am trying to get the
following information from the sybase server:
1. Last DUMPED transaction id and its timestamp from an online
database.
2. Latest APPLIED transaction id and its timestamp on a
database in "online for standby access" state.
Here, the second database is receiving transaction log files that were
dumped from the first database server. To provide an example, assume
someone did "dump transaction <dbname> to 'filename'" two days ago.
Today I would like to run a query on the sybase data or backup server
to obtain the last dumped transaction id and its timestamp (and not
the time of issue of the "dump transaction" command).
I have checked the system tables and some dbcc commands but did not
get this info. Is there a way to get the above data?
