The QUSRBRM.HISTORY_SYNC view shows the systems that are sending backup history to the current system.

Authorization:

The authorization ID of the statement must include the following privileges:

Result Table

The following table describes the columns in the view. The system name is HIST_SYNC. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
SYSTEM_NAME	SYSTEM	VARCHAR(17)	The system name we are receiving backup history from. Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.
ASP_NAME	ASP_NAME	VARCHAR(10)	The auxiliary storage pool (ASP) name on the system to receive backup history from. The possible values are: SYSBAS - This is a system (1) or basic user (2-32) auxiliary storage pool. asp-name* - The auxiliary storage pool name (33-255) to receive backup history from.
CHANGE_SYSTEM_NAME	CHGSYSNAM	VARCHAR(3)	Indicates if the history records received have their system name changed to match the receiving system. The possible values are: NO YES

Examples

Example 1: Display all systems that are sending backup history to this system.

SELECT SYSTEM_NAME, NETWORK_ID, ASP_DEVICE, CHANGE_SYSTEM_NAME FROM QUSRBRM.HISTORY_SYNC

Example output:

SELECT SYSTEM_NAME, NETWORK_ID, ASP_DEVICE, CHANGE_SYSTEM_NAME FROM QUSRBRM.HISTORY_SYNC WHERE CHANGE_SYSTEM_NAME = ‘YES’

Example output: