RE: Problem with dbimport
Which dbspace are you creating the index in ? You also do not have
any temp spaces - even though you named it tempchunk, it is not a
temporary dbspace - you might be running out of space in Unix (/tmp?)
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of E
Sent: 25 August 2005 04:48 PM
To: informix-list@iiug.org
Subject: Problem with dbimport
Hi
I've not used Informix for seven years now - I'm rusty - please excuse
my ignorance.
I'm trying to restore an export, pretty quickly into the process I get
the error
212 - Cannot add index.
131 - ISAM ERROR: no free disk space
As far as I can see I have plenty of space, I have my ltapedev
pointing to /dev/null and running ontape -c, so I don't believe it's
transaction log issues.
Below is my onstat -d output.
Thanks in advance
Paul
IBM Informix Dynamic Server Version 9.40.UC5TL -- On-Line -- Up 2 days
17:07:32 -- 71088 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
4760e7d8 1 0x20001 1 1 N informix
rootdbs
4760ee08 2 0x20001 2 1 N informix
physchunk
47e4c018 3 0x20001 3 4 N informix
tempchunk
47e4c168 4 0x20001 4 1 N informix
datachunk
4 active, 2047 maximum
address number flags fchunk nchunks flags owner name
4760e7d8 1 0x20001 1 1 N informix
rootdbs
4760ee08 2 0x20001 2 1 N informix
physchunk
47e4c018 3 0x20001 3 4 N informix
tempchunk
47e4c168 4 0x20001 4 1 N informix
datachunk
4 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
4760e928 1 1 0 50000 12312 PO--
/u01/infchunks/rootchunk
47718d98 2 2 0 50000 49947 PO--
/u01/infchunks/physchunk
4760eaf8 3 3 0 25000 24547 PO--
/u01/infchunks/tempchunk
4760ec80 4 4 0 1000000 25819 PO--
/u01/infchunks/datachunk
47f25018 5 3 0 51200 50347 PO--
/u01/infchunks/tempchunk2
48014939 6 3 0 512000 511997 PO--
/u01/infchunks/tempchunk3
48141320 7 3 0 1012000 1011997 PO--
/u01/infchunks/tempchunk4
7 active, 2047 maximum
Expanded chunk capacity mode: disabled
sending to informix-list