Skip to Content
Former Member
Jul 09, 2007 at 10:13 AM

SQL1553N DB2 cannot be stopped because one or more databases are in WRITE



our database is already in write suspend mode and backup is not happening.

so i am trying to bring database out of write suspende mode by issuing following command:

db2 set write resume for database

but the above command hangs so i tried to connect to database by -->

db2 connect to <dbid> but this also hangs.

i checked db2diag.log but no error message except -->

MESSAGE : Cannot obtain the requested snapshot as this database is in write

suspend mode. Skipping database FSR


so not able to stop/connect/set write resume command.

kindly, suggest.


Akshay K.

+044 07908975074