Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROMON Activity option

> Displays an overview of your system activity. Figure 19–6 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      97 %
>     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:

> Figure 19–6: Sample Output for PROMON Activity option

> `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.

> `Buffer Hits`

> Percentage of buffer hits. 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.

> `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 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.

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