IBM DB2: Difference between revisions
| (34 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
IBM DATABASE 2 (DB2) is a relational database management system. It was initially developed for MVS/ESA and MVS/XA environments. | |||
== History == | == 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 === | ||
* 1988: | ;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 | ||
* 1993: IBM DATABASE2 OS/2 1.0.1 | * 1993: IBM DATABASE2 OS/2 1.0.1 | ||
* 1994: IBM DATABASE2 OS/2 1.2 | * 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) | * 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 DB2 2.1.2 | ||
* 1996: IBM Database Server for OS/2 | * 1996: IBM Database Server for OS/2 | ||
====DB2 UDB==== | |||
[[Image:Db2.gif|thumb|Logo]] | |||
* 1997: IBM DB2 UDB 5 | * 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== | |||
* [http://www.craigsmullins.com/edgese95.htm An Introduction to the Architecture of DB2 for OS/2] | * [http://www.craigsmullins.com/edgese95.htm An Introduction to the Architecture of DB2 for OS/2] | ||
* [http://www.tendigit.com/izone/history/history.html A Brief History of DB2] | * [http://www.tendigit.com/izone/history/history.html A Brief History of DB2] | ||
===Articles=== | |||
*Rick Weaver: [https://web.archive.org/web/19980120020311/http://pscc.dfw.ibm.com/psmag/JUL95/weaver.htm Getting Object-Oriented with DB2 for OS/2 V2.1] - [[Personal Systems Magazine]], Jul/Aug 1995 | |||
*Chris Fierros: [https://web.archive.org/web/19980120020302/http://pscc.dfw.ibm.com/psmag/JUL95/fierros.htm Database Recovery with DB2 for OS/2] - Personal Systems Magazine, Jul/Aug 1995 | |||
[[Category:RDBMS]][[Category:SQL]] | |||
Latest revision as of 18:50, 17 June 2023
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
- 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