IDUG DB2 Tech Conference in Sydney, Australia 2014
Sydney, Australia
10 - 12 September, 2014

Complimentary Workshops and Certification Preparation Courses
IDUG is pleased to offer this Complimentary Workshop 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, after sitting a certification exam on September 11, 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) - Susan Lawson [YLA]
When: Tuesday Sept 9th, 2014 - 09:30 - 17:00
Where: Room 1.17
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.
Susan Lawson is an internationally recognized consultant and lecturer with a background in system and database administration. She currently works with several large clients to help develop, implement and tune some of the worlds’ largest and most complex DB2 databases and applications. She also performs Performance and Availability Audits for many clients to help reduce costs through proper performance tuning and to help ensure availability. Her other activities include authoring articles and white papers, presenting at user group meetings, and teaching a variety of DB2 courses. She is an IBM GOLD Consultant for DB2 and z/Series, and an IBM Information Champion and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’ and the IBM ‘DB2 for z/OS V7 Application Programming Certification Guide’. She is also the co-author of several DB2 books including the IBM ‘DB2 10 for z/OS DBA Certification Guide’, IBM ‘DB2 9 for z/OS DBA Certification Guide’, ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’. She is also a SME(Subject Matter Expert) for the IBM Certification exams for DB2 z/OS Database and System Administration assisting with writing and verifying questions for the exams.

Pre-Certification Workshop for DB2 10.1 DBA for LUW (exam 611) and DB2 10.5 DBA for LUW Upgrade (exam 311) - Robert Clow [Datasync]
When: Tuesday Sept 9th, 2014 - 09:30 - 17:00
Where: Room 1.16
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
Robert is a senior consultant and instructor on Information Management technology with over 25 years experience in IT. Robert has been involved in the implementation and operation of many sites in Australia and New Zealand in a variety of roles from product pre-sales, management, architecture and performance tuning. As an instructor Robert has extensive experience in teaching all areas of DB2 and SQL.
Register Now!


COMPLEMENTARY: IBM DB2 10/11 for z/OS System Performance and Monitoring Workshop
When: Tuesday Sept 9th, 2014 - 09:30-17:00
Where: Room 1.15
Price: FREE
Take advantage of a complimentary workshop with IBM.  This half day seminar will focus on the key areas of system performance - dataset activity, buffer pool and GBP, lock/latch contention, system address space CPU, EDM pool, RID pool, DBM1 virtual and real storage etc. Information will be provided on key performance indicators to be monitored and the rules of thumb to be applied in each area. Information will be provided on what more detailed tracing and analysis is required. Tuning advice will be provided for common problems.
What can you expect:
  • Introduce and discuss the key areas of system performance: system address space CPU, EDM pools, dataset activity, logging, lock/latch contention, DBM1 virtual and real storage, buffer pool and GBP, DIST (DDF) activity etc.
  • Understand the key performance indicators to be monitored
  • Provide rules-of-thumb to be applied
  • Understand how to investigate with more detailed tracing and analysis
  • Provide tuning advice for common problems
You will leave with:
  • Presentation materials
  • Networking and Contacts
Target Audience: Database Administrators, System Programmers and IT 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.
Register Now!


COMPLEMENTARY: IBM DB2 Analytics Accelerator - Hands on Workshop
When: Tuesday Sept 9th, 2014 - 13:30-17:00
Where: Room 1.14
Price: FREE
With the speed of business today, and the need to make fast, fact-based decisions, organizations are no longer willing to wait on information from long-running queries. The new IBM DB2 Analytics Accelerator can sift through the massive amounts of data generated today, extract information and transform it into knowledge quickly, while the information is still relevant and actionable.

The DB2 Analytics Accelerator is a workload-optimized appliance that enables companies to create insights from queries that would previously take hours, but now run in seconds to minutes without the cumbersome and expensive process of adding indexes or query performance tuning. There is no rewriting of applications or new database designs - the appliance simply attaches to DB2 for z/OS providing an operational deployment in days that can improve query response times up to 2000x.
Take advantage of a complimentary workshop with IBM.  This half day workshop is a technical, hands-on workshop geared towards Database Administrators, System Administrators, and anyone who is interested in getting hands-on experience with the IBM DB2 Analytics Accelerator. You will leave this Proof of Technology with an end to end technical foundation in IDAA
What can you expect:
  • Enabling the Accelerator
  • Loading Data to the Accelerator and Accelerating Queries
  • Incremental Update of Data in the Accelerator
  • High Performance Storage Saver
  • Administering a DB2 Analytics Accelerator with Data Studio
  • Installation Overview
  • Performance Analysis
You will leave with:
  • Presentation materials
  • Practical Experience of running a Proof of Technology for the DB2 Analytics Accelerator.
  • Networking and Contacts
Target Audience: Database Administrators, System Programmers and IT Architects
Presenters: Shantan Kethireddy & Neale Armstrong