主页 / dba / 问题 / 342826
Accepted
RonJohn
Asked: 2024-10-06 20:26:58 +0800 CST

PRUNE LOGFILE PRIOR TO 不会删除存档日志文件

  • 772

DB2 UDB 11.5.7.0

$ db2 get db cfg for PRPT01D | grep  LOGARCH
 First log archive method                 (LOGARCHMETH1) = DISK:/udb/alogs/
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) = 
 Second log archive method                (LOGARCHMETH2) = OFF
 Archive compression for logarchmeth2    (LOGARCHCOMPR2) = OFF
 Options for logarchmeth2                  (LOGARCHOPT2) = 


$ db2 list history backup all for PRPT01D | head

                    List History File for PRPT01D

Number of matching file entries = 1


 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20241006050916001   N    D  S0002434.LOG S0002434.LOG                
 ----------------------------------------------------------------------------
$ db2 "prune logfile prior to S0002323.LOG"
DB20000I  The PRUNE command completed successfully.

即使运行该命令后，旧日志文件仍然存在/udb/alogs/udbinst/PRPT01D/NODE0000/LOGSTREAM0000/C0000000。我是不是从根本上误解了什么？我可以只保留rm那些存档日志文件吗？

transaction-log

1 个回答

  1. Best Answer

    无法说为什么PRUNE不起作用，但用手动删除旧的存档日志文件绝对没问题rm。

    • 1

相关问题