Select Page


Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: Db2

Intelligent Automatic Reoptimization?

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

Craig Mullins | April 12, 2016

The Most Important Thing is Recoverability

Many DBAs think that managing performance is the most important thing they do, but they are confusing frequency with importance.

Craig Mullins | March 24, 2016

Selecting Every Other Row

A recent question I received went something like this: “Can I get the odd and even number of rows from a DB2 table?” Learn the answer in this post.

Craig Mullins | March 15, 2016

On Date Formats in DB2 – Part 1

From time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a popular theme – dealing with DB2 date data.

Craig Mullins | February 9, 2016

DB2 Date and Time Data

DB2 allows you to add and subtract DATE, TIME, and TIMESTAMP columns. In addition, you can add date and time durations to, or subtract them from, date and time columns.

Craig Mullins | January 26, 2016

Q+A: Locking

The question was: I want to perform a retry on an INSERT under DB2 Z/OS when I get a deadlock/timeout. -911 causes a rollback automatically.

Craig Mullins | December 24, 2015

Consider Table Expressions to Improve Performance

Table expressions are frequently overlooked as a potential solution for resolving problems using only SQL. Learn more in this post.

Craig Mullins | December 23, 2015

Database Performance and Row Size for DB2

“Does the number of columns or size of the row matter in terms of performance?” Let’s explore this question in further detail.

Craig Mullins | December 18, 2015

Q+A: Nulls and DASD

Let’s say I have a table A which has 500 columns. Out of those 500 columns only 5 columns have been defined as not nullable and the rest have been defined as NULLS allowed.

Craig Mullins | December 14, 2015