Thank you for your reply. Here is what I got after running gstat -h before and
after backup restore.
Before backup/restore
Database "d:\data\POS\cfbdbcopy.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 31599023
Page size 8192
ODS version 10.1
Oldest transaction 27879204
Oldest active 27879205
Oldest snapshot 10427673
Next transaction 31599017
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 25, 2015 23:39:50
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
After backup/restore
Database "d:\data\POS\cfbdbcopy.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 24775
Page size 8192
ODS version 10.1
Oldest transaction 8857
Oldest active 8858
Oldest snapshot 8857
Next transaction 24769
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date May 24, 2015 6:44:11
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Look at the freshly restore DB Oldest active transaction and Next transaction
counters, I don't understand why such gap. We just restored the database and
run some ibExpert queries.
Thank you,
-Halim
