It looks like you have a full dbspace. Use onstat -d to find it and
onspaces to extend it, if necessary.


--EEM

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

stupid question I know, but you are specify the dbspace to put the
database into aren't you?

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 (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]
On Behalf Of E
Sent: 25 August 2005 04:48 PM
To: informix-list (AT) iiug (DOT) 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

your temp dbspace called tempchunk is not a real temp dbspace.
you forgot to supply the -t flag when you created it...
i assume you want to have temp space...

if so then make also sure that it's listed in your onconfig file
eq

DBSPACETEMP tempchunk
-- i would not call it tempchunk .. maybe tempdbs

it could also be a reason that you run out of space if no tempdbs then
/tmp is used (when PSORT_DBTEMP or DBTEMP is not set...) when building
indexes....

Superboer.

Everett Mills schreef: