Re: DB2 file statistics

[Charles Wilt <charles.wilt@xxxxxxxxx>]

DSPFD

Data Space Activity Statistics  . . . . . :
  Data space size in bytes  . . . . . . . :          503533568
  Physical file open accesses . . . . . . :                       470,306
  Physical file close accesses  . . . . . :                       470,136
  Write operations  . . . . . . . . . . . :                        16,599
  Update operations . . . . . . . . . . . :                       128,620
  Delete operations . . . . . . . . . . . :                           429
  Logical Reads . . . . . . . . . . . . . :                   331,083,147
  Physical Reads  . . . . . . . . . . . . :                     3,797,299
  Clear operations  . . . . . . . . . . . :
  Data space copy operations  . . . . . . :
  Reorganize operations . . . . . . . . . :

HTH,
Charles

On Fri, Jan 7, 2011 at 2:57 PM,  <Blake.Moorcroft@xxxxxxxxxx> wrote:
> Hello all...
>
> I remember reading in a text, awhile ago, that read/write/delete
> statistics were kept in various tables on the iSeries.  We've got a
> request to conduct an analysis to determine if we have files that require
> removal and unfortunately we cannot use the last used date on the file
> because our mirroring software messes with that.  Our thought was to use
> the statistics to determine if a file has had any file access during a
> specified time period, we could hit it with a quick report program and
> pull details for further analysis.
>
> Does anyone know of such a file (or files)?
>
> Have a good day.
>
>
> Blake Moorcroft
> Analyst/Programmer - Corporate
> Russell A. Farrow Limited
> 1980 Ambassador Drive, PO Box 333, Windsor, Ontario N9C 3R4
> Bus: 519-966-3003 ext. 566, Fax: 519-966-9870
> blake.moorcroft@xxxxxxxxxx
>
>
> This electronic message contains information from Russell A. Farrow
> Limited, Russell A. Farrow (U.S.) Inc., canadaplus.com or RAF Express
> Inc., that may be confidential or privileged. The information in this
> electronic message is only for the use of the intended recipient.
> Inappropriate disclosure, copying, distribution or other use of the
> contents of this electronic message is strictly prohibited. If you have
> received this electronic transmission in error, please notify the sender
> immediately by return e-mail. Thank you.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.