RE: How to see if *LF's are being used...

["Graap, Ken" <keg@xxxxxxxxxxxxxxx>]

Well, I want to thank everyone for all the helpful information that was
posted in response to my question....

I ended up using DSPOBJD to an *OUTQFILE and then I created a query which
selected all logical files that had a use count of zero....

It looks like I may have found around 2.8GB's of storage I can recover!

Here is what I discovered:

Object      Library     Object      Creation  Days Used   Object
                        Attribute   Date      Count       Size

UBLHRSA     P1FILES     LF           112297      0   1,009,795,072
UBLHURP     P1FILES     LF           071097      0     628,113,408
UBLHRCUS    P1FILES     LF           110898      0     601,899,008
UBLHBSB     P1FILES     LF           032899      0     535,859,200
UBLHRSO     P1FILES     LF           110898      0     109,064,192

Thanx again everyone.

Kenneth

--
********************************
         Kenneth  E.  Graap             
    IBM Certified Specialist                 
          AS/400   Professional                   
          System  Administrator                  
 NW Natural - Information Services        
           System Services                         
        503 226 4211 X5537                 
          FAX  503 721 2521                  
      keg@nwnatural.com               
********************************


-----Original Message-----
From: R. Bruce Hoffman, Jr. [mailto:rbruceh@ibm.net]
Sent: Monday, May 10, 1999 11:43 AM
To: MIDRANGE-L@midrange.com
Subject: Re: How to see if *LF's are being used...


Graap, Ken wrote:
> 
 
> My boss wants to know if there are any logical files on the system that
have
> never been used....
> 

Yuch.  Used for what?  If you perform queries, SQL or OPNQRYF, the
logical files may be used, but I don't know if the usage information on
the object gets updated.

Otherwise, just check the last used date on the objects.  DSPOBJD to
output file and query.


-- 
===========================================================
R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Administrator

-- The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---