Updated on 2025-03-13 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

name

Instance name.

remote_name

name

Name of the peer instance.

remote_host

text

IP address of the peer instance.

remote_port

bigint

Port number of the peer instance.

is_connected

Boolean

Detects the network status between the current instance and the peer instance:
  • t (true): The network between instances is normal.
  • f (false): The network between instances 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.