NODE_SUBSCRIPTIONS

Lists information about database node subscriptions.

Column Name Data Type Description
SUBSCRIPTION_OID

INTEGER

 Subscription OID
NODE_OID

INTEGER

 Subscribed node OID
NODE_NAME VARCHAR Name of the node
SHARD_OID

INTEGER

 OID of the shard to which the node is subscribed
SHARD_NAME

VARCHAR

 Name of the shard to which the node is subscribed
SUBSCRIPTION_STATE

VARCHAR

 Node's current subscription state
FROM _VERSION INTEGER Deprecated
IS_PRIMARY BOOLEAN Specifies whether the node is currently the primary subscriber.
IS_RESUBSCRIBING BOOLEAN

Indicates whether a subscription is resubscribing to a node:

  • t (true): A subscription is resubscribing, only applies to PENDING subscriptions created during the cluster or node startup.
  • f (false): A subscription is not resubscribing, applies to PENDING subscriptions created with REBALANCE_SHARDS that transitioned to an ACTIVE state.
CREATOR_TID INTEGER ID of transaction that created this subscription