db2detaildeadlock Event Monitor
This default deadlock event monitor has been deprecated for quite some time, since at least Db2 9.7. However, most places I run into still have it defined and it is running but many times its output is not used or it is still being used instead of the new LOCKING event monitor that took it’s place. To see how to create the new LOCKING event monitor, drop the old db2detaildeadlock and format the new event monitor data, refer to this link: https://www.ibm.com/docs/en/db2/11.1?topic=statements-create-event-monitor-locking. If Db2 was installed correctly and the DB2 Java is installed, you shouldn’t have any problem compiling and using the db2evmonfmt.java program. Follow this link on how to set it up https://www.ibm.com/docs/en/db2/11.1?topic=tables-db2evmonfmt-tool-reading-event-monitor-data.