Subject | AW: [firebird-support] Upgrade Firebird and Change PC-System |
---|---|
Author | Olaf Kluge |
Post date | 2008-06-18T09:54:37Z |
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,
database specific page buffers value is set to 0!
Before I do the change, I make a backup ob the
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
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
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]
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 afirebird
> 1.5-Database-Superserver. I will change the PC-System to aThe server-wide setting in firebird.conf will only apply, if the
> Quadcore-Architecture and Firebird 2.1 latest release and classic server.
>
>
>
> The firebird.conf-entry "DefaultDbCachePages" I will change to 128
> (previously # and 2048).
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.Check out the "Known compatibility issues" section in
>
> Please can you help me, which other things and rules I must observe?
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]