Complimentary Workshops and Certification Preparation Courses
IDUG is pleased to offer these Complimentary Workshops and Certification Preparation Courses for FREE. By attending any of these you 'll make sure to be well prepared to take a certificate back home and squeeze the most educational value out of your conference.

Pre-Certification for DB2 10 for z/OS fundamentals & DBA certification exam (Exam 610 & Exam 612) - Kurt Struyf [Suadasoft]
When: Sunday Oct 13th, 2013 - Full day
Price: FREE
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.
This training is a preparation for candidates looking to take the certifications exams “ DB2 10 family fundamentals exam” (610) and “DB2 10 for z/OS Database Administration exam” (612). The class has been designed to optimally prepare the students. It is a lecture only class, overviewing DB2 concepts that are important within the 610 & 612 exam objectives. Participants are expected to have basic knowledge of relational principles, but preferably have a good understanding of DB2. This 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 & 612 exams.
The outline is as follows:
  • Section 1 – DB2 10 Fundamentals
  • Section 2 – DB2 10 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 10 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.


Pre-Certification for DB2 10.1 for Linux, UNIX, and Windows Advanced Database Administration certification exam (Exam 614) - Guy Przytula [Infocura]
When: Sunday Oct 13th, 2013 - Full day
Price: FREE
Guy has more than 30 years experience with DB2. He worked for IBM as hardware engineer and later in the software support center and software services department. He is a leading expert on DB2 for VM/VSE (SQL/DS) and DB2 for LUW, with which he started when it was still called common server. He teaches many courses related to DB2 LUW and Infosphere Information Server. The past decade he also worked with Oracle, SQL/server and DB2 on z/Linux.
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 UDB V10.1 for Linux, UNIX, and Windows Advanced Database Administration certification exam (Exam 614). The material for this course is aligned with the 614 exam objectives. This session offers an intense, overall review of those areas that will be on the certification exams and is a lecture-only class with no labs. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 10.1 features.
The following areas will be covered:
  • Introduction on Exam Preparation.
  • Part 1: Database Design
Design, create and manage database storage paths. Design, create and manage table spaces and buffer pools. Design and configure a database for multi-temperature data and ability to use Data Studio to manage database environments
  • Part 2: Data partitioning and Clustering
Design, create, and manage database partitioning (DPF) and multi-dimensional clustered tables. Design, create, and manage range portioning, insert time clustering tables and range clustering tables.
  • Part 3: High Availability and Diagnostics.
Manage database logs for recovery. Usage of advanced backup features and advanced recovery features. How to use WLM and High Availability Disaster Recovery (HADR). Determine the appropriate diagnostic tool to use for a given scenario.
  • Part 4: Performance and Scalability
Knowledge of query optimizer concepts and ability to manage and tune database, instance and application memory and I/O. Ability to use compression, exploit parallelism and determine the appropriate index for a given scenario. Given a scenario, resolve performance problems. •
  • Part 5: Advanced Concepts
Knowledge of how/when to create a federated database environment and the DB2 Audit facility. Knowledge of replication and PureScale.


COMPLIMENTARY: Recommended Best Practices from Customer DB2 Health Check Studies - John Campbell [IBM] & Florence Dubois [IBM]
When: Sunday Oct 13th, 2013 - Full day
Price: FREE
This complementary workshop will introduce and discuss the major lessons to be learned from customer DB2 Health Check Studies carried out by DB2 for z/OS Development and provide recommended best practices in each area..
The objectives are to: introduce and discuss the most common issues, share the experience gained from customer health check studies, share the experience from live customer production incidents, provide proven recommended best practice, and to encourage proactive behavior..
The following topics will be covered:
  • WLM Policy Setup
  • Balanced Design across CICS and DB2
  • Disaster Recovery
  • use of Flashcopy
  • Continuous Availability vs. Fast Failover
  • Preventative Software Maintenance
  • Multiple Data Sharing Groups
  • Running Multiple DB2 Subsystems on same LPAR
  • Normal DB2 Warm Restart vs. Restart Light
  • Storage Tuning.
