get heartbeat

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:

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.