Critical File Resource statistics displayed in SirMon - Revision history

JAL: `for menu items`


2017-06-06T20:02:06Z
<code> for menu items

				
				
				
				
				
				← Older revision
				Revision as of 20:02, 6 June 2017
				
Line 9:
Line 9:
is being viewed, but the activity that is occurring against them. is being viewed, but the activity that is occurring against them.



In RKWeb, you can display critical file resource statistics for files or user by selecting Performance&nbsp;>&nbsp;Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.   In [[RKWeb]], you can display critical file resource statistics for files or user by selecting <code>Performance&nbsp;>&nbsp;Custom</code> from the <code>Monitor</code> tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.  



<table class="thJustBold"> <table class="thJustBold">



JAL: mention RKWeb equivalents
2017-05-16T20:02:20Z
mention RKWeb equivalents

				
				
				
				
				
				← Older revision
				Revision as of 20:02, 16 May 2017
				
Line 9:
Line 9:
is being viewed, but the activity that is occurring against them. is being viewed, but the activity that is occurring against them.



In RKWeb, you can display both file and user critical file resource statistics by selecting Performance&nbsp;>&nbsp;Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.   In RKWeb, you can display critical file resource statistics for files or user by selecting Performance&nbsp;>&nbsp;Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.  



<table class="thJustBold"> <table class="thJustBold">



JAL: mention RKWeb equivalents
2017-05-16T19:49:54Z
mention RKWeb equivalents

				
				
				
				
				
				← Older revision
				Revision as of 19:49, 16 May 2017
				
Line 3:
Line 3:
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&nbsp;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.
Keep in mind that the resources themselves are not what Keep in mind that the resources themselves are not what
is being viewed, but the activity that is occurring against them. is being viewed, but the activity that is occurring against them.

In RKWeb, you can display both file and user critical file resource statistics by selecting Performance&nbsp;>&nbsp;Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item. 



<table class="thJustBold"> <table class="thJustBold">



JAL: minor formatting
2017-05-11T23:55:48Z
minor formatting

				
				
				
				
				
				← Older revision
				Revision as of 23:55, 11 May 2017
				
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.



Admin: 1 revision: SirMon pages
2015-09-10T22:05:23Z
1 revision: SirMon pages

				
				← Older revision
				Revision as of 22:05, 10 September 2015
				
(No difference)



JAL: minor cleanup
2015-09-10T18:38:00Z
minor cleanup
New page
<!--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

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

<var class="product">Model 204</var> file structure.

Critical file resource statistics are provided by <var class="product">SirMon</var> 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.



<table class="thJustBold">

<tr><th>BUFPAGE</th>

<td>Total number of pages in the disk buffer pool currently occupied by pages from all tables in the database file. Equal to <code>BUFPAGA+BUFPAGB+BUFPAGC+BUFPAGD+BUFPAGF</code>.</td></tr>



<tr><th>CFRCDIR</th>

<td>Conflicts on the <code>DIRECT</code> critical file resource (rate or total).  This resource protects the integrity of Table B.</td></tr>



<tr><th>CFRCEXS</th>

<td>Conflicts on the <code>EXISTS</code> critical file resource.  This resource protects the integrity of the existence bit map.</td></tr>



<tr><th>CFRCIND</th>

<td>Conflicts on the <code>INDEX</code> critical file resource.  This resource protects the integrity of the database indexes.</td></tr>



<tr><th>CFRCREC</th>

<td>Conflicts on the <code>RECENQ</code> critical file resource.  This resource protects the integrity of the record enqueueing tables.</td></tr>



<tr><th>CFRQDIR</th>

<td>Number of users waiting for the <code>DIRECT</code> critical file resource. This resource protects the integrity of table B.</td></tr>



<tr><th>CFRQEXS</th>

<td>Number of users waiting for the <code>EXISTS</code> critical file resource. This resource protects the integrity of the existence bit map.</td></tr>



<tr><th>CFRQIND</th>

<td>Number of users waiting for the <code>INDEX</code> critical file resource. This resource protects the integrity of the database indexes.</td></tr>



<tr><th>CFRQREC</th>

<td>Number of users waiting for the <code>RECENQ</code> critical file resource. This resource protects the integrity of the record enqueuing tables.</td></tr>



<tr><th>CFRQUEU</th>

<td>Number of users waiting for any critical file resource.</td></tr>



<tr><th>DKRD</th>

<td>Physical page reads from a Model204 database file or CCATEMP.</td></tr>



<tr><th>DKWR</th>

<td>Physical page writes to a Model 204 database file or CCATEMP.</td></tr>



<tr><th>HDDIRCT</th>

<td>Type of enqueue on the critical file resource that protects the Table B records (<code>EXC</code>, <code>SHR</code>, or blank).</td></tr>



<tr><th>HDEXIST</th>

<td>Type of enqueue on the critical file resource that protects the existence bit map (<code>EXC</code>, <code>SHR</code>, or blank).</td></tr>



<tr><th>HDINDEX</th>

<td>Type of enqueue on the critical file resource that protects the Table C and D indexes (<code>EXC</code>, <code>SHR</code>, or blank).</td></tr>



<tr><th>HDRECNQ</th>

<td>Type of enqueue on the critical file resource that protects existence bit map pages for locked record sets (<code>EXC</code>, <code>SHR</code>, or blank).</td></tr>



<tr><th>PNAME</th>

<td>Name of the currently executing or last executed procedure.</td></tr>

</table>



==See also==

{{Template:SirMon topic list}}



[[Category: SirMon]]

← Older revision		Revision as of 20:02, 6 June 2017
Line 9:		Line 9:
	is being viewed, but the activity that is occurring against them.		is being viewed, but the activity that is occurring against them.

	In RKWeb, you can display critical file resource statistics for files or user by selecting Performance > Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.		In [[RKWeb]], you can display critical file resource statistics for files or user by selecting <code>Performance > Custom</code> from the <code>Monitor</code> tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.

	<table class="thJustBold">		<table class="thJustBold">

← Older revision		Revision as of 20:02, 16 May 2017
Line 9:		Line 9:
	is being viewed, but the activity that is occurring against them.		is being viewed, but the activity that is occurring against them.

	In RKWeb, you can display ~~both file and user~~ critical file resource statistics by selecting Performance > Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.		In RKWeb, you can display critical file resource statistics for files or user by selecting Performance > Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.

	<table class="thJustBold">		<table class="thJustBold">

← Older revision		Revision as of 19:49, 16 May 2017
Line 3:		Line 3:
	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 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.
	Keep in mind that the resources themselves are not what		Keep in mind that the resources themselves are not what
	is being viewed, but the activity that is occurring against them.		is being viewed, but the activity that is occurring against them.

			In RKWeb, you can display both file and user critical file resource statistics by selecting Performance > Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item.

	<table class="thJustBold">		<table class="thJustBold">

← Older revision		Revision as of 23:55, 11 May 2017
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 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.

← Older revision	Revision as of 22:05, 10 September 2015
(No difference)

Critical File Resource statistics displayed in SirMon - Revision history

JAL: for menu items

JAL: mention RKWeb equivalents

JAL: mention RKWeb equivalents

JAL: minor formatting

Admin: 1 revision: SirMon pages

JAL: minor cleanup

JAL: `for menu items`