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 Workshop for IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals (Exam 610 & Exam 312) - Kurt Struyf [Suadasoft]
When: Sunday Nov 9th, 2014 - Full day
Where: Room Virgo
Price: FREE
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 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. 

Pre-Certification Workshop for DB2 10.1 DBA for LUW (exam 611) and DB2 10.5 DBA for LUW Upgrade (exam 311) - Guy Przytula [Infocura]
When: Sunday Nov 9th, 2014 - Full day
Where: Room Taurus
Price: FREE
This workshop is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DBA Verision 10.1 for Linux, UNIX, and Windows certification exam (Exam 611). The material for this course is aligned with the 611 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 upgrade certificate to DB2 10.5, test number 311 will also be covered during this class. 
The following areas will be covered:
  • Introduction on Exam Preparation.
  • Part 1: Database Design
  • Part 2: Data partitioning and Clustering
  • Part 3: High Availability and Diagnostics.
  • Part 4: Performance and Scalability
  • Part 5: Advanced Concepts
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.
Register Now!

COMPLIMENTARY: DB2 11 Migration Planning Workshop
When: Sunday Nov 9th, 2014 - 9:30-16:30
Where: Room Leo
Price: FREE
DB2 10 set the stage to “give back”. DB2 11 does this again with more out of the box performance improvements, greater migration flexibility, many optimization's, administration, and application features.
  • Versioning of information expands beyond temporal management into archiving of data.
  • Online schema evolution continues to provide more ways to enhance database designs while maintaining information availability.
  • The DB2 11 optimizer provides insights into the statistics it needs to make the best decisions.
  • The DPSI is back with enhanced optimization and parallelism.
  • The Native SQL Procedures Language keeps getting better. Have you been looking for an array? Look at DB2 11.
  • DB2 for z/OS SQL, aided by industry leading optimization, continues to push transactional performance and expands native analytical capability with new Group By options and integration with Big Data via Hadoop.
  • Distributed communications are a blast. Literally. Learn about this new communication protocol.
  • Do you use external security? It now communicates with DB2.
  • DB2 11 provides flexible paths to expand RBA / LRSNs, assisting Data Sharing high volume insert processing and eliminating logging restrictions.

What is the Migration Planning Workshop (MPW)?

  • One-day, comprehensive review of the capabilities, considerations, preparations, and project planning for DB2 11.
  • This offering enables customers to understand the breadth of features delivered in DB2 for z/OS versions.
  • The enhanced migration process is explained.
  • Leave the session with materials that you can use to start your installation / migration immediately, or in the future.
For more information download the DB2 11 Migration Planning Workshop trifold.
Presenters: Bart Steegmans & Dirk Coomans

Register Now!


COMPLIMENTARY: IBM DB2 Analytics Accelerator Architecture Workshop
When: Thursday Nov 13th, 2014 - 14:00-17:00
Where: Room Taurus
Price: FREE
Take advantage of a complimentary architecture workshop with IBM - to help you understand how this game-changing technology enables DB2 for z/OS to now truly support analytics. By integrating the IBM DB2 Analytics Accelerator, users can run complex queries against DB2 for z/OS and get sub-second response times, without affecting the production workload. Conducted at IDUG NA 2013 and IDUG EU 2013 conferences, the DB2 Analytics Accelerator Architecture Workshop is a half-day, interactive session that will help you understand this new technology up to the latest available version and how this can help you in improving your performance and cost of your DB2 for z/OS based Data Warehouse and related analytical business processes. This workshop is for everybody who wants to get up to speed with the latest version of IBM DB2 Analytics Accelerator and understand the technical processes that happen 'under the covers'.
What can you expect:
  • Technical deep dive into the latest version and enhancements of IBM DB2 Analytics Accelerator
  • Obtain latest news from IBM DB2 Analytics Accelerator development
  • Customer experiences for latest enhancements
  • Demonstration of data life cycles with IBM DB2 Analytics Accelerator
  • Data maintenance options (loading strategies, incremental update)
  • Example performance numbers for query acceleration, load and CPU savings
  • System prerequisites of IBM DB2 Analytics Accelerator customer 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.
Register Now!

COMPLIMENTARY: DB2 BLU Acceleration for the Cloud
When: Thursday Nov 13th, 2014 - 14:00-17:00
Where: Room Leo
Price: FREE
Need to get started using DB2 quickly and at a low cost? Need BI and Data warehousing in-memory computing fast? Attend this technical workshop where you will learn about the exciting new enhancements with DB2 BLU, how they relate to Cloud implementations and how they can provide data insights to your organization fast and easily.
DB2 on the Cloud is available in several pre-installed, pre-configured editions of DB2 to support needs that range from a small workgroup to advanced enterprise data applications. These environments can meet a variety of needs including development, test, online transaction processing and more.
BLU Acceleration for Cloud, recently released as a public technology preview, is designed to provide self-service BI or data warehousing in a simple agile cloud-based in-memory computing solution. It includes an option to use BLU Acceleration with Cognos BI so that you can get insights from your data very quickly and affordably.

Presenter: Michael Wurst

Register Now!