Title: IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals Certification Workshop
TIME 9:15 - 16:00
There will be an opportunity to take the following exams at IDUG at NO CHARGE
1. EXAM 610 Test C2090-610: DB2 10.1 Fundamentals
2. EXAM 312 Test C2090-312: IBM DB2 11 DBA for z/OS
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.
Kurt Struyf has well over fifteen years’ experience as a (system) DBA and have been installing, migrating, troubleshooting and tuning DB2 systems throughout Europe.