Re: Corrupt indexes on a system catalog

Peter Tashkoff wrote: > dbexport -ss gives the server specific information including extent sizes> lock levels and dbspace assignments. > Taking the logging off the database until it is loaded > avoids any long transaction issues. > I don't disagree with your other comments though Felix, I simply prefer to > use dbexport because it is a known quality to me, and I do not <snip> Hi-Pete, You are right about that -ss option, but I have seen problems with the Informix_Server_Id being slapped in before column names which gets updated in triggers, we started noticing this from Engine 7.23. It modifies "UPDATE Table SET Col_Name" to "UPDATE Ownerid.Table SET DBName@Informix_Server_Id:ownerid.Table". If you use this backup/dbexport to restore the database under another Informix_Server_Id, it will fail. As long as you are comfortable with dbexport, and it doesn't give you any trouble, it is good, but databases which have not been successfully dbimported from dbexport-files, may face problems. -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com