RE: Problem with dbimport

It looks like you have a full dbspace. Use onstat -d to find it and onspaces to extend it, if necessary. --EEM > -----Original Message----- > From: E [mailto:e@aol.com] > Sent: Thursday, August 25, 2005 9:48 AM > 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

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: > It looks like you have a full dbspace. Use onstat -d to find it and > onspaces to extend it, if necessary. > > > --EEM > > > -----Original Message----- > > From: E [mailto:e@aol.com] > > Sent: Thursday, August 25, 2005 9:48 AM > > 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