— Online Course —
Db2 LUW DBA Basics Workshop

 

In 6 afternoon sessions, every student will learn the basic DBA skills. From creating tablespaces and tables to doing backups/restores and database reorgs and much more. This course has a practical approach and teaches what is needed (no marketing hype). Each afternoon (approx. 3+ hours) we will discuss DBA topics in a live session on Microsoft Teams. Your trainer is Klaas Brant and the language is English.

With each session, each student gets several assignments that they must complete in their own time. Each assignment will take approx. 2-3 hours to complete. A DB2 on Linux environment is provided during, and four weeks after the training. You can also use your own in-house test environment (files and setup instructions are provided, on request). No special Linux knowledge is needed, and all exercises apply to any platform db2 runs on. You will need an SSH client on your PC (more details in the confirmation). This course is up to date with the latest DB2 releases.

This is the perfect course for anybody who needs Db2 DBA skills in their day-to-day job like junior DBAs, Developers responsible for a Db2 environment, DevOps team members, and System Administrators.

Planning live sessions

Starting at 13:00 CET on dates:

  • week 16 – 16, 17, 18 April
  • week 17 – 23, 24, 25 April

 

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 June 1st 2024. The same applies for the exercise environment.
Extra Q&A are scheduled for Fridays 19, 26 April and 3, 10 May from 17:00-18:00 CET (11-12 am EST).

Pricing:

Euro-zone: € 2495 (ex. VAT)

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

USA: $ 2695 (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 DBA Basics Workshop Content:

Unit 1: The DB2 environment

  • DB2 fundamentals
  • DB2 Platforms and versions
  • Accessing DB2 – different clients
  • Using the command line processor
  • Other (GUI) tools

Unit 2: Instances, databases and applications

  • Instance and Databases
  • Config(s) and Registry
  • Applications (list and terminate)

Unit 3: Storages Groups and Tablespaces

  • Storage groups and file systems / mounts
  • Tablespaces / Containers / Pages
  • Design considerations
  • Create tablespaces command
  • Tablespace status

Unit 4: Creating database tables, views and indexes

  • DB2 Catalog
  • Columns / Datatypes
  • NULL
  • Primary and Foreign Key Constraint
  • Other Constraints
  • Views
  • Indexes / Clustering
  • Object hierarchy / Cascading drops
  • Using DB2Look

Unit 5: Moving data in and out

  • Import / Export
  • Load utility
  • Load phases
  • Discarded data
  • Online Load
  • Backup
  • Set integrity
  • DB2MOVE

 Unit 6: Logging

  • What is logged and why
  • Crash recovery
  • Circular logging / Secondary logs / Log sizes
  • Archival logging
  • Switching from Circular to Archival logging
  • Archive process / Forcing log archive

Unit 7: Backup and Recovery

  • What is a backup
  • Online vs Offline backup
  • Types of backup
  • Backup naming / destinations
  • Restore
  • Rollforward
  • Recover command
  • Introduction HADR

Unit 8: Reorganizing data

  • Why data must be reorganized
  • REORGCHK
  • Online vs Offline reorg
  • Monitoring REORG

Unit 9: Locking and Concurrency

  • What can / will be locked and why
  • Timeouts
  • Isolation levels
  • Lock Escalation
  • Deadlocks

Unit 10: Security basics

  • Authentication vs Authorization
  • SYSADM / SECADM / DBADM
  • Privileges
  • Roles
  • GRANT / REVOKE

Unit 11: RUNSTATS / Optimizer

  • Optimizing SQL / Package Cache
  • RUNSTATS
  • Using Explain

Unit 12: Problem determination

  • DB2DIAG
  • DB2PD
  • Using MON_GET

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!