








	*DCOLLECT Tools*

Sample Space Usage Report
from DCOLLECT Type D 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 D (Active Data Set) records. (See DCOLLECT type D record layout.)

We select only datasets residing on the volume we are interested in (volume serial VPWRKC). For each active dataset, we compute the percentage of allocated space that is actually used. We only include in our report just thoses datasets whose percent of allocated spaced used is at least 90%.

Our report shows the allocated and used space information, as well as some dataset attributes (LRECL, BLKSIZE and Creation Date). The report is printed in descending order of percentage space used.

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: PERCENT_USED(0,DIVTOTS) = (DCDUSESP * 100) / DCDALLSP 

INCLUDEIF: DCURCTYP = 'D'                                      
           AND DCDVOLSR = 'VPWRKC'                             
           AND PERCENT_USED >= 90                              

COLUMNS:                                                       
  DCDDSNAM(30)                                                 
  DCDALLSP('ALLOC|SPACE' 7)                                    
  DCDUSESP('USED|SPACE' 7)                                     
  PERCENT_USED(7 NOACC)                                        
  DCDBKLNG('BLKSIZE' 7 NOACC)                                  
  DCDLRECL('LRECL' 6 NOACC)  
  DCDCREDT('CREATED')     
                                 
SORT:  PERCENT_USED(D)                                
BREAK: DSDVOLSR NOTOTALS                                       

TITLE: 'DATASETS USING 90% OR MORE OF ALLOCATED SPACE'         
TITLE: 'FOR VOLUME: VPWRKC'

Produce This DCOLLECT Report:


                DATASETS USING 90% OR MORE OF ALLOCATED SPACE                 
                                VOLUME: VPWRKC                                

                                ALLOC   USED   PERCENT                        
           DCDDSNAM             SPACE   SPACE   USED   BLKSIZE LRECL  CREATED 
______________________________ _______ _______ _______ _______ ______ ________
                                                                              
SYS1.VTOCIX.VPWRKC                 775     775     100   2,048  2,048 08/14/07
USRACCT.SPLWORK2.COPYLIB           830     830     100  23,440     80 01/08/12
USRACCT.TEMP.VBFILE84.DATA          55      55     100  23,300     84 12/21/14
USRACCT.BNK182.DATA            214,150 213,652     100  27,998 32,767 07/20/09
USRACCT.BNK.ASM                 37,352  36,798      99  23,440     80 02/25/11
USRACCT.BNK100.INTSAVL.DATA     10,791  10,569      98  27,998 32,760 09/15/13
USRACCT.QW200.BK141118          57,217  55,779      97  23,440     80 11/18/14
USRACCT.TEMP.QWROUND.DATA        1,162   1,107      95  23,440     80 12/06/14
USRACCT.TEMP.DYLROUND.DATA       1,162   1,107      95  23,440     80 12/06/14
USRACCT.BNK30.UBS2STEP.DATA     10,791  10,182      94  32,760 32,756 02/13/13
USRACCT.BNK.UBS120.DATA          2,490   2,324      93  32,004 32,000 03/22/11
USRACCT.ST400.ASM               49,802  46,095      93  23,440     80 10/19/12
USRACCT.SPBNKINF.COPYLIB        41,502  37,960      91  23,440     80 08/30/09
                                                                              
*** GRAND TOTAL (    13 ITEMS) 428,079 417,233

;

Spectrum SMF Writer - the 4GL SMF Report Writer.

Sample Space Usage Report from DCOLLECT Type D Records

These Spectrum DCOLLECT Reporter Statements:

Produce This DCOLLECT Report:

Sample Space Usage Report
from DCOLLECT Type D Records