Edwin,
I have had issues with crash Recovery my suggestion is to kill or cancel
all the threads associated with the recovery and restore your database it
will be much faster.


Fran Tatonetti
IT Database Group
(336)335-7511



"Edwin Uy "
<db2udbdba-ezmlmshield-x23922692.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: Crash recovery taking 99% CPU resource and taking
hours
09/29/04 02:24 AM






Hi all,

I have a DB2 8.1 database running on Windows2000Server with 1GB of
memory, database is roughly 2GB of ACCPAC's database. I decided to
reboot my server as the users are getting hanged up, after the restart
of the server, the event log reports ADM1530E: Crash recovery has been
initiated. It's been 2hours and it hasn't finished, any recommendation
on what I should do?

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html








DB2 & UDB email list listserv db2-l LazyDBA home page