Re: Infinite Recovery Help Needed (Online 5.0)

>> This is a problem which we've experienced on out project several >> times. Informix technical support can abort your long transaction >> by logging into your system and running a utility called tbzero. >> >> As I said, we've had this done several times. Perhaps someone from >> Informix will explain why they will not release this utility. >> >> Cheers, >> Coty coty, first, informix shouldnt release tbzero as a general utility. the fact that you get long transactions suggest that you do not have enough logical logs (or logical logs which are too small) or you should examine the transactions you are running. tbzero alters the online instance and sets the active transaction flag to be 0. so when you fire up online again, it does not rollback any transactions. this potentially leaves your database in an inconsistent state. informix suggests that you tbcheck your database tables for any problems. for instance, if you were building an index on a table when this situation occured, your hosed. the index is partially built and in some cases you cannot drop the index/table. if indeed you encounter problems after running tbzero, your on your own as far as support. again, the problem can be fixed by increasing your logical logs (up to the magic number of 61) or by tbinit'ing with larger logical logs. regards, ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------ Sun 690-MP Informix Versions: Online - 5.00.UC2 ISQL - 4.10.UD1 4GL-RDS- 4.10.UC1 ------------------------------------------------------------------------------