[Glass] Compacting extent as part of the daily cleanup/backup scripts? Re: Compact a extend0.dbf

[Mariano Martinez Peck]

On Sat, Jun 7, 2014 at 9:55 AM, Dale Henrichs <
dale.henrichs at gemtalksystems.com> wrote:

> Dario,
>
> The procedure for compacting extent files is:
>
>   1. make a full backup
>   2. shut down stone
>   3. cp a virgin extent ($GEMSTONE/bin/extent0.seaside.dbf) into your
>       data directory
>   4. start stone
>   5 restore from backup
>
>
Hi Dale,

I had a similar scenario today. My extent is about 11GB and 9GB out of them
are free. I get that doing   '(SystemRepository freeSpace / 1024 / 1024 )
asFloat  greaseString'.
So...yes, yeah, I would like to compact this extent.

Now...I have backup and cleanup strings every day which do a MFC and
reclaim, make full backup, and remove unnecessary tranlogs according to
last backup. Very much as the script you provided me from ss3.  So I was
wondering if the compact of the extent could also be part of this scripts.
 Would it be worth?  I guess I must measure myself right? I mean, I can
compacting it a the beginning of a business day, and see how much free
space I have again at night? Then regarding that answer, I can consider
whether do this daily, or weekly or ...

Another question is...I guess that when you make the extent bigger there is
some cost associated. So...I don't want to be compacting frequently (say
every day) if then the app will run slower because it is making bigger the
extent all the time.

Thanks in advance,




> Dale
>
>
> On Sat, Jun 7, 2014 at 2:14 AM, Dario Trussardi <
> dario.trussardi at tiscali.it> wrote:
>
>> Ciao,
>>
>>         i have a 3.1.0.4   extend0.dbf   file  with dimensions of 13GB.
>>
>>         The     SystemRepository freeSpace     report    more of 12 GB .
>>
>>         Now my questions is :
>>
>>                 i can compact the  extend0.dbf          so as to have a
>> more manageable file.
>>
>>         If yes the compacting it 's a long time procedures?
>>
>>         It's a risky procedure ?
>>
>>
>>         Thank for any help,
>>
>>
>>                 Dario
>> _______________________________________________
>> Glass mailing list
>> Glass at lists.gemtalksystems.com
>> http://lists.gemtalksystems.com/mailman/listinfo/glass
>>
>
>
> _______________________________________________
> Glass mailing list
> Glass at lists.gemtalksystems.com
> http://lists.gemtalksystems.com/mailman/listinfo/glass
>
>


-- 
Mariano
http://marianopeck.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gemtalksystems.com/mailman/private/glass/attachments/20140818/84b1db7f/attachment-0001.html>