ANR0162W SQL1552N dsmserv fails to start due to suspended write operations
The start up of dsmserv is failing with the message:
SQL1552N The command failed because write operations for the database are suspended or are being suspended.
ANR0162W Supplemental database diagnostic information: -1552:**No State Information Available (-2)**:-1552 (SQL1552N The command failed because write operations for the database are suspended or are being suspended.).
The database has been put into a 'write suspended' state
Resolving the problem
In most cases, this problem can be resolved by running the 'db2 set write resume' command.
However, if it is not possible to connect to the TSMDB1 database due to the SQL1552N message, then you cannot run the command 'db2 set write resume', and must restart the database using the following DB2 command:
$ db2 restart db tsmdb1 write resume
Translate this page: