About ABIS
All CoursesbalkjeGeneral Soft skills Introduction to HW & SW TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases, transaction systems and middleware DB2 for z/OS DB2 UDB for Linux, UNIX and Windows Oracle SQL Server MySQL IMS CICS WebSphere MQ WebSphere Application Server Data warehouse, business analytics and big dataApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java IBM development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
DB2 concepts

Intended for

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


Some familiarity with database management systems is required (see RDBMS concepts).

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.


At the end of this course, the participant will:

  • have a thorough insight into the different components of DB2: the concepts, objects and procedures;
  • handle DB2 terminology efficiently;
  • have an insight into the application possibilities of DB2, the participant will locate the product in an automated environment and know its influences on that environment;
  • 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

  • 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, ...) and their relation
  • 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 security system
  • the locking problem