Oninit cdi / Archive
Talk to an expert →

dbexport/dbimport

Posted in 2006

Summary

Quman, migrating from IDS 9.4 to 10 with dbexport/dbimport, asked for speed tips and how to resume after an error. Art Kagel said to edit the schema (.sql) file, removing already loaded tables, or create tables from the schema and load with LOAD, dbload or hploader. He confirmed removing completed parts works, but check index creation and clean partial tables.

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

Topics: Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life, Jobs, Consulting & Announcements

Quman — — source: IIUG Forums & Mailing Lists

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 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Quman
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

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.

↪ replying to ART KAGEL, BLOOMBERG/ 731 LEXIN
Quman — — source: IIUG Forums & Mailing Lists

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. > >

↪ replying to Quman
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

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.

Glossary