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.

look into the IBM Informix Migration guide and your machine notes.

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

Which is volume of data?

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 .

Thank you very match for you help CEINMA.