Unix Technical Forum

Re: Upgrade AIX and IDS at same time - bad idea?

This is a discussion on Re: Upgrade AIX and IDS at same time - bad idea? within the Informix forums, part of the Database Server Software category; --> We moved from 4.3.3 to 5.2, and 9.3 to 9.4 without much pain. Only real stumble was OPTCOMPIND. You ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 07:23 AM
Brian Grellinger
 
Posts: n/a
Default Re: Upgrade AIX and IDS at same time - bad idea?


We moved from 4.3.3 to 5.2, and 9.3 to 9.4 without much pain.
Only real stumble was OPTCOMPIND.
You might want to dbexport from 7.24 and dbimport into 9.4.
RTFM and carefully set your onconfig.



Brian Grellinger
I.S. Manager
DHIAC Information Systems
>>> "Obnoxio The Chav" <obnoxio@serendipita.com> 01/11/05 20:00 PM >>>


Olaf Gustafson said:
> We're planning on upgrading from AIX 4.3.3 to 5.1 and IDS 7.24 to 9.4
> over the weekend soon.
>
> Does anyone else think this is a bit risky?
>
> I recall something similar happening where I used to work and it was a
> real pain trying to figure out which upgrade caused the problem (it
> was HP-UX though - don't remember the versions)
>
> It turned out the problem in that case was a faulty DBA (not me!) -
> left out an index because he also recreated some tables to use fewer
> extents.


Well, once you've tested it a couple of times you should know that it
will
be OK...

--

Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"I'm trying to see things your way, but I can't get my head up my ass"
- JCH

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco

You're so stupid, you think martial arts are paintings by a sheriff...

I went to the airport to check in and they asked what I did because I
looked like a terrorist. I said I was a comedian. They said, "Say
something funny then." I told them I had just graduated from flying
school.

-- Ahmed Ahmed
sending to informix-list

sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 07:23 AM
Darryl Priest
 
Posts: n/a
Default Re: Upgrade AIX and IDS at same time - bad idea?

Brian Grellinger wrote:
> We moved from 4.3.3 to 5.2, and 9.3 to 9.4 without much pain.
> Only real stumble was OPTCOMPIND.
> You might want to dbexport from 7.24 and dbimport into 9.4.
> RTFM and carefully set your onconfig.
>
>
>
> Brian Grellinger
> I.S. Manager
> DHIAC Information Systems
> >>> "Obnoxio The Chav" <obnoxio@serendipita.com> 01/11/05 20:00 PM
>>>

>
> Olaf Gustafson said:
> > We're planning on upgrading from AIX 4.3.3 to 5.1 and IDS 7.24 to

9.4
> > over the weekend soon.
> >
> > Does anyone else think this is a bit risky?
> >
> > I recall something similar happening where I used to work and it

was a
> > real pain trying to figure out which upgrade caused the problem (it
> > was HP-UX though - don't remember the versions)
> >
> > It turned out the problem in that case was a faulty DBA (not me!) -
> > left out an index because he also recreated some tables to use

fewer
> > extents.

>
> Well, once you've tested it a couple of times you should know that it
> will
> be OK...
>
> --
>
> Bye now,
> Obnoxio
>
> "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
> - Coluche
>
> "I'm trying to see things your way, but I can't get my head up my

ass"
> - JCH
>
> "Ogni uomo mi guarda come se fossi una testa di cazzo"
> - Marco
>
> You're so stupid, you think martial arts are paintings by a

sheriff...
>
> I went to the airport to check in and they asked what I did because I
> looked like a terrorist. I said I was a comedian. They said, "Say
> something funny then." I told them I had just graduated from flying
> school.
>
> -- Ahmed Ahmed
> sending to informix-list
>
> sending to informix-list


We upgraded from 4.3.3 to 5.2, and 7.31 to 9.40 without too much pain.
Ditto on the OPTCOMPIND issue and the onconfig settings. The optimizer
just seems to be less forgiving of mediocre code. Also make sure to get
the most recent version of 4gl, we had inexplicable program hangs until
we did.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 07:24 AM
Olaf Gustafson
 
Posts: n/a
Default Re: Upgrade AIX and IDS at same time - bad idea?

On 12 Jan 2005 06:40:50 -0800, "Darryl Priest"
<darryl.priest@piperrudnick.com> wrote:

>
>We upgraded from 4.3.3 to 5.2, and 7.31 to 9.40 without too much pain.


That's encouraging.

>Ditto on the OPTCOMPIND issue and the onconfig settings.


And RTFM too!

>The optimizer
>just seems to be less forgiving of mediocre code.


That's not encouraging.

>Also make sure to get
>the most recent version of 4gl, we had inexplicable program hangs until
>we did.


Got it - for some reason. We're actually going to be using FourJs -
which is working sort of....

There are a few things that don't work, but if the users complain too
much, I'll delete their accounts ;-)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:34 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com