File statistics displayed in SirMon: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 601: Line 601:
<tr><th>REQ</th>
<tr><th>REQ</th>
<td>Number of requests and DISPLAY PROCEDURE commands run on the file (rate or total).</td></tr>
<td>Number of requests and DISPLAY PROCEDURE commands run on the file (rate or total).</td></tr>
<tr><th>RETRYA</th>
<td>Page retries in Table A</td></tr>
<tr><th>RETRYC</th>
<td>Page retries in Table C</td></tr>


<tr><th>SECTY</th>
<tr><th>SECTY</th>

Revision as of 14:28, 8 July 2019

File statistics provide information about each file currently open in the Online system. The value of each file statistic is determined by the activity against that file within the Online.

In RKWeb, you can display all the file statistics and view their descriptions by selecting Performance > Custom from the Monitor tab, then clicking the Files radio button.


ASIZE Size of table A in number of pages.
ASTRPPG Table A strings per page.
ATRPG Number of attribute pages in Table A.
BACKOUTS Number of backed out update units since the file was opened. The stat begins incrementing when the file is first opened, and is reset to 0 when the last user closes it. If the file is reopened the incrementing begins again from 0 (rate or total).
BADD Fields added to Table B (rate or total).
BCHG Fields changed in place in Table B (rate or total).
BDEL Fields deleted from table B (rate or total).
BFULLP Estimate of the percentage of table B that is full. This statistic is equal to the table B highest active page (BHIGHPG) divided by the total number of table B pages (BSIZE).
BHIGHPG The current table B high water mark. Same as the Model 204 BHIGHPG parameter.
BLOWPG The lowest active table B page. Same as the Model 204 BLOWPG parameter.
BQLEN The number of pages in the table B reuse queue. Same as the Model 204 BQLEN parameter.
BRECPPG Maximum number of records per Table B page.
BRESERVE The amount of space in bytes on a Table B page on which new records cannot be started. The space is reserved for the expansion of existing records on the Table B page.
BREUSED The number of records added to the file that reused the record number of a previously deleted record. Same as the Model 204 BREUSED parameter.
BSIZE Size of table B in number of pages.
BUFF. Total number of pages in the disk buffer pool currently occupied by pages from all tables in the database file. Equal to BUFFF + BUFFA + BUFFB + BUFFC + BUFFD + BUFFE + BUFFX.
BUFF.G Total number of above-the-bar pages in the disk buffer pool occupied by pages from all tables in the database file. Equal to BUFFFG + BUFFAG + BUFFBG + BUFFCG + BUFFDG + BUFFEG + BUFFXG. Above-the-bar buffers reside at virtual addresses above two gigabytes and are only used when the NUMBUFG parameter is set to a non-zero value under Model 204 V6R2 or later.
BUFF.L Total number of below-the-bar pages in the disk buffer pool occupied by pages from all tables in the database file.

Equal to BUFFFL + BUFFAL + BUFFBL + BUFFCL + BUFFDL + BUFFEL + BUFFXL.

Below-the-bar buffers reside at virtual addresses below two gigabytes. BUFF.L has the same value as BUFF. unless the NUMBUFG parameter is set to a non-zero value under Model 204 V6R2 or later.
BUFFA Total number of pages in the disk buffer pool currently occupied by Table A pages from the database file.
BUFFAG Total number of above-the-bar pages in the disk buffer pool currently occupied by Table A pages from the database file.
BUFFAL Total number of below-the-bar pages in the disk buffer pool currently occupied by Table A pages from the database file.
BUFFB Total number of pages in the disk buffer pool currently occupied by Table B pages from the database file.
BUFFBG Total number of above-the-bar pages in the disk buffer pool currently occupied by Table B pages from the database file.
BUFFBL Total number of below-the-bar pages in the disk buffer pool currently occupied by Table B pages from the database file.
BUFFC Total number of pages in the disk buffer pool currently occupied by Table C pages from the database file.
BUFFCG Total number of above-the-bar pages in the disk buffer pool currently occupied by Table C pages from the database file.
BUFFCL Total number of below-the-bar pages in the disk buffer pool currently occupied by Table C pages from the database file.
BUFFD Total number of pages in the disk buffer pool currently occupied by Table D pages from the database file.

Note that CCATEMP pages are listed as being in Table D, though they are not really Table D.

