background image

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

SirFile User's Guide

(Model 204 File Monitor)

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

 

Sirius Software, Inc.

 

875 Massachusetts Avenue, Suite 21

 

Cambridge, MA 02139

Telephone: (617) 876-6677
FAX: (617) 234-1200
E-mail: [email protected]
World Wide Web: http://sirius-software.com

March 14, 2006

© 2006 Sirius Software, Inc.

Содержание SirFile 204

Страница 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...

Страница 2: ...ii SirFile User s Guide...

Страница 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...

Страница 4: ...Proprietary Notices iv SirFile User s Guide...

Страница 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...

Страница 6: ...Contents Index 49 vi SirFile User s Guide...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 22: ...Main File Menu 16 SirFile User s Guide...

Страница 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...

Страница 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...

Страница 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...

Страница 26: ...File Thresholds Screen 20 SirFile User s Guide...

Страница 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...

Страница 28: ...File Open Screen 22 SirFile User s Guide...

Страница 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...

Страница 30: ...File Detail Screen 24 SirFile User s Guide...

Страница 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...

Страница 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...

Страница 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...

Страница 34: ...File Tables Screen 28 SirFile User s Guide...

Страница 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...

Страница 36: ...Messages Screen 30 SirFile User s Guide...

Страница 37: ......

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 52: ...File statistics definitions 46 SirFile User s Guide...

Страница 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...

Страница 54: ...Date Processing 48 SirFile User s Guide...

Страница 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...

Страница 56: ...Index 50 SirFile User s Guide...

Отзывы: