Migration to 9.4

Posted in 2004

Summary

The poster asked whether onunload/onload could be used to move databases from IDS 9.20/9.30 to 9.40, noting it didn't work for 9.20->9.30. Replies said 9.3->9.4 in-place migration works fine (9.4 supports paths from 9.3, 9.21, 7.31, 7.24, possibly needing a quick hop to 9.21 from 9.20), and that onunload/onload is unsuitable because it writes version-specific binary formats; in-place migration converts the data. Advice included reading the Migration Guide and machine notes (e.g. PLOG_OVERFLOW_PATH for physical log space), taking a level-0 backup, and shutting down ISM first. The poster's final clarified question — whether onunload on 9.3 can be onloaded on a separate 9.4 machine — is not answered in the thread.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades, Migration, Import/Export & Data Conversion

Ljiljana Zivanovic — Wed, 03 Mar 2004 22:24:55 — source: IIUG Forums & Mailing Lists

Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --------------AFB7D32B4223D64582D2373C--

↪ replying to Ljiljana Zivanovic

Madison Pruet — Thu, 04 Mar 2004 00:09:57 — source: IIUG Forums & Mailing Lists

--0__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2 Content-type: multipart/alternative; Boundary="1__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2" --1__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2 Content-type: text/plain; charset=US-ASCII 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --------------AFB7D32B4223D64582D2373C-- --1__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> 9.3->9.4 should work with no problem. <img src="cid:10__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for "Ljiljana Zi...." <ljiljana@mizuhocap.com>">"Ljiljana Zi...." <ljiljana@mizuhocap.com> <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>"Ljiljana Zi...." <ljiljana@mizuhocap.com> Sent by: forum.subscriber@iiug.org 03/03/2004 02:24 PM</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: ids@iiug.org cc: Subject: Migration to 9.4 [2599]</td></tr> </table> <tt>Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged.  If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail.  If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --------------AFB7D32B4223D64582D2373C-- </tt> </body></html> --1__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2-- --0__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2 Content-type: image/gif; name="pic32288.gif" Content-Disposition: inline; filename="pic32288.gif" Content-ID: <30__=07BBE4DEDF931EA28f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYGnKEFJeGrxUZy8dB8gmAXI/sPvH ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1WiMmgkPHQRIrwgFuNV90A3doNKT mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTVIA0yl5ciTovgLuBDKFUDE9aQcw 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA Ow== --0__=07BBE4DEDF931EA28f9e8a93df938690918c07BBE4DEDF931EA2--

↪ replying to Madison Pruet

NormaJean.Sebastian@tellabs.com — Thu, 04 Mar 2004 01:29:28 — source: IIUG Forums & Mailing Lists

I'm confused. Why would you use onunload/onload to migrate when it's so easy to do inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine notes, then start the engine.... and informix converts. Informix is so cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

↪ replying to Madison Pruet

Madison Pruet — Thu, 04 Mar 2004 04:23:33 — source: IIUG Forums & Mailing Lists

--0__=07BBE4DEDF84F1648f9e8a93df938690918c07BBE4DEDF84F164 Content-type: multipart/related; Boundary="1__=07BBE4DEDF84F1648f9e8a93df938690918c07BBE4DEDF84F164" --1__=07BBE4DEDF84F1648f9e8a93df938690918c07BBE4DEDF84F164 Content-type: multipart/alternative; Boundary="2__=07BBE4DEDF84F1648f9e8a93df938690918c07BBE4DEDF84F164" --2__=07BBE4DEDF84F1648f9e8a93df938690918c07BBE4DEDF84F164 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable I guess I should have asked what the issue was with doing an inplace upgrade from 9.2 to 9.3. When 9.3 was released, it was guarenteed to be migratable from 9.21 and= 7.31. 9.4 expanded the migration path to/from 9.3, 9.21, 7.31, 7.24. The inplace upgrade should work. It might be that you might have to do= a temp upgrade from 9.20 to 9.21, but that should be a rather quick proce= ss. M.P. = NormaJean.Sebastian@ = tellabs.com To: forum.subsc= riber@iiug.org, ids@iiug.org, Madison Pruet/Dallas/IBM@IBMUS cc: = 03/03/2004 05:25 PM Subject: RE: Migrati= on to 9.4 [2600] = I'm confused. Why would you use onunload/onload to migrate when it's so easy to do inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine notes, then start the engine.... and informix converts. Informix is so= cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic ----------------------------------------- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = --2__=07BBE4DEDF84F1648f9e8a93df938690918c07BBE4DEDF84F164 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> I guess I should have asked what the issue was with doing an inplace= upgrade from 9.2 to 9.3. When 9.3 was released, it was guarenteed to be migratable from 9.21 and= 7.31. 9.4 expanded the migration path to/from 9.3, 9.21, 7.31, 7.24. = The inplace upgrade should work. It might be that you might have to do= a temp upgrade from 9.20 to 9.21, but that should be a rather quick pr= ocess. M.P. <img src=3D"cid:10__=3D07BBE4DEDF84F1648f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for NormaJean.Sebastian= @tellabs.com">NormaJean.Sebastian@tellabs.com <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D07BBE4DEDF84= F1648f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D07BBE4DEDF84F1648f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D07BBE4DEDF84F1648f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>NormaJean.Sebastian@tellabs.com 03/03/2004 05:25 PM</ul> </ul> </ul> </ul> </td><td width=3D"100%"><img src=3D"cid:20__=3D07BBE4DEDF84F1648f9e8a93= df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> To: forum.subscriber@iiug.org= , ids@iiug.org, Madison Pruet/Dallas/IBM@IBMUS cc: Subject: RE: Migration to 9.4= [2600]</td></tr> </table> <tt>I'm confused. Why would you use onunload/onload to migrate when it's so easy to do<br= > inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine<= br> notes, then start the engine.... and informix converts.  Informix = is so cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's= so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [<a href=3D"mailto:mpruet@us.ibm.com">mailto:mp= ruet@us.ibm.com</a>] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem.                     =                     &= nbsp;                   &n= bsp;                               =  "Ljiljana Zi...."           &n= bsp;                   &nb= sp;                     =  <ljiljana

↪ replying to NormaJean.Sebastian@tellabs.com

Martin Fuerderer — Thu, 04 Mar 2004 12:05:08 — source: IIUG Forums & Mailing Lists

Hi, Norma Jean is right (and Madison too, of course). And it's not only that you can do the migration forward, i.e. from 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not need 9.30 as an intermediate step, but I'm not sure). Generally you can even go backwards, i.e. revert backwards, unless you start using new features in 9.40 that didn't exist in the earlier version ... You can read all about this in detail in the "IBM Informix Migration Guide" manual (make sure you're looking at this manual's edition for IDS 9.40). Additionally I would recommend doing a level 0 backup before starting the migration, but that is described in the manual as well. [ No need for onunload/onload at all. These utilities write and read data in a binary format that is (in parts) specific to the version of IDS in use. Therefore they are not useful for migration, because they will not "adapt" the data to the new binary format of the new version. But this is exactly what is done by the "in place migration", i.e. the normal and recommended way of migration, that Norma Jean and Madison are talking about. ] Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "NormaJean.S...." <NormaJean.Sebastian@tellabs.com> Sent by: forum.subscriber@iiug.org 04.03.2004 02:29 To ids@iiug.org cc Subject RE: Migration to 9.4 [2601] I'm confused. Why would you use onunload/onload to migrate when it's so easy to do inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine notes, then start the engine.... and informix converts. Informix is so cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

↪ replying to NormaJean.Sebastian@tellabs.com

NormaJean.Sebastian@tellabs.com — Thu, 04 Mar 2004 13:21:06 — source: IIUG Forums & Mailing Lists

