Informix data files interchangable btw Unix & Win?

Posted in 2004

Summary

Michael asked whether Informix data files from a Unixware server could be used on a Windows server. Tilman said it is unsupported but can work with the same page size and byte order, with caution about locales. Francisco Virgilio said chunks cannot be moved and suggested dbexport/dbimport, unload/load or replication. Christine Normile confirmed dbexport and dbimport are required.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Platform-Specific Issues

Michael — Wed, 24 Mar 2004 06:54:46 — source: IIUG Forums & Mailing Lists

Currently i've a server running Informix on Unixware. I'm thinking of setting up a development server running on Windows server and Informix for Windows. Is it possible for the data files to be transfer from the Unix server to be used in the windows server? Are there any step by step documentation for this? Thanks!

↪ replying to Michael

Tilman — Wed, 24 Mar 2004 08:54:31 — source: IIUG Forums & Mailing Lists

Dear Michael, This trick is not supported at all. It works , though, for platforms that: 1) have the same Informix page size (2K for most platforms, 4K for AIX and Windows) 2) Have the same byte order scheme (big endian vs little endian) For example, this trick has been successfully been implemeted for migrations of an IDS instance on RELIANT to a SOLARIS machine. In any case, you need to take care , if your databases have been created with OS locales . There may be difficulties if the locales in the source system are not present in the target system. Again, this is far from being officially supported. If you can afford a downtime to export all data to a file system, create a new instance , with a new datbase of the same schema and then reload all data I'd recommend this approach over the hack. With kind regrads Tilman -- Tilman Model-Bosch IBM Data Managment Solutions, Informix Advanced Support c\\\\o SAP AG TECHDEV 05 Neurrotstr.16 69190 Walldorf "Michael" <michael@mikeymal l.com> To Sent by: ids@iiug.org forum.subscriber@ cc iiug.org Subject Informix data files interchangable 03/24/2004 07:54 btw Unix & Win? [2727] AM Currently i've a server running Informix on Unixware. I'm thinking of setting up a development server running on Windows server and Informix for Windows. Is it possible for the data files to be transfer from the Unix server to be used in the windows server? Are there any step by step documentation for this? Thanks!

↪ replying to Michael

Francisco Virgilio — Wed, 24 Mar 2004 21:50:35 — source: IIUG Forums & Mailing Lists

Hi, What kind of Data Files ? (DB Chunks ?). If DB Chunks, it's not possible. Try DBEXPORT and FTP to Windows and DBIMPORT or (table level) Unload to file Load from file or (replicate transactions) Use Replication (CDR)

↪ replying to Tilman

- — Thu, 25 Mar 2004 11:02:19 — source: IIUG Forums & Mailing Lists

hmm... so am i right to say that the only way is thru a dbexport from the unix system and dbimport into my windows system?

↪ replying to -

Christine Normile — Thu, 25 Mar 2004 22:20:53 — source: IIUG Forums & Mailing Lists

Yes. To move Informix Dynamic Server from one operating system to another, you must run DBExport and DBImport. Christine Normile I/T Specialist, Informix Solutions Data Management Worldwide Technical Enablement Telephone: 877-252-5399 T/L 273-0981 Mobile: 210-365-5073 "- MICHAEL" <michael@mikeymall.com> Sent by: forum.subscriber@iiug.org 03/25/2004 05:02 AM To: ids@iiug.org cc: Subject: Re: Re: Informix data files interchangable btw Unix & Win? [2741] hmm... so am i right to say that the only way is thru a dbexport from the unix system and dbimport into my windows system?