node_id

Node id

table_id

Table ID

tab_copy_status

Status of copying of table distribution data to disk; one of IDLE, SR_PHASE1_READ_PAGES, SR_PHASE2_READ_TABLE, SR_PHASE3_COPY_TABLE, REMOVE_NODE, LCP_READ_TABLE, COPY_TAB_REQ, COPY_NODE_STATE, ADD_TABLE_COORDINATOR, ADD_TABLE_PARTICIPANT, INVALIDATE_NODE_LCP, ALTER_TABLE, COPY_TO_SAVE, or GET_TABINFO

tab_update_status

Status of updating of table distribution data; one of IDLE, LOCAL_CHECKPOINT, LOCAL_CHECKPOINT_QUEUED, REMOVE_NODE, COPY_TAB_REQ, ADD_TABLE_MASTER, ADD_TABLE_SLAVE, INVALIDATE_NODE_LCP, or CALLBACK

tab_lcp_status

Status of table LCP; one of ACTIVE (waiting for local checkpoint to be performed), WRITING_TO_FILE (checkpoint performed but not yet written to disk), or COMPLETED (checkpoint performed and persisted to disk)

tab_status

Table internal status; one of ACTIVE (table exists), CREATING (table is being created), or DROPPING (table is being dropped)

tab_storage

Table recoverability; one of NORMAL (fully recoverable with redo logging and checkpointing), NOLOGGING (recoverable from node crash, empty following cluster crash), or TEMPORARY (not recoverable)

tab_partitions

Number of partitions in table

tab_fragments

Number of fragments in table; normally same as tab_partitions; for fully replicated tables equal to tab_partitions * [number of node groups]

current_scan_count

Current number of active scans

scan_count_wait

Current number of scans waiting to be performed before ALTER TABLE can complete.

is_reorg_ongoing

Whether the table is currently being reorganized (1 if true)