Let's go back in time... over three decades ago... back to the wild and woolly 1980s! And watch our favorite DBMS, DB2, grow up over t...

DB2 can use both DECIMAL and FLOAT data types to store non-integer numeric data. But the two are not equivalent. In general, use DECIMAL in...

Continuing our series on DB2 locking, let's look into a relatively recent development -- optimistic locking... IBM added improvement...

Did you know that DB2 V9 added a new column to the Real Time Statistics to help identify unused indexes? The LASTUSED column in the SYSINDE...

Just a brief blog post today to inform regular readers who might be concerned that I have not been blogging as frequently as in the past. I ...

Judy Nall has performed a much-needed service for the DB2 for z/OS community by writing her new book, DB2 9 System Administration for z/OS...

Application developers frequently need to retrieve a limited number of qualifying rows from a table. For example, maybe you need to list the...

Just a quick note to question the entire DB2 community about embracing the latest (I hesitate to call a 2 year old product "new") ...

Today I'm posting a quick blog entry to let my readers know about a couple of recent DB2-related articles/columns that I've had publ...

Most seasoned SQL programmers know that when you use host variables, DB2 may not always come up with the absolutely most optimal access path...

First of all, I want to apologize for the lack of new posts here the last couple of weeks. I've been busy traveling and preparing for th...

Welcome back to my blog as I continue our examination of the new features of DB2 9 for z/OS. Today we will look at the new UPDATE SCHEMA cap...

I am posting today’s blog entry from Athens, Greece as I participate in the European IDUG conference . Good thing I know how to use the Blog...

As we continue to wind our way through the multiple improvements that DB2 V9 brings to the IBM utilities, it is time to address the enhancem...

Today we continue our investigation into the new functionality in DB2 9 for z/OS... and specifically into the improvements made to IBM utili...

Next up in this sub-series on IBM utility improvements in the larger series on DB2 V9 features and functions we will take a look at the new ...

Next up in this on-going series covering the new features and functionality of DB2 9 for z/OS we will tackle the improvements that have been...

DB2 Version 9 improves support for coding optimistic locking techniques. What is optimistic locking? Sometimes referred to as optimistic con...

Just a short entry today to discuss a feature that will be useful for organizations having tables containing long text strings which are sto...

DB2 V9 offers some encryption news, but we need to go back a version to start the story. You see, DB2 supports encryption in Version 8 throu...