This post is specific to WebSphere Commerce. We spent a fair amount of time on this, both on a SUSE server and a Red Hat Server. The problem manifested in different ways. The main thing that became obvious to me is that Commerce was not creating the Commerce database as the dbaUser specified in createInstance.properties… Read the rest
Continue reading »Tag: Troubleshooting
Analyzing Deadlocks – the new way
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.
Edit on 09/29/2016: Correction to the SQL for counting statements when context data is collected.… Read the rest
Analyzing Deadocks – the old way
In 9.7, DB2 started offering a new monitoring method for deadlocking. Though this post describes the “old” way, this method also works in db2 9.7. Detailedeadlock event monitors have been deprecated, but not yet removed. This means that even in 9.7, you can still create them and work with them.… Read the rest
Continue reading »SQL Analysis Overview
So I thought I’d do a short series on analyzing SQL. I want to focus on some of the techniques I use, so not necessarily everything you could know about it, but some basics on one way to do it.
Identifying Problem SQL
Many DBAs have their own methods and approaches in this area, but there are some basic sources and methods that I use. I’ll cover at least the basics of SQL analysis in one or more future posts
Get SQL from Developers
So the optimum situation is that your developers give you the SQL they’re planning to use in custom code (or better yet, they have a dba write it in the first place).… Read the rest
Continue reading »db2diag Tool for Parsing the Diagnostic Log
Understanding the db2 diagnostic log takes a while when you’re new to DB2. Then you get better at spotting what is actually a problem. But there’s still so much there sometimes. How many messages for stmm adjustments or archived log files do I have to scroll through to find what I’m really looking for?… Read the rest
Continue reading »