Learnings

Friday, November 12, 2010

DB2 correct way of taking a backup to avoid sql1035N

Quiesce the db, deactivate it and then backup.
From http://www.db2ude.com/?q=node/43

db2 CONNECT TO SAMPLE
db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
db2 TERMINATE
db2 DEACTIVATE DB SAMPLE
db2 BACKUP DATABASE SAMPLE TO "C:\DB2Backup" WITHOUT PROMPTING
db2 CONNECT TO SAMPLE
db2 UNQUIESCE DATABASE
db2 TERMINATE

0 Comments:

Post a Comment

<< Home