IBM DB2
From EDM2
IBM DATABASE 2 (DB2) is a relational database management system. It was initially developed for MVS/ESA and MVS/XA environments.
Contents
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
- 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
- Rick Weaver: Getting Object-Oriented with DB2 for OS/2 V2.1 - Personal Systems Magazine, Jul/Aug 1995
- Chris Fierros: Database Recovery with DB2 for OS/2 - Personal Systems Magazine, Jul/Aug 1995