IBM DB2

From EDM2
Jump to: navigation, search

IBM DATABASE 2 (DB2) is a relational database management system. It was initially developed for MVS/ESA and MVS/XA environments.

History

Relational database originally developed for IBM mainframes, later adopted to AS/400 midranges as SQL/400 and to IBM OS/2 as Database Manager.

Mainframe

Version 1
  • Apr 1985: DB2 V1R1 (for MVS) - announced 1983-06-07
  • Mar 1986: DB2 V1R2
  • Jun 1987: DB2 V1R3 - introduced DATE data types
Version 2
  • Sep 1988: DB2 V2R1 - Referential Integrity (RI)
  • Sep 1989: DB2 V2R2 - distributed database support
  • Oct 1991: DB2 V2R3 - segmented table spaces, DRDA
Version 3
  • Dec 1993: DB2 V3
Version 4
  • 1995: DB2 V4R1 (for MVS/ESA) - stored procedures
  • 1996: DB2 V4R2 (for MVS/ESA)
DB2 for OS/390
  • Jun 1997: DB2 for OS/390 Version 5
  • 1999: DB2 Universal Database for OS/390 V6
  • Mar 2001: V7
  • V8
DB2 9 for z/OS
  • DB2 9
  • DB2 10
  • DB2 11

OS/2-Versions

DATABASE2 OS/2

DB2/2 is a 32-bit implementation, also available as DB2/6000 for AIX

  • 1993: IBM DATABASE2 OS/2 1.0
  • 1993: IBM DATABASE2 OS/2 1.0.1
  • 1994: IBM DATABASE2 OS/2 1.2

DB2 Common Server

Common base for OS/2, UNIX and Windows NT

  • 1995: IBM DB2 2.1 (Server & Single user)
  • 1996: IBM DB2 2.1.1 - included Visualizer Flight
  • 1996: IBM DB2 2.1.2
  • 1996: IBM Database Server for OS/2

DB2 UDB

Logo
  • 1997: IBM DB2 UDB 5
  • 1999: IBM DB2 UDB 6.1
  • 2001: IBM DB2 UDB 7.1
  • 2002: IBM DB2 UDB 7.2

REXX Libraries

Publications

See also: The DB2 FAQ

  • Anthony S. Rudd: Implementing Practical DB2 Applications - Springer 2013, ISBN 3-540-19953-5

Links

Articles