IBM Db2 Family

DB2IBM DB2pureQueryDB/2IBM PureQueryDatabase 2DB2 (LUW)DB2 EveryplaceDB2 Express-CDB2,
Db2 is a family of data management products, including database servers, developed by IBM.wikipedia
374 Related Articles

Z/OS

IBM z/OSzOSIBM z
DB2 9 for z/OS was announced in early 2007.
z/OS supports stable mainframe systems and standards such as CICS, COBOL, IMS, DB2, RACF, SNA, IBM MQ, record-oriented data access methods, REXX, CLIST, SMP/E, JCL, TSO/E, and ISPF, among others.

OS/2

OS/2 WarpIBM OS/2OS/2 Warp 4
Later, IBM brought DB2 to other platforms, including OS/2, UNIX, and MS Windows servers, and then Linux (including Linux on IBM Z) and PDAs.
Other development tools included a subset of the video and keyboard APIs as linkable libraries so that family mode programs are able to run under MS-DOS, and, in the OS/2 Extended Edition v1.0, a database engine called Database Manager or DBM (this was related to DB2, and should not be confused with the DBM family of database engines for Unix and Unix-like operating systems).

SQL

Structured Query LanguageSQL databaseSQL Databases
A key development of the System R project was the Structured Query Language (SQL).
After testing SQL at customer test sites to determine the usefulness and practicality of the system, IBM began developing commercial products based on their System R prototype including System/38, SQL/DS, and DB2, which were commercially available in 1979, 1981, and 1983, respectively.

Open Database Connectivity

ODBCODBC driverDatabase driver
As a result, they use different drivers.
Like the different varieties of SQL, the Embedded SQLs that used them varied widely, not only from platform to platform, but even across languages on one platform – a system that allowed calls into IBM's DB2 would look very different from one that called into their own SQL/DS.

Database server

SQL Serverdatabasedatabase servers
Db2 is a family of data management products, including database servers, developed by IBM.
Examples of proprietary database applications include Oracle, DB2, Informix, and Microsoft SQL Server.

Linux on IBM Z

s390xIBM LinuxONEIBM Z
Later, IBM brought DB2 to other platforms, including OS/2, UNIX, and MS Windows servers, and then Linux (including Linux on IBM Z) and PDAs.
When Linux applications in an LPAR access data and applications in other LPARs such as CICS, IBM DB2, IMS, Linux, and other mainframe subsystems, running on the same physical mainframe, they can utilize HiperSockets – fast, memory-only TCP/IP connections.

IBM System i

AS/400iSeriesSystem i
However, in the 1990s IBM changed track and produced a Db2 common product, designed with a mostly common code base for L-U-W (Linux-Unix-Windows); DB2 for System z and DB2 for System i are different. DB2 is also embedded in the i5/OS operating system for IBM System i (iSeries, formerly the AS/400), and versions are available for z/VSE and z/VM.
Features include a RDBMS (DB2/400), a menu-driven interface, support for multiple users, block-oriented terminal support (IBM 5250), and printers.

MVS

MVS/ESAMVS/XAMVS/370
The name DB2 (IBM Database 2), was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform.
The most significant motives for the rapid upgrade to 31-bit addressing were the growth of large transaction-processing networks, mostly controlled by CICS, which ran in a single address space—and the DB2 relational database management system needed more than 8 MB of application address space to run efficiently.

IBM i

OS/400i5/OSIBM i5/OS
DB2 is also embedded in the i5/OS operating system for IBM System i (iSeries, formerly the AS/400), and versions are available for z/VSE and z/VM.
For example, IBM i has a built-in DB2 database which does not require separate installation.

PL/SQL

PLSQLMetatranz StepSqlitePL/SQL (Oracle)
These include support for the most commonly used SQL syntax, PL/SQL syntax, scripting syntax, and data types from Oracle Database.
PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since version 7), Times Ten in-memory database (since version 11.2.1), and IBM DB 2 (since version 9.7).

IBM Information Management System

IMSInformation Management SystemHierarchical Sequential Access Method
The inspiration for the mainframe version of DB2's architecture came in part from IBM IMS, a hierarchical database, and its dedicated database-manipulation language, IBM DL/I.
The IMS Database component stores data using a hierarchical model, which is quite different from IBM's later released relational database, Db2.

IBM mainframe

IBM mainframesmainframeIBM mainframe computers
For some years DB2, as a full-function DBMS, was exclusively available on IBM mainframes.
Current IBM mainframes run all the major enterprise transaction processing environments and databases, including CICS, IMS, WebSphere Application Server, DB2, and Oracle.

VM (operating system)

VM/CMSVMVM/370
IBM's first commercial relational-database product, SQL/DS, was released for the DOS/VSE and VM/CMS operating systems in 1981.
Examples include RAMIS, FOCUS, SPSS, NOMAD, DB2, REXX, RACF, and OfficeVision.

IBM SQL/DS

SQL/DSSQL
IBM's first commercial relational-database product, SQL/DS, was released for the DOS/VSE and VM/CMS operating systems in 1981.
A little later, IBM also introduced DB2, another SQL-based DBMS, this one for the MVS operating system.

Stored procedure

stored proceduresproceduresdatabase procedures
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.

Oracle Corporation

OracleOracle Technology NetworkOracle Corp.
When Informix Corporation acquired Illustra and made their database engine an 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.
Oracle Corporation's main competitors in the database arena remain IBM DB2 and Microsoft SQL Server, and to a lesser extent Sybase and Teradata, with open source databases such as PostgreSQL and MySQL also having a significant share of the market.

VSE (operating system)

z/VSEDOS/VSEVSE
DB2 is also embedded in the i5/OS operating system for IBM System i (iSeries, formerly the AS/400), and versions are available for z/VSE and z/VM. IBM's first commercial relational-database product, SQL/DS, was released for the DOS/VSE and VM/CMS operating systems in 1981.
DB2 is also available and popular.

Database

database management systemdatabasesDBMS
The name DB2 (IBM Database 2), was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform.
By the early 1990s, however, relational systems dominated in all large-scale data processing applications, and they remain dominant: IBM DB2, Oracle, MySQL, and Microsoft SQL Server are the most searched DBMS.

Object-relational database

object-relationalobject-relational database management systemobject extensions
When Informix Corporation acquired Illustra and made their database engine an 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. They initially supported the relational model, but were extended to support object-relational features and non-relational structures like JSON and XML.
For example, IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success.

Distributed Data Management Architecture

hierarchical directoriesrecord-oriented fileRecord-oriented file (DDM)
(Note that DRDA is based on objects and protocols defined by Distributed Data Management Architecture (DDM).)

Comparison of database tools

database toolmulti-database query, design, and database comparison tool

DRDA

Distributed Relational Database ArchitectureDistributed Relational Database Architecture Distributed Relational Database Architecture (DRDA)
IBM extended the functionality of Database Manager a number of times, including the addition of distributed database functionality by means of Distributed Relational Database Architecture (DRDA) that allowed shared access to a database in a remote location on a LAN.

IBM Parallel Sysplex

Parallel SysplexSysplexGDPS
IBM based the design of DB2 pureScale on the Parallel Sysplex implementation of DB2 data sharing on the mainframe.

MySQL

M'''ySQLMySQL 4.1MySQL 4.x
In 2009, it was announced that DB2 can be an engine in MySQL.