Help with dbexport
Posted in 1997
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
I have a dbexport from Informix Turbo crashing out with a memory
allocation error. It only happens on one table, the largest approx 18
GB, most of which is blob data. I also have all 32 chunks in use and
can't allocate anymore (known Turbo bug)
A truss output for the export confirms that there is a ENOMEM error
being produced at a brk() call in the code. I believe I've tried all
the obvious things eg
Added 256 MB RAM to the box (originally 128)
Up'd SHMMAX from 512000 (ish) to 4096000 (ish)
Up'd ULIMIT from 64000 (ish) to 1000000 (ish)
No errors are being reported in the message areas both for Unix and
Informix.
BTW the export needs to be done at the weekend so the data can be
reorganised or else
the site will be out of space by Monday.
Anybody got any ideas, and yes I know that nobody anywhere still uses
Turbo 'cos its *@*(!!.
TIA
Paul Watson
NCR St Davids
Scotland
Tel: +44 01383 643347 ( Voice mail out of hours)
email pwatson@stdavids.ncr.com