Subject AW: [firebird-support] Upgrade Firebird and Change PC-System
Author Olaf Kluge

my Database Information of my test.db:

Database "D:\Interbase\TEST.gdb"

Database header page information:

Flags 0

Checksum 12345

Generation 151

Page size 4096

ODS version 11.0

Oldest transaction 148

Oldest active 149

Oldest snapshot 149

Next transaction 150

Bumped transaction 1

Sequence number 0

Next attachment ID 30

Implementation ID 16

Shadow count 0

Page buffers 0

Next header page 0

Database dialect 3

Creation date Jun 18, 2008 10:08:18

Attributes force write

The Standard-Page buffers setting of my db is 0.

I hope, everything works out.



> Currently we have an old PC-System with Dual P3-Architecture and a
> 1.5-Database-Superserver. I will change the PC-System to a
> Quadcore-Architecture and Firebird 2.1 latest release and classic server.
> The firebird.conf-entry "DefaultDbCachePages" I will change to 128
> (previously # and 2048).

The server-wide setting in firebird.conf will only apply, if the
database specific page buffers value is set to 0!

Before I do the change, I make a backup ob the
> database *.gbk and on my new system, I restore this to a packed new *.gdb.
> Please can you help me, which other things and rules I must observe?

Check out the "Known compatibility issues" section in
Firebird_v2.1.0.InstallationGuide.pdf included in your Firebird 2.1

This document is also available online:

> What new options I have with the new firebird-version?

There are MANY new features in 2.1. ;-)

You'd best checking out the Firebird 2.1 release notes:

Can I see, what
> clients are connected with the server?

Yes, on a per database base, with a monitoring table query like:

select * from mon$attachments

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene <> com

[Non-text portions of this message have been removed]