Note also that in the system buffer usage statistics, CCATEMP pages are not included in the Table D totals and are instead included in a separate value called BUFFT.
BUFFDG Total number of above-the-bar pages in the disk buffer pool currently occupied by Table D pages from the database file.

Note that CCATEMP pages are listed as being in table D, though they are not really Table D.

Note also that in the system buffer usage statistics, CCATEMP pages are not included in the Table D totals and are instead included in a separate value called BUFFTG.
BUFFDL Total number of below-the-bar pages in the disk buffer pool currently occupied by table D pages from the database file.

Note that CCATEMP pages are listed as being in Table D, though they are not really Table D.

Note also that in the system buffer usage statistics, CCATEMP pages are not included in the Table D totals and are instead included in a separate value called BUFFTL.
BUFFE Total number of pages in the disk buffer pool currently occupied by Table E pages from the database file.
BUFFEG Total number of above-the-bar pages in the disk buffer pool currently occupied by Table E pages from the database file.
BUFFEL Total number of below-the-bar pages in the disk buffer pool currently occupied by Table E pages from the database file.
BUFFF Total number of pages in the disk buffer pool currently occupied by FCT pages from the database file.
BUFFFG Total number of above-the-bar pages in the disk buffer pool currently occupied by FCT pages from the database file.
BUFFFL Total number of below-the-bar pages in the disk buffer pool currently occupied by FCT pages from the database file.
BUFFX Total number of pages in the disk buffer pool currently occupied by Table X pages from the database file.
BUFFXG Total number of above-the-bar pages in the disk buffer pool currently occupied by Table X pages from the database file.
BUFFXL Total number of below-the-bar pages in the disk buffer pool currently occupied by Table X pages from the database file.
BUFM. Total number of pages in the disk buffer pool currently occupied by modified pages from all tables in the database file. Equal to BUFMF + BUFMA + BUFMB + BUFMC + BUFMD + BUFME + BUFMX.
BUFMA Total number of pages in the disk buffer pool currently occupied by modified table A pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMAG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified table A pages from the database file. These must pages be written to disk before they can be flushed from the buffer pool.
BUFMAL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified table A pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMB Total number of pages in the disk buffer pool currently occupied by modified table A pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMBG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified table B pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMBL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified table B pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMC Total number of pages in the disk buffer pool currently occupied by modified table A pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool. Total number of pages in the disk buffer pool currently occupied by modified table A pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMCG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified table C pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMCL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified table C pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMD Total number of pages in the disk buffer pool currently occupied by modified table A pages from the database file.

These pages must be written to disk before they can be flushed from the buffer pool. Note that CCATEMP pages are listed as being in table D, though they're not really table D.

Note also that in the system buffer usage statistics, CCATEMP pages are not included in the table D totals and are instead included in a separate value called BUFMT.
BUFMDG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified table D pages from the database file.

These pages must be written to disk before they can be flushed from the buffer pool. Note that CCATEMP pages are listed as being in Table D, though they're not really table D.

Note also that in the system buffer usage statistics, CCATEMP pages are not included in the table D totals and are instead included in a separate value called BUFMTG.
BUFMDL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified Table D pages from the database file.

These pages must be written to disk before they can be flushed from the buffer pool. Note that CCATEMP pages are listed as being in Table D, though they're not really Table D.

