IBM DB2

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

• Apr 1985: DB2 V1R1 (for MVS) - announced 1983-06-07
• Mar 1986: DB2 V1R2
• Jun 1987: DB2 V1R3
• Sep 1988: DB2 V2R1
• Sep 1989: DB2 V2R2
• Oct 1991: DB2 V2R3
• Dec 1993: DB2 V3
• 1995: DB2 V4 (for MVS/ESA)
• Jun 1997: DB2 for OS/390 Version 5
• 1999: DB2 Universal Database for OS/390

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

OS/2 tools that can access DB/2 databases directly

• REXX/SQL - SQL access for REXX - Open source - Current

Publications

• 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