Progress
Database Administration
Guide and Reference
PROMON Activity Option
Displays an overview of your system activity. Figure 19–8 shows an example of this option’s output.
Figure 19–8: Sample Output For PROMON Activity Option
DISPLAY FIELDS
Event
The events that have occurred on the system and the cumulative total number of events and the number of events per second. Table 19–5 defines the event types listed in the Event field. For each event type, PROMON lists the cumulative total number of events and the number of events per second.
Rec Lock Waits
Percentage of record accesses that result in record lock waits. A record lock wait occurs when the database engine must wait to access a locked record.
BI Buf Waits
Percentage of before-image (BI) buffer waits. A BI buffer wait occurs when the database engine must wait to access a BI buffer.
AI Buf Waits
Percentage of after-image (AI) buffer waits. An AI buffer wait occurs when the database engine must wait to access an AI buffer.
Writes by APW
Percentage of database blocks written to disk by the APW; this is a percentage of the total number of database blocks written by the database engine.
Writes by BIW
Percentage of BI blocks written to disk by the BIW; this is a percentage of the total number of BI blocks written to disk by the database engine.
Writes by AIW
Percentage of AI blocks written to disk by the AIW; this is a percentage of the total number of AI blocks written by Progress.
Buffer Hits
Percentage of buffer hits. A buffer hit occurs when Progress locates a database record in the buffer pool and does not have to read the record from disk.
DB Size
Size of your database in kilobytes.
BI Size
Size of your BI file in kilobytes.
AI Size
Size of your AI file in kilobytes.
FR chain
Number of blocks on your database’s free chain. The free chain is a chain of empty database blocks.
RM chain
Number of blocks on your database’s record-management chain. The record-management chain is a chain of partially filled database blocks.
Shared Memory
Amount of shared memory used by the database, in kilobytes.
Segments
Number of shared-memory segments allocated by the database engine. The size of a shared-memory segment is determined by your kernel configuration.
The last line of the PROMON Activity output summarizes the current number of each type of process running against the database at the time you ran the Activity option, not a cumulative total. Table 19–6 defines the process types.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |