RE: 40GB limits?

Bashar, You can create as many dbspaces as you like (there should be an informix limit on that value but it won't bug you) in an NT device (which are the logical drives on your system) as far as its size <= 2.0 GB. Then you can add as many chunks to a dbspace as you like with same size limitation. You dont have to assign each chunk to a logical drive. NT dbspaces and chunks are files i.e d:\\ifmxdata\\<your_db_server_name>\\rootdbs_dat.000 is your primary chunk for rootdb dbspace. Then rootdbs_dat.001 representing second chunk of the root dbspace and so on. Same applies for data, log, physical, temporary dbspaces. We have several "real" IDS 7.23 TC14 servers running on "real" NT 4.0 SP4 OS with total 54-59 GB size (14-15 2GB chunks in several dbspaces). They are working fine. Good luck Gursoy YERLI > -----Original Message----- > From: Bashar Chalabi > Sent: Thursday, August 12, 1999 12:01 PM > To: informix-list@iiug.org > Subject: 40GB limits? > > We need to create a 50GB database on NT (IDS 7.30). > > Using raw space, IDS has a limitation on chunks. We can only use the first > 2GB of every partition to create the chunk. We are not able to create a > chunk with size + offset > 2GB (although this is not documented anywhere). > > The solution is to create partitions of 2GB each, and assign them drive > letters. > > This creates 2 problems: > > The PC has a limitation of 4 partitions per disk. This means we cannot use > more that 8GB per disk. > > We have 20 letters available (after floppies, CD, NT and a few network > connections), for a total size of 40GB. > > Does this mean IDS on NT cannot handle more than a total of 40GB and more > than 8GB per disk when using raw space? Highly unlikely. So, we must be > missing something, but what? > > Can we create chunks with size + offset > 2GB? How? > Any other solution? > > -- > Bashar Chalabi > CTL, London > >