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.
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.
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 UNIXkill-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
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 |