Monthly Archive: January 2012

0

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 because I’m focusing on things outside of work more than normal. It also happens other times – Early Summer when...

12

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

6

Oracle’s SCN Flaw – could it happen in DB2?

I read an article on a flaw in Oracle that was recently discovered. It had to do with the SCN number that is constantly increasing in any database: http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163-0 Thanks to my friend Fitz for bringing it to my attention – and you really should read all 6 pages of that article – it is fascinating for a database geek....

7

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

0

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 that: http://web.archive.org/web/20040603042937/http://www.idug.org/idug/member/journal/Nov01/articl05.cfm http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.perf.doc/doc/c0005134.html   I’m not doing to describe reading explain plans at this time, but it is absolutely critical...

0

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 it’s good to know the category of the table for a number of reasons. There could also be hundreds of...

0

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 automated include: Backups Reorgs Runstats In addition, I also automate/script: Clean up of the diag log, notify log, and the...

0

DB2 Tools Cheat Sheet

By Special request, a DB2 Tools Cheat Sheet. Not all-inclusive, but some of the ones you’re most likely to use in supporting e-commerce databases. Click on the command to get to the DB2 Info Center entry on each one. If you think I’ve missed something important, comment with it. Tool Category Purpose Export Data Movement Pull data out of a...

1

Scripting/Automation for DBAs

So if you’re in a multiple-dba situation, you’ve probably got one DBA who is the “scripting guru”. If you’re a lone DBA, you’ve either written or acquired from others the scripts for basic automation of the most simple tasks. Everyone has their shortcuts and tricks. I thought I’d write a general post on things you should be aware of when...

2

Locking Parameters

So I thought I’d write a post covering locking parameters. This is by no means a comprehensive coverage of isolation levels and locking, but more of a practically oriented guide to the parameters available in DB2 that relate to locking. LOCKTIMEOUT This database configuration parameter specifies the time in seconds that a connection will wait for a needed lock before returning an...