清理DB2数据库归档日志
2025 年 1 月 7 日DB2恢复后连接报错ROLL-FORWARD PENDING. SQLSTATE=57019
2025 年 1 月 26 日
1.列出备份：
ls -l /db2_backups
- 总字节数：549014184
- 文件列表：
-rw-r----- 1 db2inst1 1004 21 Jan 21 16:16 ISIMDB.0.db2inst1.DBPART000.20250121155030.001
因为/opt剩余空间1T，能放下500G的数据库，
2.新建一个目录
sudo mkdir /opt/isimdb
sudo chown db2inst1:db2iadm1 /opt/isimdb
3.切换到db2inst1
su – db2inst1
4.执行数据库恢复命令
db2 restore db ISIMDB from /db2_backups taken at 20250121155030 to /opt/isimdb redirect without prompting
输出：SQL1277W A redirected restore operation is being performed. During a table space restore, only table spaces being restored can have their paths reconfigured. During a database restore, storage group storage paths and DMS table space containers can be reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.
5.设置存储组路径
db2 “SET STOGROUP PATHS FOR IBMSTOGROUP ON ‘/opt/isimdb'”
输出：DB20000I The SET STOGROUP PATHS command completed successfully.
6.继续恢复
db2 restore db ISIMDB continue
