Subject | Re: gbak trigger(3) error |
---|---|
Author | jack.mason58 |
Post date | 2013-08-09T15:10:31Z |
Where do I find fbstat? It is not included in the 2.5.2 download I pulled yesterday from firebirdsql.com. It is not in the bin directory nor the top directory.
Here is what is in the bin directory:
C:\Program Files\Firebird\Firebird_2_5\bin>dir
Volume in drive C has no label.
Volume Serial Number is FA80-0C12
Directory of C:\Program Files\Firebird\Firebird_2_5\b
08/08/2013 12:28 PM <DIR> .
08/08/2013 12:28 PM <DIR> ..
03/19/2013 11:21 AM 874,496 fbclient.dll
03/19/2013 11:22 AM 154,112 fbguard.exe
03/19/2013 11:22 AM 5,708,800 fbserver.exe
03/19/2013 11:23 AM 139,776 fbsvcmgr.exe
03/19/2013 11:23 AM 125,952 fbtracemgr.exe
03/19/2013 11:22 AM 340,480 fb_lock_print.e
03/19/2013 11:22 AM 357,888 gbak.exe
03/19/2013 11:22 AM 385,024 gdef.exe
03/19/2013 11:22 AM 147,968 gfix.exe
03/19/2013 11:22 AM 696,320 gpre.exe
03/19/2013 11:22 AM 232,448 gsec.exe
03/19/2013 11:21 AM 18,432 gsplit.exe
03/19/2013 11:23 AM 241,664 gstat.exe
03/19/2013 11:21 AM 8,192 ib_util.dll
03/19/2013 11:09 AM 1,558,016 icudt30.dll
03/19/2013 11:09 AM 575,488 icuin30.dll
03/19/2013 11:09 AM 935,936 icuuc30.dll
03/19/2013 11:23 AM 20,480 instclient.exe
03/19/2013 11:21 AM 13,312 instreg.exe
03/19/2013 11:21 AM 79,872 instsvc.exe
03/19/2013 11:23 AM 353,280 isql.exe
03/19/2013 11:23 AM 218,112 nbackup.exe
03/19/2013 11:23 AM 466,432 qli.exe
23 File(s) 13,652,480 bytes
2 Dir(s) 1,296,759,689,216 bytes free
Here is what is in the bin directory:
C:\Program Files\Firebird\Firebird_2_5\bin>dir
Volume in drive C has no label.
Volume Serial Number is FA80-0C12
Directory of C:\Program Files\Firebird\Firebird_2_5\b
08/08/2013 12:28 PM <DIR> .
08/08/2013 12:28 PM <DIR> ..
03/19/2013 11:21 AM 874,496 fbclient.dll
03/19/2013 11:22 AM 154,112 fbguard.exe
03/19/2013 11:22 AM 5,708,800 fbserver.exe
03/19/2013 11:23 AM 139,776 fbsvcmgr.exe
03/19/2013 11:23 AM 125,952 fbtracemgr.exe
03/19/2013 11:22 AM 340,480 fb_lock_print.e
03/19/2013 11:22 AM 357,888 gbak.exe
03/19/2013 11:22 AM 385,024 gdef.exe
03/19/2013 11:22 AM 147,968 gfix.exe
03/19/2013 11:22 AM 696,320 gpre.exe
03/19/2013 11:22 AM 232,448 gsec.exe
03/19/2013 11:21 AM 18,432 gsplit.exe
03/19/2013 11:23 AM 241,664 gstat.exe
03/19/2013 11:21 AM 8,192 ib_util.dll
03/19/2013 11:09 AM 1,558,016 icudt30.dll
03/19/2013 11:09 AM 575,488 icuin30.dll
03/19/2013 11:09 AM 935,936 icuuc30.dll
03/19/2013 11:23 AM 20,480 instclient.exe
03/19/2013 11:21 AM 13,312 instreg.exe
03/19/2013 11:21 AM 79,872 instsvc.exe
03/19/2013 11:23 AM 353,280 isql.exe
03/19/2013 11:23 AM 218,112 nbackup.exe
03/19/2013 11:23 AM 466,432 qli.exe
23 File(s) 13,652,480 bytes
2 Dir(s) 1,296,759,689,216 bytes free
--- In firebird-support@yahoogroups.com, Norman Dunbar <Norman@...> wrote:
>
> On 09/08/13 14:07, jack.mason58 wrote:
> > Thanks for your response, but this doesn't appear to be relevant as we do not know what ODS is, have never used it, and created the database brand new under Firebird 2.5.
>
> ODS is On Disc Structure. If you run a gstat -h database_name (or fbstat
> -h database on Linux Mint!) then it will display something like the
> following:
>
> $ fbstat -h employee
>
> Database "/var/lib/firebird/2.5/data/employee.fdb"
> Database header page information:
> ...
> Page size 4096
> ODS version 11.2
> Oldest transaction 780
> Oldest active 781
> Oldest snapshot 781
> Next transaction 782
> ...
> Creation date Nov 21, 2011 16:21:09
> Attributes force write, multi-user maintenance
>
> Variable header data:
> *END*
>
>
> $ fbstat -z
>
> gstat version LI-V2.5.1.26351 Firebird 2.5
>
>
> You can see that I'm using Firebird 2.5 and I have ODS 11.2. What do you
> get for the database you created?
>
> When you run the normal backups, have you ever managed to successfully
> create a new database from the backups file? Or is this the first time
> you have tried it?
>
> What command line did you use to create the backup?
>
> And finally, you'll be glad to hear, what command line did you use to
> create the test one from the backup?
>
>
> Ok, I lied, on the backing up server what is the output from gbak -z and
> what is it on the server where you are trying to create a test database.
>
> Thanks.
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
>