Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:
> That information is also available on the database header page,
> which can be extracted by gstat -h
Unfortunately, that information is absent from gstat -h, hence my
advice to use isql SHOW DATABASE. I can't think why it is missing -
even in Fb 3 where gstat -h output has actually been updated to
display the new header info in ODS 12 databases.
not quite
> So, basically, with gstat you get ^ everything you need:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Programs64\Firebird_2_5\bin>gstat -h xxyyzz
Database "h:\databases\xxyyzz.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 1428
Page size 8192
ODS version 11.2
Oldest transaction 1093
Oldest active 1094
Oldest snapshot 1094
Next transaction 1107
Bumped transaction 1
Sequence number 0
Next attachment ID 128
Implementation ID 26
Shadow count 0
Page buffers 4092
Next header page 0
Database dialect 3
Creation date Oct 3, 2015 20:35:11
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Helen
Posted by: Helen Borrie <helebor@iinet.net.au>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (13) |
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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment