Category: Troubleshooting

8

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. If you’re at all confused about the difference between deadlocks and...

5

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. I’m going to focus on what you can do manually with no pay-for-use or even tools that require additional installation tasks. There are multiple...

7

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...

7

Locks – Timeout vs. Deadlock

So questions in this area most often come from DBAs from other RDBMS’s or from developers. I’ll probably write other posts on locks, but here are the basics on deadlocks vs. timeouts. Why we get them confused at all Ah the wisdom that went into grouping these under a single error code with different return/reason codes. For whatever reason, both...

0

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? This week I had an instance...

2

What to do when DB2 won’t work

This probably falls more in the DB2 newbie category, but I suspect I may have some readers who are DB2 newbies or at least not veterans. Several years ago (ok, probably more than 5), DB2 seemed to be considering a “Problem Determination Mastery” certification. I jumped on board and went through a series of free tutorials from IBM (which are still...