RE: DSPFD & dates

[Scott Mildenberger <scottmildenberger@xxxxxxxxx>]

Well, one thing I noticed is that running DSPFD will update the
extract date/time(s) but not the last used :)  I know that
running a program that uses the file will update the 'last used'
but I don't know if SQL or OPNQRYF updates this if the logical
is used as an index to perform a query.  I almost don't think
they do but this could be tested easily enough.  I would be
careful deleting logicals that you think aren't used because
they may be avoiding building indexes on the fly in places.  I
know this because someone here once was being helpful and
cleaned up unused logicals, performance of some jobs/programs
just became terrible.  So be careful :)

Scott Mildenberger

--- "Graves, Chuck" <cgraves@xxxxxxxxxxxxxx> wrote:
> 
> 
> When you do a DSPFD on a logical file, you get:
> 
> last used date
> last extract date/time
> extract date/time
> 
> I even get files with last used date = *BLANK, yet the extract
> & last
> extract dates/times have values...
> 
> I'm trying to determine if I have unused logicals which I can
> delete...
> 
> Can someone tell me what the difference in these dates is?
> 


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com