On Wed, 9 Jan 2013 11:29:04 -0600, Jeffrey Agosta <[email protected]> wrote:
>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
An Internet search using argument string "dfsort outfil total site:ibm.com"
will identify an IBM.COM support document reference match for generating
totals/statistics.
Scott Barry
SBBWorks, Inc.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