Hello, I believe some concerns on inplace upgrades may come from oracle experience (or other DB vendors?) I don't mean to bash oracle, I have only been working with it a year or so. However, it seems that standard for oracle upgrades is to freshly install binaries in a new directory, then export the old-version database and import it to the new-version database. sure makes a pig of filesystem space if left unchecked. i believe this is standard oracle practice because oracle is not very concerned with maintaining "under the hood" functionality/etc as ibm/informix (I can't speak for db2, but informix was/is awesome at it). for example there doesn't seem to be much similarity between oracle 8 and oracle 9 (especially under the hood) which is probably why "inplace upgrade" may be a foreign phrase for oracle-ites. A further comment on Gerd's statement: "You must have plenty of physical log (if this runs short during migration you have to restore the old version)" PLEASE do read the Informix release/machine notes that come with your binaries. typically these are found in $INFORMIXDIR/release/en_us/0333. I am upgrading from 7.31 to 9.30 (I'm on SAP... SAP hasn't blessed Informix 9.4 yet). I have a 1.2TB database, my physical log was too small. SAP didn't know the answer (we pay them, not ibm for support)). I found the answer in the Informix machine notes. I did not have to increase the size of my physical log, i merely had to define a new ONCONFIG parameter called PLOG_OVERFLOW_PATH. This parameter may only be for 9.3, I don't know... thus the recommendation to read the informix provided machine/release notes when you plant the binaries, and before you start the engine. have fun.... no doubt, if you prep properly, your inplace upgrade will work like a charm.... it's and informix database... it will come up ;) Norma Jean -----Original Message----- From: MARTINFU@de.ibm.com [mailto:MARTINFU@de.ibm.com] Sent: Thursday, March 04, 2004 6:01 AM To: ljiljana@mizuhocap.com Cc: forum.subscriber@iiug.org; ids@iiug.org; Sebastian, NormaJean Subject: RE: Migration to 9.4 [2601] Hi, Norma Jean is right (and Madison too, of course). And it's not only that you can do the migration forward, i.e. from 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not need 9.30 as an intermediate step, but I'm not sure). Generally you can even go backwards, i.e. revert backwards, unless you start using new features in 9.40 that didn't exist in the earlier version ... You can read all about this in detail in the "IBM Informix Migration Guide" manual (make sure you're looking at this manual's edition for IDS 9.40). Additionally I would recommend doing a level 0 backup before starting the migration, but that is described in the manual as well. [ No need for onunload/onload at all. These utilities write and read data in a binary format that is (in parts) specific to the version of IDS in use. Therefore they are not useful for migration, because they will not "adapt" the data to the new binary format of the new version. But this is exactly what is done by the "in place migration", i.e. the normal and recommended way of migration, that Norma Jean and Madison are talking about. ] Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "NormaJean.S...." <NormaJean.Sebastian@tellabs.com> Sent by: forum.subscriber@iiug.org 04.03.2004 02:29 To ids@iiug.org cc Subject RE: Migration to 9.4 [2601] I'm confused. Why would you use onunload/onload to migrate when it's so easy to do inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine notes, then start the engine.... and informix converts. Informix is so cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

↪ replying to Martin Fuerderer

Darren_Jacobs@carmax.com — Thu, 04 Mar 2004 13:45:06 — source: IIUG Forums & Mailing Lists

One more thing to note, if you are using ISM or other third party storage manager make sure you bring it down prior to performing the install (ism_shutdown). I have recently completed a migration from 9.21 to 9.40 and in-place upgrade is a piece of cake! As noted below, level 0 archive, bring the engine down using onmode -yuk, become root, source all env variables, from the CD directory run ids_install..... the rest is history!! Oh yeah, I performed full onchecks and stats after the upgrade. Have fun. "Martin Fuer...." <MARTINFU@de.ibm.com> Sent by: forum.subscriber@iiug.org 03/04/04 07:05 AM To ids@iiug.org cc Subject RE: Migration to 9.4 [2605] Hi, Norma Jean is right (and Madison too, of course). And it's not only that you can do the migration forward, i.e. from 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not need 9.30 as an intermediate step, but I'm not sure). Generally you can even go backwards, i.e. revert backwards, unless you start using new features in 9.40 that didn't exist in the earlier version ... You can read all about this in detail in the "IBM Informix Migration Guide" manual (make sure you're looking at this manual's edition for IDS 9.40). Additionally I would recommend doing a level 0 backup before starting the migration, but that is described in the manual as well. [ No need for onunload/onload at all. These utilities write and read data in a binary format that is (in parts) specific to the version of IDS in use. Therefore they are not useful for migration, because they will not "adapt" the data to the new binary format of the new version. But this is exactly what is done by the "in place migration", i.e. the normal and recommended way of migration, that Norma Jean and Madison are talking about. ] Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "NormaJean.S...." <NormaJean.Sebastian@tellabs.com> Sent by: forum.subscriber@iiug.org 04.03.2004 02:29 To ids@iiug.org cc Subject RE: Migration to 9.4 [2601] I'm confused. Why would you use onunload/onload to migrate when it's so easy to do inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine notes, then start the engine.... and informix converts. Informix is so cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

