At 03:19 Friday, 21.02.2003 +0000, you wrote:

>I have a database that has reached the 2GB limit and when I try to
>add an extra file it errors saying the db has reached its 2GB limit
>use a 64-bit version, etc. How can I correct this so I can add a file?
>
>Where can I find the 64-bit Linux ibserver binary? It is not in any
>firebird install, do I have to compile it myself?
>
>Regards,
>Andy Kallenbach

Hi Andy,

I'm not very familiar with multiple database files but I think you can
add more files only via backup-restore. Do a backup and then on
the restore use the gbak parameters for multiple files. Have a look
at the gbak syntax.
Examples from the operations guide (page 162, available at
http://www.firebirdsql.com/index.php?op=doc&id=userdoc):

<quote>
For restoring to multiple files:
gbak {-C|-R} [options] source dbfile1 size1 dbfile2 [size2 dbfile3 …]

For restoring from multiple files:
gbak {-C|-R} [options] source1 source2 [source3 …] dbfile

By extension, you can restore from multiple files to multiple files using
the following syntax:
gbak {-C|-R} [options] source1 source2 [source3 …] dbfile1 size1 dbfile2
[size2 dbfile3 …]
</quote>

You can get the firebird versions with 64bit I/O at SourceForge:
http://sourceforge.net/project/showfiles.php?group_id=9028
under "firebird-linux-i386" you find downloads with "64IO" in the file names.
But I don't know what you have to do to convert your database to
64bit - I assume a backup with your current firebird version and then a
restore with the 64bit version.

HTH,
Markus