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

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