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

At 04:22 PM 8/15/97 -0400, you 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.

I don't think that the deleted records issue is related to your problem,
but there are many factors that could be.  

I suggest that you use GO DISKTASKS with *ALLOBJ authority to analyze your
disk space.

Al



Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *