Need help to empty data in chunk before drop it.

Hello all, I've located one bad chunk in my database. I tried to drop it, but I can't drop chunk#26 because some tables extent still in this chunk. Since, most of the data in this chunk are related to system tables, I am not sure if it is safe to unload the data then drop those tables then load them back when the chunk fixed. Questions: 1) Is there a way to move those table extents out to another chunk? So I don't have to unload/load it and if it safe. 2) if Q1 is answer no. What's the best way to replacing this bad chunk? I don't want to do a full restore if I am out of options. 3) Is there a way to per-run (test) ontape full restore to be sure the data on tape are good, before do a real ontape restore? Thank you in advance for all your suggestion and input. --Wayne Server Studio JE show the following data still in the bad chunk#26 (see below). Name DataBase Extents Size Allocated in Chunk =============================================================== sysconstraints baan5c 4 640 pg - 1.25 MB sysobjstate baan5c 3 512 pg - 1 MB syscoldepend baan5c 3 128 pg - 256 KB syscolumns baan5c 1 64 pg - 128 KB sysindices baan5c 2 64 pg - 128 KB sysfragments baan5c 2 64 pg - 128 KB systabauth baan5c 2 48 pg - 96 KB systables baan5c 2 32 pg - 64 KB ttadv4220003abaan5 baan5c 1 6 pg - 12 KB ttaad3200002abaan5 baan5c 1 4 pg - 8 KB Informix: IDS9.21 OS: Solaris 2.8 Bad chunk is on raw disk.

Try looking into archecker. Also you could do a warm restore of just that dbspace. check the back and restore guide.

Hi, Since, this server was a Test server. I don't have a recent backup tape for it. I've a year old backup tape. In the past 6+ months I added a lot of chunks to the dbspace. Do you think this will work if I do a warm restore? Thanks --Wayne