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.
Indexes improve the performance of the database tables. However, this post covers differences between clustered index and unique index.
Useful DB2 Quiz questions for your next interview.
In this post you can find how to Create and Delete DB2 user-defined functions.
Three top SQL queries you need to get Table metadata. Metadata means Table structure. That means to know indexes and columns of a Table in question.