Chapter 4: ASE Replicator Procedures

sp_helpreplicateconn

Returns information and statistics for replicate database connections.

sp_helpreplicateconn [info [, conn_name]]

sp_helpreplicateconn {subs|empty|arts|params}, conn_name

info: The keyword that requests information for replicate database connections.

subs: The keyword that requests information about all subscriptions in the specified replicate database connection.

empty: The keyword that requests information about all empty subscriptions (subscriptions with no articles) in the specified replicate database connection.

arts: The keyword that requests information about all replicate articles in all subscriptions in the specified replicate database connection.

params: The keyword that requests information about all configuration parameters for the specified replicate database connection.

conn_name

The name of a replicate database connection. The connection name (conn_name) must be specified in the form ds.db, where:

sp_helpreplicateconn

Returns information about all replicate database connections.

Using sp_helpreplicateconn with no keyword is functionally identical to specifying only the info keyword.

sp_helpreplicateconn info, "boulder.doc"

Returns information about the replicate connection to the database doc on the data server boulder.

sp_helpreplicateconn subs, "boulder.doc"

Returns information about all subscriptions in the replicate connection to the database doc on the data server boulder.

When listing information about replicate connections, the following result set is returned:

**Table 4-27: ASE Replicator replicate connection information**
Column	Datatype	Description
conn_type	varchar(3)	Type of connection: REP – replicate
ds	sysname	Name of the replicate data server
db	sysname	Name of the replicate database
maint_user	sysname	Maintenance User name in the database identified in db
lastcmt_proxy	sysname	Lastcommit proxy table name
restart_locator	varchar(64)	Restart position in the stable queue
timestamp	datetime	Timestamp of the restart locator
status	smallint	Status of the connection: 1 – up 0 – down -1 – error
status_desc	varchar(255)	Description of the connection status

When listing parameter information about replicate connections, the following result set is returned:

**Table 4-28: ASE Replicator replicate connection configuration**
Column	Datatype	Description
parameter_name	varchar(128)	Name of the configuration parameter
default_value	varchar(255)	Default value of the parameter
legal_values	varchar(255)	Legal values of the parameter
description	varchar(255)	Description of the parameter

When listing information about subscriptions in replicate connections, the following result set is returned:

**Table 4-29: ASE Replicator replicate connection subscriptions**
Column	Datatype	Description
ds	sysname	Name of the replicate data server
db	sysname	Name of the replicate database
sub_name	sysname	Subscription name
status	smallint	Status of the subscription
status_desc	varchar(255)	Description of the subscription status
pub_name	sysname	Publication name

When listing information about replicate articles in a replicate database connection, the following result set is returned:

**Table 4-30: ASE Replicator replicate articles**
Column	Datatype	Description
ds	sysname	Name of the replicate data server.
db	sysname	Name of the replicate database.
sub_name	sysname	Subscription name.
rart_owner	sysname	Owner of replicate article.
rart_name	sysname	Name of replicate article.
rart_proc_num	smallint	Stored procedure group number for replicate article. If only one procedure exists, then proc_num=1. Tables are proc_num=0.
art_type	varchar(9)	Type of replicate article: table procedure
proxy_table	sysname	If replicate article is a table, name of the proxy table. Otherwise, null.
dist_proc	sysname	Name of distribution stored procedure for the replicate article.
valid_pt	varchar(64)	Validation point (locator) that identifies where transactions for the replicate article begin in the database log.
where_clause	varchar(255) or varchar(1837)	Condition for selecting a subset of data rows to replicate. (Datatype size depends on Adaptive Server version.)
pub_name	sysname	Publication name.
part_owner	sysname	Owner of primary article.
part_name	sysname	Name of primary article.
part_proc_num	smallint	Stored procedure group number for primary article. If only one procedure exists, then proc_num=1. Tables are proc_num=0.

When sp_helpreplicateconn is invoked with no keyword, it returns information about all replicate connections.
When you invoke sp_helpreplicateconn with no connection name (conn_name) specified, it returns information about all replicate database connections.
When you invoke sp_helpreplicateconn and specify the info keyword, the replicate database connection name (conn_name) is optional.
When you invoke sp_helpreplicateconn and specify the subs, empty, arts, or params keyword, the replicate database connection name (conn_name) is required.
To get information about all primary and replicate connections, use sp_helpconn.
To get information about primary connections only, use sp_helpprimaryconn.
To get statistics information about replicate connections, use sp_helprep stats.
When an error occurs, an error message is returned.