> If your generators are at the start of the database file and the copying
> takes a while (large db), and there are a lot of concurrent transaction
> then the state of the generator page at the time that page was copied is
> not the same as at the time the last page of the database file is copied.

In a test blank database, the first generator page is at 148 (See
Firebird Internals
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/fbint-page-9.html).


So the generator page is pretty close to the beginning of the database
file. On a large database at least.

There will be other generator pages if there are more than 508 generators.

The above is on a 4K database page size.


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767