Re: Last Used date field

John Earl wrote:

> Dana,
>
> At 11:13 AM 10/22/97 -0400, you wrote:
> >Hello all,
> >
> >I've got a question.
> >
> >I'm trying to clear up some files in my production environment and would like
> >to remove orphaned or seldomly used files.
>
> I'd be carefull with the "seldomly used files" part.  They may only be used
> once a year, but are essential to that once a year process.
>
>   I created a file that contains
> >all the files in the library and wrote a quick CL program to DSPFD (*mbr)  to
> >an outfile.  I queried the file and found that of the 540 some odd files only
> >about 20 % have been used.  Here's the question.  What is the basis of this
> >information?  Is it updated automatically by the OS when the file is opened?
>
> Yes.
>
> > When are these fields updated?   I'm using the last used date field for my
> >query.  I also had a problem and needed to restore the library last week.
> > Does this reset the last used date and time fields?
>
> Yes again.  Not only does a restore clear the 'Last Used Date', but it also
> changes the 'Last Change Date' field to be equal to the restore date. :(
>

If you do a DSPFD on the files there are fields that show the last date and time
that the records in each member were updated. I am pretty sure that these
NON-OBJECT fields are not updated by the restore.

> >Is there a better way
> >to do this? Any help would be appreciated.
>
> Likely not.  In the past I have done a DSPOBJD *ALLUSR/*ALL to an outfile
> and saved that outfile indefinetly for later reference.  It's imperfect, but
> it does give you some information.
>
> hth,
>
> jte
>
> *************************************************
> * John Earl             johnearl@blarg.net      *
> * 8514 71st NW          Gig Harbor, WA 98335    *
> *************************************************
>

Roger Vicker, CCP

--
*** Vicker Programming and Service *** Have bits will byte ***
One of the advantages of being disorderly, is that one is constantly making
exciting discoveries. -- Bob Moawad



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---