At 10:35 AM 12/3/2002 -0500, Leyne, Sean wrote:

> > How to detect whether Firebird is using only the first file.
> > Or is it using the second, third fourth secondary files etc.
>
>You need to investigate the system tables RDB$PAGES and RDB$FILES (See
>Language Reference -- System Tables and Views), to determine if the
>system has allocated a page in a secondary file.

That's not going to be completely reliable since only pointer
pages, TIPs, index roots, and generator pages show up in RDB$PAGES.
The much more popular index and data pages do not. There's a
database info parameter, isc_info_allocation, that will give the
number of pages currently in use.


Regards,

Ann
www.ibphoenix.com
We have answers.