Comparing sizes of the same file

[rsalva0630]

Hello Everyone,

I wrote a program to display files from the system and their size in bytes, then put that information in a physical file. I have this program running monthly and adding to this file. I want to compare the file size growth over the last month. What would be the best way to do this?

[DeadManWalks]

Re: Comparing sizes of the same file

please show us what the definition of the table loos like and a few rows of sample data.

[egami]

Re: Comparing sizes of the same file

I just use DSPFD data dumped to an output file and a handful of SQL statements to evaluate the data. Easy to stay on top of file growth, deleted records and other information.

[B.Hauser]

Re: Comparing sizes of the same file

Why not simple getting this information from theSYSTABLESTAT catalog views located in the QSYS2 library?

Birgitta

[jackc]

Re: Comparing sizes of the same file

Add a column to store the date you captured the file size?

That way you could compare the change between any two dates where you have data. Or even a time series