By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,433 Members | 776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,433 IT Pros & Developers. It's quick & easy.

DB2 deadlock on AS400

P: n/a
Kin
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.