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

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

Dale

On Sat, Jun 7, 2014 at 2:14 AM, Dario Trussardi <[hidden email]> 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
[hidden email]
http://lists.gemtalksystems.com/mailman/listinfo/glass

_______________________________________________
Glass mailing list
[hidden email]
http://lists.gemtalksystems.com/mailman/listinfo/glass

On Sat, Jun 7, 2014 at 9:55 AM, Dale Henrichs <[hidden email]> 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.