Description
IBM has developed a database product called as DB2 and this DB2 is a part of RDBMS. The full form of RDBMS is Relational DataBase Management System. The RDBMS is one in which the information can be referenced in the premises with respect to its contents, and these informations are literally saved. A client describes a collection of tables as a part of the database. The RDBMS is a database programming language that can performed with the accompanying operations. Such as
DB2 is intended to store, evalute and recover the information productively. The database product DB2 is stretched out with the backing of non-relational structures and Object-Oriented components with XML.
The database DB2 is utilized to deal with a wide assortment of information, for example, the outcome of exploration tests, document assets for organization managers, or the areas and serial quantities of bits of hardware's. At first, IBM had created the product of DB2 for the platforms that are explicit and in the year 1990,Universal Database DB2 Server has been developed, which can keep running on any legitimate working frameworks, for example, Windows, UNIX, and Linux.
- Enabling one to create a database with tables,sections and lists.
- Assured the Referential Integrity among the rows of different tables in the current database.
- Consequently updates the indexes .
- Read an SQL query and joins data from different database tables.
Conceptual
figure
The below conceptual keys shows the DB2 database.
Description
In DB2, the UDB present version is 10.5 with the components of BLU Acceleration and its code name as 'Kepler'. Each and every version of DB2 are indexed below, such as
| Versions | Code Names |
|---|---|
| 3.4 | Cobweb |
| 8.1,8.2 | Stinger |
| 9.1 | Viper |
| 9.5 | Viper 2 |
| 9.7 | Cobra |
| 9.8 | It added the components with only pure-scale |
| 10.1 | Galileo |
| 10.5 | Kepler |
Key Points
- DB2 Tutorials - Is a database product developed by IBM.
- DB2 Tutorials - Here different kinds of database versions are explained.