Jump to content

IBM DB2: Difference between revisions

From EDM2
← Older edit
mNo edit summary
Ak120 (talk | contribs)
35,819 edits
 
(28 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Image:Db2.gif|right]]
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''.
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 ===
=== Mainframe ===
* 1983: DB2 V1
;Version 1
* 1985: DB2 V1R1 (for MVS)
* Apr 1985: DB2 V1R1 (for MVS) - announced 1983-06-07
* 1986: DB2 V1R2
* Mar 1986: DB2 V1R2
* 1987: DB2 V1R3
* Jun 1987: DB2 V1R3 - introduced DATE data types
* 1988: DB2 V2R1
;Version 2
* 1989: DB2 V2R2
* Sep 1988: DB2 V2R1 - Referential Integrity (RI)
* 1992: DB2 V2R3  
* Sep 1989: DB2 V2R2 - distributed database support
* 1993: DB2 V3
* Oct 1991: DB2 V2R3 - segmented table spaces, DRDA
* 1995: DB2 V4 (for MVS/ESA)
;Version 3
* 1997: DB2 V5
* 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 ===
===OS/2-Versions===
* 1988: IBM OS/2 EE 1.0 Database Manager
====DATABASE2 OS/2====
* 1989: IBM OS/2 EE 1.1 Database Manager
DB2/2 is a 32-bit implementation, also available as DB2/6000 for AIX
* 1990: IBM OS/2 EE 1.2 Database Manager
* 1990: IBM OS/2 EE 1.3 Database Manager
* 1991: IBM OS/2 Extended Services with Database Manager
* 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
* 1999: IBM DB2 UDB 6.1
Line 32: Line 49:
* 2002: IBM DB2 UDB 7.2
* 2002: IBM DB2 UDB 7.2


== Links ==
==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]]
[[Category:Tools]][[Category:Databases]][[Category:SQL]][[Category:MS Windows Tools]][[Category:AIX Tools]][[Category:Linux Tools]]

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

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

Retrieved from "https://www.edm2.com/index.php?title=IBM_DB2&oldid=80936"