Tuesday, December 9, 2008

How to bring down DB2 forcefully

At times there are some held threads which prevents DB2 subsystem down for maintenance purpose. We can follow these if we require:

These are some console commands which can be tried:

/MODIFY DSN1IRLM,ABEND,NODUMP

OR
/F DSN1IRLM,ABEND


THEN IF NECESSARY

/C DBM1

/FORCE DBM1 (LAST RESORT)

OR

/C MSTR

/FORCE MSTR (LAST RESORT)


WON'T START? IPL !!!!!!!!!!!


Cheers..
Prakash C. Singh
IBM Certified DB2 DBA

No comments: