Chapter 4: ASE Replicator Procedures

sp_helpprimaryconn

Returns information and statistics for primary database connections.

sp_helpprimaryconn [info]

sp_helpprimaryconn {info|stats} [, conn_name]

sp_helpprimaryconn {pubs|empty|unpub|arts|unsub|params}, conn_name

info: The keyword that requests information about primary database connections.

stats: The keyword that requests statistics for primary database connections.

pubs: The keyword that requests information about all publications in the specified primary database connection.

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

unpub: The keyword that requests information about all unpublished objects in the database identified by the specified primary database connection.

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

unsub: The keyword that requests information about all primary articles in the specified primary database connection, for which there are no subscribers.

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

conn_name

The name of a primary database connection. Connection names must be specified in the form ds.db, where:

sp_helpprimaryconn

Returns information about all primary database connections.

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

sp_helpprimaryconn info, "boulder.doc"

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

sp_helpprimaryconn stats, "boulder.doc"

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

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

**Table 4-13: ASE Replicator primary connection information**
Column	Datatype	Description
conn_type	varchar(3)	Type of connection: PRI – primary
ds	sysname	Name of the local primary data server
db	sysname	Name of the local primary database
maint_user	sysname	Maintenance User name in the database identified in db
lastcmt_proxy	sysname	Lastcommit proxy table name
restart_locator	varchar(64)	Identifies restart position in the database log
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 statistics information about primary connections, the following result set is returned:

**Table 4-14: ASE Replicator primary connection statistics**
Column	Datatype	Description
type	varchar(3)	Type of connection: PRI – primary
name	sysname	Name of the local primary data server and database
tstamp	datetime	Timestamp the statistic was generated
statistic	varchar(128)	Name of the statistic
value	varchar(255)	Value of the statistic

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

**Table 4-15: ASE Replicator primary 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 publications in primary connections, the following result set is returned:

**Table 4-16: ASE Replicator primary connection publications**
Column	Datatype	Description
ds	sysname	Name of the local primary data server
db	sysname	Name of the local primary database
pub_name	sysname	Publication name

When listing information about unpublished objects in a primary database, the following result set is returned:

**Table 4-17: ASE Replicator primary database unpublished objects**
Column	Datatype	Description
ds	sysname	Name of the local primary data server
db	sysname	Name of the local primary database
obj_owner	sysname	Owner of primary object
obj_name	sysname	Name of primary object
obj_type	varchar(9)	Type of primary object: table procedure

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

**Table 4-18: ASE Replicator primary articles**
Column	Datatype	Description
ds	sysname	Name of the local primary data server.
db	sysname	Name of the local primary database.
pub_name	sysname	Publication name.
owner	sysname	Owner of primary article.
part_name	sysname	Name of primary article.
proc_num	smallint	Stored procedure group number. If only one procedure exists, then proc_num=1. Tables are proc_num=0.
art_type	varchar(9)	Type of article: table procedure
numsubscribers	int	Number of replicate articles that subscribe to this primary article.
shadow_table	sysname	Name of the shadow table for this primary article.

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