Note also that in the system buffer usage statistics, CCATEMP pages are not included in the Table D totals and are instead included in a separate value called BUFMTL.
BUFME Total number of pages in the disk buffer pool currently occupied by modified Table E pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMEG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified table E pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMEL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified Table E pages from the database file. These pages be must written to disk before they can be flushed from the buffer pool.
BUFMF Total number of pages in the disk buffer pool currently occupied by FCT pages from the database file. These pages must be written to to disk before they can be flushed from the buffer pool.
BUFMFG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified FCT pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMFL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified FCT pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMX Total number of pages in the disk buffer pool currently occupied by modified Table X pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMXG Total number of above-the-bar pages in the disk buffer pool currently occupied by modified Table X pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFMXL Total number of below-the-bar pages in the disk buffer pool currently occupied by modified Table X pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
BUFPAGA Total number of pages in the disk buffer pool currently occupied by Table A pages from the database file.
BUFPAGB Total number of pages in the disk buffer pool currently occupied by Table B pages from the database file.
BUFPAGC Total number of pages in the disk buffer pool currently occupied by Table C pages from the database file.
BUFPAGD Total number of pages in the disk buffer pool currently occupied by Table D pages from the database file.
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 + BUFPAGL + BUFPAGX + the number of Table X pages, which can be obtained via the BUFFX statistic.
BUFPAGF Total number of pages in the disk buffer pool currently occupied by FCT pages from the database file.
BUFPAGL Total number of pages in the disk buffer pool currently occupied by Table E pages from the database file. The L stands for LOBs, or large objects, which is what is stored in table E.
BUFPAGX Total number of pages in the disk buffer pool currently occupied by pages from CCATEMP. Note: these are *not* pages from Table X. The preferred set of buffer usage statistics that includes the Table X pages is the sets of stats that begin with the letters "BUFF".
BXCHNG New segments of records starting or local lists deleted in the ordered index (rate or total).
BXDELE Removals from tree structure in the ordered index. (rate or total).
BXFIND Searches to locate FIELD NAME = VALUE pairs in the ordered index (rate or total).
BXFREE Nodes emptied in the ordered index (rate or total).
BXINSE New records inserted with an unused FIELD NAME = VALUE pair in the ordered index (rate or total).
BXNEXT FIELD NAME = VALUE pairs touched in the ordered index during range retrievals (rate or total).
BXRFND Calls for range retrieval from the ordered index (rate or total).
BXSPLI Node splits in the ordered index (rate or total).
CFRCDEX Conflicts on the "DIRECT" and "EXISTS" critical file resources (rate or total). Equal to CFRCDIR+CFRCEXS.
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 (rate or total). This resource protects the integrity of the existence bit map.
CFRCIND Conflicts on the "INDEX" critical file resource (rate or total). This resource protects the integrity of the database indexes.
CFRCONF Conflicts on all critical file resources (rate or total).
CFRCREC Conflicts on the "RECENQ" critical file resource (rate or total). This resource protects the integrity of the record enqueuing tables.
CFRQDEX Number of users waiting for either the "DIRECT" or "EXISTS" critical file resource. Equal to CFRQDIR+CFRQEXS.
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.
COMMITS Number of committed update units since the file was opened. The stat begins incrementing when the file is first opened, and is reset to 0 when the last user closes it. If the file is reopened the incrementing begins again from 0. (rate or total.)
CSIZE Size of Table C in number of pages.
DFULLP Percentage of table D that is full. This statistic is equal to the number of Table D pages currently in use (DPGSUSED) divided by the total number of Table D pages (DSIZE).
DHIGHPG The current table D high water mark. Same as the Model 204 DHIGHPG parameter.
DIRRCD Number of records scanned in direct searches (rate or total).
DKIO Physical page reads/writes to/from the Model 204 database file (rate or total). This value is equal to DKRD + DKWR.
DKRD Physical pages reads from the Model 204 database file (rate or total).
DKUPTIME Number of milliseconds spent writing a file's pages to disk, and marking it "physically consistent". It includes time writing pages even if the disk update was interrupted. This stat is presented by SirMon in seconds.
DKWR Physical page writes to Model 204 database file (rate or total).
DPGSUSE The current number of table D pages in use. Same as the Model 204 DPGSUSED parameter.
DSIZE Size of table D in number of pages.
DUPDTS Records written to the deferred update data set for the Model 204 database file (rate or total).
EFULLP Percentage of table E that is full. This statistic is equal to the number of table E pages currently in use (EPGSUSED) divided by the total number of table E pages (ESIZE).
EHIGHPG The current table E high water mark. Same as the Model 204 EHIGHPG parameter.
ENQEXC Total number of users and subsystems that have the database file opened in update mode.
ENQSHR Total number of users and subsystems that have the database file opened in read/only mode.
EOVFADD Number of records added to the extra overflow areas. Same as the Model 204 EOVFLADD parameter (rate or total).
EOVFDEL Number of deleted from to the extra overflow areas. Same as the Model 204 EOVFLDEL parameter (rate or total).
EPGSUSE The current number of table E pages in use. Same as the Model 204 EPGSUSED parameter.
ESIZE Size of table E in number of pages.
EXTNADD Number of extension records added to table B. Same as the Model 204 EXTNADD parameter (rate or total).
EXTNDEL Number of extension records deleted from table B. Same as the Model 204 EXTNDEL parameter (rate or total).
FCTB Total number of pages in the disk buffer pool currently occupied by FCT pages from the database file.
FCTM Total number of pages in the disk buffer pool currently occupied by modified FCT pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
FICREATE Release of Model 204 in which the file was created. Values are:

