background image

——————————————————————————————————————————

 

File statistics definitions

——————————————————————————————————————————

—————— 

APPENDIX A 

 

File statistics definitions

 

File statistics provide information about each file open in the Online system.  Each file

 

has a specific value for each statistic based on the file's current activity and state within

 

the Online region.  Many of these statistics are viewable on the File Tables screen and

 

the File Detail screen in 

SirFile

.  Others may be viewable only at command level or

 through 

SirMon

.

 

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 Model204 BHIGHPG

 parameter.

 

BLOWPG

 

The lowest active table B page. Same as the Model204 BLOWPG

 parameter.

 

BQLEN

 

The number of pages in the table B reuse queue. Same as the

 

Model204 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.

——————————————————————————————————————————

SirFile User's Guide

 

37

Summary of Contents for SirFile 204

Page 1: ...Monitor Sirius Software Inc 875 Massachusetts Avenue Suite 21 Cambridge MA 02139 Telephone 617 876 6677 FAX 617 234 1200 E mail support sirius software com World Wide Web http sirius software com Mar...

Page 2: ...ii SirFile User s Guide...

Page 3: ...e Inc Sirius Software Inc 875 Massachusetts Avenue Suite 21 Cambridge Massachusetts 02139 USA 1 617 876 6677 http sirius software com Model 204 is a proprietary product of Computer Corporation of Amer...

Page 4: ...Proprietary Notices iv SirFile User s Guide...

Page 5: ...6 Getting Started 7 Chapter 3 The Refresh Process 11 Chapter 4 Main File Menu 13 Chapter 5 File Thresholds Screen 17 Chapter 6 File Open Screen 21 Chapter 7 File Detail Screen 23 Chapter 8 File Table...

Page 6: ...Contents Index 49 vi SirFile User s Guide...

Page 7: ...prehensive facility both for monitoring the physical storage utilization of Model 204 database files and for warning users of the need for file reorganizations SirFile maintains historical information...

Page 8: ...aging and Installation Requirements All of the UL SPF products are Model 204 application subsystems written in User Language UL SPF is distributed as a set of Model 204 files in a backup format produc...

Page 9: ...to the individual User Language subsystems that implement the UL SPF products SirDBA SirFile SirLib SirMon SirPro and SirScan Sirius distributes an umbrella UL SPF subsystem The ULSPF subsystem provid...

Page 10: ...Introduction to UL SPF Model 204 Command Reference Manual Model 204 File Manager s Guide Model 204 System Manager s Guide Model 204 User Language Manual 4 SirFile User s Guide...

Page 11: ...require higher or lower levels of monitoring If any file table is above a threshold SirFile flags the file with a warning causing it to be highlighted in SirFile Once SirFile has stored at least one...

Page 12: ...ile with default privileges the file is added to the database and no user intervention is required 2 The first time SirFile collects data for a file it adds the file to its Application Subsystem defin...

Page 13: ...from the File Tables screen if the cursor is not on a file name or file statistics line respectively The System Default thresholds screen is initially populated with a set of defaults that are adequat...

Page 14: ...ecord exceeds the usable space left on a Table B page Extension records are not a sign of a file full condition pending and in some record structures they may be unavoidable For this reason the EXTNAD...

Page 15: ...a TABLEC command which can be very I O intensive When Y is specified at this prompt the user must specifically request each file the TABLEC command is to be run against entering Y at the following pr...

Page 16: ...ys PF1 Accesses full screen help PF3 Return to command level or previous screen PF9 Repeats the last command line command PF12 Saves the file specific thresholds and invokes the SirFile database refre...

Page 17: ...ad from the requesting user the SIRFILE BACKGROUND interval command This runs the refresh on an sdaemon thread that is a different thread from the requesting user and it may be useful in the online s...

Page 18: ...ceeded any thresholds and at least 1 sample record has been stored for the file SirFile performs a simple linear regression to predict when the file will fill If the file full date falls within the nu...

Page 19: ...36 TOMPROC 5 CHARPROC 21 PUBS2 37 TOMWEB 6 DATALINK 22 SIRDBA 38 TOOLS 7 DEVFILE 23 SIRDBAD 8 DMEDTC 24 SIRFILE 9 DMEPROC 25 SIRFILED 10 DMEWORK 26 SIRFIXES 11 DMEWORK1 27 SIRLIB 12 DMEWORK2 28 SIRLIB...

Page 20: ...at SirFile already knows about or files that are currently open by any user a SirFile user may wish to manually open a file before running a refresh to guarantee the file is included in the sample CLO...

Page 21: ...d monitoring and specifies actions taken when the monitor notices file full pending conditions PF3 Return to command level or the UL SPF main menu PF4 Accesses a scrollable list that displays the tabl...

