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.
Mainframe programmers do not aware about there is checkpoints concept in DB2. Many guys assume that CHECKPOINT…