IBM DB2

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 V4 (for MVS/ESA) - stored procedures
 * 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

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

 * REXX/SQL - SQL access for REXX - Open source

Publications
See also: The DB2 FAQ
 * Anthony S. Rudd: Implementing Practical DB2 Applications - Springer 2013, ISBN 3-540-19953-5

Links

 * An Introduction to the Architecture of DB2 for OS/2
 * A Brief History of DB2

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