Troubleshooting
Problem
How do we fix 'Cannot open Event Monitor file' error?
Symptom
Following error will be reported:
db2evmon -db sample -evm testmon
Cannot open Event Monitor file "/home/db2v105/test_events/00000000.evt."
Syntax reference:
- Usage: db2evmon [-db] <database-alias> [-evm] <event-monitor-name>
or
db2evmon -path <event-monitor-target>
Cause
If the event monitor is not activated.
Resolving The Problem
It's common to see 'Cannot open Event Monitor file' if the event monitor is not properly activated. Run the below command to activate the event monitor before trying the db2evmon tool:
- db2 "SET EVENT MONITOR <event-monitor-name> STATE 1"
If it still fails, try the below reset commands:
- - db2 reset monitor all
- db2 flush event monitor <event_monitor_name>
- db2 "SET EVENT MONITOR <event-monitor-name> STATE 1"
- Try the db2evmon tool
Note:
If you receive SQL1620N with RC-1 during flush in step 2, go ahead and activate the monitor using step 3 and try the flush command again. Contact IBM DB2 support if you still run into issues.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Performance - Event Monitor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21882629