Workshops Sunday, 1 October

DB2 12 for z/OS - Migration Planning & Technology Workshop

Cuneyt Goksu, Tom Crocker, Michael Dewert; IBM

When:Sunday, Oct 1st, 2017 9:15AM to 17:00PM
Where: Vitis I
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS
IF YOU HAVE ANY SPECIAL DIET REQUIREMENTS PLEASE EMAIL SUREKHA@UK.IBM.COM

Abstract :

DB2 12 for z/OS Migration Planning & Technology Workshop focuses on how you can quickly upgrade to DB2 Migration and exploit New Features related with System, zHW, Application Development safely and securely .

Objectives :

Technical Overview of DB2 12 for z/OS which will cover performance enhancements for traditional workloads, performance enhancements for modern workloads, application enablement enhancements, reliability, availability, scalability and security

  • Explanation of how you can exploit new features and functions quickly to save time and money
  • Explanation of DB2 12 migration process,

The speakers will provide hints and tips, address some myths, provide additional planning information, and provide usage guidelines and positioning on new enhancements. The main objective is to help customers migrate as fast as possible, but safely and encourage version to version migration.

Speaker Bio :

Cuneyt is zAnalytics Technical Leader in MEA, focusing on DB2 for z/OS and zAnalytics Solutions. He is a L2 Certified IT Specialist, specialized in DB2 for z/OS, DB2 Tools, Data Governance, Data Migration and Cognitive Solutions in System z. Cuneyt worked as DB2 DBA, DB2 System Programmer, DB2 Gold Consultant and IBM Business Partner for 20 years. He provides a wealth of experience to customers, IBM’ers and Business Partners in defining, developing and using z Systems based applications and solutions. He served in International DB2 Users Group for 10 years as EMEA Conference Team Member, BOD Member and a passionate speaker about DB2 and Information Management in International Conferences such as IDUG and IBM Insight. He has been writing several papers, articles on DB2 and Analytics, contributes regularly at customer events, workshops, publications. Cuneyt holds a Computer Science Degree, MBA and MS in Database Systems from IIT, Chicago, USA

Tom is a Senior IT Specialist who has recently joined the IBM BetaWorks organisation, specialising in DB2 for z/OS and its associated tooling, and has recently completed running the DB2 12 Early Support Program. Before joining Tom worked in IBM Software Group in the UK, specialising in DB2 Engine, DB2 Tooling and Business Analytics. Tom has over 25 years experience in Data Management and has worked for IBM for the last 16 years , firstly as a DB2 DBA supporting SAP on System Z and for the last 14 years in Technical Pre-Sales. Before joining IBM, he worked as an independent consultant and has experience in the insurance, banking and retail industries, where he held a variety of roles including COBOL DL/1 programmer, IMS DBA, Technical Programmer and DB2 DBA. He has authored several Redbooks covering DB2 Administration and tooling.

Michael is a IBM senior DB2 Consulting Specialist based in Germany, working for IBM DB2 z/OS development (Silicon Valley Laboratory). He has over 25 years of experience working with DB2 z/OS. Before joining IBM in 2001, he worked for large banking IT providers in Germany. He is experienced in DB2, IMS and z/OS system programming, client/server, parallel sysplex, DB2 data sharing implementations aiming for high availability and performance. He is also a co-author of IBM DB2 Redbooks. Currently he works as a member of the DB2 z/OS Development SWAT team supporting customers across various industries and geographies.

Register

Pre-certification DB2 11.1 DBA for Linux, UNIX, and Windows Database Administration Upgrade Certification Exam (Exam 600)

Guy Przytula; Infocura

When:Sunday,  Oct 1st, 2017 9:15AM to 17:00PM
Where: Vitis II
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS
IF YOU HAVE ANY SPECIAL DIET REQUIREMENTS PLEASE EMAIL SUREKHA@UK.IBM.COM


This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DBA V11.1 for Linux, UNIX, and Windows certification exam (Exam 600). The material for this course is aligned with the 600 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 11.1 features. The fundamentals certificate DB2 11.1, test number 616 will also be covered during this class.

Abstract :

This course is designed to describe the major technical features and enhancements provided by the DB2 for Linux, UNIX and Windows database 11.1 software. DB2 LUW 11.1 continues to enhance the BLU Acceleration function that was added in DB2 10.5, including support for massively parallel partitioned database clusters. There are also a number of important enhancements for DB2 pureScale clusters, including additional HADR synchronization options. DB2 11.1 expands on the Native Encryption feature for DB2 databases by supporting a centralized security key manager database.

Please keep in mind that real world experience is required to stand a reasonable chance of passing the certification test. Courseware does not replace the requirement for experience.
Link to the test http://www-03.ibm.com/certify/tests/ovrC2090-600.shtml

Objectives :

After the course, the attendee will have better:

  • Knowledge: The attendees will have in depth technical knowledge of the sections of the exam.
  • Comprehension: The attendees will obtain the necessary skills to pass the certification exam.
  • Application skills: During paper labs and questions from the teacher, the students will be challenged to understand the technical details of the sections.

Course content :

The outline is as follows:
Introduction on Exam Preparation.

  • Section 1 - Database design
  • Section 2 - Data Partitioning and Clustering
  • Section 3 - High Availability and Diagnostics
  • Section 4 - Performance and Scalability
  • Section 5 - Advanced concepts

