DB2 Tutorial
DB2 Useful Resources
Selected Reading
- DB2 - LDAP
- DB2 - Roles
- DB2 - Database Security
- DB2 - Backup and Recovery
- DB2 with XML
- DB2 - Views
- DB2 - Sequences
- DB2 - Triggers
- DB2 - Indexes
- DB2 - Constraints
- DB2 - Alias
- DB2 - Tables
- DB2 - Data Types
- DB2 - Schemas
- DB2 - Storagegroups
- DB2 - Tablespaces
- DB2 - Bufferpools
- DB2 - Databases
- DB2 - Instance
- DB2 - Server Installation
- DB2 - Introduction
- Home
DB2 Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
DB2 - Introduction
DB2 - Introduction
This chapter describes history of DB2, its versions, editions and their respective features.
Overview
DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 is designed to store, analyze and retrieve the data efficiently. DB2 product is extended with the support of Object-Oriented features and non-relational structures with XML.
History
Initially, IBM had developed DB2 product for their specific platform. Since year 1990, it decided to develop a Universal Database (UDB) DB2 Server, which can run on any authoritative operating systems such as Linux, UNIX, and Windows.
Versions
For IBM DB2, the UDB current version is 10.5 with the features of BLU Acceleration and its code name as Kepler . All the versions of DB2 till today are psted below:
| 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 | Gapleo |
| 10.5 | Kepler |
Data server editions and features
Depending upon the requirement of needful features of DB2, the organizations select appropriate DB2 version. The following table shows DB2 server editions and their features:
| 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 Availabipty Disaster Recovery (HARD) Materiapzed 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 Availabipty Disaster Recovery (HARD) Onpne Reorganization Pure XML Web Service Federation support DB2 Homogeneous Federations Homogeneous SQL reppcation Backup compression |
| Express -C | It provides all the capabipties 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 pmited services. This Edition comes with - Web Service Federations DB2 homogeneous federations Homogeneous SQL Reppcations Backup compression |
| Enterprise Developer Edition | It offers only single apppcation developer. It is useful to design, build and prototype the apppcations for deployment on any of the IBM server. The software cannot be used for developing apppcations. |