Troubleshooting
Problem
Warning ADM2014W recorded for event monitor in Windows Event log
Symptom
The following message has been recorded in Windows event log:
ADM2014W The Event Monitor "JAZZ_DEADLOCKS" detected on table
"DLCONN_JAZZ_DEADLOCKS" (ID "2") that the size of the column
"TPMON_ACC_STR" is
smaller than the default size of "255". Therefore, contents will be truncated
to the user specified size.
Cause
The issue was caused by the change of definition for TPMON_ACC_STR column.
Previously DB2 defines the column with VARCHAR(200). The latest release
changes this to VARCHAR(255).
Resolving The Problem
Please run the following to resolve this issue:
db2 "call evmon_upgrade_tables(null, null, null, ?, ?, ?)"
You can verify that TPMON_ACC_STR column of table DB2ADMIN.DLCONN_JAZZ_DEADLOCKS has been updated to VARCHAR(255):
db2 describe table DB2ADMIN.DLCONN_JAZZ_DEADLOCKS
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21989457