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.
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.
Row is one kind of data type in DB2. This post covers the benefits of row id data type.
The different time formats in DB2 really a good idea to know all these format. When you are working on international projects knowing time formats is really a worth.
The DB2 timestamp format example and the new changes made in DB2 v10. Read more.