Subject Re: [firebird-support] Repeated database corruption
Author Gustavo
Thank you very much for your help.

I did gstat -h with one database and I got the following. I don?t find anything called "data page cache" but I guess perhaps what I have to check is "Page buffers", which is 0. Is it right what I am saying?

Database header page information:
Flags 0
Checksum 12345
Generation 1720
Page size 4096
ODS version 11.1
Oldest transaction 1710
Oldest active 1711
Oldest snapshot 1711
Next transaction 1712
Bumped transaction 1
Sequence number 0
Next attachment ID 7
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Oct 21, 2009 22:39:25
Attributes force write

Variable header data:
Sweep interval: 20000
*END*


----- Original Message -----
From: "Dimitry Sibiryakov" <sd@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, October 22, 2009 3:30 PM
Subject: Re: [firebird-support] Repeated database corruption


>> At server level, I found at firebird.conf, the configuration
>> DefaultDbCachePages. There it says that for Super Server the default is 2048
>> and for Client Server is 75. Is this configuration what I have to set
>> between 256 and 1024?
>
> Yes.
>
>> And where do I configure data page cache at database level?
>
> 'gstat -h' will show you if you have it set for a particular
> database. 'gfix -buffers' will allow you to change this setting, but I
> would advice you not to do it.
>
> You can find description of both these utilities in Operations Guide
> on documentation web page.
>
> SY, SD.
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]