Chapter 4: ASE Replicator Procedures

sp_helplastcommit

Description

Returns information about the most recent transaction committed in the replicate database for the article specified.

Syntax

sp_helplastcommit rep_art, {conn=conn_name|sub=sub_name}

Parameters

rep_art: The name of a replicate article. Replicate article names can be specified in the form owner.name.

conn=conn_name

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

ds is the name of the data server on which the database resides.
db is the name of the database.

sub=sub_name: The label identifying a subscription.

Examples

Example 1

sp_helplastcommit table1, "sub=subdoc"

Returns the timestamp and locator value of the most recent transaction committed for the replicate article table1 in the subscription subdoc. Also returns the validation point for the replicate article table1.

Usage

When listing information from the rl_lastcommit table, the following result set is returned:

**Table 4-9: ASE Replicator rl_lastcommit information**
Column	Datatype	Description
timestamp	datetime	Timestamp of the locator value
locator	varchar(64)	Locator value
validation_pt	varchar(64)	Validation point for the specified replicate article

sp_helplastcommit is for use primarily during troubleshooting procedures.
You can use sp_helplocator to return the fields in locator values returned by sp_helplastcommit.
When an error occurs, an error message is returned.