Kbase P52674: What is the value for the waiting column on promon?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/26/2009 |
|
Status: Unverified
GOAL:
What is the value for the waiting column on promon?
GOAL:
How to identify which resource a process is waiting for?
FIX:
The PROMON tool allows the system administrator to verify which resource a specific process is waiting for. This information is useful while troubleshooting problems with process that appears to be hung. The information is located on R&D /1 "Status"/4 "Processes/Clients"/ 2 "Blocked Clients" . This is an example of the PROMON screen:
11/06/03 Status: Blocked Clients 17:49:39
Usr Name Type Wait Trans id Login time
6 Admin SELF REC 1318 11/06/03 17:45
Enter return, R, P, T, or X (? for help):
In this situation the process 6 is waiting for the Record 1318. The next column after "Wait" without label will give the resource identification the process is waiting. This table lists the type of resources and what is the object stored on the column without label:
Wait Reason For Wait Value of Next Column
Column
-- Process is not waiting Not meaningful
for a shared resource
REC Record lock conflict Rowid to lock
SCH Database schema lock Lock type. 9 = share lock,
10 = exclusive
TRAN Another transaction to Transaction identifier
end
RGET Record get (fetch) Rowid
consistency lock
TXE Transaction commit Lock type. 1 = share,
consistency lock 2 = exclusive
BKSH Shared (read) access to Block's dbkey
a buffer in the database
buffer pool
BKEX Exclusive (update) Block's dbkey
access to a buffer in the
database buffer pool
BKSI Read with intent to Block's dbkey
update a buffer in the
database buffer pool
DBRD Database block being Block's dbkey
read from disk into
buffer pool
DBWR Database block to be Block's dbkey
written to disk from
buffer pool
DBBK Database block to be Block's dbkey
backed up before it is
updated
BIRD Before-image log data to Before-image log address
be read from disk into bi
&nbs.p; buffer
BIWR Before-image log data to Before-image log address
be written to disk from
bi buffer
AIRD After-image log data to After-image log address
be read from disk into ai
buffer
AIWR After-image log data to After-image log address
be written to disk from
ai buffer
IDLE AIW or BIW Address of last data written
unemployed: will write
for food.