Specialized IT Services focused on Data Management | Speak with Us 877-634-9222
Author: 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...
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...
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.
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.
Table expressions are frequently overlooked as a potential solution for resolving problems using only SQL.
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?"
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.
This blog will compare the use of VARCHAR to DB2 compression when you are building your DB2 databases. Visit to learn 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.