Db2 LUW Advanced topics

In 12 afternoon sessions (4 weeks of 3 afternoons each), we will review more advanced topics. Each week (unit) has a theme. There are no exercises with this course. This course will provide you with information you cannot find easily in the manuals like why and pros/cons of certain options. Each afternoon (approx. 2-3 hours) we will discuss Advanced DB2 topics in a live session on Microsoft Teams. Your trainer is Klaas Brant and the language is English.

Klaas Brant is the founder of KBCE, a company known for DB2 Training like the Db2 Symposium and Db2 Master Classes. Klaas has been working with Db2 LUW for more than 25 years now with a focus on DBA, backup & Recovery, and Performance. Klaas is one of the IBM Db2 Gold consultants (consultants selected by IBM known for their expertise), an IBM Analytics Champion (awarded lifetime), and a member of the Db2 Customer Advisory Counsel.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

This is the perfect course for anybody who has basic Db2 DBA skills but wants to know more so he or she can tune, install, upgrade, or recover DB2 with confidence. The target audience is experienced DBAs, DevOps team members, and System Administrators.

Background

Basic DBA knowledge or field experience.

Main topics

  • Unit 1: All about data
  • Design Tablespace / Bufferpool strategy
  • Automatic Storage in more depth
  • Space reclaim
  • Relocation of data inside and outside of DB2
  • Doing data and index reorganization
  • Advanced table options
  • Partitioned tables
  • Compression
  • MDC / ITC organization
  • Blu Tables
  • Security
  • SSL access to the database
  • LBAC / RCAC security
  • Separation of duties
  • Trusted Context & Roles
  • DB2 audit facility
  • Unit 2: Advanced Backup & Recovery
  • RTO / RPO
  • Logging / Backup / Restore in more detail
  • Rollforward (PIT recovery)
  • Planning your recovery
  • Partial Recovery
  • Redirected Recovery / Relocating data
  • Recover a Dropped Table
  • Problems you might encounter
  • Disk Mirror and Snapshot techniques
  • HADR
  • Introduction PureScale
  • Unit 3: Installing, Maintaining, and optimizing your DB2
  • Versions / Releases / Fixpacks / License
  • Installing
  • Configuring (DB CFG / DBM CFG / Registry)
  • Fixpack vs Upgrade what is different
  • Memory / CPU / IO
  • STMM
  • Run as container
  • WLM
  • Monitoring tools
  • Advanced diag tools (DB2DIAG / DB2PD / Inspect / DART)
  • Unit 4: Application Tuning
  • How DB2 processes your application
  • The optimizer in more depth
  • Explain & Access Paths
  • Indexes
  • Predicates & Joins
  • Cardinality Estimates
  • Optimizer Tweaks
  • Collecting statistics - RUNSTATS
  • The test environment
  • Hunting for bad SQL
  • SQL tuning tips
  • Benchmarking

Training method

This course has a practical approach and teaches what works and what to avoid (no marketing hype).

We have a video of the live session available soon after the live session. This is a perfect way to follow the course when joining from the USA, or want to, or need to, do the course in your own time. These recordings are available until July 14th, 2024.

Duration

12 afternoon sessions

Course leader

Klaas Brant, KBCE


SESSION INFO AND ENROLMENT