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.
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.
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.
Adding Column Names to an Unload File
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.
Advice on Using Variable Character Columns in DB2
One of the long-standing, troubling questions in DB2-land is when to use VARCHAR versus CHAR.
There’s a Better Way to Use Your DBAs
When an organization doesn’t have 24×7 support, the senior database administrator is typically forced to do low-level work and is placed on-call for emergencies. She becomes bogged down in “administrivia” and is unable to operate effectively.
Nulls are clearly one of the most misunderstood features of DB2. Here are some examples, tips & guidelines from Craig Mullins to demystify the use of nulls.