Table 3-2 lists the ASE Replicator procedures you can use to monitor and get information about ASE Replicator components and objects.
Procedure |
Description |
|---|---|
sp_helpconn |
Returns information about database connections |
sp_helplastcommit |
Returns the timestamp and locator value of the most recent transaction committed in the replicate database |
sp_helplocator |
Returns fields in the specified locator string |
sp_helpprimaryart |
Returns information about primary articles |
sp_helpprimaryconn |
Returns information about primary database connections |
sp_helppub |
Returns information about publications |
sp_helprep |
Returns statistics or status information for the replication system, subscriptions, and database connections |
sp_helpreplicateart |
Returns information about replicate articles |
sp_helpreplicateconn |
Returns information about replicate database connections |
sp_helpsub |
Returns information about subscriptions |
For information about connections, see “Getting information about database connections” and “Getting connection configuration information”.
For information about subscriptions, see “Getting information about publications and subscriptions”.
For information about articles, see “Getting information about primary articles” and “Getting information about replicate articles”.
