BACKUP PENDING状态的解除
1、數據庫比較大的時候
[db2inst1@db2serv1 ~]$ db2 connect to YXDB
SQL1116N? A connection to or activation of database " YXDB" cannot be made
because of BACKUP PENDING.? SQLSTATE=57019
[db2inst1@db2serv1 ~]$ db2dart YXDB /CHST /WHAT DBBP OFF
??? Updated the log file header control file.
???????? The requested DB2DART processing has completed successfully!
??????????????????????? Complete DB2DART report found in:
/db2home/db2inst1/sqllib/db2dump/DART0000/YXDB.RPT
[db2inst1@db2serv1 ~]$ db2 activate db yxdb
DB20000I? The ACTIVATE DATABASE command completed successfully.
[db2inst1@db2serv1 ~]$ db2 connect to yxdb
?? Database Connection Information
?Database server??????? = DB2/LINUXX8664 9.7.5
?SQL authorization ID?? = DB2INST1
?Local database alias?? = YXDB
?
2、backup? db
轉載于:https://blog.51cto.com/freebile/1092071
總結
以上是生活随笔為你收集整理的BACKUP PENDING状态的解除的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: sqlite数据库插入和读取图片数据 (
- 下一篇: setting virtualbox s