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
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