Re: HOW CAN I CHANGE CHUNK STATUS

> If onspaces will not mark the chunk up then the data on it has been damaged. > If you have a recent archive restore that dbspace from archive including > rolling any logs forward. If you have no recent archive you are hosed. You > can try to have Informix Tech Support force mark the chunk online but then > it may or may not be usable and I'd recommend unloading EVERYTHING in that > dbspace drop the tables, drop all the chunks, recreate the dbspace and tables, > and reload. Do you by anychance have a script which does this? If so, could you send it to this group? Thanks. -- S. Kipper: I am the S in .Kipper

"S . Kipper" wrote: > > If onspaces will not mark the chunk up then the data on it has been damaged. > > If you have a recent archive restore that dbspace from archive including > > rolling any logs forward. If you have no recent archive you are hosed. You > > can try to have Informix Tech Support force mark the chunk online but then > > it may or may not be usable and I'd recommend unloading EVERYTHING in that > > dbspace drop the tables, drop all the chunks, recreate the dbspace and tables, > > and reload. > > Do you by anychance have a script which does this? If so, could you send it > to this group? A script to do what? Force mark the chunk up? Umm, no comment. You have to have Informix tech support do that for you, it can be rather dangerous. Restore your archive? Onstat -r? Dump and reload your database? How about dbexport/dbimport? Otherwise I DID post a set of awk scripts to post-process dbschema/myschema output to produce unload and load scripts using either dbaccess<LOAD> or my ul.ec utility. See utils4_ak in the IIUG Repository. Art S. Kagel