What is "db2"

History

The name DB2 was given to the Database Management System that the IBM launched in 1983 based on SQL/DS for his mainframe. At first the product was called System R started in 1978.

The project DB2 began in the early 1970s when Edgar Frank Codd, working for IBM, described the Relational Database Theory and published his theory in June 1970. To apply the model, Codd created a relational database language that called it Alpha.

However, IBM did not believe in the potential of its ideas, leaving it outside the supervision of the group of programmers, who violated several fundamental ideas of Codd’s relational model. The result was language SEQUEL, which was later changed to its acronym SQL because SEQUEL was already a registered trademark.

Technical Information

DB2 can be administered either in a line command interface or in a graphical environment. Line command interface requires more product knowledge but can be more easily automated.

The graphical environment is a multi-platform Java that contains a wide variety of Wizards for beginners.

DB2 has Apis for . NET CLI, Java, Python, Perl, PHP, Ruby, C++, C, REXX, PL/I, COBOL, RPG, FORTRAN, and many other programming languages.

DB2 also has integration support in Eclipse and Visual Studio . NET

Resources