IBM DB2 is a relational database focus on transactional and warehousing workloads. It is built on top of many Engine dispatchable units (EDUs), which control the activity inside the database. In 2017, IBM Db2 was announced which is the successor name of DB2 (introduced in the 1980s). Recent years, Db2 started to support non-relational structures like JSON and XML. It can support many platforms including Linux, UNIX, Windows, z/OS, i, VSE, and VM.[04][05][06]
- Developer
- Country of Origin
- US
- Start Year
- 1983
- Project Type
- Commercial
- License
- Proprietary
IBM DB2 is a relational database focus on transactional and warehousing workloads. It is built on top of many Engine dispatchable units (EDUs), which control the activity inside the database. In 2017, IBM Db2 was announced which is the successor name of DB2 (introduced in the 1980s). Recent years, Db2 started to support non-relational structures like JSON and XML. It can support many platforms including Linux, UNIX, Windows, z/OS, i, VSE, and VM.[04][05][06]
History[06]
DB2 dates back to early of the 1970s. At that time, IBM researcher Edgar F. Codd described relational databases theory and published the famous paper “A Relational Model of Data for Large Shared Data Banks.”
In 1974, System R, which implemented Codd’s concepts, was developed by a team in IBM. SQL was the critical development of System R.
In the mid-1990s, DB2 Parallel Edition was released which provided scalability by shared-nothing architecture.
In the mid-2006 and October 2007, “Viper” and “Viper 2” were announced, which is the codename for DB2 9 and DB2 9.5.
In June 2009, “Cobra” DB2 9.7 was released. “Cobra” added many exciting features including temporary tables, large objects and data compression for database indexes. In October of the same year, DB2 pureScale was announced, which was a database cluster solution suitable for Online transaction processing (OLTP) workloads. Again in the same year, IBM said that DB2 could be an engine in MySQL.
In early 2012, “Galileo” DB2 10.1 was announced, which can support Linux, UNIX, and Windows. In mid-2017, “Db2” replaces the name of “DB2”.
Checkpoints[07]
IBM Db2 can take a backup using the BACKUP command. We can use the ONLINE parameter to control online or offline backup. The default option is offline, and we should enable logarchmeth1 if we want to use online backup.
dashDB
Citations
7 sources- Db2 | IBM ibm.com
- https://www-01.ibm.com/support/docview.wss?uid=swg27009474 ibm.com
- IBM Db2 - Wikipedia wikipedia.org
- IBM Db2 Database ibm.com
- IBM Documentation ibm.com
- https://www.wikiwand.com/en/IBM_Db2 wikiwand.com
- BACKUP DATABASE command - IBM Documentation ibm.com