RE: Adding Chunks

> Today I wanted to add a chunk, but everything went wrong! One of those days eh. > > Existing chunk (onstat -d): > c42dd6b8 5 5 0 1024000 429255 > /home/informix/dev/datachunk2 > > And want to add a new chunk the following way: > onspaces -a dbs1 -o 2048000 -p /home/informix/dev/datachunk4 > -s 1536000> > Failure: > Chunk size + offset (3584000k) greater than 2097151k limit. Makes sense. You are limited to 2 Gig. At least on AIX 4.3.2 I assume other flavours will have similar *functionality*. Informix can only use the first 2Gb of /home/informix/dev/datachunk4. So check where this is linked to. If the device that it links to is larger than 2 Gb you will be wasting some space. > > Also tryed: > onspaces -a dbs1 -o 0 -p /home/informix/dev/datachunk4 -s 1536000> > Failure: > A lot, i have to do a cold restore! Did you do an "onstat -d | grep datachunk4 " to ensure that there was no other data there. Perhaps a nice juicy rootdbs ? I am sure that Informix would warn you if there was but you don't mention OS or Informix version. Where there any meaningful error messages?? > > I thought I knew how to do it, I can't find out what I'm doing wrong. > With a 1GB chunk adding aboout 250mb's everything went okay. > > Hope to hear from you soon and thanks in advance, > > Alex Jo ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________

Hoi Joseph, The linked device,/dev/vg00/rdatachunk0, must be the problem, that one is 3584000k There was allready one chunk of 2048000k for link /home/informix/dev/datachunk2 and I wanted to add 1536000k for link /home/informix/dev/datachunk4 to the same device, /dev/vg00/rdatachunk0. Made a bad mistake, I should have knowe better. I've to found out now, how to decrease the device to 2048000k and how to make a /dev/vg00/rdatachunk2 of 1536000k. If you or somebody else got the answer for me, I'am glad to hear that too. Working on HP-UX 10.20 and Informix 7.24.UC6 Thanks, Alex COOPER, Joseph <Joseph.COOPER@sema.co.uk> schreef in berichtnieuws 88r52v$48a$1@news.xmission.com... > > > Today I wanted to add a chunk, but everything went wrong! > One of those days eh. > > > > Existing chunk (onstat -d): > > c42dd6b8 5 5 0 1024000 429255 > > /home/informix/dev/datachunk2 > > > > And want to add a new chunk the following way: > > onspaces -a dbs1 -o 2048000 -p /home/informix/dev/datachunk4 > > -s 1536000> > > > Failure: > > Chunk size + offset (3584000k) greater than 2097151k limit. > Makes sense. You are limited to 2 Gig. At least on AIX 4.3.2 > I assume other flavours will have similar *functionality*. > > Informix can only use the first 2Gb of /home/informix/dev/datachunk4. > So check where this is linked to. If the device that it links to is larger > than 2 Gb you will be wasting some space. > > > > > Also tryed: > > onspaces -a dbs1 -o 0 -p /home/informix/dev/datachunk4 -s 1536000> > > > Failure: > > A lot, i have to do a cold restore! > > Did you do an "onstat -d | grep datachunk4 " to ensure that there was no > other data there. > Perhaps a nice juicy rootdbs ? I am sure that Informix would warn you if > there was but you don't mention OS or Informix version. > > Where there any meaningful error messages?? > > > > > I thought I knew how to do it, I can't find out what I'm doing wrong. > > With a 1GB chunk adding aboout 250mb's everything went okay. > > > > Hope to hear from you soon and thanks in advance, > > > > Alex > > > Jo > > ___________________________________________________________________________ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > Sema Group. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the Sema Group > Helpdesk by telephone on +44 (0) 121 627 5600. > ___________________________________________________________________________ >

Alex wrote: > > Hoi Joseph, > Yes, Informix does not check that multiple links donot point to the same file/device you MUST be careful! To avoid doing this ourselves I, with Jake Salomon's great aid, created a wrapper for onspaces, aspace, that performs the checks that the named link/filename does not point to a file or device that is already being used. Aspace, and its reporting tool printchunks, are included in the package utils_ak that I submitted to the IIUG Software Repository a few years ago. Art S. Kagel > The linked device,/dev/vg00/rdatachunk0, must be the problem, that one is > 3584000k > > There was allready one chunk of 2048000k for link > /home/informix/dev/datachunk2 and I wanted to add 1536000k for link > /home/informix/dev/datachunk4 to the same device, /dev/vg00/rdatachunk0. > > Made a bad mistake, I should have knowe better. > I've to found out now, how to decrease the device to 2048000k and how to > make a /dev/vg00/rdatachunk2 of 1536000k. > If you or somebody else got the answer for me, I'am glad to hear that too. > > Working on HP-UX 10.20 and Informix 7.24.UC6 > > Thanks, > > Alex > > COOPER, Joseph <Joseph.COOPER@sema.co.uk> schreef in berichtnieuws > 88r52v$48a$1@news.xmission.com... > > > > > Today I wanted to add a chunk, but everything went wrong! > > One of those days eh. > > > > > > Existing chunk (onstat -d): > > > c42dd6b8 5 5 0 1024000 429255 > > > /home/informix/dev/datachunk2 > > > > > > And want to add a new chunk the following way: > > > onspaces -a dbs1 -o 2048000 -p /home/informix/dev/datachunk4 > > > -s 1536000> > > > > > Failure: > > > Chunk size + offset (3584000k) greater than 2097151k limit. > > Makes sense. You are limited to 2 Gig. At least on AIX 4.3.2 > > I assume other flavours will have similar *functionality*. > > > > Informix can only use the first 2Gb of /home/informix/dev/datachunk4. > > So check where this is linked to. If the device that it links to is larger > > than 2 Gb you will be wasting some space. > > > > > > > > Also tryed: > > > onspaces -a dbs1 -o 0 -p /home/informix/dev/datachunk4 -s 1536000> > > > > > Failure: > > > A lot, i have to do a cold restore! > > > > Did you do an "onstat -d | grep datachunk4 " to ensure that there was no > > other data there. > > Perhaps a nice juicy rootdbs ? I am sure that Informix would warn you if > > there was but you don't mention OS or Informix version. > > > > Where there any meaningful error messages?? > > > > > > > > I thought I knew how to do it, I can't find out what I'm doing wrong. > > > With a 1GB chunk adding aboout 250mb's everything went okay. > > > > > > Hope to hear from you soon and thanks in advance, > > > > > > Alex > > > > > > Jo > > > > > -- Art S. Kagel & Family kagel@erols.com