Db2 for Linux, UNIX and Windows
Db2 for Linux, UNIX and Windows is a database server product developed by IBM. Sometimes called Db2 LUW for brevity, it is part of the Db2 family of database products. Db2 LUW is the "Common Server" product member of the Db2 family, designed to run on most popular operating systems. By contrast, all other Db2 products are specific to a single platform.
Db2 LUW was initially called Db2 Universal Database (UDB), but over time IBM marketing started to use the same term for other database products, notably mainframe (z-Series) Db2. Thus the Db2 for Linux, UNIX and Windows moniker became necessary to distinguish the common server Db2 LUW product from single-platform Db2 products.
The current Db2 LUW product runs on multiple Linux and UNIX distributions, such as Red Hat Linux, SUSE Linux, IBM AIX, HP-UX, and Solaris, and most Windows systems. Earlier versions also ran on OS/2. Multiple editions are marketed for different sizes of organisation and uses. The same code base is also marketed without the Db2 name as IBM InfoSphere Warehouse edition.
In 2017, the "Db2 UDB" name became just "Db2".
The first release of Advanced Db2 LUW was as Db2 Universal Database version 5, available on UNIX, Windows and OS/2 platforms. This new product stemmed from two earlier products, Db2 Common Server version 2 and Db2 Parallel Edition. Db2 Universal Database version 5 continued IBM's new direction of using a common code base to support Db2 on different platforms, while incorporating the shared nothing features of Db2 Parallel Edition to support large data warehousing databases.
In addition to standard ACID-compliant row-organized relational database functionality, some of its key features are:
- IBM BLU Acceleration: OLAP oriented column-organized tables, compressed with order-preserving "approximate Huffman encoding", exploiting SIMD vector processing of compressed data. Because the compression is order preserving, a greater range of operations can be performed on compressed data.
- pureScale: A data-sharing clustering of the database over multiple servers for scalability and resilience. This technology was taken from the mainframe (z-Series) Db2 product. This form of clustering suits OLTP workloads well.
- Database partitioning feature: A shared-nothing approach to clustering, with data hashed across multiple partitions on the same server or different processors. With the right database design, this approach allows near-linear scaling. This form of clustering is generally employed for large data warehouses rather than OLTP workloads.
- XML support: XML-specific storage and indexing, accessible by both SQL and also XQuery.
- NoSQL support: Currently graph triple stores and JSON support
- "Column-organized tables". IBM. Retrieved September 13, 2017.
- Eaton, Chris. "Actionable Compression in Db2 10.5 with BLU Acceleration". Toolbox. Retrieved September 13, 2017.
- "RDF application development for IBM data servers". IBM. Retrieved September 13, 2017.
- "JSON application development for IBM data servers". IBM. Retrieved September 13, 2017.