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

In this 4-day classroom ABIS course, the physical and logical properties of the Db2 for LUW database system are thoroughly explained and practically practiced. Classroom presentation, interactive session! Useful for anyone who will start working as a (junior) Db2 DBA - but also for analysts, (DevOps) developers, .... Prior knowledge of SQL, and basic knowledge of Db2 for LUW databases is recommended.

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.

Intended for

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.

Backgroud

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.

You can test for yourself to see if you have enough background by filling out the on-line self-test 'SQL and relational databases fundamentals'.

Main topics

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

Training method

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.

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration
4 days.