About ABIS
All CoursesbalkjeGeneral Introduction to HW & SW Soft skills TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases and middleware Relational databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data and analyticsApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
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.

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

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.

Training method

Classroom instruction.

Course leader

Peter Vanroose, Kris Van Thillo.


1 day.


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 contact ABIS.


Veel theorie. Ik had meer praktijk verwacht. Ondanks dat heb ik zeker veel opgestoken! (, )
Geen opmerkingen: inhoud ruim voldoende voor mij (, )
Prima. Lesgever is goed op de hoogte & cursus is evenwichtig ingedeeld (, )
Good course, would recommend some more practice illustration (but was already very understandable) (, )
A good presentation of the general ideas & concepts, though a bit lacking in the details (, )
Very good presentation of DB2; sometimes too fast, at other times too detailed. Clear presentation (, )
De start was wel snel (, )
A good introduction to DB2 concepts (, )
Zeer leerzaam (, )
goed inzicht in over hoe DB2 structureel in elkaar zit. (, )