Updated on 2024-06-03 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, as described in Table 1.

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.