DB2 Tutorial

  • Home
  • Start Here
  • Basics
  • Views
  • Triggers
  • Indexes
  • Functions
    • Aggregate Functions
    • Date Functions
    • String Functions
    • Window Functions
Home » Getting Started with Db2 » What is Db2

What is Db2

db2 tutorial

IBM Db2 is a family of related data management products, including relational database servers, developed and marketed by IBM.

Since the 1970s, IBM has developed a complete family of database servers, started on mainframe platforms such as Virtual Machine (VM), Virtual Storage Extended (VSE), and Multiple Virtual Storage(MVS).

In 1983, IBM released Db2 for MVS version 1. IBM used Db2 to indicate a shift from a hierarchical database such as Information Management System (IMS) to the new relational database.

Since then IBM continued to develop Db2 on mainframe and distributed platforms. The distributed platforms are referred to as open system platforms such as Linux, UNIX, and Windows.

In 1996, IBM released Db2 Universal Database for distributed platforms, or Db2 UDB version 5. This was the first Db2 version that IBM designed to optimize for the web.

Since the DB2 UDB version 5, IBM continued delivering a number of releases of Db2 over the years with lots of innovations such as pureXML that supports XML documents in 2006. In 2009, IBM introduced the Db2 SQL compatibility feature that makes it easy for customers to migrate from other relational database products to Db2.

In 2012, IBM released Db2 10.1 with several features that help customers reduce operational costs. A notable feature was multi-temperature storage. For example, you can classify the data as hot and cold. The hot data is the data that you access often, which will be resided in the fastest and more expensive hardware. While the cold data is the data you rarely access, which will be stored in slower and cheaper devices.

In 2013, IBM released Db2 10.4 that introduced BLU acceleration, a memory-based column store which leverages parallel vector processing power, dynamic memory capability, and advanced storage disk technology.

In 2016, IBM released Db2 11.1 that delivered key innovation which reduces the total cost of ownership. Db2 11.1 also enhanced analytics and increased availability, reliability, and security for your business-critical applications.

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

The following picture illustrates the history of Db2:

what is db2
  • Was this tutorial helpful ?
  • YesNo
Next Install DB2

Getting Started

  • What is Db2
  • Installing Db2 Database Server
  • Db2 Sample Database
  • Creating a Db2 Sample Database
  • Connecting to a Db2 Database
  • Interacting with Db2 using SQL Developer

Data Manipulation

  • SELECT
  • ORDER BY
  • WHERE
  • SELECT DISTINCT
  • AND
  • OR
  • BETWEEN
  • LIKE
  • IN
  • LIMIT
  • FETCH
  • Join
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
  • Self-Join
  • CROSS JOIN
  • GROUP BY
  • Subquery
  • HAVING
  • UNION
  • INTERSECT
  • EXCEPT
  • Common Table Expression or CTE
  • INSERT
  • INSERT Multiple Rows
  • INSERT INTO SELECT
  • UPDATE
  • DELETE

Managing Database Objects

  • CREATE TABLE
  • Identity Columns
  • ALTER COLUMN
  • ADD COLUMN
  • DROP COLUMN
  • DROP TABLE
  • TRUNCATE TABLE
  • RENAME TABLE

Db2 Constraints

  • Primary Key
  • Foreign Key
  • DEFAULT
  • NOT NULL
  • CHECK
  • UNIQUE

Db2 Data Types

  • Integer
  • Decimal
  • VARCHAR
  • CHAR
  • DATE
  • TIME
  • TIMESTAMP

Useful Functions & Expressions

  • CAST
  • CASE Expression
  • COALESCE

About db2tutorial.com

The db2tutorial.com website provides you with a comprehensive IBM DB2 tutorial with many practical examples and hands-on sessions.

Recent Tutorials

  • Db2 Functions
  • Db2 RANK
  • Db2 ROW_NUMBER
  • Db2 Window Functions
  • What is Db2

Site Links

  • Home
  • About Us
  • Contact Us
  • Privacy Policy
Copyright © © 2021 by www.db2tutorial.com. All Rights Reserved.