Subject | Re: [firebird-support] Running gstat |
---|---|
Author | Aldo Caruso |
Post date | 2013-03-05T21:17:03Z |
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ó:
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ó:
>[Non-text portions of this message have been removed]
> 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
>
>