All Tutorials Home Page DB2 Introduction



DB2 is well known as Data base 2 which is introduced by IBM. It is known as Relational database (Relational is nothing but the data stored will have a relation in between). The relational data stored in format of TABLE which contains Tuples (ROWS) and the row consists of Attributes (COLUMNS).

DB2 is almost similar to the SQL (Structured Query Language) but with some additional features and mainly used to process the large amount of data from the Mainframe application.


Readers who are having or not having mainframe knowledge.


The tutorial is intended for the readers with no previous programming or computer science experience as well as for those with some computing background. In the tutorial, all the topics are covered with in depth description and can understandable by anyone who had minimum/no computation background.


Need to learn COBOL, JCL languages if learning for processing DB2 tables from COBOL programs.

Learn COBOL tutorial at COBOL Tutorial

Learn JCL tutorial at JCL Tutorial

There are no prerequisites to learn DB2 language if learning the DB2 only for Database knowledge. Having the computation background will be an advantage in understanding the concepts a bit easy. Without having computation background, it is a bit time taking to understand the concepts and need to go through the topic more than once to understand clearly.

Table of contents:

  1. DB2 - Introduction
  2. DB2 - Table Storage Structure
  3. DB2 - Index Storage Structure
  4. DB2 - Precompilation Process
  6. DB2 - ISOLATION levels
  7. DB2 - Db2 program Execution process
  8. DB2 - Host Variables
  9. DB2 - SQLCA
  10. DB2 - Cursor
  11. DB2 - Db2 Statements in Cobol program
  12. DB2 - DDL
  13. DB2 - DML
  14. DB2 - TCL
  15. DB2 - DCL
  16. DB2 - JOIN Statement
  17. DB2 - NULL
  18. DB2 - DB2 Error codes

  19. All Tutorials Home Page DB2 Introduction