RE: Informix migration from HPUnix to Linux
Hello Karl.
I have migrated from sco unix to linux using dbexport and dbimport utilities,
they are slower, as you mentioned.
In order to accelerate the dimport I edited the sql script, I cut the alter
table primary key statement, specially in larger tables, first the load, and
after the alter table statement.
dbimport creates a new database, so, you must put attention in the lock mode
for every table, because dbexport script do not include the lock mode.
If you have tables in different spaces, you can edit the script, including the
dbspace for table and indexes.
"
> To: ids@iiug.org
> From: karl.oliver@maf.govt.nz
> Subject: Re: Informix migration from HPUnix to Linux [28784]
> Date: Sun, 11 Nov 2012 21:21:37 -0500
>
> we plan to do this soon too, I plan to user the export/ import - why has no
> one mentioned this? I realise it is slower however i belive the integrity is
> better
> I like the way people say use HPL - in my opinion not as easy to do as it is
> to say .
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Dbexport will include the IN dbspace and LOCK MODE clauses if you run it
with the "-ss" option.
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 Sat, Dec 8, 2012 at 9:43 AM, Mario Romo Pedroza
<marope_71@hotmail.com>wrote:
> Hello Karl.
>
> I have migrated from sco unix to linux using dbexport and dbimport
> utilities,
> they are slower, as you mentioned.
> In order to accelerate the dimport I edited the sql script, I cut the alter
> table primary key statement, specially in larger tables, first the load,
> and
> after the alter table statement.
>
> dbimport creates a new database, so, you must put attention in the lock
> mode
> for every table, because dbexport script do not include the lock mode.
> If you have tables in different spaces, you can edit the script, including
> the
> dbspace for table and indexes.
>
> "
>
> > To: ids@iiug.org
> > From: karl.oliver@maf.govt.nz
> > Subject: Re: Informix migration from HPUnix to Linux [28784]
> > Date: Sun, 11 Nov 2012 21:21:37 -0500
> >
> > we plan to do this soon too, I plan to user the export/ import - why has
> no
> > one mentioned this? I realise it is slower however i belive the
> integrity is
> > better
> > I like the way people say use HPL - in my opinion not as easy to do as
> it is
> > to say .
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae93404b9bc700504d0627b62