WHERE

Displays information about reality processes being executed.

Syntax

WHERE {[portNumber || startPort-endPort]} {(options}

Syntax Elements

portNumber is the number of a particular port.

startPort-endPortis a range of port numbers.

If no port is specified, all the ports that are currently in use are listed.

Options

A lists account name instead of process-id.

S Displays the minor state for each process.

C Displays the Event Count for each process - only valid with the S option.

Report Headings

If you do not specify an option, WHERE displays the following information:

Heading	Description
PORT	The number of the port from which the process is executed.
PROCESS	The UNIX/Windows process-id.
MAJOR STATE	Reports the high level progress of the associated process, indicating any high level service function which is being performed, for example, 'Item Lock' or 'Item Read'. Such functions make one or more system calls and are therefore subject to being blocked. When not performing such a function, the Major State is set to 'Running'. For server processes that are running but in an idle state, the server name is shown.

Report Headings: S Option

If the S option is specified, WHERE displays the fields already described above, plus:

Heading	Description
STATUS	Reports the status of the associated port, either as, 'Connected' where a user is logged on or 'Reserved' where a user is logging on.
MINOR STATE	Reports the low level progress of the associated process during the current Major State (high level service function) and indicates its state at each system call which may cause a 'blocking' situation, for example, while waiting for an item lock or performing a disk read. The minor state is set at the start of each system call and cleared on successful completion.
EVENT	The Event Count. A changing Event Count indicates that a process is still active, even if the major state is always the same when interrogated by WHERE. If the Event Count does not change the process is hung or inactive, or is busy processing (that is, the major state is 'Running').

Report Headings: A Option

If you specify the A option, WHERE displays the PORT and MAJOR STATE columns but instead of the PROCESS heading, it displays the ACCOUNT-ID field - this contains the name of the account from which the associated process was started.

Display Before the Port Number Entry

An asterisk (*), or the letters T, D or S may appear on the left of a port number entry.  These refer to the following:

* marks the port that issued the WHERE command.

T marks a port from which a TIPH process is being run.

D marks a port which is running a (D)espooler process.

S marks a port which is running a (S)erver process

Example 1

In this example, the WHERE command is entered with a range of ports and the A option:

:WHERE 400-500 (A

   Port Account... State...........
*   401 SYSMAN     Running
:

Example 2

In this example the WHERE command is entered with the S option:

:WHERE (S

   Port Process... Status... Major State..... Minor State.....
*   401       3012 Connected Running
: