server migration from windows to linuxu
User asked whether chunk files (or backups) from Informix 11.7 on Windows 2008 64-bit could simply be copied/restored onto Linux 64-bit. Consensus from several respondents: no — chunk and archive formats are platform-specific (different page sizes, binary layouts), so it's unsupported and shouldn't be attempted. Recommended migration methods instead: dbexport/dbimport, HPL, cross-server INSERT INTO ... SELECT from db@remoteserver:table, Art Kagel's myutils migration tools, or Enterprise Replication to minimise downtime. The poster thanked the group.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
hello: my doubt is about chunks. can i copy chunk files from windows to linux? can linux manage right chunk files from windows? my doubt is about to export data fully with two informix v11.7 from windows 2008 64b to linux 64b. thank you and regards. --047d7bb04cf2188a3904d02c3322
Hi,
I dont think so, the binary format is platform specific, same as the backup
format.
So there is no ability to restore a windows archive to a linux machine.
In order to migrate an instance to linux, you should dbexport/dbimport or use
a HPL.
Marcus
----- Ursprüngliche Mail -----
Von: "Juan Francisco González Navarro" <jfrancisco.navarro@gmail.com>
An: ids@iiug.org
Gesendet: Donnerstag, 6. Dezember 2012 11:02:45
Betreff: server migration from windows to linuxu [29029]
hello:
my doubt is about chunks. can i copy chunk files from windows to linux? can
linux manage right chunk files from windows?
my doubt is about to export data fully with two informix v11.7 from windows
2008 64b to linux 64b.
thank you and regards.
--047d7bb04cf2188a3904d02c3322
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Juan
This is not possible, nor can you take an archive and restore. Three
options:
1. dbexport/import
2. Enable both servers to 'see' each other then on server L,
INSERT INTO table ttt SELECT * from db@serverW:ttt3. Use Art's data migration utilities from myutils.
The data Migration Guide is you r friend :-)
Keith
On 6 December 2012 10:02, Juan Francisco González Navarro <
jfrancisco.navarro@gmail.com> wrote:
> hello:
>
> my doubt is about chunks. can i copy chunk files from windows to linux? can
> linux manage right chunk files from windows?
>
> my doubt is about to export data fully with two informix v11.7 from windows
> 2008 64b to linux 64b.
>
> thank you and regards.
>
> --047d7bb04cf2188a3904d02c3322
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec54d43ea884c2004d02ca3c5
hello.
thank you everyone.
regards
El 06/12/2012 11:43, "Keith Simmons" <smiley73@gmail.com> escribió:
> Juan
>
> This is not possible, nor can you take an archive and restore. Three
> options:
> 1. dbexport/import
> 2. Enable both servers to 'see' each other then on server L,
> INSERT INTO table ttt SELECT * from db@serverW:ttt> 3. Use Art's data migration utilities from myutils.
>
> The data Migration Guide is you r friend :-)
>
> Keith
>
> On 6 December 2012 10:02, Juan Francisco González Navarro <
> jfrancisco.navarro@gmail.com> wrote:
>
> > hello:
> >
> > my doubt is about chunks. can i copy chunk files from windows to linux?
> can
> > linux manage right chunk files from windows?
> >
> > my doubt is about to export data fully with two informix v11.7 from
> windows
> > 2008 64b to linux 64b.
> >
> > thank you and regards.
> >
> > --047d7bb04cf2188a3904d02c3322
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --bcaec54d43ea884c2004d02ca3c5
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7bb04cf23faf0204d02d8c32
Officially, this will not work. In practice will it work? Don't know. I wouldn't try it for any database instance that i care about Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Dec 6, 2012 at 5:02 AM, Juan Francisco González Navarro < jfrancisco.navarro@gmail.com> wrote: > hello: > > my doubt is about chunks. can i copy chunk files from windows to linux? can > linux manage right chunk files from windows? > > my doubt is about to export data fully with two informix v11.7 from windows > 2008 64b to linux 64b. > > thank you and regards. > > --047d7bb04cf2188a3904d02c3322 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9341185e30e4b04d02df50a
Hello, I doubt it, and would never try to figure it out. Windows file/binary treatment are different from Linux. If you want to minimize your downtime, ER replication would be a good way to do it. 11.70 has several good features to do ER in different archs, and informix versions. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: server migration from windows to linuxu [29033] > Date: Thu, 6 Dec 2012 07:09:01 -0500 > > Officially, this will not work. In practice will it work? Don't know. I > wouldn't try it for any database instance that i care about > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Dec 6, 2012 at 5:02 AM, Juan Francisco González Navarro < > jfrancisco.navarro@gmail.com> wrote: > > > hello: > > > > my doubt is about chunks. can i copy chunk files from windows to linux? can > > linux manage right chunk files from windows? > > > > my doubt is about to export data fully with two informix v11.7 from windows > > 2008 64b to linux 64b. > > > > thank you and regards. > > > > --047d7bb04cf2188a3904d02c3322 > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --14dae9341185e30e4b04d02df50a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
No the base page sizes are different and then it gets worse Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Juan Francisco González Navarro Sent: Thursday, December 06, 2012 4:03 AM To: ids@iiug.org Subject: server migration from windows to linuxu [29029] hello: my doubt is about chunks. can i copy chunk files from windows to linux? can linux manage right chunk files from windows? my doubt is about to export data fully with two informix v11.7 from windows 2008 64b to linux 64b. thank you and regards. --047d7bb04cf2188a3904d02c3322 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.