Db2 concepts

At the end of this course, the participant:

  • will have a thorough insight into the different components of Db2: its usage, its objects and procedures;
  • will know and understand terms and terminology related to Db2;
  • will have an insight into the application possibilities of Db2: the participant will be able to locate the product in an automated environment and know its influences on that environment;
  • will be able to describe the available development tools and the peripheral products surrounding Db2.


No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

Everyone who wants or needs an insight into Db2: managers, department manager, end-users, operators, (non)-information scientists.


Some familiarity with relational database management systems is required.

Main topics

  • History and future
  • Db2 as (relational) database management system:

characteristics and application • (dis)advantages • use on z/OS • use on Windows, Unix, or Linux • combined use

  • Db2 in a development environment:

strategy • available tools and peripheral products (IBM as well as non-IBM) • further developments • education • DRDA

  • Db2, internal structure:
  • the objects (database, table, index, ...) and their interaction
  • the catalog as internal dictionary
  • SQL, to be used interactively in order to manipulate objects (DDL) and data (DML)
  • embedded SQL, method and characteristics
  • available utilities
  • the internal security and authorization mechanism
  • the issue of locking

Training method

Classroom instruction.


1 day.

Course leader

Peter Vanroose, Kris Van Thillo.