PROMON Activity option

Displays an overview of your system activity.

Sample Output for PROMON Activity option

The following shows an example of this option's output.

Activity  - Sampled at 04/29/04 15:09 for 0:03:39.

Event                Total   Per Sec   Event              Total     Per Sec
       Commits          50       0.2              Undos       0         0.0
Record Updates           0       0.0       Record Reads    3709        16.9   
Record Creates           0       0.0     Record Deletes       0         0.0   
     DB Writes           3       0.0           DB Read      473         2.2
     BI Writes           2       0.0           BI Reads     198         0.9   
     AI Writes           0       0.0       
  Record Locks         210       1.0       Record Waits       0         0.0   
   Checkpoints           0       0.0      Buffs Flushed       0         0.0

Rec Lock Waits    0 %    BI Buf Waits        0 %    AI Buf Waits    0 %
Writes by APW     0 %    Writes by BIW       0 %    Writes by AIW   0 %
Buffer Hits      99 %    Primary Hits      100 %    Alternate Hits 99 %
DB Size        1151 K        BI Size    2168 K        AI Size       0 K
FR chain         12 blocks   RM chain    439 blocks
Shared Memory 966656         Segments      1

0 Servers, 10 Users (10 Local, 0 Remote, 10 Batch),0 Apws

RETURN - repeat, U - continue uninterrupted, Q - quit:
Event

The events that have occurred on the system and the cumulative total number of events and the number of events per second. The table below 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 1. 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.
Buffer Hits
Percentage of buffer hits for both the primary and Alternate Buffer Pools. A buffer hit occurs when the database engine locates a record in the buffer pool and does not have to read the record from disk.
Primary Hits
Percentage of buffer hits for the primary buffer pool.
Alternate Hits
Percentage of buffer hits for the Alternate Buffer Pool.
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. The table below defines the process types.

Table 2. 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 an OpenEdge process. 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.