Oninit cdi / Archive
Talk to an expert →

Re: chunk/dbspace sizes

Posted in 2000

Topics: Storage & Space Management, Versions, Editions & End-of-Life

↪ replying to Obnoxio The Clown
Thanh — — source: Informix-list mailing list archive (1991-1998)

In article <8mut93$f2s$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: Thanh <tqma@my-deja.com> > > > >My understanding from the Admin Guide for IDS 9.2 is that: > > > >1. A dbspace can have one or more chunks > >2. A chunk has a max size of 2GBs. > > > >Is there a max size for a dbspace ? > > There's a maximum number of chunks a dbspace can have. So its 2GB x that > number (which I *think* is 2047). > > No manual, no check. :-) The Admin Guide for 9.20, page 15-19, says: "you can allocate a maxinum of 2048 chunks and 2048 storage spaces on a database server...". So, o Max dbspace = 2GB * 2048 o Max dbserver = max dbspace * 2048 Am I correct ? Thanh Sent via Deja.com http://www.deja.com/ Before you buy.

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: Thanh <tqma@my-deja.com> > >My understanding from the Admin Guide for IDS 9.2 is that: > >1. A dbspace can have one or more chunks >2. A chunk has a max size of 2GBs. > >Is there a max size for a dbspace ? There's a maximum number of chunks a dbspace can have. So its 2GB x that number (which I *think* is 2047). No manual, no check. :-) >If yes, it must be 2 GBs. But then it does not make sense >when we add more chunks to it. > >I am a little confused here. > >Thanh > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Thanh
Sebastien THOMAS — — source: Informix-list mailing list archive (1991-1998)

Hi, It seems you are... Be carefull anyway : You can't have more than 16.xxx.xxx pages in a fragment !! --> the biggest table you can have is 32Gb (2k/page * 16.000.000) You can go through this limit if you use fragmented tables. But you've better think of this before... I'm having a big work now as some people didn't think of this earlier :( Informix have strange limitations sometime :) Thanh wrote: > In article <8mut93$f2s$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > From: Thanh <tqma@my-deja.com> > > > > > >My understanding from the Admin Guide for IDS 9.2 is that: > > > > > >1. A dbspace can have one or more chunks > > >2. A chunk has a max size of 2GBs. > > > > > >Is there a max size for a dbspace ? > > > > There's a maximum number of chunks a dbspace can have. So its 2GB x > that > > number (which I *think* is 2047). > > > > No manual, no check. :-) > > The Admin Guide for 9.20, page 15-19, says: > "you can allocate a maxinum of 2048 chunks and 2048 storage spaces > on a database server...". So, > > o Max dbspace = 2GB * 2048 > o Max dbserver = max dbspace * 2048 > > Am I correct ? > > Thanh > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- _______________________________________________ Sebastien THOMAS none networks System Engineer freesbee geo:153, rue Saint-Denis, 75002 Paris, France vox:+33 1 45 08 23 10 - fax:+33 1 45 08 25 29 mailto:sebastien.thomas@none.net

Glossary