Jump to content

IBM DB2: Difference between revisions

From EDM2
Ak120 (talk | contribs)
Ak120 (talk | contribs)
No edit summary
Line 42: Line 42:
* 2002: IBM DB2 UDB 7.2
* 2002: IBM DB2 UDB 7.2


====OS/2 tools that can access DB/2 databases directly====
==OS/2 tools that can access DB/2 databases directly==
* [[REXX/SQL]] - SQL access for [[REXX]] - Open source - Current.
* [[REXX/SQL]] - SQL access for [[REXX]] - Open source - Current


== Links ==
==Publications==
* [[Howard Fosdick]]: ''The Best Book of OS/2 Database Manager'' – Hayden 1989, ISBN 0-672-48436-6
* Howard Fosdick: ''OS/2 Data Base Manager: A Developer's Guide'' - Wiley 1989, ISBN 0-471-50803-9
* [[Anthony S. Rudd]]: ''Implementing Practical Database Manager Applications'' - Ellis Horwood 1991 - ISBN 0-13-454174-X
* 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===
==Publications==
* [http://books.google.com.ec/books?id=zLEmAAAAMAAJ OS/2 database manager:A developer's guide] by [[Howard Fosdick]] - Wiley (1989)
* [[Anthony S. Rudd]]: ''Implementing Practical Data Base Manager Applications'' - 1991 - Pearson Higher Education - ASIN: B01B8SF30Y
* [[Anthony S. Rudd]]: ''Implementing Practical Db2 Applications'' - 2013 - Springer Verlag - Paperback, 220 pages - ISBN 3540199535 - ISBN 978-3540199533 - In print
* Howard Fosdick: ''The Best Book of OS/2 Database Manager'' – Hayden 1989, ISBN 0-672-48436-6
* Howard Fosdick: ''OS/2 Data Base Manager: A Developer's Guide'' - Wiley 1989, ISBN 0-471-50803-9
 
====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
*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
*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

Revision as of 23:36, 26 September 2016

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

OS/2 Database Manager

  • 1988: IBM OS/2 EE 1.0 Database Manager
  • 1989: IBM OS/2 EE 1.1 Database Manager
  • 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

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

Publications

  • Howard Fosdick: The Best Book of OS/2 Database Manager – Hayden 1989, ISBN 0-672-48436-6
  • Howard Fosdick: OS/2 Data Base Manager: A Developer's Guide - Wiley 1989, ISBN 0-471-50803-9
  • Anthony S. Rudd: Implementing Practical Database Manager Applications - Ellis Horwood 1991 - ISBN 0-13-454174-X
  • Anthony S. Rudd: Implementing Practical DB2 Applications - Springer 2013, ISBN 3-540-19953-5

Links

Articles