DB2监控备份、恢复进度

最新推荐文章于 2022-02-22 15:08:40 发布

lk_db

最新推荐文章于 2022-02-22 15:08:40 发布

阅读量5.7k

点赞数

分类专栏： DB2

本文链接：https://blog.csdn.net/lk_db/article/details/78284755

版权

本文档详细记录了如何在DB2中执行数据库备份和恢复操作，并展示了如何通过命令行工具监控备份和恢复的进度。在session1中，执行了对数据库TEST的备份到指定路径。随后在session2中进行了恢复操作，并在恢复过程中提醒用户数据库将被覆盖。通过`db2 list utilities show detail`和`db2pd -utilities`命令，实时查看了恢复的执行状态和工作完成情况。

摘要由CSDN通过智能技术生成

session1中执行备份：

[db2inst1@db ~]$ db2 backup db test to /db2data/

session2中使用如下命令监控备份进度：
[db2inst1@db db2data]$ db2 list utilities show detail
ID = 2
Type = BACKUP
Database Name = TEST
Partition Number = 0
Description = offline db
Start Time = 10/17/2017 22:54:37.300623
State = Executing
Invocation Type = User
Throttling:
Priority = Unthrottled
Progress Monitoring:
Estimated Percentage Complete = 51
Total Work = 17150073271 bytes
Completed Work = 8759459743 bytes
Start Time = 10/17/2017 22:54:37.300638

[db2inst1@db db2data]$ db2 list utilities show detail
ID = 2
Type = BACKUP
Database Name = TEST
Partition Number = 0
Description = offline db
Start Time = 10/17/2017 22:54:37.300623
State = Executing
Invocation Type = User
Throttling:
Priority = Unthrottled
Progress Monitoring:
Estimated Percentage Complete = 53
Total Work = 17150073271 bytes
Completed Work = 9095036831 bytes
Start Time = 10/17/2017 22:54:37.300638

[db2inst1@db db2data]$ db2 list utilities show detail

ID = 2
Type = BACKUP
Database Name = TEST
Partition Number = 0
Description = offline db
Start Time = 10/17/2017 22:54:37.300623
State = Executing
Invo