Proxy System Tables in master

Proxy system tables enable a secondary companion to access the primary companion’s system tables. One extent is allocated for the proxy system tables in sysobjects. You cannot drop these proxy system tables. Proxy system tables use the following naming syntax:

rmt_ha_system_table_name

Table 5-1 lists the proxy system tables in the secondary companions sysobjects:

Table 5-1: Proxy table names in secondary companion’s sysobjects

Proxy System Table name

System Table Name

rmt_ha_sysalternates

sysalternates

rmt_ha_sysattributes

sysattributes

rmt_ha_sysconfigures

sysconfigures

rmt_ha_sysdatabases

sysdatabases

rmt_ha_syslanguages

syslanguages

rmt_ha_sysloginroles

sysloginroles

rmt_ha_syslogins

syslogins

rmt_ha_sysmessages

sysmessages

rmt_ha_sysobjects

sysobjects

rmt_ha_sysprotects

sysprotects

rmt_ha_sysremotelogins

sysremotelogins

rmt_ha_sysresourcelimits

sysresourcelimits

rmt_ha_sysroles

sysroles

rmt_ha_sysservers

sysservers

rmt_ha_syssessions

syssessions

rmt_ha_syssrvroles

syssrvroles

rmt_ha_systhresholds

systhresholds

rmt_ha_systypes

systypes

rmt_ha_sysusers

sysusers