How DB2 manages indexes. There are two popular indexes present in DB2. How to differentiate these two indexes explained in simplified way.
There are different indexes being used in DB2. The reasons are no always the same. The all 7 indexes explained for ready use.
Knowing Primary Key on which column of Table it is defined is a tricky in mainframe zo/s DB2. This SQL query helps to find column name of table on which it is defined. Very useful query for mainframe developers working on DB2.
Many of the cases while working on real time projects you need to work with Excel. The tips tells how to find duplicates using Excel. Read more.
In DB2 by writing SELECT SQL query you will not get row numbers in your result. The example SQL query useful for your project to get row numbers in the result.
The real concept of check point useful to carry bulk loading the db2 tables. Read more.
Load utility in DB2 useful to load massive records. Give here key concepts for quick reference.
Row is one kind of data type in DB2. This post covers the benefits of row id data type.