NODE_STATES

Monitors node recovery state-change history on the system.

Monitors node recovery state-change history on the system. OpenText™ Analytics Database returns information only on nodes whose state is currently UP. To determine which nodes are not up, query the NODES table.

Column Name Data Type Description
EVENT_TIMESTAMP TIMESTAMPTZ Time when the database recorded the event.
NODE_ID INTEGER Catalog-assigned integer value that uniquely identifies thenode.
NODE_NAME VARCHAR Name of the node.
NODE_STATE VARCHAR

The node's state, one of the following:

  • UP

  • DOWN

  • READY

  • UNSAFE

  • SHUTDOWN

  • SHUTDOWN_ERROR

  • RECOVERING

  • RECOVER_ERROR

  • RECOVERED

  • INITIALIZING

  • STANDBY

  • NEEDS_CATCHUP

The following flow chart details different node states:

Privileges

None