Upgrade Advice

I am about to embark upon a project to upgrade from 11.5 to 12.0. The old machine is AIX and the new machine is LINUX - therefore we are going from one "endian-ness" to a different "endian-ness". I am expecting to have to unload and reload via ascii tables to handle this. The database is aprrox 1400 tables, 400 million rows, 200GB Does anyone have any suggestions as to which tools I might use to make this happen as fast as possible? UNLOAD and LOAD are the obvious ones. I'm guessing I can't use dbimport / dbexport due to the OS change.

DB-Export and DB-Import are platform neutral, using UNLOAD format data for the exchange. They are a logical pair of programs to use, unless you want to try the code from Art Kagel's utilities. On Tue, Jun 24, 2014 at 7:19 PM, RAY BURNS <ray.burns@velocityglobal.co.nz> wrote: > I am about to embark upon a project to upgrade from 11.5 to 12.0. The old > machine is AIX and the new machine is LINUX - therefore we are going from > one > "endian-ness" to a different "endian-ness". > > I am expecting to have to unload and reload via ascii tables to handle > this. > The database is aprrox 1400 tables, 400 million rows, 200GB > > Does anyone have any suggestions as to which tools I might use to make this > happen as fast as possible? UNLOAD and LOAD are the obvious ones. I'm > guessing > I can't use dbimport / dbexport due to the OS change. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --089e013cb6e4ce882004fc9fbc83

Ray: You can definitely use dbexport & dbimport to do this which will be MUCH easier than managing UNLOAD and LOAD yourself. If you want more speed, get my dbexport/dbimport replacement utility in the myexport package from the IIUG Software Repository. It optionally uses external tables for the data unload and reload which is MUCH faster than dbexport/dbimport. In addition, myexport and myimport can work in parallel working on <N> tables at once. If your machine and IO systems have the capacity to export two or more tables in parallel without slowing down that will be two or more times faster than dbexport/dbimport. Myexport is compatible with dbexport and dbimport. You an use myexport and dbimport the data or dbexport the data and use myimport to reload it, though using myexport with myimport in parallel mode is fastest. If you decide to give myexport a try, you will need my utils2_ak package because it uses my myschema utility to get the database schema. You will also need Jonathan Leffler's sqlcmd utility package. Myimport uses sqlcmd to create the database on the target system. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Tue, Jun 24, 2014 at 10:19 PM, RAY BURNS <ray.burns@velocityglobal.co.nz> wrote: > I am about to embark upon a project to upgrade from 11.5 to 12.0. The old > machine is AIX and the new machine is LINUX - therefore we are going from > one > "endian-ness" to a different "endian-ness". > > I am expecting to have to unload and reload via ascii tables to handle > this. > The database is aprrox 1400 tables, 400 million rows, 200GB > > Does anyone have any suggestions as to which tools I might use to make this > happen as fast as possible? UNLOAD and LOAD are the obvious ones. I'm > guessing > I can't use dbimport / dbexport due to the OS change. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3b5dc3dbda604fca6d8af

You can use "select from.......insert into", making sure that all tables are created in raw mode, then create other objects after the loads are complete. I have done that, and also used ESQL/C programs to do the same. Walt Sent from Samsung tablet -------- Original message -------- From RAY BURNS <ray.burns@velocityglobal.co.nz> Date: 06/24/2014 10:19 PM (GMT-05:00) To ids@iiug.org Subject Upgrade Advice [33279] I am about to embark upon a project to upgrade from 11.5 to 12.0. The old machine is AIX and the new machine is LINUX - therefore we are going from one "endian-ness" to a different "endian-ness". I am expecting to have to unload and reload via ascii tables to handle this. The database is aprrox 1400 tables, 400 million rows, 200GB Does anyone have any suggestions as to which tools I might use to make this happen as fast as possible? UNLOAD and LOAD are the obvious ones. I'm guessing I can't use dbimport / dbexport due to the OS change. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.