Slow DBexport/DBimport

Posted in 2003

Topics: Installation, Setup & Upgrades, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

MODESTO HERNANDEZ — Mon, 03 Nov 2003 20:35:08 — source: IIUG Forums & Mailing Lists

Hi, we upgrade from IDS 7.31 to 9.30, the size database is about 100 Gb., on IDS 7.31, the dbexport take a 4 hours and the restore from dbimport take 24 hours, now with IDS 9.30, the dbexport take a 8:30 Hours and the dbimport about 48, hours...just with the IDS Upgrade....Somebody Know something about it...????

↪ replying to MODESTO HERNANDEZ

PHILLIP SHELTON — Tue, 27 Apr 2004 13:07:43 — source: IIUG Forums & Mailing Lists

Check you onconfig settings for OPTCMD. We found when converting to version 9 we had to switch from 2 to 0 to allow the optimizer hints. This reduced our unload times, as well as the restore.

Glossary

IDS (Informix Dynamic Server)
dbexport / dbimport