Author: Craig Mullins

Consultant at Mullins Consulting, Inc

Craig Mullins

Craig S. Mullins is working with Datavail and its DB2 practice to expand offerings. He is president and principal consultant at Mullins Consulting, Inc. and the publisher of The Database Site. Mullins has 30 years of experience in all facets of database management and is the author of two books: “DB2 Developer’s Guide” currently in its 6th edition and “Database Administration: The Complete Guide to DBA Practices and Procedures,” the industry’s only guide to heterogeneous DBA.

Articles Written by Craig Mullins

Here is a follow-up question and answer based on my previous blog post: Q: My format does not fit into any of the formats listed in the DB2 manuals. What if I have a DATE stored like YYYYMMDD (with no dashes or...

Read More

Regular readers of my blog know that 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...

Read More

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.

Read More

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.

Read More

Table expressions are frequently overlooked as a potential solution for resolving problems using only SQL.

Read More

Recently I was reading through some posts on a database-related blog or mailing list (actually, right now I can't remember which one it was). The conversation I was reading was in response to this question: "Does the number of columns or size of the row matter in terms of performance?"

Read More

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.

Read More

This blog will compare the use of VARCHAR to DB2 compression when you are building your DB2 databases. Visit to learn more.

Read More

You should really do the investigative work required to find out the real level of support for DB2 V11 that is in the GA version of the tool. Read more.

Read More

Are any of the DB2 unload utilities able to include the column names in the same file as the unload output data? Read on to discover the answer.

Read More