— Online Course —
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. This course has a practical approach and teaches what works and what to avoid (no marketing hype). 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.

​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.

Planning live sessions

Starting at 13:00 CET on dates:

  • week 20 – 14, 15, 16 May = Unit 1
  • week 21 – 21, 22, 23 May = Unit 2
  • week 22 – 28, 29, 30 May = Unit 3
  • week 23 – 4, 5, 6 June = Unit 4

 

Recording from the live training

We have a video of the live session available soon after the live session. This 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.
Extra Q&A sessions: 17, 24, 31 May and 7 June from 17:00-18:00 CET (11-12 am EST).

Pricing:

Euro-zone: € 2995 (ex. VAT)

For non-Dutch companies the EU reverse rule applies (no VAT)

USA: $ 3199 (no VAT)

Discounts:

3-4 persons you get 10% discount
Bigger groups can be fixed price, please email info@kbce.com for a quote

Registration

Click the download PDF below. Last page of the PDF is registration form with instructions.

Download PDF

Db2 LUW Advanced Topics Content:

  • Unit 1: All about data
    • Design Tablespace / Bufferpool strategy
    • Automatic Storage in more depth
    • Space reclaim
    • Relocation data inside and outside of DB2
    • 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

Your Trainer for this workshop – Klaas Brant

Klaas Brant is the founder of KBCE, a company know world wide for DB2 Training like the Db2 Symposium and Db2 Master Classes. Klaas has been working with Db2 LUW for almost 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 life time) and a member of the Db2 Customer Advisory Counsel.

Online class using Microsoft Teams Q&A

Microsoft Teams has proven itself to be very flexible and has good video and audio quality. But maybe you or your company don’t use MS Teams. No problem! You will get an invite from us. If you already use MS Teams then the invite will add another Team (the class) to your existing Teams. If you don’t have Teams you have two options: 1. use online MS Teams in the browser or 2. download MS Team and use the MS Teams App on your PC (in general better quality). In both of these cases you don’t need a MS Teams License. You don’t have to register your email with Microsoft.

Questions we often get:

Q: Do I need a webcam?
A: No, in fact, we advise you to turn off the camera on a laptop to save bandwidth.

Q: Do I need a microphone?
A: That is handy but not a must, you can also ask question in the chat.

Q: What do I do if I have a question during the exercises or after viewing the recording?
A: Send us a message in MS Teams or attend one of the Q&A sessions.

Q: What if I miss a live session or cannot attend (e.g. different time zone)?
A: You get access to a recording of the live session. All students receive after the live session a url to the recording in the email. Please don’t share recordings!