The problem I am having is I am unable to stop a database using the normal db2 commands and even by using the force commands.


Does anyone have any suggestions, on what I could maybe check, appologies for the lack of detail.

Regards

MultiD

There is no such command to stop the database AFAIK. You can however force the applications off the system or quiesce it but it's not synchronous.

dollar

if you not able shut down instance , even by db2stop force.

use

run

ipclean as instance owner

check if ny shared process hanging by using following command


ipcs | grep instance


clean those threads by using following command

ipcrm


ipcrm -m/q/s pid


after cleaning all hanging threads

start instance

db2start


that will work for you


Let me know , if any questions


Lekharaju Ennam
Certified Oracle8i & DB2 UDB DBA
FLorida A& M University

Cheers, will give that a go