DB2 for LUW DBA - Core competences (EN/NL/FR)

This 4 day ABIS course mainly treats the structure and management of the Db2 LUW 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.

Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.

Audience: Database administrators who are going to use DB2 for LUW as an RDBMS. The course does not depend on a particular platform, and refers to the last version of the priduct.

Course content:

• The Db2 for LUW system - A roundup for DBAs
  • 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 and Databases
  • 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
• Tablespaces and Containers
  • 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
• Moving Data around
  • Export: concepts • Import: concepts • Loading Data: concept • Load Phases • Load indexing mode
  • Analysing integrity problems
  • Moving databases around: db2move • db2look
• Keep Data in shape
  • Reorgchk utility • Reorganizing table and/or index • Runstats Utility • Rebind Utility • QUIESCE Command
  • Automatic maintenance
• Database Recovery
  • 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
• Security and Access Control
  • Authentication configuration and fail-safe
  • Authorization levels: System • Database • Privileges
  • Roles • Trusted contexts and trusted connections • Encryption
  • RCAC (Row and Column Access Control)

Duration: 4 days.

Background: Some basic knowledge of the use of the database system, a thorough SQL experience and some programming experience are required.