Db2 error: write operations for the database are suspended
Symptoms
When you are backing up or restoring an OpenPages environment, a Db2 pod might report the following error:
[db2inst1@c-db2oltp-1621935580993371-db2u-0 - Db2U db2inst1]$ db2 connect to OPX
SQL1552N The command failed because write operations for the database are suspended
or are being suspended.
Resolving the problem
If this Db2 error appears after an online backup, run the following command:
cpd-cli oadp backup posthooks \
--include-namespaces ${PROJECT_CPD_INST_OPERANDS} \
--hook-kind=checkpoint
If this Db2 error appears after an offline backup, run the following command:
cpd-cli oadp backup posthooks \
--include-namespaces ${PROJECT_CPD_INST_OPERANDS}
If this Db2 error appears after a online restore, run the following command:
cpd-cli oadp restore posthooks \
--include-namespaces ${PROJECT_CPD_INST_OPERANDS} \
--hook-kind=checkpoint
If this Db2 error appears after a offline restore, run the following command:
cpd-cli oadp restore posthooks \
--include-namespaces ${PROJECT_CPD_INST_OPERANDS}