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



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.



Regards





Olaf,

> Currently we have an old PC-System with Dual P3-Architecture and a
firebird
> 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
download.

This document is also available online:
http://www.firebird
<http://www.firebirdsql.org/devel/doc/rlsnotes/html/install210.html>
sql.org/devel/doc/rlsnotes/html/install210.html

> 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:
http://www.firebird
<http://www.firebirdsql.org/devel/doc/rlsnotes/html/rlsnotes210.html>
sql.org/devel/doc/rlsnotes/html/rlsnotes210.html

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 <http://www.upscene.com> com





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