> gstat is not included in the Firebird release I downloaded:
>
> C:\Firebird>dir
> Volume in drive C has no label.
> Volume Serial Number is FA80-0C12
>
> Directory of C:\Firebird
>
> 09/29/2014 02:25 PM <DIR> .
> 09/29/2014 02:25 PM <DIR> ..
> 09/29/2014 01:16 PM 105,717 Firebird-2.1-ErrorCodes.pdf
> 09/29/2014 01:06 PM 1,159,676 Firebird-2.5-LangRef-Update.pdf
> 09/29/2014 01:06 PM 245,583 Firebird-2.5-QuickStart.pdf
> 09/29/2014 01:00 PM 10,467,361 Firebird-2.5.3.26778-0_Win32.zip
> 09/29/2014 01:01 PM 12,259,685 Firebird-2.5.3.26778-0_x64.zip
> 09/29/2014 01:00 PM 6,973,448 Firebird-2.5.3.26778_0_Win32.exe
> 09/29/2014 12:58 PM 10,282,876 Firebird-2.5.3.26778_0_x64.exe
> 09/29/2014 01:14 PM 85,664 Firebird-fbmgr.pdf
> 09/29/2014 01:16 PM 71,972 Firebird-File-Metadata-Security.pdf
> 09/29/2014 01:12 PM 133,557 Firebird-gbak.pdf
> 09/29/2014 01:15 PM 90,111 Firebird-Generator-Guide.pdf
> 09/29/2014 01:13 PM 133,621 Firebird-gfix.pdf
> 09/29/2014 01:11 PM 89,144 Firebird-gsec.pdf
> 09/29/2014 01:14 PM 47,968 Firebird-gsplit.pdf
> 09/29/2014 01:13 PM 90,958 Firebird-gstat.pdf
> 09/29/2014 01:11 PM 225,636 Firebird-isql.pdf
> 09/29/2014 01:12 PM 102,220 Firebird-nbackup.pdf
> 09/29/2014 01:15 PM 309,643 Firebird-Null-Guide.pdf
> 09/29/2014 01:14 PM 39,907 Firebird-on-Ubuntu.pdf
> 09/29/2014 01:13 PM 56,914 Firebird-shell-scripts.pdf
> 09/29/2014 01:15 PM 109,705 MSSQL-to-Firebird.pdf
> 09/29/2014 01:16 PM 195,585 Using-Firebird_(wip).pdf
> 22 File(s) 43,276,951 bytes
> 2 Dir(s) 697,431,232,512 bytes free
>
> C:\Firebird>gstat 192.168.1.252:/bfl/smtbdb/customer
> 'gstat' is not recognized as an internal or external command,
> operable program or batch file.

gstat is not a separate download but included in your Firebird installation, be it in the ZIP distribution or the installer. So, check out the Firebird\bin directory.

But this won't help you much, because gstat does not work over a regular database connection, but access the database at physical level, so you have to run that locally from your Linux machine.

> It has been 20+ years since I have done much with Unix. If you can tell
> me the directory Firebird is installed in on Linux, I will run the gstat
> on the Linux server. Otherwise, it will take me a while to locate
> it.... which I will start now.

Don't know, but I guess fbstat as mentioned in your > 2 years old thread ;-):
http://comments.gmane.org/gmane.comp.db.firebird.user/7145


Regards,
Thomas

