Hi,

> I remember reading somewhere that IB6 allowed only one single database
> file.

False.

> Now am I mistaken or were having the option to have multiple DB files
> introduced only in Firebird?

No. multiple db were supported by IB6 (and *probably* older versions)

> Are multiple files created automatically or do I have to set some switch
> for it? I remember reading somewhere that the max file size on XP is 4GB.
> What happens when the DB becomes bigger than this size?

You'll have to configure de multiple files yourself, it's not done
'automatically'. You can do that on create or alter database or during
restore.

Old IB6 had this max file limitation of 4GB on windows (and 2Gb on linux),
but this limit has gone since firebird v1. So now, you'll probably only need
to have multifiles when your DB is bigger than your HDD.

When DB gets bigger than 4GB (with IB6 on Windows) you'll get a db
corruption. AFAIK, you'll also have a db corruption in FB if your db has no
HDD space to grow;


HTH,
Regards,
Anderson Farias