This training is moved to first quarter of 2021

Online Db2 LUW DBA Basics Workshop

In this ten-day Db2 DBA Workshop you will learn all the basic DB2 DBA skills like creating tablespaces and tables, how to use import, export, load, reorg, runstats and much more. The focus will be on the practical use of DB2 as needed in day to day activities. Every day you will do one unit (approx. 2-3 hours) in a live session on Microsoft Teams. Your trainer is Klaas Brant and the language is English. Each unit has one or more exercises in which you can practice the theory you just learned. You will get SSH access to one of our Linux Db2 environments. Linux skills are not needed, all commands needed are in the excises. The Db2 commands you use apply other platforms like Windows or AIX. You will need a SSH client on your PC (more details in the confirmation).

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

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, Tablespaces and Tables

  • Storage groups and file systems / mounts
  • Tablespaces / Containers / Pages
  • Design considerations
  • Create tablespaces command
  • Tablespace status
  • DB2 Catalog
  • Tables: Columns / Datatypes
  • Nullable columns

Unit 4: More about tables and other objects

  • Primary and Foreign Key Constraint
  • Other Constraints
  • Using Compression
  • Views
  • Indexes / Clustering
  • Object hierarchy / Cascading drops
  • Using DB2Look

Unit 5: Moving data in and out

  • Import / Export
  • Load utility
  • Ingest
  • 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
  • Brief introduction to HADR

Unit 8: Using REORG and RUNSTATS

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

Unit 9: Locking / Concurrency and Security

  • What can be locked and why
  • Timeouts
  • Isolation levels
  • Lock Escalation
  • Deadlocks
  • Authentication vs Authorization
  • SYSADM / SECADM / DBADM
  • Privileges
  • Roles
  • GRANT / REVOKE

Unit 10: Optimizer and Problem Determination

  • Optimizing SQL / Package Cache
  • Using Explain
  • DB2DIAG
  • DB2PD
  • Using MON_GET Queries

Pricing:

Euro-zone: € 1695
USA: $ 1950

Discounts:

3-4 persons you get 10% discount, 5-6 persons you get 20% discount
Bigger groups can be fixed price, please email info@kbce.com

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

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 nor do you 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? A: Send us a message in MS Teams or an email and we will schedule a 1:1 session

Q: What if I miss a live session? A: You can access a recording of the live session on the kbce website. If you have a questions then post them on Teams or send an mail to the trainer.