Re: DBSpace Full?

There is some corruption in the chunk table pages. The first chunk in the dbspace, chunk #19, shows -11853 pages free which cannot be, and there should be space in all of the other chunks, not just #54, according to onstat -d (and I assume that sysmaster:syschunks reports the same data). Iwould either 1) Call IBM and ask them if they can fix this, or 2) unload everything in that dbspace, drop it, rebuild it, and reload everything (or create a new dbspace first and just move the tables in there with ALTER FRAGMENT INIT IN...). Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Feb 20, 2012 at 9:49 AM, Laurie Gustin <lgustin@utah.gov> wrote: > We are trying to insert data into a table and get the following error > > WARNING: DBspace dldata1 is full > Seems pretty straight forward... except the space is not full. Only the > last chunk added is full. (see onstat -d below) > > informix@psdb03sat:~> onstat -d | grep 19 > 8e33ee80 19 0x40001 19 7 2048 N B > informix dldata1 > 8e7cc028 19 19 67371008 5242880 -11853 > PO-B- /IDS/data/lun1 > 8e7e5028 35 19 247452672 1048576 29060 > PO-B- /IDS/data/lun1 > 8e7e59d8 40 19 252695552 2097152 106599 > PO-B- /IDS/data/lun1 > 8e7cd5f8 46 19 265540608 2097152 25255 > PO-B- /IDS/data/lun1 > 8e7e2218 52 19 278123520 1048576 731868 > PO-B- /IDS/data/lun1 > 8e7e25f8 54 19 280220672 2097152 2095365 > PO-B- /IDS/data/lun1 > 158615dd0 66 19 316396544 1048576 0 > PO-B- /IDS/data/lun1 > > Has anyone ever seen this? Is there a way to make the engine see the 4GB > chunk (#54) that is not used at all? > > Any help is appreciated. > > Laurie > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >