环境: DB2 11.1 服务器剩余空间不足10%
诊断：
$ db2 get db cfg for TESTDB|grep archive
First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/archived_logs/
Second log archive method (LOGARCHMETH2) = OFF
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
执行命令发现archived_logs占用了大量空间，但是哪些可以删掉呢？
$ db2pd -d TESTDB -logs
可以看到5714之前的日志都是归档日志，都可以清理。
Database Member 0 — Database TESTDB — Active — Up 9 days 15:10:42 — Date 2025-11-16-10.10.32.372637
Logs:
Current Log Number 5714
Pages Written 12486
Cur Commit Disk Log Reads 1
Cur Commit Total Log Reads 19
Method 1 Archive Status Success
Method 1 Next Log to Archive 5714
Method 1 First Failure n/a
Method 2 Archive Status n/a
Method 2 Next Log to Archive n/a
Method 2 First Failure n/a
Log Chain ID 1
Current LSO 555097457736
Current LSN 0x00000000519EEFD4
Address StartLSN StartLSO State Size Pages Filename
0x00007F687638D018 00000000519778BA 555046560929 0x00000000 20480 20480 S0005714.LOG
0x00007F687638D978 0000000000000000 555130037409 0x00000000 20480 20480 S0005715.LOG
0x00007F687638E2D8 0000000000000000 555213513889 0x00000000 20480 20480 S0005716.LOG
0x00007F687638EC38 0000000000000000 555296990369 0x00000000 20480 20480 S0005717.LOG
0x00007F687638F598 0000000000000000 555380466849 0x00000000 20480 20480 S0005718.LOG
0x00007F68770E01B8 0000000000000000 555463943329 0x00000000 20480 20480 S0005719.LOG
0x00007F68770E0B18 0000000000000000 555547419809 0x00000000 20480 20480 S0005720.LOG
0x00007F68770E1478 0000000000000000 555630896289 0x00000000 20480 20480 S0005721.LOG
0x00007F68770E1DD8 0000000000000000 555714372769 0x00000000 20480 20480 S0005722.LOG
0x00007F68770E2738 0000000000000000 555797849249 0x00000000 20480 20480 S0005723.LOG
0x00007F68770E3098 0000000000000000 555881325729 0x00000000 20480 20480 S0005724.LOG
0x00007F68770E39F8 0000000000000000 555964802209 0x00000000 20480 20480 S0005725.LOG
0x00007F68770E4358 0000000000000000 556048278689 0x00000000 20480 20480 S0005726.LOG
0x00007F68770E4CB8 0000000000000000 556131755169 0x00000000 20480 20480 S0005727.LOG
0x00007F68770E5618 0000000000000000 556215231649 0x00000000 20480 20480 S0005728.LOG
0x00007F68770E5F78 0000000000000000 556298708129 0x00000000 20480 20480 S0005729.LOG
0x00007F68770E68D8 0000000000000000 556382184609 0x00000000 20480 20480 S0005730.LOG
0x00007F68770E7238 0000000000000000 556465661089 0x00000000 20480 20480 S0005731.LOG
0x00007F68770E7B98 0000000000000000 556549137569 0x00000000 20480 20480 S0005732.LOG
0x00007F68770E84F8 0000000000000000 556632614049 0x00000000 20480 20480 S0005733.LOG
0x00007F68770E8E58 0000000000000000 556716090529 0x00000000 20480 20480 S0005734.LOG
0x00007F68770E97B8 0000000000000000 556799567009 0x00000000 20480 20480 S0005735.LOG
0x00007F68770EA118 0000000000000000 556883043489 0x00000000 20480 20480 S0005736.LOG
0x00007F68770EAA78 0000000000000000 556966519969 0x00000000 20480 20480 S0005737.LOG
0x00007F68770EB3D8 0000000000000000 557049996449 0x00000000 20480 20480 S0005738.LOG
0x00007F68770EBD38 0000000000000000 557133472929 0x00000000 20480 20480 S0005739.LOG
0x00007F68770EC698 0000000000000000 557216949409 0x00000000 20480 20480 S0005740.LOG
0x00007F68770ECFF8 0000000000000000 557300425889 0x00000000 20480 20480 S0005741.LOG
0x00007F68770ED958 0000000000000000 557383902369 0x00000000 20480 20480 S0005742.LOG
0x00007F68770EE2B8 0000000000000000 557467378849 0x00000000 20480 20480 S0005743.LOG
0x00007F68770EEC18 0000000000000000 557550855329 0x00000000 20480 20480 S0005744.LOG
0x00007F68770EF578 0000000000000000 557634331809 0x00000000 20480 20480 S0005745.LOG
0x00007F68770EFED8 0000000000000000 557717808289 0x00000000 20480 20480 S0005746.LOG
0x00007F68770F0838 0000000000000000 557801284769 0x00000000 20480 20480 S0005747.LOG
0x00007F68770F1198 0000000000000000 557884761249 0x00000000 20480 20480 S0005748.LOG
0x00007F68770F1AF8 0000000000000000 557968237729 0x00000000 20480 20480 S0005749.LOG
0x00007F68770F2458 0000000000000000 558051714209 0x00000000 20480 20480 S0005750.LOG
0x00007F68971B51B8 0000000000000000 558135190689 0x00000000 20480 20480 S0005751.LOG
0x00007F6897681558 0000000000000000 558218667169 0x00000000 20480 20480 S0005752.LOG
0x00007F689726D018 0000000000000000 558302143649 0x00000000 20480 20480 S0005753.LOG
0x00007F689770C3B8 0000000000000000 558385620129 0x00000000 20480 20480 S0005754.LOG
0x00007F689771C998 0000000000000000 558469096609 0x00000000 20480 20480 S0005755.LOG
0x00007F6876382758 0000000000000000 558552573089 0x00000000 20480 20480 S0005756.LOG
0x00007F68763830B8 0000000000000000 558636049569 0x00000000 20480 20480 S0005757.LOG
0x00007F6897702C58 0000000000000000 558719526049 0x00000000 20480 20480 S0005758.LOG
0x00007F68977035B8 0000000000000000 558803002529 0x00000000 20480 20480 S0005759.LOG
0x00007F68763818B8 0000000000000000 558886479009 0x00000000 20480 20480 S0005760.LOG
0x00007F6876385638 0000000000000000 558969955489 0x00000000 20480 20480 S0005761.LOG
0x00007F6876385F98 0000000000000000 559053431969 0x00000000 20480 20480 S0005762.LOG
0x00007F68763868F8 0000000000000000 559136908449 0x00000000 20480 20480 S0005763.LOG
0x00007F6876387258 0000000000000000 559220384929 0x00000000 20480 20480 S0005764.LOG
0x00007F6876387BB8 0000000000000000 559303861409 0x00000000 20480 20480 S0005765.LOG
0x00007F6876388518 0000000000000000 559387337889 0x00000000 20480 20480 S0005766.LOG
0x00007F6897FC5698 0000000000000000 559470814369 0x00000000 20480 20480 S0005767.LOG
0x00007F6897FC5FF8 0000000000000000 559554290849 0x00000000 20480 20480 S0005768.LOG
0x00007F6897FC6958 0000000000000000 559637767329 0x00000000 20480 20480 S0005769.LOG
0x00007F689807B098 0000000000000000 559721243809 0x00000000 20480 20480 S0005770.LOG
0x00007F6897FC4958 0000000000000000 559804720289 0x00000000 20480 20480 S0005771.LOG
0x00007F689763DFB8 0000000000000000 559888196769 0x00000000 20480 20480 S0005772.LOG
0x00007F689763E918 0000000000000000 559971673249 0x00000000 20480 20480 S0005773.LOG
执行以下命令清理30天以上的归档日志
$find /home/db2inst1/archived_logs/db2inst1/TESTDB/NODE0000/LOGSTREAM0000/C0000001 -type f -mtime +30 -name ‘*.LOG’ -print -exec rm -f {} \;
