Sample Disk Volume Statistics Report
from DCOLLECT Type V Records
The sample DCOLLECT report below was created with Spectrum DCOLLECT Reporter, Pacific Systems Group's low-cost 4GL DCOLLECT report writer.
It reads as input the DCOLLECT file and selects just the type V (Disk Volume Information) records. (See DCOLLECT type V record layout.)
Our report shows the volume's total capacity, free capacity and percent of free capacity. It also shows the fradementation index. We examine the "public" and "private" bit flags in the record; we use them to set a user-friendly type field to show in the report.
All of this with just a few lines of code!
Why not install a Spectrum DCOLLECT Reporter trial right now and start making your own DCOLLECT reports!
These Spectrum DCOLLECT Reporter Statements:
INPUT: DCOLLECT
COMPUTE: TYPE = WHEN(DCVUSPVT) ASSIGN('PRIVATE')
WHEN(DCVUSPUB) ASSIGN('PUBLIC')
INCLUDEIF: DCURCTYP = 'V'
COLUMNS:
DCVVOLSR('VOLUME')
TYPE
DCVFRESP('FREE|SPACE|KB' 10)
DCVVLCAP('VOLUME|CAPACITY|KB' 10)
DCVPERCT('PERCENT|FREE|SPACE' 7)
DCVFRAGI('FRAGMENTATION|INDEX')
SORT: DCVVOLSR
TITLE: 'VOLUME STATISTICS'
Produce This DCOLLECT Report:
VOLUME STATISTICS
FREE VOLUME PERCENT
SPACE CAPACITY FREE FRAGMENTATION
VOLUME TYPE KB KB SPACE INDEX
______ _______ __________ __________ _______ ______________
VPWRKA PRIVATE 1,476,528 2,490,117 59 4
VPWRKB PRIVATE 1,519,137 2,490,117 61 4
VPWRKC PRIVATE 853,003 2,490,117 34 42
VPWRKD PRIVATE 2,342,314 2,490,117 94 0
*** GRAND TOTAL ( 4 ITEMS)
6,190,982 9,960,468 248 50
;
