Migrating IDS 10.5 on AIX to IDS 12.2 on Linux X86

Good day fellow Informix users, I am planning to perform a proof of concept to migrate an IDS 10.5 (AIX 5.3) installation to an IDs 12.2 Linux x86 (probably SLES 64-bit). Does anyone in this wonderful Informix universe have any suggested readings and/or experience that he/she can share with me as I am getting ready to setup my new test VM and Informix environment. What I am sort of looking for are any hints (DO’s and DON’Ts) wither specific to the O/S, to the type of disk space/filesystem to use and/or any other serious setbacks that I could avoid using someone else’s wisdom who would have done a similar migration before (whether it be from AIX to Linux or from any other O/S to Linux). The database that I am looking at migration has essentially up to 30 dbspaces/extents with approx. 200Gb data within it. Looking forward to hearing back from any of folks. Thanks in advance for your valuable knowledge, skills, expertise and generosity. Au plaisir, / Best Regards, _____ Daniel Dansereau Systèmes LogikInfo Inc. <mailto:daniel.dansereau@logikinfo.com> daniel.dansereau@logikinfo.com Tel: (514) 225-4159 x1121 / Cell: (514) 262-3166 / Fax: (514) 426-0499 Devez-vous vraiment imprimer ce courriel ? Pensons environnement... - Do you really need to print this e-mail ? Think environmentally... Cette transmission est destinée à l'usage exclusif de la personne ou entreprise à laquelle elle est adressée et peut contenir de l'information privilégiée et confidentielle. Si ce document est lu par toute autre personne que le destinataire ou celle responsable de le lui livrer, soyez par les présentes avisé(e) que toute divulgation, distribution ou copie du contenu de cette transmission est strictement interdite. Si vous avez reçu cette transmission par erreur, veuillez nous en aviser immédiatement en répondant à l'expéditeur; de plus, veuillez aussitôt effacer la dite transmission de votre ordinateur. Nous vous remercions à l'avance de votre collaboration. This transmission is intended for the sole use of the individual and/or entity to whom it is addressed, and may contain information and/or attachments that are privileged, confidential and exempt from disclosure under applicable law. If the reader of this transmission is not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, duplication or the taking of any action in reliance on the contents of this transmission by someone other than the intended addressee or its designated agent is strictly prohibited. If you have received this transmission in error, please notify us by replying to the sender immediately and delete the transmission from your computer. We appreciate your collaboration

One definite "don't" is this: Don't set up your dbspaces on a journaled file system. Use raw space if you can, otherwise (if memory serves) you probably want to use the EXT3 file system with journaling turned off. As always avoid RAID 5 if you possibly can. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Daniel Dansereau > Sent: Monday, February 08, 2016 15:46 PM > To: ids@iiug.org > Subject: Migrating IDS 10.5 on AIX to IDS 12.2 on Linux.... [36524] > > Good day fellow Informix users, > > I am planning to perform a proof of concept to migrate an IDS 10.5 (AIX > 5.3) installation to an IDs 12.2 Linux x86 (probably SLES 64-bit). > > Does anyone in this wonderful Informix universe have any suggested > readings and/or experience that he/she can share with me as I am > getting ready to setup my new test VM and Informix environment. What I > am sort of looking for are any hints (DO's and DON'Ts) wither specific > to the O/S, to the type of disk space/filesystem to use and/or any > other serious setbacks that I could avoid using someone else's wisdom > who would have done a similar migration before (whether it be from AIX > to Linux or from any other O/S to Linux). > > The database that I am looking at migration has essentially up to 30 > dbspaces/extents with approx. 200Gb data within it. > > Looking forward to hearing back from any of folks. > > Thanks in advance for your valuable knowledge, skills, expertise and > generosity. > > Au plaisir, / Best Regards, > > _____ > > Daniel Dansereau > > Systèmes LogikInfo Inc. > > <mailto:daniel.dansereau@logikinfo.com> daniel.dansereau@logikinfo.com > > Tel: (514) 225-4159 x1121 / Cell: (514) 262-3166 / Fax: (514) 426-0499 > > Devez-vous vraiment imprimer ce courriel ? Pensons environnement... - > Do you really need to print this e-mail ? Think environmentally... > > Cette transmission est destinée à l'usage exclusif de la personne ou > entreprise à laquelle elle est adressée et peut contenir de > l'information privilégiée et confidentielle. Si ce document est lu par > toute autre personne que le destinataire ou celle responsable de le lui > livrer, soyez par les présentes avisé(e) que toute divulgation, > distribution ou copie du contenu de cette transmission est strictement > interdite. Si vous avez reçu cette transmission par erreur, veuillez > nous en aviser immédiatement en répondant à l'expéditeur; de plus, > veuillez aussitôt effacer la dite transmission de votre ordinateur. > Nous vous remercions à l'avance de votre collaboration. > > This transmission is intended for the sole use of the individual and/or > entity to whom it is addressed, and may contain information and/or > attachments that are privileged, confidential and exempt from > disclosure under applicable law. If the reader of this transmission is > not the intended recipient, you are hereby notified that any > disclosure, dissemination, distribution, duplication or the taking of > any action in reliance on the contents of this transmission by someone > other than the intended addressee or its designated agent is strictly > prohibited. If you have received this transmission in error, please > notify us by replying to the sender immediately and delete the > transmission from your computer. We appreciate your collaboration > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

Daniel: - I agree, avoid journaled filesystems, especially the ones on Linux. - Make decisions about page sizes. Your default on AIX was 4K but on Linux it is 2K so whether you use default pages on the new server or 4K pages may affect performance and may limit table size growth (re: the 2^24 page count limit). - Figure out how many objects (tables, indexes, partitions of same) there will be in each dbspace and use the -ef and -en options to onspaces (or the equivalent SQL API command options) to size the partition header page table at the time the dbspace is created to minimize fragmentation of the tablespace tablespace over time. - Use FILLFACTOR actively to properly configure newly created indexes to avoid unnecessary node splitting. - Take advantage of MAX_FILL_DATA_PAGES to minimize wasted space within tables that have variable length columns (VARCHAR, LVARCHAR, etc.). - Research the various migration methods and pick one that makes sense to you: - Export/import using - UNLOAD/LOAD or dbload - dbexport/dbimport - myexport/myimport using - sqlcmd - HPLoader - External Tables - HPLoader - Direct data copy using SQL tools to the new server - Enterprise Replication Only Enterprise Replication will let you easily perform the migration prior to server cutover and maintain both servers in sync both before and after cutover (in case you have to fall back to the old server shortly after cutover). However, setting up ER between a very old version like 10.00 and v12.10 can be tricky. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 Mon, Feb 8, 2016 at 4:46 PM, Daniel Dansereau < Daniel.Dansereau@logikinfo.com> wrote: > Good day fellow Informix users, > > I am planning to perform a proof of concept to migrate an IDS 10.5 (AIX > 5.3) > installation to an IDs 12.2 Linux x86 (probably SLES 64-bit). > > Does anyone in this wonderful Informix universe have any suggested readings > and/or experience that he/she can share with me as I am getting ready to > setup my new test VM and Informix environment. What I am sort of looking > for are any hints (DOs and DONTs) wither specific to the O/S, to the type > of disk space/filesystem to use and/or any other serious setbacks that I > could avoid using someone elses wisdom who would have done a similar > migration before (whether it be from AIX to Linux or from any other O/S to > Linux). > > The database that I am looking at migration has essentially up to 30 > dbspaces/extents with approx. 200Gb data within it. > > Looking forward to hearing back from any of folks. > > Thanks in advance for your valuable knowledge, skills, expertise and > generosity. > > Au plaisir, / Best Regards, > > _____ > > Daniel Dansereau > > Systèmes LogikInfo Inc. > > <mailto:daniel.dansereau@logikinfo.com> daniel.dansereau@logikinfo.com > > Tel: (514) 225-4159 x1121 / Cell: (514) 262-3166 / Fax: (514) 426-0499 > > Devez-vous vraiment imprimer ce courriel ? Pensons environnement... - Do > you > really need to print this e-mail ? Think environmentally... > > Cette transmission est destinée à l'usage exclusif de la personne ou > entreprise à laquelle elle est adressée et peut contenir de l'information > privilégiée et confidentielle. Si ce document est lu par toute autre > personne que le destinataire ou celle responsable de le lui livrer, soyez > par les présentes avisé(e) que toute divulgation, distribution ou copie du > contenu de cette transmission est strictement interdite. Si vous avez reçu > cette transmission par erreur, veuillez nous en aviser immédiatement en > répondant à l'expéditeur; de plus, veuillez aussitôt effacer la dite > transmission de votre ordinateur. Nous vous remercions à l'avance de votre > collaboration. > > This transmission is intended for the sole use of the individual and/or > entity to whom it is addressed, and may contain information and/or > attachments that are privileged, confidential and exempt from disclosure > under applicable law. If the reader of this transmission is not the > intended > recipient, you are hereby notified that any disclosure, dissemination, > distribution, duplication or the taking of any action in reliance on the > contents of this transmission by someone other than the intended addressee > or its designated agent is strictly prohibited. If you have received this > transmission in error, please notify us by replying to the sender > immediately and delete the transmission from your computer. We appreciate > your collaboration > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1132f2143ab767052b4a1300