DB2数据库安全清除日志文件的方法（转）

E:/>db2 get db cfg for sample|find "LOGARCHMETH1"
First log archive method                 (LOGARCHMETH1) = DISK:E:/temp/logs/
E:/>db2 get db cfg for sample |find "First active log file"
First active log file                                   = S0000024.LOG
E:/>db2 insert into salesa select * from sales
DB20000I  The SQL command completed successfully.

E:/>db2 insert into salesa select * from salesa
DB20000I  The SQL command completed successfully.

E:/>db2 insert into salesa select * from salesa
DB20000I  The SQL command completed successfully.

E:/>db2 insert into salesa select * from salesa
DB20000I  The SQL command completed successfully.

E:/>db2 commit
DB20000I  The SQL command completed successfully.

E:/>db2 get db cfg for sample |find "First active log file"
First active log file                                   = S0000025.LOG
E:/>db2 prune logfile prior to S0000025.LOG
DB20000I  The PRUNE command completed successfully.