Editing IBM Db2 (section)

=== Db2 for LUW ===
In the mid-1990s, IBM released a clustered DB2 implementation called DB2 Parallel Edition, which initially ran on AIX. This edition allowed scalability by providing a [[shared-nothing architecture]], in which a single large database is partitioned across multiple DB2 servers that communicate over a high-speed interconnect. This DB2 edition was eventually ported to all Linux, UNIX, and Windows (LUW) platforms, and was renamed to DB2 Extended Enterprise Edition (EEE). IBM now refers to this product as the Database Partitioning Feature (DPF) and bundles it with their flagship DB2 Enterprise product.

When [[Informix Corporation]] acquired [[Illustra]] and made their database engine an [[object–relational database|object-SQL DBMS]] by introducing their Universal Server, both [[Oracle Corporation]] and IBM followed suit by changing their database engines to be capable of object–relational extensions. In 2001, IBM bought [[Informix Software]], and in the following years incorporated Informix technology into the DB2 product suite. DB2 can technically be considered to be an [[object–relational database|object–SQL DBMS]].

In mid-2006, IBM announced "Viper", the codename for DB2 9 on both [[distributed computing|distributed platforms]] and z/OS. DB2 9 for [[z/OS]] was announced in early 2007. IBM claimed that the new DB2 was the first relational database to store [[XML]] "natively". Other enhancements include [[OLTP]]-related improvements for distributed platforms, [[business intelligence]]/[[data warehousing]]-related improvements for z/OS, more self-tuning and self-managing features, additional 64-bit exploitation (especially for virtual storage on z/OS), [[stored procedure]] performance enhancements for z/OS, and continued convergence of the SQL vocabularies between z/OS and distributed platforms.

In October 2007, IBM announced "Viper 2", the codename for DB2 9.5 on the [[distributed computing|distributed platforms]]. There were three [http://www.ibm.com/software/data/db2/9/labchats.html#14 key themes for the release], Simplified Management, Business Critical Reliability, and Agile XML development.

In June 2009, IBM announced "Cobra", the codename for DB2 9.7 for LUW.<ref>{{cite web |last1=IBM Corporation |url=http://www.ibm.com/software/data/db2/9/labchats.html#31 |website=ibm.com
|archive-url=https://web.archive.org/web/20120425223145/http://www.ibm.com/developerworks/wikis/display/DB2/Chat+with+the+Lab |archive-date=2012-04-25 |date=2012-04-25 |title=Technical Tour of DB2 10 and InfoSphere Warehouse 10}}</ref> DB2 9.7 added data compression for database indexes, temporary tables, and large objects. DB2 9.7 also supported native XML data in hash partitioning (database partitioning), range partitioning (table partitioning), and multi-dimensional clustering. These native XML features allow users to directly work with XML in data warehouse environments. DB2 9.7 also added several features that make it easier for Oracle Database users to work with DB2. These include support for the most commonly used SQL syntax, [[PL/SQL]] syntax, scripting syntax, and data types from Oracle Database. DB2 9.7 also enhanced its concurrency model to exhibit behavior that is familiar to users of Oracle Database and Microsoft SQL Server.

In October 2009, IBM introduced its second major release of the year when it announced [https://www.ibm.com/developerworks/data/products/db2/purescale/ DB2 pureScale]. DB2 pureScale is a cluster database for non-mainframe platforms, suitable for [[online transaction processing]] (OLTP) workloads. IBM based the design of DB2 pureScale on the [[IBM Parallel Sysplex|Parallel Sysplex]] implementation of DB2 data sharing on the mainframe. DB2 pureScale provides a fault-tolerant architecture and shared-disk storage. A DB2 pureScale system can grow to 128 database servers, and provides continuous availability and automatic load balancing.

In 2009, it was announced that DB2 can be an engine in [[MySQL]]. This allows users on the IBM i platform and users on other platforms to access these files through the MySQL interface. On IBM i and its predecessor OS/400, DB2 is tightly integrated into the operating system, and comes as part of the operating system. It provides journaling, triggers and other features.

In early 2012, IBM announced the next version of DB2, DB2 10.1 (code name Galileo) for Linux, UNIX, and Windows. DB2 10.1 contained a number of new data management capabilities including row and column access control which enables 'fine-grained' control of the database and multi-temperature data management that moves data to cost effective storage based on how "hot" or "cold" (how frequently the data is accessed) the data is. IBM also introduced "adaptive compression" capability in DB2 10.1, a new approach to compressing data tables.

In June 2013, IBM released DB2 10.5 (code name "Kepler").

On 12 April 2016, IBM announced DB2<!--an exception? DB2 too be used here?--> LUW 11.1, and in June 2016, it was released.

In mid-2017, IBM re-branded its DB2 and dashDB product offerings and amended their names to "Db2".

On June 27, 2019, IBM released Db2 11.5, the AI Database.  It added AI functionality to improve query performance as well as capabilities to facilitate AI application development.<ref>{{Cite web|url=https://www.informationweek.com/big-data/ai-machine-learning/ibm-db2-joins-the-ai-age/d/d-id/1334868|title=IBM Db2 Joins the AI Age|website=InformationWeek|date=4 June 2019 |language=en|access-date=2019-08-20|archive-date=2019-08-20|archive-url=https://web.archive.org/web/20190820203111/https://www.informationweek.com/big-data/ai-machine-learning/ibm-db2-joins-the-ai-age/d/d-id/1334868|url-status=live}}</ref><ref>{{Cite web|url=https://www.datanami.com/2019/06/03/how-ibm-is-turning-db2-into-an-ai-database/|title=How IBM Is Turning Db2 into an 'AI Database'|date=2019-06-04|website=Datanami|access-date=2019-08-20|archive-date=2019-06-16|archive-url=https://web.archive.org/web/20190616194545/https://www.datanami.com/2019/06/03/how-ibm-is-turning-db2-into-an-ai-database/|url-status=live}}</ref><ref>{{Cite web|url=https://www.zdnet.com/article/ibm-aims-to-meld-db2-with-machine-learning-data-science-workflows/|title=IBM aims to meld Db2 with machine learning, data science workflows|last=Dignan|first=Larry|website=ZDNet|language=en|access-date=2019-08-20|archive-date=2019-10-01|archive-url=https://web.archive.org/web/20191001193620/https://www.zdnet.com/article/ibm-aims-to-meld-db2-with-machine-learning-data-science-workflows/|url-status=live}}</ref>