Speaker Bio :

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

Pre-Certification Workshop for IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals (Exam 610 & Exam 312)

Kurt Struyf; Sudasoft

When:Sunday,  Oct 1st, 2017 9:15AM to 17:00PM
Where: Morus I
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS
IF YOU HAVE ANY SPECIAL DIET REQUIREMENTS PLEASE EMAIL SUREKHA@UK.IBM.COM

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.

Register

Workshops Thursday, 5 October

IBM DB2 Analytics Accelerator Architecture Workshop

Ute Baumbach, Peter Bendel; IBM

When:Thursday,  Oct 5th, 2017 14:00PM to 18:00PM
Where: Creativity
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 has been enhanced even further with new features for hybrid transactional analytical processing (HTAP). By integrating the IBM DB2 Analytics Accelerator, users can run complex queries and transformations in DB2 for z/OS and get sub-second response times, without affecting the production workload.
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 in 2016 and 2017
  • Obtain latest news from IBM DB2 Analytics Accelerator development
  • Customer experiences of latest enhancements
  • Understand use cases and technical details hybrid transactional analytical processing (HTAP) with an accelerator - zero latency at zero cost
  • Support for DB2 side schema changes
  • Federation

You will leave with:

  • Presentation materials
  • Networking and Contacts

Target Audience: Business / LOB Titles Marketing Analyst, Application Architect

Speaker Bio :

Peter is the lead architect for DB2 Analytics Accelerator for z/OS in the Boeblingen IBM development lab, Germany. Peter has spoken several times at IDUG as a presenter and panelist and has given several workshops at IDUG on IDAA.

Ute works as a member of the Analytics on IBM z Systems™ Center of Excellence team, part of the
DB2 Analytics Accelerator development organization, focusing on DB2
Analytics Accelerator proofs-of-concepts, customer deployment support, and education.
She has co-authored various IBM Redbook publications, focusing on DB2 LUW performance
management and DB2 Analytics Accelerator topics.

Register

DB2 LUW Problem Determination and Troubleshooting Workshop

Pavel Sustr; IBM

When:Thursday,  Oct 5th, 2017 14:00PM to 18:00PM
Where: TBA
Price: FREE

The popular troubleshooting seminar, updated with the newest DB2 11.1 problem determination techniques and LIVE DEMOS! Learn how to identify and resolve database hangs, crashes, performance problems, and data corruption issues. Get familiar with diagnostic tools. Learn how and when to use these troubleshooting tools for a quick problem resolution. Topics covered: Performance; FODC; Hangs; Latching; Crashes/Traps; Data Corruption. Attendees will be able to characterize a problem in order to expedite resolution, learn how and what data to collect during intermittent hangs, slowdowns, and other frequent problems, and understand DB2 Support’s methodology in troubleshooting DB2 and even non-DB2 hiccups. The seminar contains live demos during which the audience will be given an opportunity to perform an interactive investigation of selected problems.

You will leave with:

  • Presentation materials
  • Networking and Contacts

Target Audience: DBA, Application Architects

Speaker Bio :

Pavel is a Senior Manager and Senior Software Engineer with IBM DB2 LUW development, responsible for multiple core DB2 kernel components. Always thrilled to work on hard to crack puzzles. Expertise in DB2 LUW kernel architecture, configuration and administration, advanced problem determination, memory architecture, memory leak troubleshooting, and assembly language. Hands-on development experience with buffer pool management, storage, prefetching, page cleaning, transaction logging, recovery, monitoring, and problem determination. As a member of the DB2 team, Pavel spent years in DB2 L2/L3 advanced support (over 1,500 resolved cases), then transitioned to DB2 LUW kernel development. In his past life Pavel was an application developer mostly using C++, SQL, .NET, Oracle, MS-SQL, and Informix on Windows, Linux, Solaris, and HP-UX.

Register

Leverage relational and unstructured data into your JavaScript, JSON and Node.js Applications!

Michael Connor; IBM

When:Thursday,  Oct 5th, 2017 14:00PM to 18:00PM
Where: TBA
Price: FREE

While there has been considerable growth in data types and sources, relational data remains highly relevant because it codifies corporate knowledge and transactions.

Applications drive database delivery. So as an application developer or data scientist, you need database tools that help you make it fast and simple to complete applications. Db2 has broad capabilities to support mobile and web-based applications built on JavaScript, JSON, Node.js, C# and .Net; as well as analytics that use Python and R

Without the right technologies, you can end up managing multiple databases for relational and unstructured data. The new Db2 Developer-C edition stores structured and JSON data in a single database, helping to make your life simple.

Come with your laptop to explore using DB2 Developer-C edition along with new developer oriented tooling in Data Server Manager. We’ll walk you through a detailed set of demonstrations. You'll work with Node.js and JavaScript accessing relational and JSON data as a start. Then learn how to build a virtual warehouse "federation style" without moving data around. Finally you'll see access methods like ODATA, and analytic languages in action. Learn the technology, try it out, and then apply it to your own applications.

Target Audience: Application Developers

Speaker Bio :

The past 3 years, Michael has managed the Core Db2 Tools offerings focusing on Administration, Monitoring, Development, Modeling and Connectivity — ultimately speeding the database lifecycle and supporting DBA, Data Analyst and Developer roles. Michael has been at IBM 17 years with service stints in WebSphere, Rational and System z brands before moving to Analytics.

Register