This section portrays history of DB2, its renditions, versions and their separate highlights.
Overview
DB2 is a database item from IBM. It is a Relational Database Management System (RDBMS). DB2 is intended to store, dissect and recover the information productively. DB2 item is stretched out with the help of Object-Oriented highlights and non-social structures with XML.
History
At first, IBM had created DB2 item for their particular stage. Since year 1990, it chose to build up a Universal Database (UDB) DB2 Server, which can run on any definitive working frameworks, for example, Linux, UNIX, and Windows.
Versions
For IBM DB2, the UDB current adaptation is 10.5 with the highlights of BLU Acceleration and its code name as 'Kepler'. All the forms of DB2 till today are recorded beneath:
| Version | Code Name |
|---|---|
| 3.4 | Cobweb |
| 8.1, 8.2 | Stinger |
| 9.1 | Viper |
| 9.5 | Viper 2 |
| 9.7 | Cobra |
| 9.8 | It added features with Only PureScale |
| 10.1 | Galileo |
| 10.5 | Kepler |
Data server editions and features
Contingent on the prerequisite of needful highlights of DB2, the associations select fitting DB2 adaptation. The accompanying table shows DB2 server versions and their highlights:
| Editions | Features |
|---|---|
| Advanced Enterprise Server Edition and Enterprise Server Edition (AESE / ESE) | It is designed for mid-size to large-size business organizations. Platform - Linux, UNIX, and Windows. Table partitioning High Availability Disaster Recovery (HARD) Materialized Query Table (MQTs) Multidimensional Clustering (MDC) Connection concentrator Pure XML Backup compression Homogeneous Federations |
| Workgroup Server Edition (WSE) | It is designed for Workgroup or mid-size business organizations. Using this WSE you can work with - High Availability Disaster Recovery (HARD) Online Reorganization Pure XML Web Service Federation support DB2 Homogeneous Federations Homogeneous SQL replication Backup compression |
| Express -C | It provides all the capabilities of DB2 at zero charge. It can run on any physical or virtual systems with any size of configuration. |
| Express Edition | It is designed for entry level and mid-size business organizations. It is full featured DB2 data server. It offers only limited services. This Edition comes with - Web Service Federations DB2 homogeneous federations Homogeneous SQL Replications Backup compression |
| Enterprise Developer Edition | It offers only single application developer. It is useful to design, build and prototype the applications for deployment on any of the IBM server. The software cannot be used for developing applications. |
