系统集成Db2归档日志

目前db2数据库出现问题,归档日志显示已经不能写入,经查看日志目前已经写满?

查看错误日志返回的结果DATA #1 : <preformatted>
Failed to archive log file S0016022.LOG to VENDOR chain 7 from /db2home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

查看归档日志历史信息

Comment:                                                                  

Start Time: 20180620010608
End Time:

 Status: A

----------------------------------------------------------------------------
EID: 15501 Location: /db2home/db2data/db2inst1/NODE0000/db2inst1/NODE0000/SQL00007/SQLOGDIR/S0008877.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20180621020608 P D S0008878.LOG C0000000

----------------------------------------------------------------------------

Comment:                                                                  

Start Time: 20180621020608
End Time:

 Status: A

----------------------------------------------------------------------------
EID: 15505 Location: /db2home/db2data/db2inst1/NODE0000/db2inst1/NODE0000/SQL00007/SQLOGDIR/S0008878.LOG

$ db2pd -d nccaacsc -logs

Database Partition 0 -- Database NCCAACSC -- Active -- Up 65 days 20:42:37

Logs:
Current Log Number 16025
Pages Written 1777
Method 1 Archive Status Failure

select DB_NAME, LOG_UTILIZATION_PERCENT, TOTAL_LOG_USED_KB,TOTAL_LOG_AVAILABLE_KB,TOTAL_LOG_USED_TOP_KB, DBPARTITIONNUM from SYSIBMADM.LOG_UTILIZATION;

再次查看db2diag日志出现的问题
ZRC=0x800D002B=-2146631637=SQLM_RC_EVFULL "monitor full of data"

      DIA8052C The Event Monitor "" has reached its file capacity. Delete 
      the files in the target directory "" or move them to another 
      directory.
参与9

提问者

zxk458927165
数据库运维工程师中国电信
擅长领域: 服务器存储数据库

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2018-06-21
  • 关注会员:3 人
  • 问题浏览:4870
  • 最近回答:2018-06-27
  • X社区推广