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

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/