Subject Re: [firebird-support] Running gstat
Author Aldo Caruso
Hello Dmitry !

Thanks for your answer.
I read that on "The Firebird Book" by Hellen Borrie, first edition,
page 330

I quote:

*/gstat on POSIX/*/
//Because *gstat* accesses database files at the filesystem level, it is
necessary on Linux and UNIX platforms to have system-level read access
to the file//
/
Aldo Caruso

El 05/03/13 16:30, Dmitry Kuzmenko escribió:
>
> Hello, Aldo!
>
> Tuesday, March 5, 2013, 9:19:02 PM, you wrote:
>
> AC> Hi,
>
> AC> I read that gstat access directly to the database file in the host
> AC> file system, so it must be run logged in it.
>
> who said that to you? Gstat access db file directly only with -h
> option, and with other options it does not access directly the
> database file and does not need any "exclusive access" or something
> to the database, even with -h.
>
> AC> Should I have to shutdown the database previously or it can be run
> AC> concurrently with client applications which are connected to the
> database ?
>
> not at all. run gstat -a -r or gstat -h whenever you wish, while users
> are working.
> The only effect of gstat -r will be that it will read the whole
> database, and for the big file (10, 20, etc gigabytes) it can take
> some time, and with poor storage it can affect performance (not so
> much).
>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>
>



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