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