Looking Forward to IBM Insight

IBM's Insight conference (the conference formerly known as IOD or Information On Demand) is next week in Las Vegas. It's a large conference that covers more than just DB2, but it is still DB2 geek heaven. I'll be there - stop me to chat if you see me, I love to talk tech with anyone. [...]

Querying Tables for an Activity Event Monitor

I've been working with a developer to profile some SQL from a process he's running. He has no insight into the SQL that the tool is using, primarily to insert data. I thought I'd share some of the details. I still think of this kind of event monitor as a "Statement Event Monitor". I started [...]

Clustering a Table on an Index

I have been playing a fair amount lately with clustering indexes and have been rehashing my views on reorging tables on an index. This is still a work in progress, but thought I'd share some details and see if others out there have any thoughts to share with me and others on it. I've long [...]

A Better Understanding of TSA Resources and States

It is very possible to support DB2's HADR using TSA to automate failover without understanding many of the TSA components and details, and even the TSA commands. I've posted several blog entries on TSA issues resolved without any deeper knowledge of things. In this post, I hope to shed a bit more light on the [...]

Tracking Table Activity using Triggers

There are a number of situations in which a DBA may need to deterimine when data in a table is being inserted or changed. The most obvious tool for tracking this may be using the db2 auditing facility. If you haven't looked at audit for a while, it has been significantly improved in more recent [...]

DB2 Quick Tip: Checking Connection State

Sometimes the connection state is unclear. The following can all make it fuzzy wether or not you have a valid connection: A db2 error or warning related to your connection A system error related to network connectivity Changing VPNs or adding a VPN connection Leaving a connection up overnight or over longer periods This tip [...]

Example of A Clustering Low-Cardinality Index Helping Query Performance

The request from the developers was something along the lines of "Help, Ember, this query needs to perform better". Sometimes the query I'm working on is not one that shows up as a problem from the database administrator's perspective, but one that is especially important in some part of application functioning. In this case, this [...]

HADR Tools: the HADR Simulator

I have not made extensive use of the HADR Tools that IBM offers in the past. Most of my HADR setups to date have either been same-data-center using NEARSYNC or have used ASYNC to copy data between data centers. I haven't had much cause to tweak my network settings or change my SYNCMODE settings based [...]

Checking the Output of SQL Scripts and Commands for Errors

Many DBAs who have been DBAs for a while have been bitten by executing an SQL script, not thoroughly checking the output, and finding later that one or more statements in the SQL script failed. I have certainly been guilty of this at times. In Linux and UNIX, when a command is run, the OS [...]

DB2 Basics: Executing a Script of SQL

There are quite a few scenarios in which DBAs need to execute a script of SQL. Sometimes developers provide such a script to be executed. Sometimes we just have a large number of commands that need to be done as a whole. For Linux and UNIX systems the file name does not matter a bit. [...]