2. Using Ingres Commands : rcpstat Command—Display Logging System Status
 
Share this page                  
rcpstat Command—Display Logging System Status
Permission required: Installation owner.
The rcpstat utility displays the status of the logging system. It is used for system maintenance.
The rcpstat command has the following format:
rcpstat -online         [-silent]
rcpstat -transactions   [-silent]
rcpstat -exist  [-dual] [-silent]
rcpstat -format [-dual] [-silent]
rcpstat -enable [-dual] [-silent]
rcpstat -sizeok         [-silent]
rcpstat -csp_online [-node nodename] [-silent]
rcpstat -any_csp_online [-silent]
rcpstat -connected      [-silent]
rcpstat -help
-online
Shows whether the logging system is online or offline.
-transactions
Shows if the logging system has recoverable transactions in the transaction log file.
-exist [-dual]
Shows whether the primary (default) or dual (dual flag) transaction log file exists.
-format [-dual]
Shows whether the primary (default) or dual (dual flag) transaction log file is formatted.
-enable [-dual]
Shows whether the primary (default) or dual (dual flag) transaction log file is enabled.
-sizeok
Shows whether the primary and dual transaction log files are the same size.
-csp_online
Shows whether, in a cluster installation, the Cluster server (CSP) is online on this node.
-node nodename
Queries a specific node, on any of the preceding flags. A nodename is valid in a cluster installation only.
-any_csp_online
Displays whether, in a cluster installation, the Cluster server (CSP) is online on any node.
-silent
Sets the program exist status to TRUE or FALSE according to the results of the operation.
-connected
Displays the process ID of all processes connected to the logging system.
-help
Displays command syntax online.