Re: AIX and Informix
Posted in 2006
Hi,
With regard to an ROOTOFFEST of zero.
This is because the LVM uses the first 4 Byte for information.
If you use a root offset of zero is used, and any LVM work is done, like a lv copy for example, the 4 Bytes will be written back to the device, resulting in the engine failing snaity checks when you attemp to bring it online.
Please note that since for every other dbspace page zero is reserved for future use, you can use an offset of zero with no problems.
In short, using a ROOTOFFSET of zero for AIX is akin to russian roulette. Just set the value to 4K. If you rootdbspace is so short for space that losing a sing page messes you up, then you really have bigger problems.
----- Original Message ----
From: "tomcaml@yahoo.com" <tomcaml@yahoo.com>
To: informix-list@iiug.org
Sent: Friday, October 20, 2006 10:21:32 AM
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