Updated on 2023-10-23 GMT+08:00

GLOBAL_COMM_CHECK_CONNECTION_STATUS

GLOBAL_COMM_CHECK_CONNECTION_STATUS displays the connection status of all CNs and all active nodes (CNs and primary DNs). The permission control is inherited from the DBE_PERF schema.

Table 1 GLOBAL_COMM_CHECK_CONNECTION_STATUS columns

Name

Type

Description

node_name

text

Instance name

remote_name

text

Name of the peer instance

remote_host

text

IP address of the peer instance

remote_port

integer

Port number of the peer instance

is_connected

boolean

Detection result of the connection between the current instance and the peer instance
  • t (true) indicates that the connection is normal.
  • f (false) indicates that the connection is abnormal.

no_error_occur

boolean

Pooler connection result between the current instance and the peer instance
  • t (true) indicates that the pooler connection is normal.
  • f (false) indicates that the pooler connection is abnormal.