This chapter shows you how to use VDM to generate current usage reports.
Usage reports show the number of disk blocks each user currently has allocated, contrasts it with the allocation on some previous date and flags possible problems. Use usage reports to detect large increases in accounts and users who are nearing their quota. Usage reports allow you to manage disk resources by highlighting change.
Department & project analysis
VDM allows you to analyze usage by owner or account as well as username. This gives you three independent ways to summarize individual user disk allocations. If you set up your SYSUAF carefully, you can get useful department and project reporting with minimal cost and effort.
Selecting and summarizing disk drives
You can select one or more disk drives using the /DISK qualifier. If you specify the /SUMMARY qualifier, the drives will be summarized into a single report. Otherwise, each disk will be presented in a separate report.
Sorting criteria
You can generate usage reports in several sequences. You select a sequence using the /SEQUENCE qualifier.
/SEQUENCE=USERNAME shows disk allocations by username. Username is an OpenVMS code consisting of 1 to 12 alphanumeric characters assigned by systems managers to identify users. A sample username might be "GEORGE".
/SEQUENCE=UIC shows disk allocations by UIC. UIC is an OpenVMS code consisting of a group and member number separated by a comma and enclosed in brackets. It is assigned by systems managers to group users together. A sample UIC might be "[1,4]" or "[88,21]". This criteria can be used to generate project or department summaries from the VDM data. VDM allows you to display UICs in alphanumeric form such as "[ENG,ANN]". If the UIC does not have a corresponding record in the UAF, it is flagged with an "*".
/SEQUENCE=GROUP summarizes the data by group as opposed to the entire UIC.
/SEQUENCE=ACCOUNT shows disk allocations by account. Account is a 1 to 8 alphanumeric character description field in the UAF. It is assigned by systems managers to group users together. A sample account string might be "Project9". It can be used to group users together independently of UIC or username. Thus, it can be used to generate project or department summaries from the disk usage data.
/SEQUENCE=OWNER shows disk allocations by owner. Owner is a 1 to 31 alphanumeric character description field in the UAF. It is assigned by systems managers to group users together. A sample account string might be "Accounts Payable Dept". It can be used to group users together independently of UIC, username or account. It also can be used to generate project or department summaries from the VDM data.
/SEQUENCE=DIRECTORY shows disk allocations by directory. VDM truncates the directory to 50 characters for reporting purposes. Refer to the chapter "Generating directory reports" in this manual for more information.
/SEQUENCE=DISK shows disk allocations by disk. This is a summary report by disk; each disk occupies one line on the report. Use it to get a one-page overview of your disk status.
Selecting only large accounts
Use the /SIZE qualifier to select accounts with a minimum disk usage. Use this qualifier to limit the report to the major accounts where problems are most frequent.
Detecting accounts with large increases
VDM flags users whose accounts are increasing rapidly in size. You specify a percentage increase using the /LARGE_CHANGE qualifier and VDM flags current usage lines with "*" if their percentage change exceeds the amount you've specified. The default for large change is 20%.
Detecting users nearing their quota
VDM flags users whose allocations are close to their quota. You specify a percentage using the /NEAR_QUOTA qualifier and VDM flags the percent quota field with "*" if their percentage quota exceeds the amount you've specified. The default for near quota is 80%.
Reporting only exceptions
Use the /EXCEPTION qualifier to display the users who are flagged for "large change" or "near quota". This will allow you to see the potential "problem" users in the report rather then all users. On a large system with many users, this can be a great convenience.
Setting quotas
One of the problems with establishing quotas on OpenVMS is deciding on their initial size and adjusting them as the needs of the users change. VDM provides an easy way to determine quota values since it maintains both an average and a maximum value for each account. Based on those numbers, you can establish a quota which controls users without constraining them unnecessarily.
Report headings
The current usage report headings contain the following information:
• Report name
• Run date and time
• Node name
• Selected disk drive(s)
• Near Quota threshold
• Large Change threshold
These heading fields record all the options you entered on your VDM/REPORT command. The current and previous dates are displayed over the appropriate column headings.
Report fields
The current usage report contains the following fields:
Key - contains the username, account, owner, UIC, directory or disk depending on the /SEQUENCE qualifier. There is one line on the report for each entity which has disk blocks allocated.
Previous usage - contains the number of disk blocks the user had allocated on some previous date. You specify the date using the /PREVIOUS qualifier.
Current usage - contains the current number of disk blocks the user (account, owner, etc.) has allocated. You specify the date using the /CURRENT qualifier.
Percentage of blocks allocated - indicates what percentage of the total disk blocks this user has. It is calculated using the formula:
(Current / Total Allocated) X 100
Percentage change from previous - indicates by what percentage the account has changed since the previous run. It is calculated using the formula:
((Current _ Previous) / Previous) X 100
The report contains a warning "*" after this field if it exceeds a percentage you indicate with the /LARGE_CHANGE qualifier. If /EXCEPTION has been specified, the "*" is omitted.
Disk quota - contains the maximum number of blocks the user is allowed to have allocated. If quotas are not active during VDM data collection, the quota field will contain zero. If quotas are active during VDM data collection but not enabled, the quota field will contain the default quota. On summary reports, the individual quotas are added together and their
total is shown.
Percentage of quota - indicates what percentage of their account quota this user has used up. It is calculated using the formula:
(Current / Quota) X 100
The report contains a warning "*" after this field if it exceeds a percentage you indicate with the /NEAR_QUOTA qualifier. If /EXCEPTION has been specified, the "*" is omitted.
Average usage - contains the average number of blocks the user has had allocated since the last reset. This number is updated after the data collection run. Refer to the chapter "Resetting Averages" for an explanation of how the average is calculated.
Maximum usage - contains the maximum number of blocks the user has allocated since the last reset. This number is updated (if necessary) after the data collection run.
Percentages and rounding
The current usage reports contain several percentages. To present a concise, readable report, these percentages are all rounded, on the report, to ONE decimal place. (ie 23.42 becomes 23.4 and 56.87 becomes 56.9). This means the individual percentages may not always total 100 exactly.
Overflow, underflow and undefined numbers
If an observed value is too large to be shown in a report field, it is replaced by "999M". If an observed value is too small to be shown in a report field, it is replaced by "-999M". If a calculated value involving a previous number is undefined because there is no previous number, it is shown as "0" and flagged as undefined.
Non-labelled UICs and identifiers
UICs and identifiers which do not have a corresponding record in the SYSUAF or the RIGHTS list are listed at the end of the report. You should check these UICs and identifiers to see if there is a problem. In /SEQUENCE=UIC reports these records are included in the body of the report; to help differentiate them from valid UICs they are flagged with an "*".
Examples
$ VDM /REPORT=CURRENT /PREVIOUS=01_NOV_96 /SEQUENCE=USERNAME -
/SUMMARY /NEAR_QUOTA=90
Produce a current usage report by username for all disk drives using November 1st, 1993 for the previous numbers. Any user with 90% or more of their quota allocated will be flagged.
$ VDM /REPORT=CURRENT /SEQUENCE=UIC /LARGE_CHANGE=15 -
/DISK=(DRA1:,DRA2) /EXCEPTION
Produce a current usage report by UIC for the disk DRA1: and DRA2. Only the UICs which have changed by more than 15% will be printed in the report.
$ VDM /Report=current /seqeunce=username /size=5000 /current=15-dec-99
Produce a current usage report by username for all disks using December 15th as the date for the current numbers. Only users which have 5,000 or more blocks allocated will be printed in the report. The date used for PREVIOUS will be determined by VDM and will be earlier than CURRENT.
$ VDM/report=current/sequence=owner/summary/current=15-dec-99
Produce a current usage report by owner for all disks using December 15th as the date for the current numbers. Since /LARGE_CHANGE and /NEAR_QUOTA were not specified, VDM will use default values of 20 and 80 percent to flag lines in the reports. The date used for PREVIOUS will be determined by VDM and will be earlier than CURRENT.
$ VDM /report=current /sequence=detail /current=30-nov-1999
Generate the new detail report showing disk usage as of November 30, 1999, for each user. A separate page is generated for each user showing all the disks that user has files on and the total usage. This report is new with Version 7 of VDM and is an ideal tool for providing backup to RA disk billing values or for cleaning up disks.