I did a stop force on my database when the there was a trasaction rolling back. when it didnot come back up for 30 min I did a db2_kill and ipclean. Now the database would not connect. THe database manager is up and running but the connection to the database is not taking place. and I cant tell if the database is in crash recovery. I see the crash recovery happened for all other databases in the db2diag.log and I can connect to them, but our major database is not available. ANd I only see below for this one
I did a "db2 restart db dbname" but its bee runninf from a long time
What can be done to bring it back up. I know the drop database and restoring it wouldnot work either because I cannot perform any operation on it
I am on db2 9.7 fixpack 5 and circular logging because this is our UAT env .
Please help..The UAT team is on hold and I am disappointed in myself
That was the issue, the commands I issued hung there forever without resturning any results. But my restart command came back successfully after the crash recovery process completed and the database came back up