Re: HELP !!! Recovery mode

In article <6ln0gd$r9c$1@nnrp1.dejanews.com>, andywen@my-dejanews.com writes > > >> and the system seems hung in Recovery, you may well be hosed. >> However, depending on the version you are running (a detail you failed to >> mention), you may not be in an uncorrectable state. > >I've been there before. Your logs are full, and there just isn't a way to >back up logical logs. Informix Tech Support has a way to fix this if they >have dial-in access, but sometimes it's just easier to restore the last >backup. Hope you do good backups. Sorry. I've been there too. Quite >irritating. > that's why you should general use cursors with hold and commit after each record. Data transfers to/from another system are the only exception since you want to either accept/reject the whole batch.. Always have plent of logical/physical logs a few hundred meg covers a lot of sins... >Andy > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care