Category: Troubleshooting

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