Db2 LUW DBA Basics Workshop

In this five-day DBA Workshop you will learn all the basic Db2 DBA skills like creating tablespace and tables, how to use import, export, load, reorg, runstats and much more. The focus will be the practical use of Db2 as needed in day to day activities. Every unit has one or more exercises in which the student can practice the theory they just learned. Exercises are based on the effective use of the command line under Linux (Linux skills are not needed) but apply to all platforms. Students need to bring their own Laptop with SSH client (e.g. PUTTY) and be able to configure the SSH client and the Wi-Fi.

This is the perfect course for anybody who need Db2 DBA skills in their day-to-day job like junior DBAs, Developers responsible for the Db2 environment, Devops team members and System Administrators. You will get a basic understanding many components of Db2 LUW.

KBCE DB2 LUW Training Logo

If you never have done a Db2 LUW basics course but are responsible for managing a Db2 environment then this course is for you!

This is a five day Db2 LUW course: 18-22 November 2019

Location: Brussels – La Hulpe — Language: English

THIS COURSE IS GUARANTEED TO RUN

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
  • 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: Reorganizing data

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

Unit 9: Locking and concurrency

  • What can 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 Queries

Trainer for this course – Klaas Brant

Klaas Brant is the founder of KBCE, a company that is known worldwide for the DB2 training both in-house or public training like this course and the DB2 Symposium. Klaas has been busy with DB2 LUW since DB2 version 7. His focus is DBA related and his favorite topics are backup / recovery and performance. Klaas is an IBM DB2 Gold Consultant (a select group of consultants picked by IBM), a life-time IBM Data Champion and a member of the DB2 Customer Advisory Counsel.

Klaas Brant

Pricing

Pricing (5-Days!): € 2495 – Register before 28 October and get 10% discount = € 2245!

Location

Remember the old IBM international education center in la Hulpe / ter Hulpe near Brussels? A very special place in the middle of a big forest. This is where KBCE partner The Mindbridge has it’s office and we are doing our Db2 education. Although the offices were build in the 60’s it is now completely renovated including a world class hotel called Dolce La Hulpe.

Address: Chaussée de Bruxelles 135 A, 1310 La Hulpe, Belgium – free parking

Hotel is not included in the training. You can book your hotel on the website of the hotel or one of hotel booking sites. See here for details.

Warning: the location is NOT easily accessible by public transportation! From the bus stop it is a long walk (1 km) into the forest. We advise you come by car or taxi. Parking is free!

The Mindbridge Office