Scripting for DB2 LUW – Why Perl?

Why Perl? Perl is my favorite scripting language. This was actually a conscious choice. When I took an Oracle class earlier this year, I realized that I have a non-standard background. The instructor asked the class whether people became a…

Basic scripting tricks for DB2(LUW)

There are a couple of scripting tricks that I always teach when I’m training a new dba. There are some areas where we have to iterate over something that db2 doesn’t provide us with the tools to iterate. Writing statements…

Where do you find professional inspiration?

I don’t know about you but sometimes I get in “head-down just doing the basics DBA” mode. This just about always happens over the holidays when my retail clients are so busy and have so many urgent requests, and also…

Analyzing Deadlocks – the new way

The section titled “To Format the Output to a Flat File” was updated on 2 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…

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,…

More advanced SQL analysis

So the basics of analyzing SQL on db2 are in my post on Analyzing SQL. I wanted to go a bit beyond the basics. First, you have to be able to read an explain plan. A couple of resources on…

Categories of tables in E-commerce databases

Whether you’re using WebSphere Commerce or some other vended application or using a custom application, there are four basic categories that your tables will fall into. Keep in mind that there WILL be relationships between tables in different categories, but…

What do you script?

This is a quick follow up to my last post – Scripting/Automation for DBAs. In addition to what that post covered, it’s important to think about what you script/automate and what you don’t. My picks for what absolutely must be…