Re: Problem loading data - 9.21.FC4

On Tue, 27 Jan 2004 06:33:31 -0500, Howard Jones wrote: Howard, Did you pre-size the EXTENT SIZE and NEXT SIZE attributes of the new table? Adding extents during a load can be very expensive in terms of time. Have you tried using dbload or the sqlreload utility from Jonathan Leffler's sqlcmd package? These will break the large load into smaller transactions for you which will reduce the resource load on the server. Also the dbcopy utility from my utils2_ak package can make the copy directly table to table also with partial transactions. Utils2_ak also contains my dbschema replacement utility, myschema, which can calculate the extent sizing for you including optional space for growth (see the -a, -m, -M, -e, & -n options). (Sqlcmd and utils2_ak are available for download from the IIUG Software Repository.) Art S. Kagel > Platform - Informix Version 9.21.FC4 > Operating System - HPUX 11.0 > > There is a premium on space for the table unloads so I am compressing them. > The script I am using is below this works on many tables both smaller and > larger than the "problem" table. > > What I am doing is unloading all the tables within a dbspace editing the > dbschemas to reference the new database/dbspace location dropping the > excisting table then recreating and loading it into the new database ( which > is within the same instance ). > > Unload script..... <SNIP> Art S. Kagel