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.

Activity - Sampled at 03/10/02 11:25 for 2:46:37. 
Event           Total   Per Sec       Event            Total         Per Sec 
Commits          3900       0.3        Undos             1215            0.1 
Record Updates   4717       0.4        Record Reads    353418           35.3 
Record Creates  12307       1.2        Record Deletes   10837            1.0 
DB Writes       29778       2.9        DB Reads        233257           23.3 
BI Writes       27834       2.7        BI Reads         10592            1.0 
AI Writes       29443       2.9         
Record Locks   113928      11.0        Record Waits         0            0.0 
Checkpoints      1591       0.1        Buffers Flushed  21154            2.1 
Rec Lock Waits   0 %     BI Buf Waits     2 %     AI Buf Waits       0 % 
Writes by APW   23 %     Writes by BIW   85 %     Writes by AIW     88 % 
Buffer Hits     87 %    
DB Size       1520 K        BI Size      64 K         AI Size        0 K 
FR chain        16 blocks   RM chain    733 blocks   
Shared Memory  184 K        Segments      1 
0 Servers, 1 Users (1 Local, 0 Remote, 0 Batch), 0 Apws 
RETURN - repeat, U - continue uninterrupted, Q - quit: 

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.

Table 19–5: Event Types 
Event Type
Description
Commits
Number of transactions committed.
Undos
Number of transactions rolled back.
Record Updates
Number of records updated.
Record Reads
Number of records read.
Record Creates
Number of records created.
Record Deletes
Number of records deleted.
DB Writes
Number of database blocks written to disk.
DB Reads
Number of database blocks read from disk.
BI Writes
Number of BI blocks written to disk.
BI Reads
Number of BI blocks read.
AI Writes
Number of AI blocks written to disk.
Record Locks
Number of record locks used.
Record Waits
Number of times the database engine waited to access a locked record.
Checkpoints
Number of checkpoints performed.
Buffers Flushed
Number of database buffers flushed during checkpoints.

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.

Table 19–6: Process Types 
Field
Description
Servers
Number of servers running against your database. This is the current value at the time you ran the Activity option, not a cumulative total.
Users
Number of users running Progress. This field is further divided into the type of user: Local, Remote, or Batch. This is the current value at the time you ran the Activity option, not a cumulative total.
Apws
Number of APWs running against your database. This is the current value at the time you ran the Activity option, not a cumulative total.


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