Movatterモバイル変換

node_id

Node id

table_id

Table ID

tab_copy_status

Status of copying of table distribution data to disk; one ofIDLE,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_MASTER,ADD_TABLE_SLAVE,INVALIDATE_NODE_LCP,ALTER_TABLE,COPY_TO_SAVE, orGET_TABINFO

tab_update_status

Status of updating of table distribution data; one ofIDLE,LOCAL_CHECKPOINT,LOCAL_CHECKPOINT_QUEUED,REMOVE_NODE,COPY_TAB_REQ,ADD_TABLE_MASTER,ADD_TABLE_SLAVE,INVALIDATE_NODE_LCP, orCALLBACK

tab_lcp_status

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

tab_status

Table internal status; one ofACTIVE (table exists),CREATING (table is being created), orDROPPING (table is being dropped)

tab_storage

Table recoverability; one ofNORMAL (fully recoverable with redo logging and checkpointing),NOLOGGING (recoverable from node crash, empty following cluster crash), orTEMPORARY (not recoverable)

tab_partitions

Number of partitions in table

tab_fragments

Number of fragments in table; normally same astab_partitions; for fully replicated tables equal totab_partitions * [number of node groups]

current_scan_count

Current number of active scans

scan_count_wait

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

is_reorg_ongoing

Whether table is currently being reorganized (1 if true)