How to fix DIA8052C the Event Monitor has reached its file capacity

20 June,2012 by Jack Vamvas

Question: This DB2 error message appears in the DB2Diag.LOG file

 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.

 

How can I fix it?

Answer:   There’s probably a limit on the event monitor size. To check the current size – connect to the database and issue the statement:

 

SELECT  * FROM SYSCAT.EVENTMONITORS

 

 

Find the event monitor name under the EVMONNAME  column.

The main two options are to 1) Delete or move the event files in the target directory 2) Recreate a new event  monitor with new size definitions

To drop a deadlock monitor  read DB2 - Drop the DB2DETAILDEADLOCK event monitor

For a full definition of CREATE EVENT MONITOR

 

Read More on DB2 monitoring

How to monitor a deadlock in DB2 (DBA DB2)

DB2 - Drop the DB2DETAILDEADLOCK event monitor

How to read db2detaileventlock event monitor trace file (DBA DB2)

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to fix DIA8052C the Event Monitor has reached its file capacity

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright