Re: dbload problem
Jeff Craig wrote:
>
> We are running INFORMIX-Online v7.12.UC3X2 on an IRIX 5.3
> system, using dbload to load non-contiguous fields from a
> flat file to a single table. When the input fields are
> non-contiguous, dbload starts thrashing in our /tmp directory,
> putting out dbxnnnn_nnn files, running utilization up to
> 80-90%. Is there anyway to change this behavior? I have
> already tried most of the obvious, like setting DBSPACETEMP
> in the onconfig, setting PSORT_DBTEMP, etc.
>
> -------------------------------------------------------------------
> Jeff Craig | dbINTELLECT Technologies, Inc.
> Senior Consultant | Golden, CO
> | (303) 275-6954 ext. 8008
> | email: settler@dbintellect.com
> | fax: (303) 275-2134
> -------------------------------------------------------------------
My own preference given this requirement would be to write a filter to
turn the source files into Informix load format.
Ian