DB2

Other Free Books!
Business-Software-Books.us
CAD-CAM-Books.us
Computer-Books.us
Database-Books.us
Java-Books.us
Linux-Books.us
 
Remember that these titles are copyright © the author or the publisher. The author / publisher has generously allowed them to be available for free online. Please respect the terms and conditions of the copyright.

If you know of a quality book that we should include on this page, please let me know.

 

 
DB2 Virtualization Whei-Jen Chen, Jason Chan, et al.
Up and Running with DB2 for Linux Whei-Jen Chen, Rav Ahuja, Louisa Ford, Paul Jud, Kang Yong Ying
IBM DB2 - SQL Reference Vol 2 v8.2 IBM Corp.
IBM DB2 - SQL Reference Vol 1 v8.2 IBM Corp.
IBM DB2 - Quick Beginnings for DB2 Universal Database Express Edition v8.2 IBM Corp.
IBM DB2 - Quick Beginnings for DB2 Servers IBM Corp.
IBM DB2 - Quick Beginnings for DB2 Personal Edition IBM Corp.
IBM DB2 - Quick Beginnings for DB2 Data Links Manager v8.2 IBM Corp.
IBM DB2 - Quick Beginnings for DB2 Clients IBM Corp.
IBM DB2 - Message Reference Vol 2 IBM Corp.
IBM DB2 - Message Reference Vol 1 IBM Corp.
IBM DB2 UDB v9.1 SQL Cookbook Graeme Birchall
IBM DB2 - Application Development Guide IBM Corp.
IBM DB2 - Command Reference v8.3 IBM Corp.


Non-Book Resources

DB2 has a long history and was what some consider to be the first database product to use SQL.

The name DB2 was first given to the Database Management System or DBMS in 1982 when IBM released SQL/DS and DB2 on its mainframe platform. Prior to this, the product was named System Relational, or System R, which launched in 1978. DB2 has its roots back to the beginning of the seventies when Dr. E.F. Codd, working for IBM, described the theory of relational databases and in June of 1970 published the model for data manipulation. To apply the model Codd needed a relational database language which he named Alpha. At the time IBM didn't believe in the potential of Codd's ideas, leaving the implementation to a group of programmers not under Codd's supervision, who violated several fundamentals of Codd's relational model; the result was Structured English QUEry Language or SEQUEL. IBM soon changed the name to the current acronym, SQL, short for Structured Query Language, because SEQUEL had already been trademarked.

Historically, it is interesting to note that when Informix acquired Illustra and made their database engine an object-SQL DBMS by introducing their Universal Server, both Oracle and IBM followed suit by changing their database engines to be capable of object-relational extensions. Moreover, in 2001, IBM bought Informix and in the following years incorporated Informix technology into the DB2 product suite. Today, DB2 can technically be considered to be an object-SQL DBMS.

For many years DB2 was exclusively available on IBM mainframes. Later IBM brought DB2 to other platforms, including UNIX and Windows servers, then Linux (including Linux on zSeries) and PDAs. This process was mainly undertaken through the 1990s. The inspiration for DB2's implementation details came in part from IBM DL/1 and IBM IMS, both initially hierarchical and then later network (or CODASYL) databases. DB2 is also embedded in the i5/OS operating system for IBM System i (iSeries, formerly the AS/400), and versions are available for z/VSE and z/VM. An earlier version is available for OS/2 and is called DB2/2.