Hello Esteemed Listers -

I have a question related to a dcollect that we are using here.

The current process does a dcollect as follows:

DCOLLECT OFILE(DD1) ELIMIT(50) STOG(BACKUP,    -       
                                                             DB2DATA,   -       
                                                             DB2TEMP,   -       
                                                             DB2LOG2,   -       
                                                             DB2WORK) 
NODATAINFO 

Generating a file for input to iceman. 

Typical record in the file:

----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
 µ  V   PRD1  ·  ¤  DB21AJX  ß[ç jM  Ô Ã  V  ùÉ  /  3390
--+----8----+----9----+----0----+----1----+----2----+----3----+----4----
    Í  DB2DATA                       2107      ß[ç jM  Ô Ã  V  ùÉ
+----5
  /  


Then iceman sorts the file with the following parm:

   SORT FIELDS=(87,6,CH,A)                                  
OUTFIL FNAMES=RPT1,NODETAIL,CONVERT,OUTREC=(1,80),          
       HEADER1=('                                      ',/, 
                'THE STATUS OF THE POOLS ARE AS FOLLOWS'),  
       SECTIONS=(87,6,                                      
       TRAILER3=(1:'STORGRP   ',87,8,20:' # OF VOLS',       
       COUNT,40:'% AVAIL',AVG=(40,1,BI)))                   

Which produces:

THE STATUS OF THE POOLS ARE AS FOLLOWS           
STORGRP   BACKUP      # OF VOLS      12  % AVAIL 47
STORGRP   DB2DATA    # OF VOLS      36  % AVAIL  4
STORGRP   DB2LOG2    # OF VOLS       4  % AVAIL 52
STORGRP   DB2TEMP    # OF VOLS       6  % AVAIL 27
STORGRP   DB2WORK   # OF VOLS       3  % AVAIL 83

My question is, how to also provide a value for the total space per storgrp, 
does anyone have the expertice to do so?
  
Thank you kindly for you assistance,
Jeff A

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to