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 infrastructure;
  • delegates have a good understanding of the Db2 for LUW logging mechanism;
  • delegates know about the recovery strategies in Db2 for LUW.

Schedule

datedur.lang.locationprice 
17 Dec4Woerden 2000 EUR (exempt from VAT)
23 Jun4Woerden 2100 EUR (exempt from VAT)
SESSION INFO AND ENROLMENT

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.

Background

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.

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

Theory combined with exercises on Windows/Linux.

Duration

4 days.

Course leader

Koen De Backer, Kris Van Thillo.

Reviews

4.1/5 (based on 19 evaluations; the most recent ones are shown below)

De inhoud van de cursus is wat ik er van verwacht had. Helaas niet voldoende tijd om alle onderdelen helemaal te behandelen en alle labs uit te voeren.

 
  (, )

Zeer uitvoerige en goede cursus. voldeed volledig aan de verwachtingen. Ging eigenlijk verder en dieper dan ik had verwacht.

 
  (, )

Uitstekend

 
  (, )

Uitstekend, Duidelijke uitleg door Koen. Goede labs!

 
  (, )

Goed beeld gekregen van DB2 - LUW. Cursusdocumentatie goed bruikbaar in de praktijk.

 
  (, )

Erg nuttig

 
  (, )

goede cursus, veel inhoud, zelfs te veel om in de tijd te behandelen. Miste alleen HADR zaken in de cursus

 
  (, )

Er zaten/zijn wat fouten in de documentatie vooral in het boek van part 2

 
  (, )

Click here to see more comments...

Uitstekend. Veel geleerd in een paar dagen. Bedankt!

 
  (, )

Prima, verdieping op vorige cursus

 
  (, )

het was weer een genot om van Koen les te krijgen.

 
  (, )

SESSION INFO AND ENROLMENT