Subject RE: [ib-support] FIB and filesize
Author Wilson, Fred
Jason is this 180Gigs of files at the same time, as in 180gig's of file
handles, as in 10 files open, 10,000 files open, etc.. Or, is this 180GB of
file size(s) open. In other words couldn't open more that 180 files (at the
same time) that are 1 gig in size each, or couldn't open 1 file that's, say
300 gig ? If the second part is true, this is, in effect, saying that a
database can't be larger than 180GB
My head hurts ;)

Best regards,
Fred Wilson
SE, Bell & Howell

-----Original Message-----
From: Jason Chapman (JAC2) [mailto:jason@...]
Sent: Tuesday, July 23, 2002 10:47 AM
Subject: Re: [ib-support] FIB and filesize


No you're not confused at all, NT can not have more than 180GB of files open
at any one time. The limit on 2K is 192, 24? or 3?? depending on which
documentation you look at.

We couldn't find any OS tweak to get around it.

We had this problem with a database server with > 20 x 20GB databases, after
a while the server just stopped. After an age of investigation we got the
problme down to this limit in NT4.

> Jason Chapman
> JAC2 Consultancy
> Training - Development - Consultancy
> Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
> Troubleshooting projects, QA.....
> www: When I get round to it....
> Mob: (+44) 07966 211 959 (preferred)
> Tel: (+44) 01928 751088

""Wilson, Fred"" > Jason, I'm slightly confused (but for me that's a common
state of mind ;) )
> about your e-mail. Are you saying that BT4.0 has a max file size (limited
> the max file open size) of only 180GB and W2K maybe something more ??
> Best regards,
> Fred Wilson

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to