Re: lost tblspace help

jandspaul@my-deja.com wrote: > > our 5.x informix systables got hosed somehow. using > dbaccess, informix sees the database, but we can't connect > to or drop the database because of a tblspace does > not exist error. the primary chunk is also down (not mirrored). > tbcheck won't work because the tblspace doesn't exist. > using tbmonitor, we can see how much of the dbspace > is being used, but that's about it. > > how can i recover from this? any solutions are appreciated. > we can't drop the dbspace because it's not empty and we > can't empty it because we can't get to the database. Got a good archive? Yes? Restore! No? Unload all the data you CAN save and reinitialize the engine, recreate your database(s), reload what you were able to save, rebuild what you lost as best you can, start archiving regularly. First question though, how did the chunk get marked down in the first place? Is the drive trashed? Was it recovered through OS mirroring or RAIDxx recovery? You can try having Tech Support mark the chunk back online then your tablespace will no longer be "missing". If you have doubts about the quality of the data you have recovered this way then go back to paragraph one. Art S. Kagel