HI,

I am using dbexport/dbimport to migrate db from IDS 9.4 to IDS10.

Two quesstions,

(1) Any tricks to improve the performacne?
(2) If dbimport exited by error( since I need manually modify some table
locations..), can we resume it from the exited point instead of losing a
couple hours?

Thanks,
Quman

1: Use PDQPRIORITY eq set it in env and check if it works; of course
configure it too
properly!!!

2: generate your own checkpoints, when buf cache 75 % dirty then do a
onmode -c
and switch off LRU cleaning. set LRU_MIN and MAX dirty to 99.

when done force a checkpoint before reconfigure and bounce the
engine!!!!!!!!!!!!


of course configure bufferes big etc.


--> (2) If dbimport exited by error( since I need manually modify
some table
not really ; you have to write your own stuff in that case.


Superboer.




Quman schreef:

> HI,
>
> I am using dbexport/dbimport to migrate db from IDS 9.4 to IDS10.
>
> Two quesstions,
>
> (1) Any tricks to improve the performacne?
> (2) If dbimport exited by error( since I need manually modify some table
> locations..), can we resume it from the exited point instead of losing a
> couple hours?
>
> Thanks,
> Quman
>
> ------=_Part_43913_23092529.1152552509351
> Content-Type: text/html; charset=ISO-8859-1
> X-Google-AttachSize: 495
>
> <div>HI,</div>
> <div>&nbsp;</div>
> <div>I am using dbexport/dbimport to migrate db from IDS 9.4 to&nbsp; IDS10.</div>
> <div>&nbsp;</div>
> <div>Two quesstions,</div>
> <div>&nbsp;</div>
> <div>(1) Any&nbsp;&nbsp; tricks to improve the performacne?</div>
> <div>(2)&nbsp; If&nbsp; dbimport&nbsp; exited &nbsp;by error( since I need manually modify some table locations..), can we resume it from the exited point instead of losing a couple hours?</div>
> <div>&nbsp;</div>
> <div>Thanks,</div>
> <div>Quman</div>
>
> ------=_Part_43913_23092529.1152552509351--

Quman wrote:
> HI,
>
> I am using dbexport/dbimport to migrate db from IDS 9.4 to IDS10.
>
> Two quesstions,
>
> (1) Any tricks to improve the performacne?
> (2) If dbimport exited by error( since I need manually modify some table
> locations..), can we resume it from the exited point instead of losing a
> couple hours?
I have restarted it you have to trim the files generated to the point
where it failed. I don't remember exactly and luckily I haven't had to
use the tool in 4 years (Try it on some test systems first). You can
also modify the files before hand (but you didn't think about that or
you wouldn't have asked this question.)

Also, Why are you using dbimport and dbexport to upgrade from 9.4 to
IDS 10.0? What problem are you trying to get around? I am going from
9.21 to 10 and I haven't heard of having to dbexport and dbimport to do
the upgrade. Has anyone else heard that you doing a dbexport/dbimport
is valuable in doing the upgrade? You have me worried now.


>
> Thanks,
> Quman
>
> ------=_Part_43913_23092529.1152552509351
> Content-Type: text/html; charset=ISO-8859-1
> X-Google-AttachSize: 495
>
> <div>HI,</div>
> <div>&nbsp;</div>
> <div>I am using dbexport/dbimport to migrate db from IDS 9.4 to&nbsp; IDS10.</div>
> <div>&nbsp;</div>
> <div>Two quesstions,</div>
> <div>&nbsp;</div>
> <div>(1) Any&nbsp;&nbsp; tricks to improve the performacne?</div>
> <div>(2)&nbsp; If&nbsp; dbimport&nbsp; exited &nbsp;by error( since I need manually modify some table locations..), can we resume it from the exited point instead of losing a couple hours?</div>
> <div>&nbsp;</div>
> <div>Thanks,</div>
> <div>Quman</div>
>
> ------=_Part_43913_23092529.1152552509351--

> Also, Why are you using dbimport and dbexport to upgrade from 9.4 to
> IDS 10.0? What problem are you trying to get around? I am going from
> 9.21 to 10 and I haven't heard of having to dbexport and dbimport to do
> the upgrade. Has anyone else heard that you doing a dbexport/dbimport
> is valuable in doing the upgrade? You have me worried now.

Yep. I used dbexport/dbimport for go from 10UC1 to 10UC4, because the
'upgraded' engine kept vomiting after a few hours.

dbexport, scratch, install UC4, dbimport worked without incident. Just
takes a l-o-n-g time.

But that is the only time I've had that problem; we've upgraded from
7.(something), through 9.x, to 10 without any problems.

Bozon,
Could you tell us more about the other good options on upgrade for 9 to 10?


bozon wrote:

>Quman wrote:
>
>
>>HI,
>>
>>I am using dbexport/dbimport to migrate db from IDS 9.4 to IDS10.
>>
>>Two quesstions,
>>
>>(1) Any tricks to improve the performacne?
>>(2) If dbimport exited by error( since I need manually modify some table
>>locations..), can we resume it from the exited point instead of losing a
>>couple hours?
>>
>>
>I have restarted it you have to trim the files generated to the point
>where it failed. I don't remember exactly and luckily I haven't had to
>use the tool in 4 years (Try it on some test systems first). You can
>also modify the files before hand (but you didn't think about that or
>you wouldn't have asked this question.)
>
>Also, Why are you using dbimport and dbexport to upgrade from 9.4 to
>IDS 10.0? What problem are you trying to get around? I am going from
>9.21 to 10 and I haven't heard of having to dbexport and dbimport to do
>the upgrade. Has anyone else heard that you doing a dbexport/dbimport
>is valuable in doing the upgrade? You have me worried now.
>
>
>
>
>>Thanks,
>>Quman
>>
>>------=_Part_43913_23092529.1152552509351
>>Content-Type: text/html; charset=ISO-8859-1
>>X-Google-AttachSize: 495
>>
>><div>HI,</div>
>><div>&nbsp;</div>
>><div>I am using dbexport/dbimport to migrate db from IDS 9.4 to&nbsp; IDS10.</div>
>><div>&nbsp;</div>
>><div>Two quesstions,</div>
>><div>&nbsp;</div>
>><div>(1) Any&nbsp;&nbsp; tricks to improve the performacne?</div>
>><div>(2)&nbsp; If&nbsp; dbimport&nbsp; exited &nbsp;by error( since I need manually modify some table locations..), can we resume it from the exited point instead of losing a couple hours?</div>
>><div>&nbsp;</div>
>><div>Thanks,</div>
>><div>Quman</div>
>>
>>------=_Part_43913_23092529.1152552509351--
>>
>>
>
>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list
>
>
>

--
Yunyao "Frank" Qu
Computer Sciences Corporation(CSC)
NOAA/CLASS, (301)817-4696

I wonder if it is a problem with In place alters?
Check that with the following SQL:
select
{+ ORDERED }
pg_partnum + pg_pagenum - 1 partn
from
sysdbspaces a,
syspaghdr
where pg_partnum = 1048576 * a.dbsnum + 1
and pg_next != 0
into temp pp with no log

select t.tabname from systabnames t, pp where pp.partn = t.partnum ;

These will be the tables that have inplace alters that haven't been
rectified.

If you update these tables with something like:

update <tablename> set <non-indexed-field> = <non-indexed-field where
where 1 = 1 ;

I specified non-indexed because I am not sure if updating an indexed
field (even with the same value) might cause the indexing logic to do
work. If someone knows this definitively that would be nice. This would
get rid of your in place alters and might make your instance more
stable when you upgrade. Anyone else have problems with in place alters
making their upgrade less reliable?

Adam Tauno Williams wrote:
> > Also, Why are you using dbimport and dbexport to upgrade from 9.4 to
> > IDS 10.0? What problem are you trying to get around? I am going from
> > 9.21 to 10 and I haven't heard of having to dbexport and dbimport to do
> > the upgrade. Has anyone else heard that doing a dbexport/dbimport
> > is valuable in doing the upgrade? You have me worried now.
>
> Yep. I used dbexport/dbimport for go from 10UC1 to 10UC4, because the
> 'upgraded' engine kept vomiting after a few hours.
>
> dbexport, scratch, install UC4, dbimport worked without incident. Just
> takes a l-o-n-g time.
>
> But that is the only time I've had that problem; we've upgraded from
> 7.(something), through 9.x, to 10 without any problems.

I am not the expert here I am in the middle of my first 9.21 ! to 10
migration. We don't seem to have any problems yet except one and we
can't reliably recreate it.

Yunyao (Frank) Qu wrote:
> Bozon,
> Could you tell us more about the other good options on upgrade for 9 to 10?
>
>
> bozon wrote:
>
> >Quman wrote:
> >
> >
> >>HI,
> >>
> >>I am using dbexport/dbimport to migrate db from IDS 9.4 to IDS10.
> >>
> >>Two quesstions,
> >>
> >>(1) Any tricks to improve the performacne?
> >>(2) If dbimport exited by error( since I need manually modify some table
> >>locations..), can we resume it from the exited point instead of losing a
> >>couple hours?
> >>
> >>
> >I have restarted it you have to trim the files generated to the point
> >where it failed. I don't remember exactly and luckily I haven't had to
> >use the tool in 4 years (Try it on some test systems first). You can
> >also modify the files before hand (but you didn't think about that or
> >you wouldn't have asked this question.)
> >
> >Also, Why are you using dbimport and dbexport to upgrade from 9.4 to
> >IDS 10.0? What problem are you trying to get around? I am going from
> >9.21 to 10 and I haven't heard of having to dbexport and dbimport to do
> >the upgrade. Has anyone else heard that you doing a dbexport/dbimport
> >is valuable in doing the upgrade? You have me worried now.
> >
> >
> >
> >
> >>Thanks,
> >>Quman
> >>
> >>------=_Part_43913_23092529.1152552509351
> >>Content-Type: text/html; charset=ISO-8859-1
> >>X-Google-AttachSize: 495
> >>
> >><div>HI,</div>
> >><div>&nbsp;</div>
> >><div>I am using dbexport/dbimport to migrate db from IDS 9.4 to&nbsp; IDS10.</div>
> >><div>&nbsp;</div>
> >><div>Two quesstions,</div>
> >><div>&nbsp;</div>
> >><div>(1) Any&nbsp;&nbsp; tricks to improve the performacne?</div>
> >><div>(2)&nbsp; If&nbsp; dbimport&nbsp; exited &nbsp;by error( since I need manually modify some table locations..), can we resume it from the exited point instead of losing a couple hours?</div>
> >><div>&nbsp;</div>
> >><div>Thanks,</div>
> >><div>Quman</div>
> >>
> >>------=_Part_43913_23092529.1152552509351--
> >>
> >>
> >
> >_______________________________________________
> >Informix-list mailing list
> >Informix-list@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
> >
> >
> >
>
> --
> Yunyao "Frank" Qu
> Computer Sciences Corporation(CSC)
> NOAA/CLASS, (301)817-4696