Progress
Database Administration
Guide and Reference


PROMON User Control Option

Displays information for each database process. Figure 19–4 shows an example of this option’s output.

User Control 
Usr   Name     Type      Wait    Trans    PID    Sem   Srv   Login     Time 
0              BROK        0         0    3989   3     0     12/20/92  15:38 
1     sue      SELF        0      3145    6356   4     0     12/21/92  16:00 
2     dave     SELF DB     0         0    6943   5     0     12/22/92  14:45 
3              SERV        0         0    6968   6     0     12/22/92  15:00 
4     mary     REMC REC   87      3267    7007   7     3     12/22/92  15:28 
5     bill     REMC        0         0    7034   9     3     12/22/92  16:01 
6              MON         0         0    7123   9     0     12/22/92  16:36 
The DB holder is user -1. The MT holder is user -1. 
RETUN - repeat, U - continue uninterrupted, Q - quit 

Figure 19–4: Sample Output For PROMON User Control Option

DISPLAY FIELDS
Usr

User numbers are assigned sequentially to database processes as they are started. The broker process is always user (0).

Name

The user name for end-user (client) processes.

Type

Table 19–2 lists the distinct types of database processes that can appear in the Type field.

Table 19–2: Type Column Values
Value
Process Type
BROK
Broker process
MON
Monitor process
REMC
Remote client
SELF
Self-service client
SERV
Remote-user server
AIW
After-image writer (AIW) process
SHUT
Database shutdown process

Wait

If a process is waiting, there are 10 possible values for the Wait column. Table 19–3 lists the values and resource or event the process is waiting for. (Wait is actually two
columns – one textual, the other numeric.)

Table 19–3: Wait Column Values
Value
Name
Resource/Event
REC
Record lock
The process is waiting for a locked record to be freed. The numeric column shows the record ID number of the record the process is waiting for.1
SCHM
Schema lock
The process is waiting for the schema lock. There is one schema lock; only one user at a time can update any part of the schema.1
TSK
Another task (transaction to end)
The process is waiting to access (or skip) a record that has been marked for deletion, or whose key field value has been changed, by a task (transaction) that has not yet terminated. When the task terminates, this process can resume executing.1
DEAD
Process termination
The process has actually terminated, although it still appears in the process list. This can happen if a process is killed with the UNIX kill-9 command.
BUFF
Database buffer
The process is waiting for a database buffer.2
DB
Database service
The process is waiting for the database server.2
IX
Index lock
The process is waiting for an index lock.2
MT
Microtransaction
The process is waiting for a microtransaction.2
READ
Block read
The process is waiting to read a block.2
WRT
Block write
The process is waiting to write a block.2
  1. These are application waits. There is no time limit on how long one of these locks can be held.
  2. These are for short-duration (micro- to milliseconds) locks used internally by Progress.

Trans

Transaction (task) number, if one is active. After the broker starts, numbers are assigned sequentially to each transaction that accesses the database.

PID

The process ID as assigned by the operating system. The PID column typically displays (0) for remote clients.

Sem

The number of the semaphore the process is using. Each process uses exactly one semaphore. Progress uses two semaphores (numbers 1 and 2) internally and assigns the remaining semaphores one at a time (starting with the broker) as database processes log in.

Srv

For remote clients (REMC), the user number of the server the client runs against.

Login

The date the process started.

Time

The time the process started.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095