Pre-Certification Workshop for IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals

(Exam 610 & Exam 312)

Presenter:  Kurt Struyf [Suadasoft] 

When: Sunday Nov 13th, 2016 - 9:30-16:30
Where: Harmony
Price: FREE

Abstract: This workshop is a certification preparation course intended to help you take DB2 10 Family Fundamentals exam (610) and DB2 11 for z/OS Database Administration exam (312). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 11 for z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 10 for z/OS and basic knowledge of DB2 11 features. The class has been designed to optimally prepare the students. It is a lecture only class, his class is NOT a full database administration class, it is a condense one day review, focusing on refreshing and teaching the necessary skills to pass both 610 & 312 exams.

The outline is as follows:

  • Section 1 – DB2 10 Fundamentals
  • Section 2 – DB2 11 Database administration

The first part of the class will sole focus on the skills needed to passing the family fundamentals exam. We will give an overview of the DB2 products, focusing on strengths an differences of the different members of the DB2 family. Beyond that basic DB2 database administration skills are explained. As connectivity is important to understand, time will be spent on providing an overview of the possibilities.
The second part of the class will focus on the specifics of DB2 11 for z/OS and the skills needed on the exam. The overall system architecture is explained, covering, amongst others, knowledge of DB2 catalog and directory and Distributed Data and Subsystem Pools. Furthermore we will cover access control including granting, auditing, trusted context etcetera, as well as explain the locking mechanism.
Evidently a part of the class will focus on the new possibilities with regards to DB2 objects (creating, altering and dropping), new possibilities, maintenance options and SQL (basics and enhancements). Backup and recovery, as well as data sharing, basics and strategies are covered to give an insight and prepare for the certification exam.
Speaker Bio:
Kurt works as a senior consultant for SuadaSoft based in Luxembourg. He has well over fifteen years’ experience as a (system) DBA and have been installing, migrating, troubleshooting and tuning DB2 systems throughout Europe. Besides his consultancy missions he has been teaching a broad spectrum of DB2 classes, both in Europe and the USA. Kurt has been a speaker at several large European and North America conferences, such as IDUG, IOD and at numerous DB2 regional user groups in Europe and is a IBM information Champion since 2010 and as part of the IDUG content committee responsible for DB2 for z/OS content.  


DB2 10.5 for Linux, UNIX, and Windows Database Administration Upgrade Certification Exam (Exam 311) Preparation

Presenter:  Roger Sanders [IBM]

When: Sunday Nov 13th, 2016 - 9:30-16:30
Where: Exploration
Price: FREE

Abstract:  This training is designed to introduce the student to the concepts a test candidate must know to take and pass the DB2 10.5 for Linux, UNIX, and Windows Database Administration certification upgrade exam (Exam 311). The material for this course is aligned with the 311 exam objectives and was created by an individual who helped develop the 311 exam.

Audience experience level: Intermediate
Presentation Category:
Data Management, Disaster Recovery, Implementing New DB2 Releases and Features, Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform:
DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to:
Data Architects, Database Administrators
Technical areas this presentation will apply to:
Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), High Availability (DB2 for LUW), New Release (DB2 for LUW), pureScale, Tools and Utilities
If Tools and Utilities was selected which products:
InfoSphere Optim Tools, ADMIN_MOVE_TABLE(), db2convert, EXPORT, IMPORT, LOAD, INGEST, db2pd
Objective 1:
Understanding DB2 Server Management
Objective 2:
Physical Design
Objective 3:
Monitoring DB2 Activity
Objective 4:
High Availability
Objective 5:
Using Select DB2 Utilities

Speaker Bio: Roger E. Sanders is a DB2 for LUW Offering Manager at IBM. He has been working with DB2 for Linux, UNIX, and Windows since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition) and is the author of 23 books on relational database technology (22 are on DB2 and one is on ODBC). Roger authored the Distributed DBA column in IBM Data Magazine (formerly DB2 Magazine) for 10 years and has written numerous tutorials and articles for IBM's developerWorks website as well as for publications like Certification Magazine and IDUG Solutions Journal (the official magazine of the International DB2 User's Group). He has also helped IBM develop 23 DB2 certification exams. From 2008 to 2015, Roger was recognized as an IBM Champion for his contributions to the IBM Data Management community; in 2012 he was recognized as an IBM developerWorks Master Author, Level 2 (for his contributions to IBM developerWorks).