Re: same file added twice as chunk

On 6 Jan 2006 03:27:09 -0800, xls <dan.tofan@gmail.com> wrote: > On a server more space was needed, and somebody added 5 chunks. I don't > know what he did, but here is the output of 'onstat -d': > > Informix Dynamic Server Version 7.31.TC5 -- On-Line -- Up 8 days > 21:01:14 -- 685824 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > 25e08150 1 1 1 2 N informix rootdbs > 25e09290 2 1 2 22 N informix > ol_db_new > 2 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > 25e08210 1 1 0 7680 4433 PO- > D:\\IFMXDATA\\ol_db_new\\rootdbs_dat.000 > 25e08360 2 2 0 512000 3 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.000 > 25e08438 3 1 0 500000 499989 PO- > D:\\IFMXDATA\\ol_db_new\\rootdbs_dat.001 > 25e08510 4 2 0 500000 1 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.001 > 25e085e8 5 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.002 > 25e086c0 6 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.003 > 25e08798 7 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.004 > 25e08870 8 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.005 > 25e08948 9 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.006 > 25e08a20 10 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.007 > 25e08af8 11 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.008 > 25e08bd0 12 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.009 > 25e08ca8 13 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.010 > 25e08d80 14 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.011 > 25e08e58 15 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.012 > 25e08f30 16 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.013 > 25e09008 17 2 0 500000 0 PO- > D:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.014 > 25e090e0 18 2 0 512000 0 PO- > d:\\ifmxdata\\ol_db_new\\ol_db_new_dat.015 > 25e091b8 19 2 0 512000 191157 PO- > d:\\IFMXDATA\\ol_db_new\\ol_db_new_dat.016 > 2630a680 20 2 0 500000 499997 PO- > E:\\ifmxdata\\ol_db_new\\ol_db_new_dat.017 > 26361dc8 21 2 0 500000 499997 PO- > E:\\ifmxdata\\ol_db_new\\ol_db_new_dat.017 > 2630a0f8 22 2 0 500000 499997 PO- > E:\\ifmxdata\\ol_db_new\\ol_db_new_dat.018 > 2630ad20 23 2 0 500000 499997 PO- > E:\\ifmxdata\\ol_db_new\\ol_db_new_dat.019 > 2630adf8 24 2 0 500000 499997 PO- > E:\\ifmxdata\\ol_db_new\\ol_db_new_dat.020 > 24 active, 2047 maximum > > As one can see the file ol_db_new_dat.017 is added twice! > > I tried to import a database and I received some 105 ISAM error, so I > tried to run oncheck -cDI database_name -q -n > output file, which ran > for more than 8 hours without finishing, even if the database is about > 10g only. I guess that chunk might be the reason. > > Any ideas? What suggestions do you have? On the face of it, you have a situation that IDS should have prevented; it should not permit the same chunk device (file) name to be used twice unless the chunks have different offsets within the device such that they are not overlapping (which doesn't seem to be the case here - both offsets seem to be zero). We have to hope that you don't have too much data trying to share that space. Contact IBM/Informix Tech Support. Worry a little that you're using 7.31.TC5 rather than TDx (TD8 or TD9 is current, IIRC). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/