Re: AIX and Informix

Thanks for the comments. We are running into several things. One is that we set the offset of the dbspace to 0. We are being told it needs to have an offset of "something" - that AIX wants this for the volume group management. Our current environ is HP which we have always used an offset of 0 - it has never been an issue. We have our physical, log and root spaces mirrored and there looks to be some kind of corruption, according to support. Kinda wondering if the HACMP clustering might be involved also but unsure. What we are seeing is this: I dropped a large database and when I went to check out the spaces using onstat -d pertaining to the space the DB used to be in, the % used was a negative number. So the total size free is greater than the total size allocated. Tom Obnoxio The Clown wrote: > tomcaml@yahoo.com said: > > Hello > > > > We are running into some major walls trying to configure and use AIX > > 5.3 and Informix v10 with HACMP clustering and Informix HDR. AIX looks > > to be very behind the times, as does the clustering piece. This is for > > an intended migration of the main "cash cow" application. Does anyone > > run their "important stuff" on AIX ? I have been researching and most > > of what I see is people using AIX from years back or they only use AIX > > for smaller apps that they don't have great concerns being down. > > Comments, Suggestions, Rants or Raves? > > Personally, I think AIX tin is very good. I can't comment on HACMP, other > than that I've never met anyone who used ANY clustering software (HACMP, > Sun, Veritas, Compaq) who didn't prefer HDR. > > -- > Bye now, > Obnoxio > > "... no bill is required as no value was provided." > -- Christine Normile > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean.

tomcaml@yahoo.com said: > > One is that we set the offset of the dbspace to 0. We are being told it > needs to have an offset of "something" - that AIX wants this for the > volume group management. Our current environ is HP which we have always > used an offset of 0 - it has never been an issue. Are you going to lose a whole megabyte? > We have our physical, > log and root spaces mirrored and there looks to be some kind of > corruption, according to support. Kinda wondering if the HACMP > clustering might be involved also but unsure. HACMP = Horribly Awful Mongolian Cluster Phuck. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Obnox, No cares about losing space whatsoever. The problem and its root cause are our concern. The integration of HACMP and Volume Manager may be a problem - but we are unsure and are researching, etc. Wish I knew - Tom Obnoxio The Clown wrote: > tomcaml@yahoo.com said: > > > > One is that we set the offset of the dbspace to 0. We are being told it > > needs to have an offset of "something" - that AIX wants this for the > > volume group management. Our current environ is HP which we have always > > used an offset of 0 - it has never been an issue. > > Are you going to lose a whole megabyte? > > > We have our physical, > > log and root spaces mirrored and there looks to be some kind of > > corruption, according to support. Kinda wondering if the HACMP > > clustering might be involved also but unsure. > > HACMP = Horribly Awful Mongolian Cluster Phuck. > > -- > Bye now, > Obnoxio > > "... no bill is required as no value was provided." > -- Christine Normile > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean.

AIX should NOT require an offset, if you use one then there is no harm. The LVM VTOC is not visible to the OS Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend IDUG 2007 San Jose, North America May 6-10, 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: tomcaml@yahoo.com [mailto:tomcaml@yahoo.com] > Posted At: 20 October 2006 10:22 > Posted To: comp.databases.informix > Conversation: AIX and Informix > Subject: Re: AIX and Informix > > > Thanks for the comments. > We are running into several things. > > One is that we set the offset of the dbspace to 0. We are > being told it needs to have an offset of "something" - that > AIX wants this for the volume group management. Our current > environ is HP which we have always used an offset of 0 - it > has never been an issue. We have our physical, log and root > spaces mirrored and there looks to be some kind of > corruption, according to support. Kinda wondering if the > HACMP clustering might be involved also but unsure. > What we are seeing is this: I dropped a large database and > when I went to check out the spaces using onstat -d > pertaining to the space the DB used to be in, the % used was > a negative number. So the total size free is greater than the > total size allocated. > > Tom > > > Obnoxio The Clown wrote: > > tomcaml@yahoo.com said: > > > Hello > > > > > > We are running into some major walls trying to configure > and use AIX > > > 5.3 and Informix v10 with HACMP clustering and Informix HDR. AIX > > > looks to be very behind the times, as does the clustering piece. > > > This is for an intended migration of the main "cash cow" > > > application. Does anyone run their "important stuff" on > AIX ? I have > > > been researching and most of what I see is people using AIX from > > > years back or they only use AIX for smaller apps that > they don't have great concerns being down. > > > Comments, Suggestions, Rants or Raves? > > > > Personally, I think AIX tin is very good. I can't comment on HACMP, > > other than that I've never met anyone who used ANY > clustering software > > (HACMP, Sun, Veritas, Compaq) who didn't prefer HDR. > > > > -- > > Bye now, > > Obnoxio > > > > "... no bill is required as no value was provided." > > -- Christine Normile > > > > -- > > This message has been scanned for viruses and dangerous content by > > OpenProtect(http://www.openprotect.com), and is believed to > be clean. >

OK from comments others have made I sit corrected, but I have a number of V4 AIX systesm (no HACMP) with zero offsets that have been rebooted many times without a problem Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend IDUG 2007 San Jose, North America May 6-10, 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Paul Watson [mailto:paul@oninit.com] > Posted At: 20 October 2006 12:45 > Posted To: comp.databases.informix > Conversation: AIX and Informix > Subject: Re: AIX and Informix > > > AIX should NOT require an offset, if you use one then there > is no harm. > The LVM VTOC is not visible to the OS > > Paul Watson > Tel: +44 1414161772 > Mob: +44 7818003457 > Web: www.oninit.com > > GO FURTHER with DB2 > GET THERE FASTER with Informix. > Attend IDUG 2007 San Jose, North America May 6-10, 2006 Visit > http://www.iiug.org/conf for more information. > > > > > > -----Original Message----- > > From: tomcaml@yahoo.com [mailto:tomcaml@yahoo.com] Posted At: 20 > > October 2006 10:22 Posted To: comp.databases.informix > > Conversation: AIX and Informix > > Subject: Re: AIX and Informix > > > > > > Thanks for the comments. > > We are running into several things. > > > > One is that we set the offset of the dbspace to 0. We are > being told > > it needs to have an offset of "something" - that AIX wants this for > > the volume group management. Our current environ is HP > which we have > > always used an offset of 0 - it has never been an issue. We > have our > > physical, log and root spaces mirrored and there looks to > be some kind > > of corruption, according to support. Kinda wondering if the HACMP > > clustering might be involved also but unsure. > > What we are seeing is this: I dropped a large database and > when I went > > to check out the spaces using onstat -d pertaining to the > space the DB > > used to be in, the % used was a negative number. So the total size > > free is greater than the total size allocated. > > > > Tom > > > > > > Obnoxio The Clown wrote: > > > tomcaml@yahoo.com said: > > > > Hello > > > > > > > > We are running into some major walls trying to configure > > and use AIX > > > > 5.3 and Informix v10 with HACMP clustering and Informix > HDR. AIX > > > > looks to be very behind the times, as does the > clustering piece. > > > > This is for an intended migration of the main "cash cow" > > > > application. Does anyone run their "important stuff" on > > AIX ? I have > > > > been researching and most of what I see is people using > AIX from > > > > years back or they only use AIX for smaller apps that > > they don't have great concerns being down. > > > > Comments, Suggestions, Rants or Raves? > > > > > > Personally, I think AIX tin is very good. I can't comment > on HACMP, > > > other than that I've never met anyone who used ANY > > clustering software > > > (HACMP, Sun, Veritas, Compaq) who didn't prefer HDR. > > > > > > -- > > > Bye now, > > > Obnoxio > > > > > > "... no bill is required as no value was provided." > > > -- Christine Normile > > > > > > -- > > > This message has been scanned for viruses and dangerous > content by > > > OpenProtect(http://www.openprotect.com), and is believed to > > be clean. > > >

I actually did a test with our AIX system administration team. If we set offset to 0 ir corrupts the volume label. And that is used when you try to export the volume to a different system - as is often the case with HACMP. So, use offset 0 if you wish but don't expect it always to work. Malcolm -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of tomcaml@yahoo.com Sent: 20 October 2006 16:22 To: informix-list@iiug.org Subject: Re: AIX and Informix Thanks for the comments. We are running into several things. One is that we set the offset of the dbspace to 0. We are being told it needs to have an offset of "something" - that AIX wants this for the volume group management. Our current environ is HP which we have always used an offset of 0 - it has never been an issue. We have our physical, log and root spaces mirrored and there looks to be some kind of corruption, according to support. Kinda wondering if the HACMP clustering might be involved also but unsure. What we are seeing is this: I dropped a large database and when I went to check out the spaces using onstat -d pertaining to the space the DB used to be in, the % used was a negative number. So the total size free is greater than the total size allocated. Tom Obnoxio The Clown wrote: > tomcaml@yahoo.com said: > > Hello > > > > We are running into some major walls trying to configure and use AIX > > 5.3 and Informix v10 with HACMP clustering and Informix HDR. AIX > > looks to be very behind the times, as does the clustering piece. > > This is for an intended migration of the main "cash cow" > > application. Does anyone run their "important stuff" on AIX ? I have > > been researching and most of what I see is people using AIX from > > years back or they only use AIX for smaller apps that they don't > > have great concerns being down. Comments, Suggestions, Rants or > > Raves? > > Personally, I think AIX tin is very good. I can't comment on HACMP, > other than that I've never met anyone who used ANY clustering software > (HACMP, Sun, Veritas, Compaq) who didn't prefer HDR. > > -- > Bye now, > Obnoxio > > "... no bill is required as no value was provided." > -- Christine Normile > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list