Dear all,

Thank you very much for your help in advance. I am using DB2 on AS400.
Recently, I receive deadlock message from developers. I would like to
do following tasks. Could anyone teach me how to do so.

1. Find out SQL statements that involve in deadlock cycle.
2. Detail information about deadlock cycle. e.g. event timestamp,
which one kick out and rollback... etc.
3. Monitor any lock information of database objects occur. (Similar to
create event monitor deadlocks at NT platform)

Thanks and regards,
Kin