The server status report displays on your screen and contains a description of the current state of the server, the network, and the individual workers.
Use the following system command to display the status of the Query Processor server:
── NA MCPSQL ─┬────────┬─ STATUS ─┬───────────────┬─────────────────────┤
└─ SHOW ─┘ ├─ <worker ID> ─┤
└─ ALL ─────────┘ ┌►──────── , ────────┐
──┴─┬─<mix number>───┬─┴───────────────────────────────────────────────┤
├─<IP address>───┤
└─ (<usercode>) ─┘The following table explains the elements of the syntax diagrams.
|
Element |
Definition |
|---|---|
|
STATUS or SHOW STATUS |
Shows global information about the server including the total number of connections. |
|
STATUS <worker ID> |
Shows detailed information about a specific worker. The worker can be specified by any of the following identifiers: Each worker identifier must resolve to one worker. If a usercode with more than one worker is used, an error is reported. |
|
STATUS ALL or SHOW STATUS ALL |
Obtains status information for all workers. |
