Re: dbimport and tbload on RS6000
Rick Hamel (rickh@yeshua.marcam.com) wrote:
: I am having problems importing a few large tables (3 X 200 rows). I
: have tried dbimport and tbload and neither will work. I am running out of
: disk space.The tables came out of a database that was 300 meg in size. I am
: importing them into a database that is 500 meg in size and is empty. Informix
: told me I needed more contiguous space so I created a new volume group with
: a physical partition size of 256 Meg (as opposed to the default of 4 Meg).
: It still doesn't work. By using tbstat -d it seems the dbspace is filling
: up very fast. I have plenty of space in my /tmp filesystem. Has anyone else
: come across this problem. Thanks in advance.
: --
Are you using OnLine or SE?
How was the data created? (dbexport, unload?)
Are you trying to create a 300-500Mb database in a 256 OnLine partition?
Call me if I can help
********************************************************************************
__ _ _ __ () , _
/ ) // ' ) ) /`-'| // / _/_
/ / __. // _ /--' / / o // /___/> __ /
/__/_(_/|_</_</_ / \\ o /__-<_<_</_/_) (__/ (_<__
Dale R. Gilbert
DGC/4GL email: dgc@netcom.com
1256 Cabrillo Ave., Suite 250 FAX: (310) 320-3579
Torrance, CA 90501 VOICE: (310) 320-4300
********************************************************************************
Inteligencia: The ONLY Row Level Backup/Restore Solution for Informix OnLine(r)
********************************************************************************
--
********************************************************************************
__ _ _ __ () , _
/ ) // ' ) ) /`-'| // / _/_
/ / __. // _ /--' / / o // /___/> __ /
/__/_(_/|_</_</_ / \\ o /__-<_<_</_/_) (__/ (_<__
Dale R. Gilbert
DGC/4GL email: dgc@netcom.com
1256 Cabrillo Ave., Suite 250 FAX: (310) 320-3579
Torrance, CA 90501 VOICE: (310) 320-4300
********************************************************************************
Inteligencia: The ONLY Row Level Backup/Restore Solution for Informix OnLine(r)
********************************************************************************