Thanks for that Art :)
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.08.19.07.35.24.343792.10594@bloomberg.net>...
> On Tue, 19 Aug 2003 03:57:57 -0400, Strangiato wrote:
>
> > "Art S. Kagel" <kagel@bloomberg.net> wrote in message
> > news:<pan.2003.08.18.15.03.54.220774.10594@bloomberg.net>...
> >> On Thu, 14 Aug 2003 12:43:18 -0400, Strangiato wrote:
> >>
> >> > Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?
> >>
> >> Yes
> >>
> >>
> >> Art S. Kagel
> >
> > Art, just to clarify, do you agree with the further posting that in fact
> > dbspace aren't limited to 2gb because they can be composed of many 2gb
> > chunks?
>
> My apologies. I read and answered quickly between other things. There
> is a 2GB limit on chunk size in 7.3x on all platforms. Dbspaces and the
> total capacity of the IDS 7 server is limited to 2048 chunks. This can
> be attached to a single dbspace or can comprise up to 2048 dbspaces of
> at least one chunk each. Using maximum sized chunks that makes the
> storage limit on the instance and for a single dbspace instance at ~4TB.
>
> Note that a single table/index fragment is limited to 16,777,216 pages
> (32GB on 2K page systems, 64GB on a 4K page system like WinXX or AIX) so
> to have larger tables you need to create multiple dbspaces so you can
> fragment those larger tables.
>
> Art S. Kagel
>
> cc: David N. Heydon