The section titled “To Format the Output to a Flat File” was updated on 2/13/2012. Edit on 12/11/2014: This new method of analyzing locking issues became available in DB2 9.7. So you can still use the old way, and if you want to avoid event monitors that write to tables, that’s still the only way. See Analyzing Deadlocks – the...
IBM Knowledge Center Link Problems
Note: IBM DB2 Knowledge Center links in some older posts are currently broken. I am working through fixing them, but there are over 300, and this is not something I can do during my day job. If you find a link you need, add a comment on the post about it and it will jump to the top of my list to fix.
The posts here represent my personal views and not those of my employer. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with IBM support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. DB2 is a trademark of IBM. I am not an employee or representative of IBM.