Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : PROMON Activity option
 

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 80. 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 81. 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.