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

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

813 Views

Hi,

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.

Regards,

Akshay K.

+044 07908975074