Db2 for z/OS database administration

At the end of this course, the participant will:

  • have a clear overview of the very versatile tasks of a DBA in Db2;
  • have a thorough technical insight into the physical and logical structure of the different objects in Db2;
  • have learned to translate a logical data model into a physical database in test/acceptance/production environments;
  • have practical skills to define and prepare procedures for the management of the databases.


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

New database administrators and other users occupied with (part of) the tasks of a DBA.

Database administrators of Db2 who want a refresh, specifically regarding new possibilities in versions 10 , 11, and 12.


Sufficient practical experience with Db2 (see course Db2 for z/OS fundamentals course).

Main topics

  • PART 1: Database Implementation
  • Overview of the versatile tasks of a DBA.
  • Physical design and implementation of Db2 objects:
  • Db2 object definition: decision rules
  • Possibilities for the implementation of a logical design: referential integrity (primary/foreign keys), check constraints, triggers, sequence objects, identity columns, distinct types, XML, LOBs, views and MQTs; index and tablespace design; partitioning; temporal tables and transparent archiving
  • schema evolution: possibilities of ALTER; pending changes
  • implementing a test environment: DDL • test data • statistics
  • preparing for migration
  • prepare the database for performance analysis (but see also course Db2 for z/OS SQL performance)
  • Access control to Db2 objects:
  • scenarios for efficient security management and auditing requirements
  • details regarding the different possibilities: owner-based, role-based, multilevel-based, or object-based; trusted context; "separate security" possibilities (incl. row permissions and column masks)
  • plans, packages, and bind & rebind options
  • The Catalog and the Directory:
  • contents • usage • management
  • effective use of the real-time statistics (RTS)
  • PART 2: Database maintenance & integrity control
  • Data Utilities:
  • Using utilities: Db2I & JCL • listdef and templates • exec sql • tablespace sets • terminate and restart
  • online reorg • load & unload • check data & check index • rebuild • runstats & stospace • statistics profiles
  • Related aspects:
  • dynamic allocation of datasets (with or without SMS)
  • (re)partitioning of tables; moving data to other volumes
  • use of data compression
  • possibilities of and potential problems with foreign keys
  • PART 3: Database recovery
  • Internal physical structure of Db2 data objects:
  • tablespaces and indexspaces, partitions; page sets and fan sets; VSAM; BSDS
  • Db2 backup and recovery utilities & service aids:
  • using utilities & service aids to backup, recover & verify integrity of data
  • inspect and copy the contents of Db2 datasets or selective pages
  • point-in-time recovery and disaster recovery: best practices

Training method

Theory with ample room for practical exercises.


4 days.

Course leader

Peter Vanroose.


Goed, maar de docent zou af en toe iets minder mogen uitweiden over zaken.

  (, )

Veel geleerd, wel erg intensief.

  (, )

Très bonne connaissance de la part de l'instructeur.

  (, )

Prima cursus, losse puzzelstukjes vielen op hun plaats

  (, )