Re: Is there a 2gb dbspace limit NT 4.0, IDS 7.3?

"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? Regards

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