File statistics displayed in SirMon: Difference between revisions
m (<code> for menu items) |
No edit summary |
||
(2 intermediate revisions by the same user not shown) | |||
Line 591: | Line 591: | ||
<tr><th>PRIVDEF</th> | <tr><th>PRIVDEF</th> | ||
<td>Default privileges for the file (summed hex value).</td></tr> | <td>Default privileges for the file (summed hex value).</td></tr> | ||
<tr><th>RECADD</th> | |||
<td>Number of records started in Table B, not including extension records</td></tr> | |||
<tr><th>RECDEL</th> | <tr><th>RECDEL</th> | ||
Line 597: | 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> | ||
Line 609: | Line 619: | ||
<tr><th>SPILDEL</th> | <tr><th>SPILDEL</th> | ||
<td>Number of records deleted from spill areas in table B. Same as the Model 204 SPILLDEL parameter (rate or total).</td></tr> | <td>Number of records deleted from spill areas in table B. Same as the Model 204 SPILLDEL parameter (rate or total).</td></tr> | ||
<tr><th>UPDTTIME</th> | |||
<td>Number of milliseconds that the user was actively updating at least one file</td></tr> | |||
<tr><th>XFULLP</th> | <tr><th>XFULLP</th> |
Latest revision as of 14:31, 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 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). |
UPDTTIME | Number of milliseconds that the user was actively updating at least one file |
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
- 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