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 for LUW DBA - Core competences


This course follows the DB2 for LUW fundamentals course and mainly treats the structure and management of the Database Management system. Goal of the course is to provide the audience with the conceptual and practical information to cope with the day-to-day administration of a DB2 for LUW system.

At the end of the course:

  • the participant is able to set-up the correct product configuration for his environment;
  • the participant knows the physical set-up of the DB2 for LUW objects;
  • the participant is able to set-up the correct physical organisation and security of the DB2 for LUW data;
  • the participant has a good understanding of the use and scope of the database tools and db-system commands;
  • the participant is able to set up a troubleshooting approach based on the available error logging infrasctructure;
  • delegates have a good understanding of the DB2 for LUW logging mechanism;
  • delegates know about the recovery strategies in DB2 for LUW.

Main topics

  • The DB2 for LUW Instance • Memory segments • Bufferpools • Agents • Engine Dispatchable Units
  • DB2 for LUW Physical storage
  • Database scalability • Parallelism • Partitioning
  • db2 - Command Line Processor
  • Instances: set-up • configuration • administration • Fault Monitor Facility
  • Databases: Creating • Physical structure • Database configuration • Configuration Advisor
  • DB2 for LUW System Information
  • The Catalog • LIST command • administration logs (db2diag) • Using db2pd • Memory tracking • SYSIBMADM Views
  • Tablespace Types: SMS Tablespaces • DMS Tablespaces • Automatic storage table spaces • Storage groups
  • Tablespace Design Issues: Page sizes • Extent size • Prefetch size • Bufferpools
  • Logical Objects
  • Tables: Internals • Large objects • Table 'space' management • Range partitioning • Time travel
  • Indexes: Structure • Internals • Types • Design Advisor
  • Looking at objects and object behaviour
  • Export: concepts • Import: concepts • Loading Data: concept • Load Phases • Load indexing mode
  • Analyzing integrity problems
  • Moving databases around: db2move • db2look
  • Reorgchk utility • Reorganizing table and/or index • Runstats Utility • Rebind Utility • QUIESCE Command
  • Automatic maintenance
  • Transactional logging • Types of logging
  • Backing Up the Database: Backup Types • The Recovery History File • Automatic database backup
  • Database Recovery: Crash recovery • Database Restore • Recovery Types: Roll forward - Cloning
  • Authentication configuration and fail-safe
  • Authorization levels: System • Database • Privileges
  • Roles • Trusted contexts and trusted connections • Encryption
  • RCAC (Row and Column Access Control)

Intended for

Database administrators who are going to use DB2 for LUW as an RDBMS. The course does not depend on a particular platform, version 10.5 is the version level of reference.


Some basic knowledge of the use of the database system (see course DB2 for LUW fundamentals course), a thorough SQL experience (see course SQL workshop) and some programming experience are required.

Training method

Theory combined with exercises on Windows/Linux.

Course leader

Koen De Backer, Kris Van Thillo.


4 days.


You can enrol by clicking on a date
datedur.lang.  location  price
19 Dec4NWoerden  (NL)2000 EUR  (exempt from VAT) 

Global score

4.0/5 (based on 76 evaluations)


All the sessions were very knowledgeable and give a good insight in to DB2. (, )
Goed.De docent beschikt ook over veel parate kennis in relatie met oracle. dat was heel positief. (, )
was voor mij zeer zinvol (, )
Gewoon goede cursus, goede docu + goede docent. (, )
goede verdeling van de theorie en oefeningen eerste twee dagen. Vrijdag was veel theorie en weinig oefenen. (, )
leerzaam, Goede indruk van DB2 gekregen. (, )
Gaat goed in op de reeds aanwezige kennis, vooral aandacht voor de verschillen LUW en Z/OS (, )
geeft een goed beeld van DB2 for LUW. Er wordt gedetailleerd op de materie ingegaan. Misschien te diep af en toe.Dit leer je in de praktijk wel. (, )
Er zaten/zijn wat fouten in de documentatie vooral in het boek van part 2 (, )
het was weer een genot om van Koen les te krijgen. (, )

Refresh this page to see other comments.