Re: loading large *.unl file into database with logging
On Thu, 9 Sep 1999, Kire Prostizenovski wrote:
> I have this problem where we have a table with millions of rows we no longer
> need, we only need the last 500,000 rows or so. I planned on writting a
> script for our operators to run out of hours which would;
>
> 1. unload the data we want to retain.
> 2. drop the existing table
> 3. create the table with no indexes
> 4. load the *.unl file into the empty table
> 5. add the indexes.
>
> The problem I have is that we have unbuffered logging enabled on this
> database, and loading this one file causes the log space to be exhausted.
>
> I know that I can use ontape -n <database name> to turn logging off, and
> later enable it again using ontape -s -l 0 -n <database name>. I was
> wondering if there was a way to perform this load without disabling logging
> only for that particular table, similar to the WITH NO LOG option for temp
> tables.
>
> Thanks,
>
> Kire
>
> Kire Prostizenovski
> Business Analyst
> J Blackwood and Son Limited
> 13 Cooper Street
> Smithfield NSW 2164
> Australia
> Phone +61 2 9203 0133 Fax +61 2 9203 0160
>
>
>
If you just need to load one table, I would use the dbload utility which
commits the inserts every so many rows (default of 100).
Syntax for the dbload utility is available in the Informix Migration
Guide.
====================================================================
Harold Luse Phone: (970) 491-4120
Veterinary Teaching Hospital Fax: (970) 491-4123
Colorado State University Pager: (970) 229-8173
Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu
====================================================================