This article contains content that is written like an advertisement. Please help improve it by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view.(March 2022) (Learn how and when to remove this message)
"DB2" redirects here. For other uses, see DB2 (disambiguation).
IBM Db2
Developer(s)
IBM
Initial release
1983; 41 years ago (1983)[1]
Stable release(s)
11.5.9[2]
/ 15 November 2023; 5 months ago (15 November 2023)
Written in
C, C++, assembly, Java
Operating system
Linux, Unix-like, Windows. Historical support for OS/2
Platform
x86-64, x86, SPARC, IBM Power microprocessors
Size
1.6 GB
Available in
English, Spanish, French, German, Russian, Japanese
Type
RDBMS
License
Proprietary commercial software, Proprietary EULA
Website
www.ibm.com/products/db2/
IBM Db2 for z/OS
Developer(s)
IBM
Initial release
1983; 41 years ago (1983)
Stable release
13.1
Written in
PL/X, C, C++, assembly
Operating system
z/OS
Platform
z/Architecture
Available in
English
Type
RDBMS
License
Proprietary EULA
Website
ibm.com/products/db2-for-zos
Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2[3][4][5] until 2017,[6] when it changed to its present form. (In the early days, it was sometimes wrongly styled as DB/2 - in a false derivation from the operating system OS/2 [7].)
^"IBM Database 2 (DB2) Release 1 Is Announced". IBM Offering Information. 7 June 1983. Archived from the original on 13 April 2023. Retrieved 13 April 2023.
^"Db2 Documentation". Retrieved 15 November 2023.
^Don Chamberlin (1998). A Complete Guide to DB2 Universal Database. Morgan Kaufmann. ISBN 1558604820. DB2 for MVS (later OS/390) in 1983
^"The Evolution of DB2 for z/OS Optimization". IBM Systems magazine. Archived from the original on 2018-10-30. Retrieved 2018-10-29. Since the introduction of DB2 in 1983, IBM ...[unreliable source?]
^"The Executive Computer; Bringing Point-and-Click Ease to ..." The New York Times. January 22, 1995. Archived from the original on October 30, 2018. Retrieved October 29, 2018. relational data base management ... I.B.M.'s DB2
^"Db2 on Cloud". IBM. Archived from the original on 2018-08-25. Retrieved 2018-08-24.
Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended...
database (Oracle, SQL Server, IBM DB2 Universal Database or PostgreSQL) which can be separate or on the same server where IBM Director Server resides. Smaller...
programming failures as a result of SQL calls by IBMDb2 programs. An important feature of IBMDb2 programs is the error processing. The error diagnostic...
hierarchical model, which is quite different from IBM's later released relational database, IBMDb2. In IMS, the hierarchical model is implemented using...
given the name DB2/400 in 1994 to indicate comparable functionality to IBM's other commercial databases. Despite the Db2 branding, Db2 for IBM i is an entirely...
Integrated Information Processor: dedicated to run specific workloads including IBMDb2, XML, and IPSec These are essentially identical, but distinguished for...
Pratt & Whitney in 1977. IBMDb2IBM SQL/DS Ingres (database) SQL System/38 "A History and Evaluation of System R" (PDF). IBM. "Phase Zero" of the project...
follows is an expression or a statement respectively. IBMDB2 for distributed systems known as DB2 for LUW (LUW means Linux, Unix, Windows) supports three...
KVM on IBM Z is another hypervisor option. When Linux applications in an LPAR access data and applications in other LPARs such as CICS, IBMDb2, IMS, Linux...
2011. Retrieved 17 March 2015. "pureXML overview -- DB2 as an XML database". IBM Knowledge Center. IBM. Retrieved 17 March 2015. "Using XML in SQL Server"...
2013-02-14. Retrieved 2013-02-05. Full-text search with Db2 Text Search, Developer Works, IBM Does Firebird support full-text search?, Firebird FAQ Fulltext...
(APIs) to perform the access. It was first used in DB2 2.3. DRDA was designed by a work group within IBM in the period 1988 to 1994. The messages, protocols...
following databases: TiDB MySQL and MariaDB PostgreSQL Greenplum Oracle IBMDb2 EXASOL SQL Server Mimer SQL Sybase Firebird Teradata Vertica SAP HANA Apache...
although the TSM database used many of the same underlying technologies as IBM'sDb2, has a SQL engine (for read-only use), and supports access through ODBC...
because some DBMS's support only one column type (or neither of them). IBMDb2 supports Virtual column of Version 8 as Generated column. MariaDB is a...
IBMDb2 Query Management Facility (QMF) for z/OS is business analytics software developed by IBM. It was originally created to be the reporting interface...
Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBMDb2 (DB2 UDB Version 7) database system. It provides...
control, and store rich text data. IBM Domino 7 to 8.5.x supports the use of IBMDb2 database as an alternative store for IBM Notes databases. This NSFDB2 feature...
is one of the brands within IBM Software Group (SWG) division. The major Information Management products include: IBMDb2 — relational database management...
Software, now Oracle Corporation. Ingres and IBM BS12 followed. Other examples of an RDBMS include IBMDb2, SAP Sybase ASE, and Informix. In 1984, the...
brand, IBM DB2, to five: DB2, Lotus, WebSphere, Tivoli, and Rational. Content to leave the consumer applications business to other firms, IBM's software...
(DataBase 2) IBMDB2 Content Manager IBMDB2 Document Manager IBMDB2 Records Manager IBM Deep Computing Visualization for Linux V1.2 IBM DISOSS Distributed...
GNU, and Windows operating systems primarily against IBM'sDb2 and Microsoft SQL Server. IBM'sDb2 still[update] dominates the mainframe database market...
Services, IPSec offload, certain parts of IBMDB2 DRDA, star schema, IBM HiperSockets for large messages, and the IBM GBS Scalable Architecture for Financial...
debugged from various IDEs. "Db2 12 - Application programming and SQL - Calling a stored procedure from your application". www.ibm.com. Retrieved 2022-05-26...