IDS Forum

Re: Migrating IDS 10.5 on AIX to IDS 12.2 on Linux

Posted By: Art Kagel
Date: Monday, 8 February 2016, at 5:54 p.m.

In Response To: Migrating IDS 10.5 on AIX to IDS 12.2 on Linux X86 (Daniel Dansereau)

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

Messages In This Thread

• Migrating IDS 10.5 on AIX to IDS 12.2 on Linux X86
  Daniel Dansereau -- Monday, 8 February 2016, at 4:46 p.m.
  • RE: Migrating IDS 10.5 on AIX to IDS 12.2 on Linux
    Everett Mills -- Monday, 8 February 2016, at 5:28 p.m.
  • Re: Migrating IDS 10.5 on AIX to IDS 12.2 on Linux
    Art Kagel -- Monday, 8 February 2016, at 5:54 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.