Re: 2GB Chunk & Extent Size Limit ?

}>From ilist@rmy.emory.edu Thu May 29 06:22:18 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id GAA27212; Thu, 29 May 1997 06:21:21 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id GAA00706 for informix-list-out; Thu, 29 May 1997 06:05:01 -0400 (EDT) }>Message-Id: <199705291004.AA168290250@everest.sin-apit.dhl.com> }>From: Richard Ridley <rridley@sin-apit.DHL.COM> }>Date: Thu, 29 May 1997 18:04:10 +0800 }>To: informix-list@rmy.emory.edu }>Subject: 2GB Chunk & Extent Size Limit ? }>X-Mailer: OAS 1.2.1 }>Sender: informix-list-owner@rmy.emory.edu }>Reply-To: Richard Ridley <rridley@sin-apit.DHL.COM> }>X-Informix-List-Id: <list.14692> }> }>Dear All, }> }>Sorry if this is has been asked before, but I can't understand the }>answers I have been getting ! }> }>Using Informix 5 or Informix 7, is the size of a chunk still limited }>to 2GB ? (We use HP-UX 10.10 and 10.2). }> }>If so, does this effectively restrict the size of an extent to 2GB as }>well (since one extent cannot span across chunks ?) ? }> }>I am having problems believing this - how do people maintain }>terabyte-sized databases without having more than the recommended }>limit of 8 extents ??? (I realise that there will be more than one }>table, but surely some tables must exceed the recommendation ?) }> }>Thanks for any info, }> }>Richard Ridley }> The two-gigabyte limit is in effect UNLESS you are running on a 64-bit OS and using a 64-bit application. For large database tables, I fragment data across as many two-gigabyte dbspaces as necessary to fit the table. Alternatively, you could create a large dbspace composed of multiple two-gigabyte chunks. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------