系统集成Db2归档日志

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

查看错误日志返回的结果DATA #1 : <preformatted>Failed to archive log file S0016022.LOG to VENDOR chain 7 from /db2home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.查看归档日志历史信息Comment: ...显示全部

查看错误日志返回的结果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

查看其它 2 个回答1301664724qq的回答

1301664724qq1301664724qqIT顾问IBM

磁盘满了吧!!!

IT其它 · 2018-06-21
浏览2977

回答者

1301664724qq 最近回答过的问题

回答状态

  • 发布时间:2018-06-21
  • 关注会员:3 人
  • 回答浏览:2977
  • X社区推广