清理DB2日志释放空间

问题：CentOS磁盘剩余空间报警

分析：通过命令发现，/home/db2inst1占用了36G

du -ah / | sort -rh | head -n 100

36G /home/db2inst1
36G /home
35G /home/db2inst1/archived_logs/db2inst1/PRODDB/NODE0000/LOGSTREAM0000/C0000001

解决：

1.执行看下目前的归档日志有哪些

db2 connect to PRODDB

db2 list history all for PRODDB | egrep “B P|B D|X D”
B D 20230526132840000 N S0000000.LOG S0000000.LOG
B D 20230601220826000 N S0000000.LOG S0000000.LOG
B D 20230601220855001 F D S0000000.LOG S0000000.LOG
B D 20240107175047000 N S0000000.LOG S0000000.LOG

X D 20240107181525 1 D S0000000.LOG C0000001
X D 20240107181547 1 D S0000001.LOG C0000001
X D 20240107181607 1 D S0000002.LOG C0000001

…

X D 20241012020002 1 D S0002420.LOG C0000001
X D 20241012020028 1 D S0002421.LOG C0000001
B D 20241012132004000 N S0002421.LOG S0002421.LOG
X D 20241012132037 P D S0002422.LOG C0000001
B D 20241012132018001 N D S0002421.LOG S0002421.LOG

X  D:归档日志

B  P:表空间的备份

B  D:表数据的完整备份

2. 确认哪些是可以删除的日志

db2 get db cfg for PRODDB

找到First active log file，记录文件名，这是目前在使用中的最早的归档日志

3. 删除日志

执行命令 db2 prune logfile prior to S0002421.LOG 打上标记

注意：如果当前数据库的恢复历史依赖于这些日志，删除操作可能会导致问题。