get heartbeat

Description

Retrieves the heartbeats that have been defined in the RMS. A heartbeat is a process that runs the Replication Server rs_ticket stored procedure at the primary database at a specified interval. The output, or heartbeat ticket, is stored in a table in the replicate database.

Syntax

get heartbeat [for ds.db]

Parameters

ds.db: The name of a connection that is participating in a heartbeat process. This name can be either a primary or replicate connection.

Examples

Example 1

Retrieves all heartbeats defined in the RMS:

get heartbeat

Example 2

Retrieves heartbeats defined for the “inventory_pds.pdb1” connection:

get heartbeat for inventory_pds.pdb1

Usage

get heartbeat returns the following result set:

**Table 9-17: Column descriptions for Get Heartbeat**
Column	Type	Description
Primary	varchar	The name of the primary data server and database.
Replicate	varchar	The name of the replicate data server and database.
Interval	int	The interval in seconds that the RMS executes the rs_ticket command.
Max Rows	int	The maximum number of rows that the rms_ticket_history table can contain. The RMS tests the size of the table at every heartbeat interval. If the size is greater then max_rows, the RMS removes the oldest entries.