[Glass] small database

[Otto Behrens]

Hi,

I missed that we set the STN_FREE_SPACE_THRESHOLD to 2GB, which always
keeps at least 2GB free space. @Lourens van Nieuwenhuizen
<LvNieuwenhuizen at momentum.co.za> helped out to find the setting.

Thanks

Otto Behrens

+27 82 809 2375
[image: FINWorks]
[image: FINWorks] <http://za.linkedin.com/in/waltherbehrens>
www.finworks.biz

Disclaimer & Confidentiality Note: This email is intended solely for the
use of the individual or entity named above as it may contain information
that is confidential and privileged. If you are not the intended recipient,
be advised that any dissemination, distribution or copying of this email is
strictly prohibited. FINWorks cannot be held liable by any person other
than the addressee in respect of any opinions, conclusions, advice or other
information contained in this email.


On Fri, Jun 10, 2022 at 6:56 AM Otto Behrens <otto at finworks.biz> wrote:

> Hi,
>
> We have a database that we build from $GEMSTONE/bin/extent0.dbf; we load
> seaside & magritte and then our code base. When we are done, the extent is
> 2.3GB. We get the following:
>
> run
> SystemRepository fileSizeReport
> %
> Extent #1
>    Filename = /var/local/gemstone/extent/extent0.dbf
>    File size =           2.3 GB
>    Space available =     2.0 GB
>
> We try doing a GC & reclaim. Then backup and restore. The result stays the
> same.
>
> I would like to remove the free space and reduce the extent size.
>
> How do I do that?
>
> Otto Behrens
>
> +27 82 809 2375
> [image: FINWorks]
> [image: FINWorks] <http://za.linkedin.com/in/waltherbehrens>
> www.finworks.biz
>
> Disclaimer & Confidentiality Note: This email is intended solely for the
> use of the individual or entity named above as it may contain information
> that is confidential and privileged. If you are not the intended recipient,
> be advised that any dissemination, distribution or copying of this email is
> strictly prohibited. FINWorks cannot be held liable by any person other
> than the addressee in respect of any opinions, conclusions, advice or other
> information contained in this email.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gemtalksystems.com/mailman/archives/glass/attachments/20220610/8cd867cb/attachment.htm>