background image

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

Main File Menu

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

 

Top

 

Moves the display to the top of the file list.

 

Bottom

 

Moves the display to the bottom of the file list.

 

M

 When 

using 

PF7

 or 

PF8

 , scroll up or down to the top or

 

bottom of the list of files.

 

ADD xxxxxxxx

 

Add the specified file to the database. 

SirFile

 attempts to

 

open the file.  If the file cannot be opened the user is

 

prompted for a password on the separate password

 

screen.  Once the file is open 

SirFile

 analyzes the file

 

tables, stores a file record and returns to the Main File

 

menu, where the new file will appear.

 

REFRESH xxxxxxxx

 

REFRESH performs the same function as the ADD

 

command if the specified file is not already in the

 

database.  If the file 

is

 in the database its tables are

 

checked, and a record is stored for the file if the specified

 

number of days has passed since the last sample, or if a

 

threshold has been exceeded.

 

OPEN xxxxxxxx

 

Opens a file.  As data can only be collected for files that

 

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.

 

CLOSE xxxxxxxx

 

Closes a file.  Any file that the 

SirFile

 user has open can be

 

closed, except SIRFILE, SIRLOCAL and CCASYS (the

 

required application subsystem files for 

SirFile

).

 

DELETE xxxxxxxx

 

Removes the file from the 

SirFile

 database.  It is never

 

necessary to delete a file from 

SirFile

, but if a file is

 

obsolete, or is never allocated to the online region, the

 

SirFile

 administrator may find it inconvenient to always be

 

prompted for passwords when the file cannot be opened

 

during a refresh.  DELETE removes all records associated

 

with the file: warnings, history and thresholds.

 

TIME xxxx yy

 

Puts the screen into auto-refresh mode.  The screen will

 refresh 

xxxx

 times every 

yy

 seconds.  This command does

 

not invoke the refresh process each time it wakes up, so it

 

is only useful if a background task (or some other user) is

 

running occasional refreshes, and this screen is used to

 

view the changed information.

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

14

 

SirFile User's Guide

Содержание 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...

Отзывы: