Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Red face Unanswered: migration 32 to 64 bits.

    Hi Gurus Informix,

    I have currently informix 940UC7 32 bits, I want migrate to informix 940FC9 64 bits, the operative system is AIX 5.2. In this instalation there are Webshere, cics, cobol, microfocus, etc.

    My question is where look information for this case, or any people than had experience in this.

    Thank you for you help.

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    look into the IBM Informix Migration guide and your machine notes.

  3. #3
    Join Date
    Sep 2008
    Posts
    33

    Hi Guys

    HI geo,

    I have to do the same task in dis weekend.I have to upgrade 7.31 HD10 32 bit to 64 bit.It would be greatly appreciated if you can provide the methdology..


    Thanks
    Mallik

  4. #4
    Join Date
    Mar 2006
    Posts
    15
    Which is volume of data?

  5. #5
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    Exists a few guidelines to follow. All specified in the Migration Guide.

    But, Considering you are migrating in the same version (9.40 32bits -> 9.40 64bits) , theoretically don't have any problem and take less then 4 minutes, the basic steps are:
    - install the new version (64 bits) in other directory
    - copy your enviroment ( set of variables like INFORMIX*) pointing to new dir
    - copy your configurations (onconfig,sqlhosts) to this new directory
    - execute a backup Level 0 ( Murphy Laws still exists )
    - put your instance in quiscent
    - force a checkpoint and jump to next logical log (onmode -c ; onmode -l )
    - wait for all logical log backup (and save this backups! )
    - shutdown your instance
    - open new session pointing to new installation (64 bits)
    - start your database
    - drop all update statistics distributions
    - execute update statistics
    - And your IDS is free to your users...

    I already do this in a IDS 7.31UC2 to 731.FC2 in HP-UX 11.0b with an 700GB database ...
    In some cases have more steps like , remove all ALTER-IN PLACE and other little steps. All this are in the Migration Guide.

    My suggestion , read the Migration Guide. Is a very small manual.

    Just to remember , if you have clients program executing in the same machine and accessing the database with onipcshm (shared memory) , your client application will must be recompiled with 64 bits IDS client , or , you change the type of connection to onipcshm or onsoctcp .
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  6. #6
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Thank you very match for you help CEINMA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •