Re: DspSysSts vs. DspObjD - Where did all my disk go? -- MIDRANGE-L

telsci wrote:
> 
> When I do a DspSysSts, it tells me that I'm at 70% of 30GB = 21GB.
> 
> But when I do DspObjD and add it up, I get 13GB.
> 
> So where's the other 8GB?
> 
> Turns out that when you CRTPF the default reuse deleted records is *NO.
> So, when a record is deleted, its space is not reused.  This is to keep the
> file in arrival sequence, for those non-relationals amongst us.
> 
> Anyway, I think my 8GB might be (mostly) in deleted records!  Does anyone
> know this with certainty?  And I know I'm starting to sound like an
> auditor, but shouldn't DspSysSts and DspObjD agree?
> 
> If I RGZPFM, it doesn't help.  I have to CHGPF first, to set reuse deleted
> records to *YES, then RGZPFM.  The RGZPFM takes a long time and rebuilds
> indecies, which is bad when users are online.
> 
> Thanks in advance for answering my above questions.
> 
> Yours Truly
> Peter Lunde
> 
Pete,

   DSPOBJD does include deleted records in calculating the size of the
file.  There are many performance issues about using "reuse deleted
space", so you might wish to be very careful on that.  As for RGZPFM
when users are online, that is a big mistake.  THis is a weekend or
night-time job that should be run when you don't have users on the
system, and you are not running batch jobs which maybe using the
physical file, or the logical file. 

   There is a known problem with calculating the size of objects using
ODOBSZ of the DSPOBJD command.  If an object is over a certain size
(don't recall if it is 1GB or 10GB, the system reports the wrong size). 
You are better off multiplying the field that contains the pagesize by
the number of pages to come up with the exact size of the object no
matter what size the object is. 

   Another way of not seeing some objects is that you maybe running this
command from an id that does not have *ALLOBJ authority. Are you saying
*ALL/*ALL *ALL for lib/obj and type respectively? I can't believe that
you have that much temporary space, but what you may need to do is a
RCLSTG.  THis might clean up your system somewhat.  

   In any case 8GB out of 30GB is a lot to not be found. If you want to
discuss this any further, give me a call.

HTH 
Pete Massiello
OS Solutions International 
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *