In DB2, the dynamic indexes concept is a frequently asked question. Here is complete information on how DB2 will create those.
Here explained how DB2 CHAR and VARCHAR stores strings. It’s helpful to understand the differences between these two.
Check and Default constraints are both not the same. They create during create Table. Differences between these you can understand with these examples.
Here is a resolution for SQL error -206. You will get an error of object is not valid. Here are possible reasons for this error. Also given solution for how to fix it.
How to use package in DB2, and its real benefits explained to use in your programs.
Here is the top B-Tree index mechanism that followed in DB2. It is a helpful explanation for DB2 developers.
Here’s a way you can use to check DB2 utility job completion status in mainframe Z/Os.
DB2 SQL query performance tuning ideas. Here’re the ways that you can use.
In DB2, you need to know Rusnstats utility when it has to run. Ideas that are given in this post help you to make a decision.
SQL procedure saves your time when writing it for repetitive tasks. On top of that, writing code with Labels improves readability. So that maintenance is easy.
DB2 Collects Table statistics in an automated way. This post tells you how Optimizer uses the Statistics for a better SQL query execution plan.
In DB2, you can avoid unnecessary locking by following these Technics. These improve application performance.