DB2 DBMS

A Guide to Database Management Systems - DBMS

DB2 is a relational database management system (DBMS) that was introduced by IBM in 1983.  The product was initially developed to run on the MVS operating system.  A distributed version of DB2 was then released on OS/2 in 1987.  Today DB2 is widely used by large organizations and can run on wide variety of UNIX, Linux and Windows platforms.

IBM markets different "editions" DB2 with different licensing arrangements. The cost of DBMS ownership therefore is based on the options that are needed.  DB2 Editions include the following:

  1. DB2Workgroup
  2. DB2 Workgroup Unlimited
  3. DB2 Enterprise Server Edition
  4. DB2 UDB Data Warehouse Enterprise Edition (DWE)

The DB2 UDB Data Warehouse Enterprise Edition includes business intelligence capabilities such as ET, data mining and online analytics. DB2 has APIs for many languages including the following:

  1. .NET
  2. CLI
  3. Java
  4. Python
  5. Perl
  6. PHP
  7. C++
  8. C
  9. REXX
  10. PL/1
  11. Cobol
  12. RPG
  13. Fortran

Next Page