same file added twice as chunk
Posted in 2006
Hi,
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?
Thanks