Cloud Pak for Data Group

Expand all | Collapse all

DB2 WH: Unable to restore an offline backup

  • 1.  DB2 WH: Unable to restore an offline backup

    Posted Fri September 25, 2020 05:48 PM
    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
    ------------------------------


  • 2.  RE: DB2 WH: Unable to restore an offline backup

    Posted Mon September 28, 2020 02:02 AM
    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
    ------------------------------



  • 3.  RE: DB2 WH: Unable to restore an offline backup

    Posted Tue September 29, 2020 03:19 AM
    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
    ------------------------------



  • 4.  RE: DB2 WH: Unable to restore an offline backup

    Posted Tue September 29, 2020 10:42 AM
    I have followed exactly what the official steps provided repeatedly. Finally, I was able to restore but I still do not know why it did not work before. Yes, it does look like a comparable problem.

    ------------------------------
    Thanks,
    Simon
    ------------------------------