Critical File Resource statistics displayed in SirMon: Difference between revisions
Jump to navigation
Jump to search
m (minor cleanup) |
m (1 revision: SirMon pages) |
(No difference)
| |
Revision as of 22:05, 10 September 2015
Critical File Resource statistics describe activity which is occurring
against the four critical file resources: DIRECT, INDEX, EXISTS, and RECENQ.
Each of the critical file resources protects the integrity of a
Model 204 file structure.
Critical file resource statistics are provided by SirMon to assist
in diagnosing second order performance problems.
Keep in mind that the resources themselves are not what
is being viewed, but the activity that is occurring against them.
| BUFPAGE | Total number of pages in the disk buffer pool currently occupied by pages from all tables in the database file. Equal to BUFPAGA+BUFPAGB+BUFPAGC+BUFPAGD+BUFPAGF. |
|---|---|
| CFRCDIR | Conflicts on the DIRECT critical file resource (rate or total). This resource protects the integrity of Table B. |
| CFRCEXS | Conflicts on the EXISTS critical file resource. This resource protects the integrity of the existence bit map. |
| CFRCIND | Conflicts on the INDEX critical file resource. This resource protects the integrity of the database indexes. |
| CFRCREC | Conflicts on the RECENQ critical file resource. This resource protects the integrity of the record enqueueing tables. |
| CFRQDIR | Number of users waiting for the DIRECT critical file resource. This resource protects the integrity of table B. |
| CFRQEXS | Number of users waiting for the EXISTS critical file resource. This resource protects the integrity of the existence bit map. |
| CFRQIND | Number of users waiting for the INDEX critical file resource. This resource protects the integrity of the database indexes. |
| CFRQREC | Number of users waiting for the RECENQ critical file resource. This resource protects the integrity of the record enqueuing tables. |
| CFRQUEU | Number of users waiting for any critical file resource. |
| DKRD | Physical page reads from a Model204 database file or CCATEMP. |
| DKWR | Physical page writes to a Model 204 database file or CCATEMP. |
| HDDIRCT | Type of enqueue on the critical file resource that protects the Table B records (EXC, SHR, or blank). |
| HDEXIST | Type of enqueue on the critical file resource that protects the existence bit map (EXC, SHR, or blank). |
| HDINDEX | Type of enqueue on the critical file resource that protects the Table C and D indexes (EXC, SHR, or blank). |
| HDRECNQ | Type of enqueue on the critical file resource that protects existence bit map pages for locked record sets (EXC, SHR, or blank). |
| PNAME | Name of the currently executing or last executed procedure. |
See also
- SirMon
- SirMon application structure
- SirMon main menu
- SirMon System Overview screen
- SirMon threshold setting
- SirMon background monitor
- SirMon System Monitor menu
- SirMon User Monitor menu
- SirMon File Monitor menu
- SirMon Subsystem Monitor menu
- SirMon Task Monitor menu
- SirMon Janus Monitor menu
- SirMon custom screens
- SirMon critical-file-resource monitoring
- SirMon user-initiated capturing of statistics
- System statistics displayed in SirMon
- User statistics displayed in SirMon
- File statistics displayed in SirMon
- Subsystem statistics displayed in SirMon
- Task statistics displayed in SirMon
- Critical File Resource statistics displayed in SirMon
- SirMon date processing