On recovering single fragmented table via archecker
Posted in 2009
Hi, there.
I'm testing the new feature on Informix 10 (FC8 under solaris 9) which allows to recover a single table from an ontape backup, in order to save us backup tasks on every table using unload in order to avoid restore entire instance to recover a single table.
I prefer to do this by sending recovered table to a text file using an external table clause - so we don't need to use informix sessions at all - and it works fine when table isn't fragmented; but when table is fragmented (and with rowids, BTW) resulting file is all mixed up. Somebody knows if this archecker feature allows recovering fragmented tables, and in general how reliable is archecker to do this kind of stuff.
Thanks in advance
Omar Muñoz