IDS Forum

Re: dbexport/dbimport

Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN
Date: Monday, 10 July 2006, at 2:39 p.m.

In Response To: Re: dbexport/dbimport (Quman)

Yes. The only thing to check for is whether dbimprt got around to recreating
the indexes on the tables it had already loaded and to clean out any partially
loaded table(s?) which you may want to reload.

Art S. Kagel

----- Original Message -----
From: Quman <ids@iiug.org>
At: 7/10 13:56:57

Thanks, Art.

Since dbimport also does lot of other jobs: index, reference, view..., not
noly data loading, can I just remove the script(in database.sql file) before
Error Exited point, then restart dbimport?

On 7/10/06, ART KAGEL, .... <kagel@bloomberg.net> wrote:
>
>
> See below:
>
> Art S. Kagel
> ----- Original Message -----
> From: Quman <ids@iiug.org>
> At: 7/10 13:33:31
>
> 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?
> The only way would be to either manually edit the schema file
> (<database>.sql)
> and remove tables that have already completed loading or to create the
> tables
> by just running the schema and then load the data using dbaccess's LOAD
> command,
> dbload, or the hploader.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• dbexport/dbimport
  Quman -- Monday, 10 July 2006, at 1:29 p.m.
  • Re: dbexport/dbimport
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 10 July 2006, at 1:36 p.m.
    • Re: dbexport/dbimport
      Quman -- Monday, 10 July 2006, at 1:52 p.m.
      • Re: dbexport/dbimport
        ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 10 July 2006, at 2:39 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.