0 - Release 7.1 or earlier release of Model 204 1 - Release 8.0 of Model 204 2 - Release 8.1 of Model 204 3 - Release 9.0 (or later) of Model 204 4 - Version 2 Release 2 (or later) of Model 204 and also has a non-zero setting of FILEMODL parameter. 5 - Version 3 Release 2 (or later) of Model 204 and also has a non-null setting of LANGFILE parameter. 6 - Version 6 Release 1 (or later) of Model 204. 7 - Version 6 Release 2 (or later) of Model 204. 8 - Version 6 Release 3 (or later) of Model 204.

FIFLAGS Summed hex value representing file status detail. Valid settings are sums of the following values:

X'80' - Group index entry required (sorted files). X'40' - Table B appends page full. X'20' - Currently active Table D inversion page full. X'10' - Field level constraints (file has at least one field with a UNIQUE attribute). X'08' - New Table C logic for initial property entry. X'04' - Ordered Index list page full. X'01' - File is post release 3.16.

FILEORG Summed hex value representing the organization of Table B. Valid settings are sums of the following values:

X'40' - File skewing is enabled. X'20' - Unordered file. X'08' - Hash key file. X'04' - Reuse Record Number file (RRN). X'02' - Sort or hash key required in every record. X'01' - Sorted file. X'00' - Entry order file.

FISTAT The current value of the database file's status byte. Same as the Model 204 FISTAT parameter. Values can be summed:

X'40' - File might be logically inconsistent. X'20' - File is in deferred update mode. X'10' - File has been recovered. X'08' - File is full. X'02' - File is physically inconsistent. X'01' - File is not initialized.

Model 204 FISTAT parameter.
FOPT Summed hex value representing file options, as follows:

X'80' - Prohibit statement numbers in procedures. X'40' - Prohibit statement labels in procedures. X'08' - Append-first mode in RDFS file. X'02' - Disable lock pending updates. X'01' - Disallow new field name definitions. X'00' - Allow labels and statement numbers in procedures.

FRCVOPT Summed hex value indicating file recovery options, as follows:

X'80' - Updates not allowed without roll forward active. X'40' - Updates not allowed unless checkpointing active. X'20' - File does not participate in checkpointing. X'10' - Discontinuities not allowed. X'08' - Transaction backout disabled. X'04' - File does not take part in roll forward logging. X'02' - File does not participate in roll forward. X'01' - Transaction boundaries are ignored when applying roll forward updates.

FREESIZ Number of unassigned pages in the database file. Same as the Model 204 FREESIZE parameter.
FVFPG Number of Table A pages used for storing the values from "few valued" coded fields.
HIGHSRT Record number containing the highest sort key. Same as the Model 204 HIGHSORT parameter.
IXADD Index entries added to tables C and D, including attempts to add duplicates (rate or total).
IXDEL Index entries deleted from tables C and D (rate or total).
MODPAGA Total number of pages in the disk buffer pool currently occupied by modified table A pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
MODPAGB Total number of pages in the disk buffer pool currently occupied by modified table B pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
MODPAGC Total number of pages in the disk buffer pool currently occupied by modified table C pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
MODPAGD Total number of pages in the disk buffer pool currently occupied by modified table D pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
MODPAGE Total number of pages in the disk buffer pool currently occupied by modified pages from all tables in the database file. These pages must be written to disk before they can be flushed from the buffer pool. Equal to MODPAGA + MODPAGB + MODPAGC + MODPAGD + MODPAGF + MODPAGL.
MODPAGF Total number of pages in the disk buffer pool currently occupied by modified FCT pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool.
MODPAGL Total number of pages in the disk buffer pool currently occupied by modified table E pages from the database file. These pages must be written to disk before they can be flushed from the buffer pool. The L stands for LOBs, or large objects, which is what is stored in table E.
MODPAGX Total number of pages in the disk buffer pool currently occupied by modified pages from CCATEMP. Note: these are *not* modified pages from table X. The preferred set of buffer usage statistics that includes the table X pages is the sets of stats that begin with the letters "BUFM".
MSTRADD Number of records added to table B. Same as the Model 204 MSTRADD parameter (rate or total).
MSTRDEL Number of records physically deleted from table B. Same as the Model 204 MSTRDEL parameter (rate or total).
MVFPG Number of Table A pages used for storing the values from "many valued" coded fields.
NDPU The current number of table D pages in use. Same as the Model 204 DPGSUSED parameter.
NPTA Size of table A in pages. Same as ASIZE.
NPTB Size of table B in pages. Same as BSIZE.
NPTC Size of table C in pages. Same as CSIZE
NPTD Size of table D in pages. Same as DSIZE.
NPTE Size of table E in pages. Same as ESIZE.
NPTF Size of FCT in pages.
NRECEXT Number of extension records currently in table B.
NRECMAS Number of master records currently in table B.
NRECOVF Number of records currently in overflow areas in table B.
NRECSPL Number of records currently in spill areas in table B.
NREQ Current number of active transactions which reference the file.
NUPD Current number of active transactions which update the file.
OIDEPTH Number of Ordered Index B-tree levels (depth of the B-tree).
OILEAFP Percentage of ordered index leaf pages that contain data. OILEAFP = 100 * (OINBYTS / OILEAVS) / PAGESZ. In general, the higher this value, the better.

After a reorg, this value will generally be close to 100 - LRESERV.

A value close to 50 or lower is a sign of relatively low ordered index density and suggests a reorg.
OILEAVS The number of Ordered Index B-tree leaf-level nodes. The number of Table D pages used for the B-tree leaves.
OILPACT Page number of the Order Index B-tree page which is active.
OINBYTS Number of Ordered Index B-tree entry bytes. .
OINENTR The number of distinct field name = value pairs stored in the Ordered Index B-tree.
OINODEP Percentage of ordered index node pages that contain data. OINODEP = 100 * (OINBYTS / OINODES) / PAGESZ. In general, the higher this value, the better.

After a reorg, this value will generally be close to 100 - LRESERV. A value close to 50 or lower is a sign of relatively low ordered index density and suggests a reorg.

This value will usually be close to OILEAFP except in the case where there are few leaf nodes per higher level nodes. This situation would suggest a reorg.
OINODES The number of Ordered Index B-tree nodes. The total number of Table D pages used for the Ordered Index B-tree.
OPENCTL PUBLIC, PRIVATE or SEMIPUBLIC status of file.
OVFLADD Number of records added to overflow areas in table B. Same as the Model 204 OVFLADD parameter (rate or total).
OVFLDEL Number of records deleted from overflow areas in table B. Same as the Model 204 OVFLDEL parameter (rate or total).
PDCHUNK Number of "chunks" allocated for the procedure dictionary. The procedure dictionary is allocated in chunks of PDSIZE pages. When an attempt to store a name in the dictionary fails because all chunks are full, a new chunk is allocated.
PDPAGES Total number of pages allocated for the procedure dictionary. Equal to PDCHUNK * PDSIZE.
PDSIZE Procedure Dictionary size.
PDSTRPG Procedure Dictionary Strings per page.
PNDGTIME Number of milliseconds since the last update unit completed that a file's pages have been waiting to be written. The stat is only accumulated when DKUPDTWT is non-zero.
PRIVDEF Default privileges for the file (summed hex value).
RECADD Number of records started in Table B, not including extension records
RECDEL Records deleted from table B not including extension records or records deleted by DELETE RECORDS or IFDSET (rate or total).
REQ Number of requests and DISPLAY PROCEDURE commands run on the file (rate or total).
RETRYA Page retries in Table A
RETRYC Page retries in Table C
SECTY Summed hex value indicating type of security in effect for file:

X'01' - Procedure security. X'04' - Procedures secured after Release 4.

SPILADD Number of records added to spill areas in table B. Same as the Model 204 SPILLADD parameter (rate or total).
SPILDEL Number of records deleted from spill areas in table B. Same as the Model 204 SPILLDEL parameter (rate or total).
XFULLP Estimate of the percentage of table X that is full. This statistic is equal to the table X highest active page (XHIGHPG) divided by the total number of table B pages (XSIZE).
XHIGHPG The current table B high water mark. Same as the Model 204 XHIGHPG parameter.
XQLEN The number of pages in the table X reuse queue. Same as the Model 204 XQLEN parameter.
XRECPPG Maximum number of records per Table X page.
XRESERVE The amount of space in bytes on a Table B page on which new records cannot be started. The space is reserved for the expansion of existing records on the Table B page.
XREUSED The number of records added to the file that reused the record number of a previously deleted record. Same as the Model 204 XREUSED parameter.
XSIZE Size of table X in number of pages.

See also