db2start or db2stop are not working

[Former Member]

Hi,

We are using DB2 10.1

we have tried to stop DB2 by using db2stop... it has taken long time.. so we killed it..

after that when we try to start or stop it is giving as START or STOP command is in progress

Please suggest.

Regards,

KK

[Former Member · Accepted solution]

Hi,

You can use command db2_kill from db2<sid> to clean all running commands.

It wont effect anything in DB you can use this command.

Try this.

Regards,

Karthik

[manumohandas82 · Accepted solution]

This is not correct .

db2_kill shuts of  the DB2 engine abruptly  . The next time you start the DB2 it will do a creash recovery and the startup will take more time .

Hi Karthik ,

Before  you stop the db2 , did you stop the frontend applications .

do a list of all the applications runnning using the command

db2 list applications show detail .  [ If any applications are running you could force them one by one or together using the  db2 "force application " cmd ]

The following commands should be the ideal

db2 force applications all

db2 terminate  ( If you had already made a connection )

db2 deactivate db <SID>

db2stop

Thanks ,

Manu

[martin_mikala]

Hi again,

If you are startring DB2 you can check what is doing by db2 list utilities or in db2diag.log (db2diag -f).

[martin_mikala]

Hi,

Before db2 stop, you can list running DB2 applications by command db2 list applications and if there are running applications, you can kill them by db2 force application all or kill only specific app by db2 "force application ( <App handler id> )".

You can also try disconnect your db2 session db2 disconnect current or db2 termination, if you are connected into DB2.

Short is also command db2stop force.

B.R.

Martin