sp_helprep

Description

Returns statistics or status information about ASE Replicator, ASE Replicator objects, or ASE Replicator components.

Syntax

sp_helprep [stats [, { reset|pri_conns|rep_conns|subs|
	{pri_conn|rep_conn}=conn_name|
	sub=sub_name }]]
sp_helprep [status [, {conns|subs|
	{pri_conn|rep_conn}=conn_name|
	sub=sub_name }]] 
sp_helprep [version] 

Parameters

stats

is a keyword that requests statistics information about ASE Replicator.

status

is a keyword that requests status information about ASE Replicator. This is the default value.

version

is a keyword that requests the ASE Replicator version string.

reset

is a keyword that resets all statistics counters to zero.

pri_conns

is a keyword that requests statistics or status information for all primary database connections.

rep_conns

is a keyword that requests statistics or status information for all replicate database connections.

subs

is a keyword that requests statistics or status information for all subscriptions.

pri_conn=

is a label identifying a primary database connection to request statistics or status information for that connection.

rep_conn=

is a label identifying a replicate database connection to request statistics or status information for that connection.

conn_name

is a connection name specified in the form ds.db, where:

sub=sub_name

is a label identifying a subscription to request statistics or status information for that subscription.

Examples

Example 1

sp_helprep

Returns current status of overall replication system.

NoteUsing sp_helprep with no keyword is functionally identical to specifying only the status keyword.

Example 2

sp_helprep stats, pri_conns

Returns current statistics for all primary database connections.

Example 3

sp_helprep stats, "pri_conn=boulder.doc"

Returns current statistics for the primary database connection to the database doc on data server boulder.

Example 4

sp_helprep stats, "sub=subdoc"

Returns current statistics for the subscription subdoc.

Example 5

sp_helprep status, "sub=subdoc"

Returns current status of the subscription subdoc.

Example 6

sp_helprep version

Returns the ASE Replicator version string.

Usage

See also

sp_helpconn, sp_helpprimaryart, sp_helpprimaryconn, sp_helppub, sp_helpreplicateart, sp_helpreplicateconn, sp_helpsub