Re: Migration from AIX to Linux

Should I ask You how You transfer data among these Informix instances on AIX and Linux? We also plan to migrate Informix 11.50 from AIX (RISC) to Red Hat Linux (x86_64) and as I know, the only way how to migrate data is to use text files (using HPL for performance reasons) - it's not possible to use onunload/onload utilities or backup/recovery utilities like ontape or onbar. Is there any another how to migrate data from "RISC" platform to "x86_64"? Thanks a lot Ondrej

Hello. You could always use ER for migration purposes without downtime. It´s a great feature for that. You might just have to tune some TCP stuff, to optimize data transfer, and voilà. Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: ondrej.mika@ais.cz > Subject: Re: Migration from AIX to Linux [32188] > Date: Thu, 9 Jan 2014 08:42:28 -0500 > > Should I ask You how You transfer data among these Informix instances on AIX > and Linux? > We also plan to migrate Informix 11.50 from AIX (RISC) to Red Hat Linux > (x86_64) and as I know, the only way how to migrate data is to use text files > (using HPL for performance reasons) - it's not possible to use onunload/onload > utilities or backup/recovery utilities like ontape or onbar. > > Is there any another how to migrate data from "RISC" platform to "x86_64"? > > Thanks a lot > Ondrej > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

There are several other options besides dbexport to text and reload: 1 - If you have no BLOB, CLOB, TEXT, or BYTE columns you can use my binary export/import tool ul.ec which is in the utils2_ak package in the IIUG Software Repository. It's default binary format is portable between architectures and the binary files also tend to be a bit smaller than text export files unless you have lots of varchar and lvarchar type columns that are mostly empty or char type columns with lots of trailing spaces. 2 - You can copy the data directly from one server to the other using tools like my dbcopy and dbmove utilities (also in utils2_ak). 3 -Use the HPLoader to copy data out through pipes to HPLoader instances on the new server reloading it directly without disk in between. 4 - Use External tables linked to pipes to do the same thing as in #3 but simpler to implement and manage. 5 - Use Enterprise Replication to replicate the data to the new server. This has the advantage that it can maintain both servers in sync both before and after the cut over to the new system. That way in case there are performance or other unexpected problems after cut over you can always cut back to the original server(s) until the problem on the new server(s) can be resolved. Then, once everything has been on line on the new server(s) for a month or so and all is well, you can stop ER and shut down the older servers for good. In addition, besides using dbexport/dbimport for export/import using text files, you can use my dbexport/dbimport replacement utility package, myexport (also in the IIUG Repository and it requires utils2_ak at a minimum) which can use external tables and export/import many or all tables in parallel to speed up the process. It's a least 2x as fast as dbexport/dbimport. It also has some nice features like automatic remapping of dbspace assignments in "IN <dbspace>" clauses. Art Art S. Kagel, Principal Consultant 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 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 Thu, Jan 9, 2014 at 8:42 AM, ONDREJ MIKA <ondrej.mika@ais.cz> wrote: > Should I ask You how You transfer data among these Informix instances on > AIX > and Linux? > We also plan to migrate Informix 11.50 from AIX (RISC) to Red Hat Linux > (x86_64) and as I know, the only way how to migrate data is to use text > files > (using HPL for performance reasons) - it's not possible to use > onunload/onload > utilities or backup/recovery utilities like ontape or onbar. > > Is there any another how to migrate data from "RISC" platform to "x86_64"? > > Thanks a lot > Ondrej > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c233ec74587704ef8a2cee

Or, use the dbexport, dbimport commands. On 01/09/2014 08:00 AM, Alexandre Marini wrote: > Hello. > You could always use ER for migration purposes without downtime. It´s a great > feature for that. > You might just have to tune some TCP stuff, to optimize data transfer, and > voilà. > > Best regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 > > IBM Information Management Informix Technical Professional > > IBM Infosphere DataStage Technical Professional > Informix Senior DBA - Orizon Brasil > BRIUG website administrator > Informix independent consultant > >> To: ids@iiug.org >> From: ondrej.mika@ais.cz >> Subject: Re: Migration from AIX to Linux [32188] >> Date: Thu, 9 Jan 2014 08:42:28 -0500 >> >> Should I ask You how You transfer data among these Informix instances on AIX >> and Linux? >> We also plan to migrate Informix 11.50 from AIX (RISC) to Red Hat Linux >> (x86_64) and as I know, the only way how to migrate data is to use text > files >> (using HPL for performance reasons) - it's not possible to use > onunload/onload >> utilities or backup/recovery utilities like ontape or onbar. >> >> Is there any another how to migrate data from "RISC" platform to "x86_64"? >> >> Thanks a lot >> Ondrej >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212 "Never attribute to malice, that which can be adequately explained by stupidity" - Hanlon's Razor

We did this, two years ago perfectly . http://presentations.oninit.com/public/2013IIUG/B04.pdf Thanks, Frank On Thu, Jan 9, 2014 at 8:42 AM, ONDREJ MIKA <ondrej.mika@ais.cz> wrote: > Should I ask You how You transfer data among these Informix instances on > AIX > and Linux? > We also plan to migrate Informix 11.50 from AIX (RISC) to Red Hat Linux > (x86_64) and as I know, the only way how to migrate data is to use text > files > (using HPL for performance reasons) - it's not possible to use > onunload/onload > utilities or backup/recovery utilities like ontape or onbar. > > Is there any another how to migrate data from "RISC" platform to "x86_64"? > > Thanks a lot > Ondrej > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1135f14044679004ef8c58c5