Critical File Resource statistics displayed in SirMon: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (1 revision: SirMon pages)
m (minor formatting)
Line 1: Line 1:
<!--Page automatically generated by CMSTOWIK EXEC and will be
** automatically replaced ** -- any manual edits will be lost.
You've been warned.  ..  (Page built by JAL at the SIRIUS VM; file: FUNPGNEW SYSUT2) -->
<!-- Page name: Critical File Resource statistics displayed in SirMon-->
Critical File Resource statistics describe activity which is occurring
Critical File Resource statistics describe activity which is occurring
against the four critical file resources: <code>DIRECT</code>, <code>INDEX</code>, <code>EXISTS</code>, and <code>RECENQ</code>.
against the four critical file resources: <code>DIRECT</code>, <code>INDEX</code>, <code>EXISTS</code>, and <code>RECENQ</code>.
Each of the critical file resources protects the integrity of a
Each of the critical file resources protects the integrity of a
<var class="product">Model 204</var> file structure.
<var class="product">Model&nbsp;204</var> file structure.
Critical file resource statistics are provided by <var class="product">SirMon</var> to assist
Critical file resource statistics are provided by <var class="product">SirMon</var> to assist
in diagnosing second order performance problems.
in diagnosing second order performance problems.

Revision as of 23:55, 11 May 2017

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

Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=Critical_File_Resource_statistics_displayed_in_SirMon&oldid=102945"