tbinit core dumps during recovery, urgent help needed!!!

> I now have two ideas which I don't know exactly how to try: > A Remove the flag (somewhere in the reserved pages) that says > that recovery is needed. Accept the incosistencies that may > follow from this decisions, and run tbcheck before going > online. Informix tech support has a program, called tbzero, that does this. It may well result in inconsistencies in your data. They must dial into your system and run it, as it is a password-protected program. They used to leave the source code laying around, but now they don't. Changing the flags (either with tbzero or your own program) is seriously NOT supported, and tech support may cut you off entirely if they find you doing that, not to mention the potential for damage in your db. It may still be your best option, just be aware of the risks. > B Somehow remove the bad index. Let tbinit recover, and create > the index afterwards. If you can get the database up long enough to drop the index thru SQL, then definitely do it. I've done things like this before, but the engine has been up when I did. If the engine is down and won't come up then you can't do this using the SQL tools. If you have the option, sometimes it's best not to take OnLine offline, as it may not come back. > C Remove the test (or somehow fake it) in tbcheck for Quiscent > mode when the repairing of the bad index should start. I don't know of a way to do this. Good luck, I've been there before and you'll need it! __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|