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

To
Peter Lunde

In case of keyed database files,there is no need to use CHGPF command to set
the reuse deleted records to *YES.The command RGZPFM works perfectly.In case
of files with no keyfields,the arrival sequence is the only processing
method that allows
a program to use the storage space previously occupied by a deleted record
by placing
another record in that storage space.Another method,in which the system
manages the space created by deleting records,is the reuse deleted records
attribute that can be 
specified for physical files.

Srinivas
Software engineer,
SRIVEN COMPUTER SOLUTIONS LTD
Hyderabad,
INDIA.

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.
>
>Thanks in advance for answering my above questions.
>
>Yours Truly
>Peter Lunde
>
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* 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   *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>umidr
>
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *