Skip to main content

Search

Welcome to Tibero GTS!

Explanation of Detailed Information Items from the cmrctl show --tscid Command in TSC Observer

Document Type | Technical Information

Category | Administration

Applicable Product Version | 7FS02PS

Document Number | TADTI021

 

Overview

This document explains each item of the information output when executing the command cmrctl show --tscid <tscid> in the TSC (Transparent Shared Cluster) Observer.

 

Method

 cmrctl show --tscid <tscid> command is used to check detailed information for the TSC ID.
$ cmrctl show --tscid 123
TSC(ID: 123) Information
==============================================================================================
FAILOVER       MODE       CLS_ID    CM_NAME    CONN   LOG    Heartbeat         RCVD.TSN      
---------- -------------- -------- ----------- ------ ----- ------------- --------------------
 ON(TSN)      PROTECTIVE        4         cms   Y(M)   -              60                    0
                                1         cmp   Y(M)     1            60               548475
==============================================================================================
 

Explanation of Output Items

FAILOVER

Indicates whether Auto FAILOVER is performed, with the following three states available.
  • OFF: Auto Failover is not performed even if the Primary node fails.
  • ON(TSN): When Auto Failover is performed, the Standby node with the highest Received TSN is selected as the target Standby.
  • ON(FIXED): Failover is performed to the Standby node specified by the user.

 

MODE

Indicates the operating mode of Auto Failover, with the following two modes available.
  • DIS_PLAN: Represents DISASTER PLAN mode, which is a disaster recovery mode. Failover occurs when the entire Primary Cluster is down due to failure. 
    In this case, if all CMs of the Primary Cluster lose connection to the Observer, Auto Failover may occur, and under certain conditions, the Primary Cluster may shut down itself.
  • PROTECT: Represents Protective mode, which prioritizes the stability of the Primary Cluster. 
    Under no circumstances will the Primary Cluster shut down itself, and if all CMs are shut down due to power failure, Auto Failover will not occur. In other words, Auto Failover is only possible when the connection between the Observer and CMs is valid.

 

CONN

Indicates the connection status with the corresponding CM, distinguished by the following three values.
  • N: Not connected to the CM.
  • Y(M): Connected to the CM, and the CM is in Master state within its cluster.
Note
This is meaningful when TAC is supported in Primary or Standby environments, but currently it is also displayed in Single environments.
  • Y: Connected to the CM, but not in Master state.
 

LOG

Meaningful only on Standby nodes, indicating how many Redo Threads the Standby instance is currently receiving logs from.

 

HEARTBEAT

An indicator to check the network communication status between the Observer and CM.

 

RCVD.TSN

Meaningful only on Standby nodes, representing the TSN (Transmission Sequence Number) that the Standby instance has received so far.
 
 
 

Related to