Hi,
We have a very big table that keeps millions of records and this table has 4 segments allocated to that table. Recently we were getting a critical error when ever we logon to the client saying that 3 segments were more than 95% filled up. So we deleted lot of rows from this table to solve the space issue. Even though the percentage is not increasing any more, we are still getting this critical error message. Informis is using the deleted space but database itself is not able to see this space. How can I defragment the segments in order for the database to see this space and get rid of the critical error message ??

Thanks in advance.

Thanks,
Raja.

Dear Raja,
we had a similar problem with one of our tables. If I remember right, it is not possible to re-use the old segment by deleting some rows.

So we created totaly new dbspaces for the different fragments and altered the table, e.g.

alter fragment on table xxx init
fragment by expression
(column1= "expression1") in dbspace1,
(column1= "expression2") in dbspace2,
...
remainder in dbspace8;

In our case we used expression based fragments, also possible is the round-robin-fragment. What makes sense depends on your data.

I'm not sure if this is the best solution, but it worked fine.

Good Luck
Regina

U can also check this out

1. Delete all the index on the tables and recreate it once more.

I think this will help you.

Thanks
adityanlal