↪ replying to NormaJean.Sebastian@tellabs.com

Ljiljana Zivanovic — Thu, 04 Mar 2004 14:49:21 — source: IIUG Forums & Mailing Lists

Hi, the way I asked question might be little bit confusing. Let me put it this way. We will normally do "in place migration" it is not the question. But lets say I have machine with IDS 9.3 and the other one with IDS 9.4. Can I onunload database on 9.3 and onload it on 9.4 ? Does that work? For 9.2-->9.3 as I stated previously it doesn't. -- Ljiljana Martin Fuerderer wrote: > > Hi, > > Norma Jean is right (and Madison too, of course). > > And it's not only that you can do the migration forward, i.e. from > 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not > need 9.30 as an intermediate step, but I'm not sure). > > Generally you can even go backwards, i.e. revert backwards, > unless you start using new features in 9.40 that didn't exist in the > earlier version ... > > You can read all about this in detail in the "IBM Informix Migration > Guide" manual (make sure you're looking at this manual's edition > for IDS 9.40). > > Additionally I would recommend doing a level 0 backup before > starting the migration, but that is described in the manual as well. > > [ No need for onunload/onload at all. These utilities write and read > data in a binary format that is (in parts) specific to the version > of IDS in use. Therefore they are not useful for migration, because they > will not "adapt" the data to the new binary format of the new version. > But this is exactly what is done by the "in place migration", i.e. the > normal and recommended way of migration, that Norma Jean and > Madison are talking about. ] > > Regards, > Martin > -- > Martin Fuerderer > IBM Informix Development Munich > Data Management Solutions > > "NormaJean.S...." <NormaJean.Sebastian@tellabs.com> > Sent by: forum.subscriber@iiug.org > 04.03.2004 02:29 > > To > ids@iiug.org > cc > > Subject > RE: Migration to 9.4 [2601] > > I'm confused. > Why would you use onunload/onload to migrate when it's so easy to do > inplace Informix upgrades? > > Don't people generally stop the DB, install the new binaries in > $INFORMIXDIR, make any environment/system changes per Informix machine > notes, then start the engine.... and informix converts. Informix is so > cool that way. > > Generally we do not do "in place" upgrades of Oracle cuz it's so much > more complex and glitchy. > > Norma Jean > > -----Original Message----- > From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] > Sent: Wednesday, March 03, 2004 6:10 PM > To: ids@iiug.org; forum.subscriber@iiug.org > Subject: Re: Migration to 9.4 [2600] > > 9.3->9.4 should work with no problem. > > > > "Ljiljana Zi...." > > <ljiljana@mizuhoc To: ids@iiug.org > > ap.com> cc: > > Sent by: Subject: Migration to > 9.4 [2599] > forum.subscriber@ > > iiug.org > > > > > > 03/03/2004 02:24 > > PM > > > > Hi, > we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use > onunload/onload for migrating databases? I know that for 9.20 -> 9.30 > it is not working. How about 9.30 -> 9.40? > Thanks. > Ljiljana Zivanovic > > ----------------------------------------- > ============================================================ > The information contained in this message may be privileged > and confidential and protected from disclosure. If the > reader of this message is not the intended recipient, or an > employee or agent responsible for delivering this message to > the intended recipient, you are hereby notified that any > reproduction, dissemination or distribution of this > communication is strictly prohibited. If you have received > this communication in error, please notify us immediately by > replying to the message and deleting it from your computer. > > Thank you. > Tellabs > ============================================================ --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --------------D6E9DC1062CB18A2D3E09238--

↪ replying to NormaJean.Sebastian@tellabs.com

Martin Fuerderer — Thu, 04 Mar 2004 15:10:41 — source: IIUG Forums & Mailing Lists

Hi, no. It's not expected to work. You would have to use dbexport/dbimport for that kind of operation. Or use High Performance Loader to get things done faster than with dbexport/dbimport. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions Ljiljana Zivanovic <ljiljana@mizuhocap.com> 04.03.2004 15:45 To Martin Fuerderer/Germany/IBM@IBMDE cc forum.subscriber@iiug.org, ids@iiug.org, NormaJean.Sebastian@tellabs.com Subject Re: Migration to 9.4 [2601] Hi, the way I asked question might be little bit confusing. Let me put it this way. We will normally do "in place migration" it is not the question. But lets say I have machine with IDS 9.3 and the other one with IDS 9.4. Can I onunload database on 9.3 and onload it on 9.4 ? Does that work? For 9.2-->9.3 as I stated previously it doesn't. -- Ljiljana Martin Fuerderer wrote: > > Hi, > > Norma Jean is right (and Madison too, of course). > > And it's not only that you can do the migration forward, i.e. from > 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not > need 9.30 as an intermediate step, but I'm not sure). > > Generally you can even go backwards, i.e. revert backwards, > unless you start using new features in 9.40 that didn't exist in the > earlier version ... > > You can read all about this in detail in the "IBM Informix Migration > Guide" manual (make sure you're looking at this manual's edition > for IDS 9.40). > > Additionally I would recommend doing a level 0 backup before > starting the migration, but that is described in the manual as well. > > [ No need for onunload/onload at all. These utilities write and read > data in a binary format that is (in parts) specific to the version > of IDS in use. Therefore they are not useful for migration, because they > will not "adapt" the data to the new binary format of the new version. > But this is exactly what is done by the "in place migration", i.e. the > normal and recommended way of migration, that Norma Jean and > Madison are talking about. ] > > Regards, > Martin > -- > Martin Fuerderer > IBM Informix Development Munich > Data Management Solutions > > "NormaJean.S...." <NormaJean.Sebastian@tellabs.com> > Sent by: forum.subscriber@iiug.org > 04.03.2004 02:29 > > To > ids@iiug.org > cc > > Subject > RE: Migration to 9.4 [2601] > > I'm confused. > Why would you use onunload/onload to migrate when it's so easy to do > inplace Informix upgrades? > > Don't people generally stop the DB, install the new binaries in > $INFORMIXDIR, make any environment/system changes per Informix machine > notes, then start the engine.... and informix converts. Informix is so > cool that way. > > Generally we do not do "in place" upgrades of Oracle cuz it's so much > more complex and glitchy. > > Norma Jean > > -----Original Message----- > From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] > Sent: Wednesday, March 03, 2004 6:10 PM > To: ids@iiug.org; forum.subscriber@iiug.org > Subject: Re: Migration to 9.4 [2600] > > 9.3->9.4 should work with no problem. > > > > "Ljiljana Zi...." > > <ljiljana@mizuhoc To: ids@iiug.org > > ap.com> cc: > > Sent by: Subject: Migration to > 9.4 [2599] > forum.subscriber@ > > iiug.org > > > > > > 03/03/2004 02:24 > > PM > > > > Hi, > we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use > onunload/onload for migrating databases? I know that for 9.20 -> 9.30 > it is not working. How about 9.30 -> 9.40? > Thanks. > Ljiljana Zivanovic > > ----------------------------------------- > ============================================================ > The information contained in this message may be privileged > and confidential and protected from disclosure. If the > reader of this message is not the intended recipient, or an > employee or agent responsible for delivering this message to > the intended recipient, you are hereby notified that any > reproduction, dissemination or distribution of this > communication is strictly prohibited. If you have received > this communication in error, please notify us immediately by > replying to the message and deleting it from your computer. > > Thank you. > Tellabs > ============================================================[attachment "ljiljana.vcf" deleted by Martin Fuerderer/Germany/IBM] --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. ---------------------------------------------------------

↪ replying to Darren_Jacobs@carmax.com

ART KAGEL, BLOOMBERG/ 499 PARK — Thu, 04 Mar 2004 15:35:09 — source: IIUG Forums & Mailing Lists

I would just add that it is FAR better to install the new version in a different subdirectory before bringing the engine down. This has several advantages: - Minimize downtime by copying sqlhosts and onconfig files and adjusting any new or changed ONCONFIG parameters before bringing the engine offline. - No scramble to find the installation tape/disk/file and serial number card/file if an emergency reversion is needed. - Minimize rollback time to revert to old version. - Permit leisurely installation at convenient time and minimize loss of sleep during the upgrade itself. ;-) Disadvantages?: - Need to install all development products, etc. again in each new version directory. - Needs extra disk space for multiple copies of the other products. To ease doing things this way I always use a symbolic link for the actual INFORMIXDIR which is linked to whichever directory contains the current release we're running. Rolling forward or back just entails shutting down the engine, removing the link, recreating the link to point to the desired version, So the procedure is: 1- Create new subdirectory for new version installation. 2- Install pre-requisites (ie older version software like ISQL that need to be installed before the engine). 3- Install new version of IDS. 4- Install software like ESQL/C that must be installed after the engine. 5- Copy config files ($ONCONFIG and sqlhosts and onbar backup files, etc.) and update the configuration with new parameters and changes (ex: NUMCPUVPS, NOAGE, etc. have been overridden by a new parameter in 9.4). 6- Take the safety archive of the existing instance and shutdown the instance. 7- rm $INFORMIXDIR 8- ln -s $NEW_INSTALL_DIR $INFORMIXDIR 9- Reset your PATH to point to the new $INFORMIXDIR/bin (relogin, rerun profile, etc.) 10- start new IDS 11- Take the safety archive of the new instance. 12- Test. 13- Put system back into production mode. Art S. Kagel ----- Original Message ----- From: Darren_jaco.... <Darren_Jacobs@carmax.com> At: 3/ 4 9:33 One more thing to note, if you are using ISM or other third party storage manager make sure you bring it down prior to performing the install (ism_shutdown). I have recently completed a migration from 9.21 to 9.40 and in-place upgrade is a piece of cake! As noted below, level 0 archive, bring the engine down using onmode -yuk, become root, source all env variables, from the CD directory run ids_install..... the rest is history!! Oh yeah, I performed full onchecks and stats after the upgrade. Have fun. "Martin Fuer...." <MARTINFU@de.ibm.com> Sent by: forum.subscriber@iiug.org 03/04/04 07:05 AM To ids@iiug.org cc Subject RE: Migration to 9.4 [2605] Hi, Norma Jean is right (and Madison too, of course). And it's not only that you can do the migration forward, i.e. from 9.20 to 9.30 to 9.40 (and I even think for 9.20 to 9.40 you might not need 9.30 as an intermediate step, but I'm not sure). Generally you can even go backwards, i.e. revert backwards, unless you start using new features in 9.40 that didn't exist in the earlier version ... You can read all about this in detail in the "IBM Informix Migration Guide" manual (make sure you're looking at this manual's edition for IDS 9.40). Additionally I would recommend doing a level 0 backup before starting the migration, but that is described in the manual as well. [ No need for onunload/onload at all. These utilities write and read data in a binary format that is (in parts) specific to the version of IDS in use. Therefore they are not useful for migration, because they will not "adapt" the data to the new binary format of the new version. But this is exactly what is done by the "in place migration", i.e. the normal and recommended way of migration, that Norma Jean and Madison are talking about. ] Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "NormaJean.S...." <NormaJean.Sebastian@tellabs.com> Sent by: forum.subscriber@iiug.org 04.03.2004 02:29 To ids@iiug.org cc Subject RE: Migration to 9.4 [2601] I'm confused. Why would you use onunload/onload to migrate when it's so easy to do inplace Informix upgrades? Don't people generally stop the DB, install the new binaries in $INFORMIXDIR, make any environment/system changes per Informix machine notes, then start the engine.... and informix converts. Informix is so cool that way. Generally we do not do "in place" upgrades of Oracle cuz it's so much more complex and glitchy. Norma Jean -----Original Message----- From: mpruet@us.ibm.com [mailto:mpruet@us.ibm.com] Sent: Wednesday, March 03, 2004 6:10 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Re: Migration to 9.4 [2600] 9.3->9.4 should work with no problem. "Ljiljana Zi...." <ljiljana@mizuhoc To: ids@iiug.org ap.com> cc: Sent by: Subject: Migration to 9.4 [2599] forum.subscriber@ iiug.org 03/03/2004 02:24 PM Hi, we are planning to upgrade from 9.20, 9.30 to 9.40. Can we use onunload/onload for migrating databases? I know that for 9.20 -> 9.30 it is not working. How about 9.30 -> 9.40? Thanks. Ljiljana Zivanovic ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

↪ replying to Martin Fuerderer

MAHESH DASHORA — Fri, 05 Mar 2004 03:17:46 — source: IIUG Forums & Mailing Lists

From Version 7.24, 7.3,7.31,9.2,9.21,9.3,9.4 TO 9.4 ( both 32 and 64) is direct migration path supported and tested. (both Converting and Reverting) There is no need for intermediate conversion. Section 2-5 of IBM Informix migration guide will help you decide which are the best utilities for you to consider. In place migration is best way to do it (Chapter 3). Martin has made good suggestions for backing up data (per manual). Regards, Mahesh

↪ replying to NormaJean.Sebastian@tellabs.com

cberner99@juno.com — Fri, 05 Mar 2004 14:27:16 — source: IIUG Forums & Mailing Lists

Hi Norma, You are correct with Oracle upgrades, but no more with 10G. This version will give IBM a run for there money Oracle has finally caught up to Informix ease of use. I remember late 90's Oracle has highered number of Informix Developers and I see they have incorporated the Informix database ideas into Oracle like external tables and modify memory paramters with out rebooting. PS I see you working at tellabs. Are you working out of the Illinois office? I interviewed with them back in 1985.

↪ replying to ART KAGEL, BLOOMBERG/ 499 PARK

Andreas.KUTSCHE@spar.at — Sat, 06 Mar 2004 15:43:40 — source: IIUG Forums & Mailing Lists

----LNX_Sat_Mar_06_2004_16:39:55_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2004.03.04 19:12:40 >Sender: ART KAGEL, .... <KAGEL@bloomberg.net> > >I would just add that it is FAR better to install the new version ina di= fferent > subdirectory before bringing the engine down. This has several advanta= ges: >- Minimize downtime by copying sqlhosts and onconfig files and adjusting= any new > or changed ONCONFIG parameters before bringing the engine offline. >- No scramble to find the installation tape/disk/file and serial number >card/file if an emergency reversion is needed. >- Minimize rollback time to revert to old version. >- Permit leisurely installation at convenient time and minimize lossof s= leep >during the upgrade itself. ;-) > >Disadvantages?: >- Need to install all development products, etc. again in each new versi= on >directory. >- Needs extra disk space for multiple copies of the other products. > >To ease doing things this way I always use a symbolic link for the INFOR= MIXDIR = Hi, = as always Art Kagels recommendations are a great win. We go even a little= bit further and install the (newer) development tools (e.g. SDKs) in extra di= rectories (with sqlhosts being a symbolic link to the server directory). That solution sh= ould be possible in most cases. With this approach it is easier to change between= SDKs version (or use them in parallel) and to work with 32bit SDKs and a 64bit server. = Regards, Andreas Kutsche ------------------------------------------------ SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastra=DFe 3 A-5015 Salzburg = Telefon : +43 662 4470 24423 E-Mail : Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------------ = ----LNX_Sat_Mar_06_2004_16:39:55_V3.33----

Related threads

Glossary

onload / onunload