sp_iqmpxincheartbeatinfo procedure

Function

If run on the coordinator node, displays INC heartbeat status for every node. If executed on a secondary node, displays INC heartbeat status for just the current node.

Syntax

sp_iqmpxincheartbeatinfo

Permissions

DBA authority required.

Description

The sp_iqmpxincheartbeatinfo procedure returns the following:

**Table A-5: sp_iqmpxincheartbeatinfo columns**
Column name	Data type	Description	Values
server_id	unsigned int	Identifier for the server
server_name	char(128)	Name of the server
last_positive_hb	TIMESTAMP	Date/time of last successful heartbeat ping	DD:MM:YYYY:HH:MM:SS
time_not_responding	TIME	Time since last successful heartbeat ping	HH:MM:SS
time_until_timeout	TIME	If a node is not responding, the time left until node is declared offline.

Example

This example shows sample output of sp_iqmpxincheartbeatinfo:

server_id,server_name,last_positive_hb,
time_not_responding,time_until_timeout
2,'r2_dbsrv90210',2008-11-17
15:48:42.0,00:00:00,00:00:00
3,'w3_dbsrv90210',2008-11-17
15:48:42.0,00:00:00,00:00:00