The database administrator (DBA) plays a key role in the data management process. The DBA is the scriptwriter and director in the design, implementation and maintenance of database structures; and is partly responsible for setting up and maintaining a high-performance database system. This course therefore offers a thorough technical and logical overview of the Db2 for LUW database management system. The training is primarily focussed on application DBAs.

At the end of the course, the participant:

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

• 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)

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

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

Database administrators (junior role); other users who perform part of the DBA's task; application developers (in a DevOps environment); system administrators who want to gain insight into the mainly logical Db2 for LUW object structures.