SHOW PARTITION

SHOW PARTITION

Display server data partition information.

Format

SHOW PARTITION

Command Qualifiers

Defaults

/BACKEND

/BACKEND

/BRIEF

/NOBRIEF

/CLUSTER

/NOCLUSTER

/FACILITY

/FACILITY="*"

/FULL

/NOFULL

/NODE[=node-list]

/NODE=default-node-list

/OUTPUT[=file-spec]

/OUTPUT=stdout

/ROUTER

/ROUTER

Description

The SHOW PARTITION command displays information about key range partitions, their states, and current transaction activity. This information is useful for diagnosing bottlenecks or partition difficulties in RTR.

The ``States'' field of SHOW PARTITION /BACKEND can display the following values:

Table 6–20 Key-Range States

State

Meaning

wt_tr_ok wt_quorum lcl_rec lcl_rec_fail lcl_rec_icpl lcl_rec_cpl shd_rec shd_rec_fail shd_rec_icpl shd_rec_cpl catchup standby active pri_act sec_act remember

Server is waiting for routers to accept it Server is waiting for backend to be quorate Local recovery

Primary server waiting for access to a restart journal Getting next journal to recover from

Processed all journals for local recovery

Shadow recovery

Shadow server waiting for access to a restart journal Shadow getting next journal to recover from Processed all journals for shadow recovery Secondary is catching up with primary

Server is declared as standby

Server is active

Server is active as primary shadow Server is active as secondary shadow Primary is running without shadow secondary

The ``State'' field of SHOW PARTITION /ROUTER can display the following values:

6–152RTR Command Line Interface

Page 228
Image 228
Compaq AA-Q88CE-TE manual Show Partition, Key-Range States