Solution : https://service.sap.com/sap/support/notes/837115 (SAP Service marketplace login required)
Key words :
set event monitor db6_dlmon_histvals state 0drop event monitor db6_dlmon_histvalsdrop table sapr3, set event monitor db6_dlmon_histvals state 1to deactivate, set event monitor db6_dlmon_histvals state 0note, set event monitor db6_dlmon_histvals state 0delete, set event monitor db6_dlmon_histvals state 0export, db6_dlmon_histvals_control db6_dlmon_histvals_deadlock db6_dlmon_histvals_connheader db6_dlmon_histvals_dlconn db6_dlmon_histvals_dllock db6_dlmon_histvals_stmthist db6_dlmon_histvals_stmtvals, create event monitor db6_dlmon_histvals, flush event monitor db6_dlmon_histvalsusing, db2 udb version 8 fixpak 9, terms extended monitor deadlock
Related Notes :
| 851220 | DB6: Extended deadlock monitor (individual shipment) |
| 851151 | DB6: New functions in DB2 V8 FixPak 9 (V8.2.2) |
| 327595 | Analysis of database lock situations using db6util |
| 175036 | DB6: The DBSL deadlock trace |