SYNC_ACTIVE_MASTER

SQL Guide : Database system tables and system views : Synchronization-related views : SYNC_ACTIVE_MASTER_MESSAGES

SYNC_ACTIVE_MASTER_MESSAGES

This table is on the replica and holds information about messages sent to the master. It is possible to view all necessary information about failed messages using one simple view:

SELECT * FROM SYNC_FAILED_MASTER_MESSAGES.

This returns the following columns:

Column name	Data type	Description
MASTER_NAME	WVARCHAR	Given node name of the master.
MESSAGE_NAME	WVARCHAR	Name of the message given by user.
MESSAGE STATE	VARCHAR	Current state of the message as a string. See details in system table SYS_SYNC_REPLICA_MSGINFO.

All users have access to this view; no particular privileges are required.