Looks like a comparable problem, as submitted in the Db2 IDEAS AHA! portal :
3 jan 2019 "Allow offline backup to automatically force all Allow offline utilities such as backup, restore, rollforward to auconnections"
https://ibm-data-and-ai.ideas.aha.io/ideas/DB24LUW-I-265(which has status: " plannend for future release"
------------------------------
Erwin Hattingh
Systems Engineer / Db2 DBA
Triodos Bank
------------------------------
Original Message:
Sent: Mon September 28, 2020 02:02 AM
From: Markus Fraune
Subject: DB2 WH: Unable to restore an offline backup
hi, seems as you are not alone on the database when executing the restore. have you executed all the prio steps like db2stop, force applications deacivate db and so on? if yes, look for open connection right before the restore command with "db2 list applications". if there are any force off, wait for the database to deactivate and issue the restore command again.
------------------------------
Markus Fraune
Original Message:
Sent: Thu September 24, 2020 03:53 PM
From: Simon Cheng
Subject: DB2 WH: Unable to restore an offline backup
Hi,
I have been trying to restore an offline backup for BLUDB in DB2 WH in CP4D 3.0.1, using the steps below.
https://www.ibm.com/support/producthub/icpdata/docs/content/SSQNUZ_current/cpd/svc/dbs/backup_db_db2w_restore.html
(I also tried to restore an online backup but I got the same error message.)
However, I kept getting this error when I executed the restore command (step 10a).
SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019
Does anyone have any ideas?
------------------------------
Thanks,
Simon
------------------------------
#CloudPakforDataGroup