Filter
Top Products
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 Server is waiting for routers to accept it
wt_quorum Server is waiting for backend to be quorate
lcl_rec Local recovery
lcl_rec_fail Primary server waiting for access to a restart journal
lcl_rec_icpl Getting next journal to recover from
lcl_rec_cpl Processed all journals for local recovery
shd_rec Shadow recovery
shd_rec_fail Shadow server waiting for access to a restart journal
shd_rec_icpl Shadow getting next journal to recover from
shd_rec_cpl Processed all journals for shadow recovery
catchup Secondary is catching up with primary
standby Server is declared as standby
active Server is active
pri_act Server is active as primary shadow
sec_act Server is active as secondary shadow
remember Primary is running without shadow secondary
The ‘‘State’’ field of SHOW PARTITION /ROUTER can display the following
values:
6–152 RTR Command Line Interface