No space left on device to create index

Hi, I failed to create an index on a table having about 300,000+ rows. The message says 'no space left on device'. Using 'onstat -d', you can tell there're plenty of space. Also, in the instance where the data was exported from there's less space in each individual dbspace than in the target instance where the index could not be created. The data is identical in the two instances. Your help is greatly appreciated. Sincerely, Lixin Wu bash-2.04$ dbaccess - -<<EOF > database db_name; > create index index_name on tab_name(col_name) in data01; -- or data02> EOF Database selected. 212: Cannot add index. 28: No space left on device Error in line 1Near character position 70 Database closed. bash-2.04$ onstat -d IBM Informix Dynamic Server Version 9.40.UC2 -- On-Line -- Up 01:20:40 --167232 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 5010e7d8 1 0x20001 1 1 N informix rootdbs 509cf798 2 0x40001 2 2 N B informix physdbs 509cf8e8 3 0x1 3 1 N informix logdbs 509cfa38 4 0x62001 4 2 N TB informix tmpdbs 509cfb88 5 0x40001 5 2 N B informix data01 509cfcd8 6 0x40001 6 1 N B informix data02 6 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 5010e928 1 1 1 24000 14468 PO-- /db/links/CLASS_TEST 5020edf0 2 2 24001 16000 0 PO-- /db/links/PHYSDBS 509cf018 3 3 40001 27500 2447 PO-- /db/links/LOGDBS 509cf198 4 4 67501 25000 24947 PO-- /db/links/TMPDBS 509cf318 5 5 92501 1024000 944046 PO-B /db/links/DATA01 509cf498 6 6 1116501 256000 255947 PO-B /db/links/DATA02 509cf618 7 2 1372501 240000 239997 PO-B /db/links/PHYSDBS 50a835c8 8 5 1612501 1024000 1023997 PO-B /db/links/DATA01 50c74df8 9 4 2636501 256000 255997 PO-B /db/links/TMPDBS 9 active, 32766 maximum Expanded chunk capacity mode: enabled

Lixin- Check your environment (.profile and onconfig); the database may be trying to build the index in /tmp instead of your tmpdbs. --EEM > -----Original Message----- > From: LIXIN WU [mailto:lixinwufeng@yahoo.com] > Sent: Friday, October 29, 2004 3:41 PM > To: ids@iiug.org > Subject: No space left on device to create index [3602] > > Hi, > > I failed to create an index on a table having about 300,000+ rows. The > message says 'no space left on device'. Using 'onstat -d', you can tell > there're plenty of space. Also, in the instance where the data was > exported from there's less space in each individual dbspace than in the > target instance where the index could not be created. The data is > identical in the two instances. > > Your help is greatly appreciated. > > Sincerely, > > Lixin Wu > > bash-2.04$ dbaccess - -<<EOF > > database db_name; > > create index index_name on tab_name(col_name) in data01; -- ordata02 > > EOF > > Database selected. > > > 212: Cannot add index.> > 28: No space left on device > Error in line 1> Near character position 70 > > > Database closed. > > bash-2.04$ onstat -d> > IBM Informix Dynamic Server Version 9.40.UC2 -- On-Line -- Up 01:20:40 > -- 167232 Kbytes> > Dbspaces > address number flags fchunk nchunks flags owner name > 5010e7d8 1 0x20001 1 1 N informix rootdbs > 509cf798 2 0x40001 2 2 N B informix physdbs > 509cf8e8 3 0x1 3 1 N informix logdbs > 509cfa38 4 0x62001 4 2 N TB informix tmpdbs > 509cfb88 5 0x40001 5 2 N B informix data01 > 509cfcd8 6 0x40001 6 1 N B informix data02 > 6 active, 2047 maximum > > Chunks > address chunk/dbs offset size free bpages flags > pathname > 5010e928 1 1 1 24000 14468 PO-- > /db/links/CLASS_TEST > 5020edf0 2 2 24001 16000 0 PO-- > /db/links/PHYSDBS > 509cf018 3 3 40001 27500 2447 PO-- > /db/links/LOGDBS > 509cf198 4 4 67501 25000 24947 PO-- > /db/links/TMPDBS > 509cf318 5 5 92501 1024000 944046 PO-B > /db/links/DATA01 > 509cf498 6 6 1116501 256000 255947 PO-B > /db/links/DATA02 > 509cf618 7 2 1372501 240000 239997 PO-B > /db/links/PHYSDBS > 50a835c8 8 5 1612501 1024000 1023997 PO-B > /db/links/DATA01 > 50c74df8 9 4 2636501 256000 255997 PO-B > /db/links/TMPDBS > 9 active, 32766 maximum > > Expanded chunk capacity mode: enabled >