Blog
Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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.
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.
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.
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.
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.
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.
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.
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.