Target Audience: DBA's, database developers and data architects
Presenters: John Campbell & Florence Dubois
John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.
Florence is an IBM Certified Consulting IT Specialist and a member of the DB2 for z/OS Development SWAT team. In this role, she consults for worldwide customers on a variety of technical topics, including implementation and migration, design for high performance and availability, performance and tuning, system health checks, disaster recovery. Florence presents regularly at conferences and has co-authored several IBM Redbooks publications.

COMPLIMENTARY: Data Warehousing with DB2 for z/OS: IBM DB2 Analytics Accelerator Deep Dive Workshop - Patric Becker [IBM] & Peter Bendel [IBM]
When: Thursday Oct 17th, 2013 - 2:15 PM - 6:15 PM
Price: FREE
Take advantage of a complimentary architecture workshop with IBM - to help you understand how this game-changing technology can be used in DB2 for z/OS Data Warehousing and BI environments. Conducted at IDUG NA 2013 Conference, the DB2 Analytics Accelerator Architecture Workshop is a half-day, interactive session that will help you understand this new technology and how this can help you in improving your cost and performance of your DB2 for z/OS based Data Warehouse and related analytical business processes.
What you can expect?
  • Technical deep dive into IBM DB2 Analytics Accelerator
  • Demonstration of data life cycles with IBM DB2 Analytics Accelerator
  • Data maintenance options (load, incremental update)
  • Example performance numbers for query acceleration, load and CPU savings
  • System prerequisites of IBM DB2 Analytics AcceleratorCustomer experiences
You will leave with:
  • Presentation materials
  • Networking and Contacts
Target Audience: Business / LOB Titles Marketing Analyst, Application Architect
Presenters: Patric Becker & Peter Bendel
Patric Becker is a Software Architect in the Data Warehousing on System z Center of Excellence at IBM Boeblingen Lab. The team has specialized in IBM DB2 Analytics Accelerator and conducts Proof of Concepts for large and complex DWH installations. He has over 15 years experience with DB2 for z/OS. Before joining IBM, Patric worked for one of the largest DB2 for z/OS customers in Europe. He has been responsible for developing several high availability DB2 and IMS™ applications and is co-author of five IBM Redbook publications focusing on DB2 for z/OS.
Peter Bendel is a Senior developer for DB2 Analytics Accelerator.

COMPLIMENTARY: DB2 10.5 for LUW Immersion Workshop - with new BLU Acceleration - Danny Arnold [IBM]
When: Thursday Oct 17th, 2013 - 2:15 PM - 6:15 PM
Price: FREE
In today's competitive data-driven world, more knowledge and more professional flexibility is an advantage. This workshop is a no-charge offering that can help extend your technical skills to include the latest features and capabilities in DB2 10.5 for LUW with BLU Acceleration. These server platforms are common to data centers across the globe, and often, DB2 for LUW is used as part of an IBM Big Data solution.
This DB2 Fundamentals workshop is designed for database administrators, data application developers and data architects to provide an introduction to the latest DB2 for LUW technology--including the latest features and enhancements. Taught by IBM DB2 technical experts, the workshop provides attendees with in-depth explanation of new features including: even deeper compression, Multi-temperature Data Management, Temporal Data Management, enhanced workload management, data security advances and more.
What you can expect?
  • DB2 10.5 Overview
  • DB2 BLU Acceleration Deep Dive
  • What's New in 10.5 for High Availability and pureScale
  • New Oracle Migration and Compatibility Features
  • Storage Management and Compression Details
Target Audience: DBA's, database developers and data architects
Presenter: Danny Arnold
Danny Arnold is an Executive IT Specialist on the Worldwide Technical Sales and Competitive Technologies team within IBM Information Management. He has been working with DB2 for Linux, UNIX, and Windows since joining IBM in 1995. His roles within IBM have included database consulting within IBM Global Services and DB2 Lab Services, subject matter expert within Advanced Technical Support for DB2 for LUW, and an executive IT specialist within competitive database technologies. Danny has over 30 years of experience working with relational database technology including lead DBA responsibilities for large scale production environments while working at other companies prior to joining IBM. In his present role, Danny works with the IBM technical community and customers to assist them in furthering their understanding of DB2 database technology, and how this technology delivers business value.