Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

server crashed informix in recovery state.

SOLVED
Go to solution
someone_4
Honored Contributor

server crashed informix in recovery state.

Hey everone,
We had a server shutdown today. It was running an informix engine. I dont know much about informix so I dont know many details all I know is that it is in "recovery" state. Does anyone have any tips on this type of issue. I was told by my DB people that all we can do is wait. And that it could take 1 hour or 1 week to get it back up. We are running Informix 9.30.

Thanks,
Richard
5 REPLIES
Mark Greene_1
Honored Contributor

Re: server crashed informix in recovery state.

they are correct about waiting it out, but you should be able to get a better guesstimate on the time.

here's the informix support page at IBM:

http://www-3.ibm.com/software/data/informix/support/

there are white papers, faqs, and links the the informix user group's page that has more info.

HTH, good luck,
mark
the future will be a lot like now, only later
Nick Wickens
Respected Contributor

Re: server crashed informix in recovery state.

Try the informix command "onmode -m" to bring the database to multi-user state. This sometimes works for us.

Nb - "onmode -?" will lists other options.
Hats ? We don't need no stinkin' hats !!
someone_4
Honored Contributor

Re: server crashed informix in recovery state.

Hey thanks for the posts. Everything came up yesterday around 5pm. So it was not that bad. But for me it was mainly the feeling of not being able to do something about it. I am a very reactive person and if something goes down and crashes I like working on it till it comes up. Just sitting waiting is not my cup of tea. But in this biz sounds like I will have to calm down a little and be more patient.

- Richard
Jeff Schussele
Honored Contributor
Solution

Re: server crashed informix in recovery state.

Hi Richard,

Yes, patience is a virtue.
Especially valuable when you don't have "control" as in this case
And it's a learned skill - you'll get better at it.
Just remember "Don't sweat the small stuff - and it's ALL small stuff."
Cheers & have a great day!

Best Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Rainer von Bongartz
Honored Contributor

Re: server crashed informix in recovery state.

Richard,

next time check with onstat -D.

you'll see read and writes on your dbspaces. This tells you at least that INFORMIX is still working on recovering and not just hanging.

Regards
Rainer
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...