> Thanks,
> Jack
>
>
> C:\Firebird>
>
> On 6/11/2015 9:13 AM, 'Thomas Steinmaurer' ts@...
> [firebird-support] wrote:
>>
>>
>> > The databases are backed up between midnight and 6 am when no one is
>> > using them. However, the databases are still open in multiple
>> > programs. The backup is:
>> >
>> > C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA
>> > -pas masterkey 192.168.1.252:/bfl/smtbdb/customer
>> > C:\backups\Buford\Thursday\customer.bak
>> >
>> > and the restore is:
>> >
>> > C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA
>> > -pas masterkey C:\backups\Buford\Thursday\customer.bak
>> > localhost:c:\temp\customer
>>
>> What is the result of gstat -h on the production database?
>>
>> Thomas
>>
>> > Jack
>> >
>> >
>> >
>> > On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' ts@...
>> > [firebird-support] wrote:
>> >>
>> >>
>> >> > The databases reside on a Linux Mint server, but we back them up to a
>> >> > Windows 7 system. Both are running the same release of Firebird. We
>> >> > use Linux as the server because Linux is far more reliable than
>> Windows
>> >> > for everything, but it is the only Linux computer we use. Everything
>> >> > else is Windows because of other software we run. So, to back up the
>> >> > databases, we put the backups on a Windows 7 computer, blandly
>> assuming
>> >> > it is just a file that can be restored by the same program that
>> backed
>> >> > it up, gbak on Windows 7.
>> >>
>> >> You mean a physical file copy from Linux to Windows while the database
>> >> is in use?
>> >>
>> >> > We had the same problem two years ago, and it never got resolved, it
>> >> > just disappeared, so we assumed we had done something wrong and
>> were no
>> >> > longer doing whatever that was.
>> >>
>> >> And you don't call a different gbak version by accident, e.g. due to a
>> >> set PATH environment variable etc.?
>> >>
>> >> Regards,
>> >> Thomas
>> >>
>> >> > Jack
>> >> >
>> >> > On 6/11/2015 3:02 AM, Thomas Steinmaurer ts@...
>> >> > [firebird-support] wrote:
>> >> >>
>> >> >> Hello,
>> >> >>
>> >> >> > We have backed up our databases daily for two years using
>> >> Firebird 2.52
>> >> >> > Superserver and its associated gbak. We now need to restore one
>> >> of the
>> >> >> > databases and gbak fails to do the restore, giving the following
>> >> error:
>> >> >> >
>> >> >>
>> >> >> [snip gbak output]
>> >> >>
>> >> >> > gbak: ERROR:action cancelled by trigger (3) to preserve data
>> >> integrity
>> >> >> > gbak: ERROR: table/procedure has non-SQL security class defined
>> >> >> > gbak:Exiting before completion due to errors
>> >> >> >
>> >> >> >
>> >> >> > We have no procedures defined in or for our database. It
>> appears gbak
>> >> >> > has restored the database except for something at the end. The
>> >> database
>> >> >> > is working correctly every day. Is this copy of the database
>> backup
>> >> >> toast?
>> >> >> >
>> >> >> >
>> >> >> > Should we be using a different backup tool like nbackup? Can
>> we use
>> >> >> > Interbase gbak to recreate the database?
>> >> >> >
>> >> >> >
>> >> >> > We are backing up our databases on Windows 7 using 2.52
>> Superserver.
>> >> >> > The databases are on a Linux Mint server.
>> >> >>
>> >> >> I'm confused. The databases are hosted on Linux (InterBase or
>> >> Firebird?)
>> >> >> but you are running a backup from Win7?
>> >> >>
>> >> >> You asked something similar > 2 years ago:
>> >> >> http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>> >> >>
>> >> >> --
>> >> >> With regards,
>> >> >> Thomas Steinmaurer
>> >> >> http://www.upscene.com/
>> >> >>
>> >> >> Professional Tools and Services for Firebird
>> >> >> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>> >> >>
>> >> >> > However, when we are trying
>> >> >> > to do the restore, we are restoring it to a directory on Windows 7
>> >> >> > because we don't trust restoring it over the currently running
>> >> >> > database. So, the backup and restore are both on the same
>> Windows 7
>> >> >> > computer using the same 2.52 Superserver.
>> >> >> >
>> >> >> >
>> >> >> > We need some data from the database from yesterday, so we just
>> >> wanted to
>> >> >> > restore that long enough to pull the data. The table we want,
>> >> ON_ORDER,
>> >> >> > appears to have been restored but we cannot open the restored
>> >> database
>> >> >> > to access it.
>> >> >> >
>> >> >> >
>> >> >> > Help?
>> >> >> >
>> >> >> >
>> >> >> > ------------------------------------
>> >> >> > Posted by: Jack Mason <jackmason@...>
>> >> >> > ------------------------------------
>> >> >> >
>> >> >> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> >> >> >
>> >> >> > Visit http://www.firebirdsql.org and click the Documentation item
>> >> >> > on the main (top) menu. Try FAQ and other links from the left-side
>> >> >> menu there.
>> >> >> >
>> >> >> > Also search the knowledgebases at
>> >> >> http://www.ibphoenix.com/resources/documents/
>> >> >> >
>> >> >> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> >> >> > ------------------------------------
>> >> >> >
>> >> >> > Yahoo Groups Links
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> > --
>> >> > "Our Constitution was made only for a moral and religious people.
>> It is
>> >> > wholly inadequate to the government of any other." -- John Adams,
>> Oct.
>> >> > 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>> >> >
>> >>
>> >>
>> >
>> > --
>> > "Our Constitution was made only for a moral and religious people. It is
>> > wholly inadequate to the government of any other." -- John Adams, Oct.
>> > 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>> >
>>
>>
>
> --
> "Our Constitution was made only for a moral and religious people. It is
> wholly inadequate to the government of any other." -- John Adams, Oct.
> 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>