Page 22: ...Main File Menu 16 SirFile User s Guide...

Page 23: ...red samples DFULLP 90 26 6 9999 7 EXTNADD 5000 0 9999 OVFLADD 5000 0 9999 EOVFLADD 5000 0 9999 of days advance warning SPILLADD 1000 0 9999 on threshold exceeded 7 Collect CFULLP for this file Y N N U...

Page 24: ...pt allows SirFile to run the TABLEC command for the file This prompt is not presented if the user has specified N for the following prompt on the System Default thresholds screen Collect CFULLP only o...

Page 25: ...File Thresholds Screen PF9 Repeats the last command line command PF12 Saves the file specific thresholds and for this file only invokes the SirFile database refresh operation SirFile User s Guide 19...

Page 26: ...File Thresholds Screen 20 SirFile User s Guide...

Page 27: ...open screen SirFile requires only read privileges in files being monitored If the user is being prompted for passwords in the middle of a refresh operation the PF key choices are as shown in the figur...

Page 28: ...File Open Screen 22 SirFile User s Guide...

Page 29: ...00 0 00 0 00 0 00 TOT 0 0 0 0 0 0 0 0 1 Help 3 Quit 6 Msgs File Detail screen File statistics definitions on page 37 contains statistic descriptions for this display The File Detail screen may be pla...

Page 30: ...File Detail Screen 24 SirFile User s Guide...

Page 31: ...FILE 0 0 0 000 48 400 0 0 1 Help 3 Quit 5 SortFile 6 Msgs 7 Up 8 Down 9 Repeat 10 Detail 11 Thresh 12 Refresh File Tables screen Like the File Detail screen the File Tables screen displays information...

Page 32: ...he list of files SORT stat x Where stat is the screen name of any of the displayed statistics and x is A or D for ascending or descending Multiple sort criteria may be specified as in the following ex...

Page 33: ...ver a file statistic line when the PF key is pressed PF11 Accesses the threshold screen for a selected file PF12 Performs the Refresh process either for all files or for a single file if the cursor is...

Page 34: ...File Tables Screen 28 SirFile User s Guide...

Page 35: ...1 Help 3 Quit 6 Main 7 Up 8 Down 9 Repeat 10 Detail SIRFILE TRC 2 This screen can only be accessed for files that have messages posted Messages are only posted when a file is predicted to fill If the...

Page 36: ...Messages Screen 30 SirFile User s Guide...

Page 37: ......

Page 38: ...Ds and numbers must be separated by blanks or commas The following commands work on this screen OPEN xxxxxxxx Opens a file As data can only be collected for files that SirFile already knows about or f...

Page 39: ...s as appropriate then returns to a sleep state The background task may be BUMPed the same as any user To change the time parameter for the background task it should be bumped and resubmitted PF5 from...

Page 40: ...the background SirFile task that is it will enter a sleep state that is not interruptable unless it is bumped You can also use the SIRFILE BATCH command to invoke a refresh once see Running SirFile un...

Page 41: ...es CFULLP is a more accurate measure of the full status of Table C but it requires that a TABLEC command be executed which can be a very resource intensive operation Following is a sample job fragment...

Page 42: ...if CFULLP allocation is not determined file by file Note A file must be open with File Manager privileges PRIVDEF must contain the x 8000 bit in order for the TABLEC command to operate When SirFile a...

Page 43: ...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...

Page 44: ...tables in the database file Equal to BUFPAGA BUFPAGB BUFPAGC BUFPAGD BUFPAGF BUFPAGL BUFPAGF Total number of pages in the disk buffer pool currently occupied by FCT pages from the database file BUFPAG...

Page 45: ...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...

Page 46: ...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 Model204 EHIGHPG parameter...

Page 47: ...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 f...

Page 48: ...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...

Page 49: ...elds NDPU The current number of table D pages in use Same as the Model204 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...

Page 50: ...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 Inde...

Page 51: ...r of table C rehashes required to add an item to table C This statistics returns the total for the file since it was initialized A high value for RETRYC could indicate that table C is getting close to...

Page 52: ...File statistics definitions 46 SirFile User s Guide...

Page 53: ...PDATE clock as page headers in various end user displays To keep track of the date and time of various changes to a file to enable predictions about file conditions using the TIME SVC modified by the...

Page 54: ...Date Processing 48 SirFile User s Guide...

Page 55: ...3 26 CFULLP 8 n scroll backward 13 26 CFULLP stat collection 9 Add 14 CRETRIES 7 Close 9 14 18 26 32 DFULLP 8 DELETE 14 EOVFLADD 8 F Find forward 13 26 EXTNADD 8 n scroll forward 13 25 Number of days...

Page 56: ...Index 50 SirFile User s Guide...

Reviews: