Progress
Database Administration
Guide and Reference
Activity Displays>Summary
Displays general information about database activity. Figure A–21 shows a sample Summary Activity display.
Figure A–21: PROMON Summary Activity Display
The Summary Activity display shows the number of events that have occurred on the system, including the cumulative total and the number of events per second. The display includes the following events:
- Commits — The number of transactions all users have committed.
- Undos — The number of transactions rolled back.
- Record Reads — The number of records read.
- Record Updates — The number of records updated.
- Record Creates — The number of records created.
- Record Deletes — The number of records deleted.
- Record Locks — The number of record locks used.
- Record Waits — The number of times users have waited to access a locked record.
- DB Reads — The number of database blocks read.
- DB Writes — The number of database blocks written to disk.
- BI Reads — The number of BI blocks read.
- BI Writes — The number of BI blocks written to disk.
- AI Writes — The number of AI blocks written to disk.
- Checkpoints — The number of checkpoints that have been performed.
- Flushed at chkpt — The number of database buffers that have been flushed to disk because they were not written by the time the checkpoint ended.
The Summary Activity display also shows the following information:
- Rec Lock Waits — The percentage of record accesses that result in record lock waits. A record lock wait occurs when Progress must wait to access a locked record.
For optimum performance, try to keep this number as low as possible. You can lower this number by modifying your application to perform shorter transactions so that record locks are held for shorter periods of time.
- BI Buf Waits — The percentage of BI buffer waits. A BI buffer wait occurs when Progress must wait to access a BI buffer.
For optimum performance, try to keep this number as low as possible. To decrease this number, allocate more BI buffers with the Before-image Buffers (-
bibufs
) parameter.- AI Buf Waits — The percentage of AI buffer waits. An AI buffer wait occurs when Progress must wait to access an AI buffer.
For optimum performance, try to keep this number as low as possible. To decrease this number, allocate more AI buffers with the After-image Buffers (-
aibufs
) parameter.- Writes by APW — The percentage of database blocks written to disk by the APW; this is a percentage of the total number of database blocks written by Progress.
For optimum performance, try to keep this number as high as possible. To increase this number, start more APWs and increase the cluster size.
- Writes by BIW — The 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 Progress.
For optimum performance, try to keep this percentage fairly high. You can increase the number of BI buffers with the -bibufs
parameter.- Writes by AIW — The percentage of AI blocks written to disk by the AIW; this is a percentage of the total number of AI blocks written by Progress.
For optimum performance, try to keep this percentage fairly high. You can increase the number of AI buffers with the -aibufs
parameter.- DB Size — The size of your database, in kilobytes.
- BI Size — The size of your BI file, in kilobytes.
- AI Size — The size of your AI file, in kilobytes.
- Empty blocks — The number of empty (never used) database blocks.
- Free blocks — The number of blocks on the database’s free chain. The free chain is a chain of previously used and then deallocated database blocks.
- RM chain — The number of blocks on the database’s RM chain. The RM chain is a chain of partially filled database blocks.
- Buffer hits — The percentage of buffer hits. A buffer hit occurs when Progress locates a database record in the Progress buffer pool and does not have to read the record from disk.
For optimum performance, keep this number as high as possible. To increase this number, allocate more buffers with the -
B
parameter. Increase the number of buffers until one of the following occurs:- Active trans — The number of active transactions.
The last line of the Summary Activity display summarizes the current number of each type of process running against the database at the time you run the Activity option. Table A–10 defines the process types.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |