Why you should program to interfaces in SQL

With DB2 9.7’s introduction of modules and the ability to create an alias on a module, you now have the ability to program to a function or procedure’s interface rather than its implementation. Why would you want to do this? In today’s post, I will go over reasons to program to an interface and show you how to do it using modules and aliases. Continue reading ‘Why you should program to interfaces in SQL’

db2top: How to change column order and preserve it in the next session

Over the next few db2top-related blog posts, I am planning to post some videos that demonstrate some of the features I wrote about in earlier posts. First up is the Change Columns Order screen and a video to demonstrate how to change the column order and keep it changed for the next time you launch db2top:

Watch this video directly on YouTube.

db2top Performance Report

StopwatchUp to now, we have been looking mostly at db2top as a tool for observing the behavior of your system in real-time, but background mode and recording and playback has shown us that db2top can produce and examine historical data as well. The db2top tool can also be used to perform an analysis on such historical data and present a performance report. This ‘analysis’ feature is the topic of today’s post. Continue reading ‘db2top Performance Report’

Amazon Kindle 2.5 in Pictures

Amazon Kindle with 2.5 software updateThe Amazon Kindle 2.5.2 software update was released today for US and international Kindle and Kindle DX readers. You can download it from the Amazon Kindle Software Updates page or wait until it is delivered wirelessly to your Kindle automatically over the next few weeks. I tried the manual process on my own Kindle and the installation was pretty painless, just copying a file over and telling the Kindle to start the software update. Continue reading ‘Amazon Kindle 2.5 in Pictures’

8 Simple Steps To Improve Your Writing

Revising Prose book coverI want to become a better writer. So when I saw Jason Fried, CEO of 37signals, tweeting last month that Richard A. Lanham’s book Revising Prose was “the best book on writing & editing I’ve ever read”, I had to get myself a copy. I was not disappointed. Continue reading ‘8 Simple Steps To Improve Your Writing’

db2top Display Settings

Display settings

When a monitoring or reporting tool reaches a certain level of sophistication, it needs to be able to report on itself as well. The db2top tool has a large number of configurable options, so it is fortunate that there is a screen that lets us see the present value of each such option. In today’s post, we will look at the Display Settings screen. Continue reading ‘db2top Display Settings’

db2top Native Snapshot

Snapshot of a database

The db2top tool, on each of its various screens, presents a subset of the full capabilities of the DB2 snapshot monitor. In this post, we’ll see how you can use the native snapshot feature to gain access to the full snapshot. Continue reading ‘db2top Native Snapshot’

New in DB2 for LUW 9.7.2: UDF default parameters

IBM released DB2 for LUW 9.7.2 recently and, along with numerous quality improvements, there were a number of interesting new features. In today’s post, I will talk about the “default parameters in UDFs” feature and how that helped me shrink the amount of code I needed to write for one of my UDFs. Continue reading ‘New in DB2 for LUW 9.7.2: UDF default parameters’

db2top Change Columns Order

Reordering of columns

What good is a tool if you can’t customize it to your liking? Fortunately, db2top is quite customizable. In today’s post, we will look at how you can customize the order in which columns are presented for the majority of those screens in db2top that present their information in a table.
Continue reading ‘db2top Change Columns Order’


Histogram as bar graphIn Curt Cotner’s recent blog post, What’s new in statement-level performance metrics, he wrote about the popularity among customers of Optim Performance Manager (OPM)’s ability to create and visualize histograms of statement costs. In this post, I’m going to take a look at histograms in general, examine some histograms that are new in DB2 for LUW as of version 9.5, and provide some resources that can show you how to make use of histograms yourself. Continue reading ‘Histograms’

  • Search