Upgrading from 11.5 to 11.7
A DBA asked where to find documentation for an in-place upgrade of IDS from 11.5 to 11.7. Replies pointed to the IBM Infocenter migration guide and an IBM support docview page. Art Kagel outlined the procedure: install the new version in a new directory, copy/merge onconfig and sqlhosts, shut down the instance, repoint the INFORMIXDIR link, start the new oninit, let conversions finish, then drop distributions and rerun UPDATE STATISTICS for tables and SPL routines. On reverting, since 11.7 makes structural/SMI changes, you don't need a restore: take a precautionary archive, then use 'onmode -b <version>' to revert and restart under the old binaries; John Miller added that conversion guard (RESTORE_POINT_DIR with onrestorept) can roll back pages if the conversion itself fails. The poster was satisfied.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I have been tasked to upgrade one of our servers from 11.5 to 11.7 I have not installed or upgraded Informix in many years. This should be real easy, and I plan to do an in-place upgrade. Question: where can I download a guide / manual to upgrade from 11.5 to 11.7 ? Dirk NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
You can download all documentation from IBM, or you can read it online: http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.mig.doc/ids_ mig_244.htm HTH Hrvoje On 03.08.2011. 13:11, Dirk Cornel.... wrote: > I have been tasked to upgrade one of our servers from 11.5 to 11.7 > > I have not installed or upgraded Informix in many years. This should be real > easy, and I plan to do an in-place upgrade. > > Question: where can I download a guide / manual to upgrade from 11.5 to 11.7 ? > > Dirk > > NOTE: This e-mail message is subject to the MTN Group disclaimer see > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Upgrading Informix is trivial. Install the new version in a new directory,
copy the Onconfig and sqlhosts files (or update a copy of .hr new
Onconfig.WTF with your specific values), shutdown the current instance,
change the INFORMIXDIR link to point to the new installed directory, start
the new oninit, wait for conversions to complete, drop distributions on all
tables, rerun update statistics for all tables then for all SPL pitied,
done.
Art
On Aug 3, 2011 7:11 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za> wrote:
> I have been tasked to upgrade one of our servers from 11.5 to 11.7
>
> I have not installed or upgraded Informix in many years. This should be
real
> easy, and I plan to do an in-place upgrade.
>
> Question: where can I download a guide / manual to upgrade from 11.5 to
11.7 ?
>
> Dirk
>
> NOTE: This e-mail message is subject to the MTN Group disclaimer see
> http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--bcaec50162819fd0e704a9992373
That should be onconfig.std below.
On Aug 3, 2011 8:38 AM, "Art Kagel" <art.kagel@gmail.com> wrote:
> Upgrading Informix is trivial. Install the new version in a new directory,
> copy the Onconfig and sqlhosts files (or update a copy of .hr new
> Onconfig.WTF with your specific values), shutdown the current instance,
> change the INFORMIXDIR link to point to the new installed directory, start
> the new oninit, wait for conversions to complete, drop distributions on
all
> tables, rerun update statistics for all tables then for all SPL pitied,
> done.
>
> Art
> On Aug 3, 2011 7:11 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za> wrote:
>> I have been tasked to upgrade one of our servers from 11.5 to 11.7
>>
>> I have not installed or upgraded Informix in many years. This should be
> real
>> easy, and I plan to do an in-place upgrade.
>>
>> Question: where can I download a guide / manual to upgrade from 11.5 to
> 11.7 ?
>>
>> Dirk
>>
>> NOTE: This e-mail message is subject to the MTN Group disclaimer see
>> http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>>
>>
>>
>
>
*******************************************************************************
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>
> --bcaec50162819fd0e704a9992373
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--bcaec501628187b8d904a9992bc2
On 03/08/2011 12:11, Dirk Cornel.... wrote: > I have been tasked to upgrade one of our servers from 11.5 to 11.7 > > I have not installed or upgraded Informix in many years. This should be real > easy, and I plan to do an in-place upgrade. > > Question: where can I download a guide / manual to upgrade from 11.5 to 11.7 ? > > Dirk https://www-304.ibm.com/support/docview.wss?uid=swg21259394 Lazy cunt. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.
"wait for conversions to complete"
There are conversions going from 11.5 to 11.7 ? Does this mean that if I want
to revert back, I have to restore the old version of the database ?
Dirk
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Wednesday, 03 August 2011 02:38 PM
> To: ids@iiug.org
> Subject: Re: Upgrading from 11.5 to 11.7 [24515]
>
> Upgrading Informix is trivial. Install the new version in a new
> directory,
> copy the Onconfig and sqlhosts files (or update a copy of .hr new
> Onconfig.WTF with your specific values), shutdown the current instance,
> change the INFORMIXDIR link to point to the new installed directory,
> start
> the new oninit, wait for conversions to complete, drop distributions on
> all
> tables, rerun update statistics for all tables then for all SPL pitied,
> done.
>
> Art
> On Aug 3, 2011 7:11 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za> wrote:
> > I have been tasked to upgrade one of our servers from 11.5 to 11.7
> >
> > I have not installed or upgraded Informix in many years. This should
> be
> real
> > easy, and I plan to do an in-place upgrade.
> >
> > Question: where can I download a guide / manual to upgrade from 11.5
> to
> 11.7 ?
> >
> > Dirk
> >
> > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> >
> >
> >
>
> ***********************************************************************
> ********
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --bcaec50162819fd0e704a9992373
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
NOTE: This e-mail message is subject to the MTN Group disclaimer see
http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
Yes there are structural conversions, new SMI tables, changes to sysadmin,
etc. No, you do not have to restore the old database, though I do hope you
took a precautionary archive before the upgrade. You would just have to run
an "onmode -b <version>" command to revert the data structures back to that
version and then restart the instance with the older software.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Fri, Aug 5, 2011 at 4:49 AM, Dirk Cornel.... <moolma_dc@mtn.co.za> wrote:
> "wait for conversions to complete"
>
> There are conversions going from 11.5 to 11.7 ? Does this mean that if I
> want
> to revert back, I have to restore the old version of the database ?
>
> Dirk
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art Kagel
> > Sent: Wednesday, 03 August 2011 02:38 PM
> > To: ids@iiug.org
> > Subject: Re: Upgrading from 11.5 to 11.7 [24515]
> >
> > Upgrading Informix is trivial. Install the new version in a new
> > directory,
> > copy the Onconfig and sqlhosts files (or update a copy of .hr new
> > Onconfig.WTF with your specific values), shutdown the current instance,
> > change the INFORMIXDIR link to point to the new installed directory,
> > start
> > the new oninit, wait for conversions to complete, drop distributions on
> > all
> > tables, rerun update statistics for all tables then for all SPL pitied,
> > done.
> >
> > Art
>
> > On Aug 3, 2011 7:11 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za> wrote:
> > > I have been tasked to upgrade one of our servers from 11.5 to 11.7
> > >
> > > I have not installed or upgraded Informix in many years. This should
> > be
> > real
> > > easy, and I plan to do an in-place upgrade.
> > >
> > > Question: where can I download a guide / manual to upgrade from 11.5
> > to
> > 11.7 ?
> > >
> > > Dirk
> > >
> > > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> > >
> > >
> > >
> >
> > ***********************************************************************
> > ********
> >
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> > --bcaec50162819fd0e704a9992373
> >
> >
> > ***********************************************************************
> > ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> NOTE: This e-mail message is subject to the MTN Group disclaimer see
> http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf307cfd84b3e95b04a9c3497f
You actually have 2 options besides restoring.
1) Using onmode -b <version> will revert the system back to your original
version
2) You can use conversion guard (which is generally on by default). Once
the conversions
completes this can not be used, This saves a binary image of every
page before
any modification are made and stored in the directory pointed to
RESTORE_POINT_DIR.
You can use onrestorept to restore the pages, After the conversion
complete, you can
using option #1 above
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 08/05/2011 01:49:08 AM:
> From: "Dirk Cornel...." <moolma_dc@mtn.co.za>
> To: ids@iiug.org
> Date: 08/05/2011 01:49 AM
> Subject: RE: Upgrading from 11.5 to 11.7 [24545]
> Sent by: ids-bounces@iiug.org
>
> "wait for conversions to complete"
>
> There are conversions going from 11.5 to 11.7 ? Does this mean that if I
want
> to revert back, I have to restore the old version of the database ?
>
> Dirk
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art Kagel
> > Sent: Wednesday, 03 August 2011 02:38 PM
> > To: ids@iiug.org
> > Subject: Re: Upgrading from 11.5 to 11.7 [24515]
> >
> > Upgrading Informix is trivial. Install the new version in a new
> > directory,
> > copy the Onconfig and sqlhosts files (or update a copy of .hr new
> > Onconfig.WTF with your specific values), shutdown the current instance,
> > change the INFORMIXDIR link to point to the new installed directory,
> > start
> > the new oninit, wait for conversions to complete, drop distributions on
> > all
> > tables, rerun update statistics for all tables then for all SPL pitied,
> > done.
> >
> > Art
>
> > On Aug 3, 2011 7:11 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za> wrote:
> > > I have been tasked to upgrade one of our servers from 11.5 to 11.7
> > >
> > > I have not installed or upgraded Informix in many years. This should
> > be
> > real
> > > easy, and I plan to do an in-place upgrade.
> > >
> > > Question: where can I download a guide / manual to upgrade from 11.5
> > to
> > 11.7 ?
> > >
> > > Dirk
> > >
> > > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> > >
> > >
> > >
> >
> > ***********************************************************************
> > ********
> >
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> > --bcaec50162819fd0e704a9992373
> >
> >
> > ***********************************************************************
> > ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> NOTE: This e-mail message is subject to the MTN Group disclaimer see
> http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Excellent. Thank you Art.
Dirk
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Friday, 05 August 2011 04:56 PM
> To: ids@iiug.org
> Subject: Re: Upgrading from 11.5 to 11.7 [24546]
>
> Yes there are structural conversions, new SMI tables, changes to
> sysadmin,
> etc. No, you do not have to restore the old database, though I do hope
> you
> took a precautionary archive before the upgrade. You would just have to
> run
> an "onmode -b <version>" command to revert the data structures back to
> that
> version and then restart the instance with the older software.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own
> opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other
> organization with which I am associated either explicitly, implicitly,
> or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
> On Fri, Aug 5, 2011 at 4:49 AM, Dirk Cornel.... <moolma_dc@mtn.co.za>
> wrote:
>
> > "wait for conversions to complete"
> >
> > There are conversions going from 11.5 to 11.7 ? Does this mean that
> if I
> > want
> > to revert back, I have to restore the old version of the database ?
> >
> > Dirk
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > Art Kagel
> > > Sent: Wednesday, 03 August 2011 02:38 PM
> > > To: ids@iiug.org
> > > Subject: Re: Upgrading from 11.5 to 11.7 [24515]
> > >
> > > Upgrading Informix is trivial. Install the new version in a new
> > > directory,
> > > copy the Onconfig and sqlhosts files (or update a copy of .hr new
> > > Onconfig.WTF with your specific values), shutdown the current
> instance,
> > > change the INFORMIXDIR link to point to the new installed
> directory,
> > > start
> > > the new oninit, wait for conversions to complete, drop
> distributions on
> > > all
> > > tables, rerun update statistics for all tables then for all SPL
> pitied,
> > > done.
> > >
> > > Art
> >
> > > On Aug 3, 2011 7:11 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za>
> wrote:
> > > > I have been tasked to upgrade one of our servers from 11.5 to
> 11.7
> > > >
> > > > I have not installed or upgraded Informix in many years. This
> should
> > > be
> > > real
> > > > easy, and I plan to do an in-place upgrade.
> > > >
> > > > Question: where can I download a guide / manual to upgrade from
> 11.5
> > > to
> > > 11.7 ?
> > > >
> > > > Dirk
> > > >
> > > > NOTE: This e-mail message is subject to the MTN Group disclaimer
> see
> > > > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> > > >
> > > >
> > > >
> > >
> > >
> ***********************************************************************
> > > ********
> > >
> > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > >
> > >
> > > --bcaec50162819fd0e704a9992373
> > >
> > >
> > >
> ***********************************************************************
> > > ********
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> >
> >
> >
> >
> ***********************************************************************
> ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --20cf307cfd84b3e95b04a9c3497f
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
NOTE: This e-mail message is subject to the MTN Group disclaimer see
http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
Fine, fine ..... you can call me that. But I know one of you will at least have the Docs link saved somewhere - I do not. In trying to explain, i can give you the short version of my life's story, or the long version - which do you prefer ? Thanks OB / OTC :-) > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Obnoxio The Clown > Sent: Thursday, 04 August 2011 09:21 AM > To: ids@iiug.org > Subject: Re: Upgrading from 11.5 to 11.7 [24534] > > On 03/08/2011 12:11, Dirk Cornel.... wrote: > > I have been tasked to upgrade one of our servers from 11.5 to 11.7 > > > > I have not installed or upgraded Informix in many years. This should > be real > > easy, and I plan to do an in-place upgrade. > > > > Question: where can I download a guide / manual to upgrade from 11.5 > to 11.7 > ? > > > > Dirk > https://www-304.ibm.com/support/docview.wss?uid=swg21259394 > > Lazy cunt. > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum. NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx