Use Spectrum DCOLLECT Reporter to:

  • create regular production reports to monitor disk capacity and usage.
  • quickly run one-time queries to investigate DASD questions
  • turn DCOLLECT data into Web reports (HTML format)
  • convert DCOLLECT data into comma-delimited export files that lets you analyze or graph your DCOLLECT data in spreadsheet programs (example)

Support for DCOLLECT Records

The DCOLLECT file is a complicated file, containing many different record types. And the arcane data formats used in DCOLLECT records are rarely found in other files, requiring complicated conversion routines to make sense out of.

But Spectrum DCOLLECT Reporter makes it easy to produce reports from your DCOLLECT files. Spectrum DCOLLECT Reporter supports:

  • the unique DCOLLECT date format CYYDDDF - packed Julian, but with a leading century indicator (containing a 0 or 1).
  • DCOLLECT's "binary hundredths of seconds since midnight" timestamps and intervals
  • DCOLLECT's complex STCK (Store Clock) style timestamps and intervals, now in both 8- and 12-byte varieties
  • the testing and outputing of individual bits within a byte
  • unsigned, as well as signed binary fields, and packed decimal fields
  • floating point fields
  • gives you full computational ability to perform your own calculations
  • automatic calculation of subtotals, totals and other statistics
  • ability to sort and break on any number of fields, to organize the report in the way that is most useful to you
  • lets you chain to VSAM files or DB2 tables (for example, to expand a 4-byte System ID to a descriptive name.)
  • time functions that let you easily compute intervals between any two timestamps (even when they are stored in different formats)
  • powerful built-in functions for performing complex date calculations and manipulations, as well as string and math functions
  • plus all the powerful formatting functions to automatically present the raw data in an attractive report format

Want to Learn More?

Want to learn more about Spectrum DCOLLECT Reporter? You can also:
  • just scroll down further to see several sample DCOLLECT reports, or see a complete list of all of our DCOLLECT report examples
  • view our informative nine-lesson tutorial on making SMF reports.
  • check out the Spectrum DCOLLECT Reporter price list
  • download a free 30-day trial of this DCOLLECT reporting utility to start making reports right away!
  • send us your own questions or comments. We'll get back to you quickly with an answer.
  • or call us toll-free at 1-800-572-5517. We look forward to hearing from you.

 

What Are You Waiting For?
DCOLLECT Report Writer

Download your free trial of Spectrum DCOLLECT Reporter right now!

Run our sample DCOLLECT reports on your shop's data. Then make your own new DCOLLECT reports and PC-export files!

 
 

 
 

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

 
 

 
 

Sample VSAM Dataset Information Report
from DCOLLECT Type A 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 A (VSAM Association) records. (See DCOLLECT type A record layout.)

For each VSAM dataset, we show such information as: the type of VSAM file, its key information (if keyed), various record and operation counts, and the number of CI and CA splits.

Notice that we use Spectrum DCOLLECT Reporter's powerful computational ability to create a field with a value of KSDS, ESDS or RRDS (based on 3 bit flags in the record). This makes a more user-friendly report (compared to just showing some bit values).

We also used a logical COMPUTE statement to set the key information fields only for KSDS datasets (leaving them blank for non-keyed VSAM datasets).

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

INCLUDEIF: DCURCTYP = 'A'                                      
                                               
COMPUTE: TYPE = WHEN(DCAKSDS) ASSIGN('KSDS')                   
                WHEN(DCAESDS) ASSIGN('ESDS')                   
                WHEN(DCARRDS) ASSIGN('RRDS')                   

COMPUTE: RKP = WHEN(DCAKSDS)  ASSIGN(#FORMAT(DCARKP,4))        
COMPUTE: KLN = WHEN(DCAKSDS)  ASSIGN(#FORMAT(DCAKLN,5))        

COLUMNS:                                                       
  DCADSNAM(30)                                                 
  TYPE                                                         
  RKP                                                          
  KLN                                                          
  DCANLR('NUM|LOGICAL|RECS' 7)                                 
  DCADLR('NUM|DELETED|RECS' 7)                                 
  DCADLR('NUM|INSERTED|RECS' 8)                                
  DCADLR('NUM|UPDATED|RECS' 7)                                 
  DCACIS('NUM|CI|SPLITS' 5)                                    
  DCACAS('NUM|CA|SPLITS' 5)                                    

TITLE: 'VSAM DATASET INFORMTION'

 

Produce This DCOLLECT Report:


                                   VSAM DATASET INFORMTION

                                                  NUM     NUM     NUM      NUM    NUM   NUM
                                                LOGICAL DELETED INSERTED UPDATED  CI    CA
            DCADSNAM            TYPE RKP   KLN   RECS    RECS     RECS    RECS   SPLIT SPLIT
______________________________ ____ ____ _____ _______ _______ ________ _______ _____ _____

 USRACCT.VSAM.AIRLIST.D         KSDS   49     8      19       0        0       0     1     0
 USRACCT.VSAM.AIRLIST.I         KSDS   49     8       1       0        0       0     0     0
 USRACCT.VSAM.EMPLFILE.D        KSDS    0     3      18       2        2       2     2     0
 USRACCT.VSAM.EMPLFILE.I        KSDS    0     3       1       0        0       0     0     0
 USRACCT.VSAMESDS.SALEFILE.D    ESDS                 14       0        0       0     0     0
 USRACCT.VSAMESDS.TEMPFILE.D    ESDS                 70       0        0       0     0     0
 SYS1.VVDS.VVPWRKC              ESDS                  0       0        0       0     0     0

 *** GRAND TOTAL (     7 ITEMS)                     123       2        2       2     3     0

 
 

 
 

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

 

Spectrum SMF Writer - the 4GL SMF Report Writer.