Può succedere che un RESTORE su un database DB2 non vada a buon fine e dunque ad ogni tentativo di connessione si ottenga un errore del tipo:
SQL1119N A connection to or activation of database “DBNAME” cannot be made
because a previous restore is incomplete or still in progress. SQLSTATE=57019
Per ripristinare l’accesso al DB conviene ripetere l’operazione di restore in questo modo:1) sconnettere tutte le applicazioni eventualmente connesse
db2 FORCE APPLICATION ALL
2) disattivare il database
db2 deactivate database DBNAME
3) ripetere il restore
db2 RESTORE DB DBNAME FROM RESTORE_FILE_PATH TAKEN AT BACKUP_TIMESTAMP WITHOUT PROMPTING
4) riattivare il database
db2 activate database DBNAME
Thank you for the help. I couldn’t translate to English but I think I understand.
Hi to all, the contents present at this site are genuinely awesome
for people knowledge, well, keep up the nice work fellows.
Dead ppent articles, Really enjoyed reading.
wonderful post, very informative. I wonder why the opposite specialists of this
sector do not understand this. You must proceed your writing.
I’m confident, you have a great readers’ base already!