Proshut -F

[SSuhaib]

Hi,

When the DB didn't shutdown even after 2 hours of proshut, we used the -F with proshut <dbname> -by -F and it shut down immidietly.

Later when we started it took around half-an-hour ( which it seems ok) to perform crash recovery.

2 hours to shutdown looks quite awful. What could be wrong?
Hate to say but we are still in progress 9.1D whch is old and unsupported.

Thanks

 

[taqvia]

Was there any huge transaction active when the shutdown was initiated which might have resulted in rollback causing the delay.



Arshad

 

[TomBascom]

There is no definitive answer to that, it could be lots of things. I usually start by reading the .lg file to see what the normal process is doing and what it might be getting "stuck" on. Comparing that with what the -F shutdown did that is different can be helpful.