Educational Seminars
Sunday, June 2
9:00 AM - 5:00 PM

IDUG is pleased to offer pre-conference Educational Seminars in addition to our regular sessions. Educational Seminars will take place before the conference kicks off on Sunday, June 2. The cost of each seminar is $250, which is not included in your registration fee.

To register for any of these courses, please select your choice as an add-on when you register for the conference. If you've already registered, you may log back into your registration and click "Add Additional Options."

  • Db2 11 for z/OS DBA Certification & Db2 12 DBA for z/OS 2018 Proficiency Badge Crammer
    Susan Lawson, YL&A

    This course is a certification preparation course intended to help you take the Db2 11 Fundamentals for z/OS(320), 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 z/OS Database Administration. This course also covers the new Proficiency Badge for Db2 12 DBA for z/OS - 2018. In order to earn the new Db2 12 DBA for z/OS - 2018 Proficiency Badge, three exams must be passed (Delta, Intermediate, and Advanced). This course will cover all topics addressed on these exams.

  • Db2 11.1 DBA for Linux, UNIX and Windows Certification (C2090-600) Crammer Course
    Mohankumar Saraswatipura, Kronsys Inc
    Robert Collins, BNSF Railway Inc

    This certification crammer course is designed for IT professionals who plan to take the IBM Certified Database Administrator–Db2 11.1 for Linux, Unix, and Windows exam C2090-600. In this course, you will learn how to do the following:

    1. Configure and manage Db2 v11.1 servers, instances, and databases

    2. Implement Db2 BLU Acceleration databases

    3. Create and implement database objects

    4. Implement business rules using constraints

    5. Implement high availability and disaster recovery solutions

    6. Monitor and troubleshoot at instance and database levels

    7. Implement security at instance, database, and objects levels

    This certification study course is designed to provide the Db2 professional with the information required to successfully obtain C2090-600 certification. Each chapter contains topics covered in the exam, plus valuable insights into each topic, along with sample exam questions and detailed answers.

  • Db2 12 System Administrator for z/OS Certification Crammer Class
    Judy Nall, CBI

    Exam #C2090-318 is divided into six topic sections; installation and migration, security and auditing, system operation and maintenance, backup and recovery, performance and tuning, and troubleshooting.

    Each of those six sections will be reviewed to help students build or refresh their skill sets for the exam. Examples of topics covered: Db2 and system environment, Db2 subsystem parameters characteristics (DSNZPARM), system tuning techniques using specific traces, Db2 commands, monitoring threads, overview of data sharing in Db2, backup and recovery of Db2, disaster recover considerations, system performance and tuning, buffer pools, workload manager settings, specialty engines in Db2, and troubleshooting scenarios.

  • SQL PL Best Practices - Cross Platform
    Tony Andrews, Themis Inc.

    One of the most anticipated new features of Db2 was the SQL PL stored procedures (especially on z/OS). A key advantage is the ability to work entirely within the IBM Data Studio environment to accomplish Db2 development and deployment. Students will have the ability to log in and code a few stored procedures during this educational seminar. Also leave with some best practices of the language. Topics like XML parameters, array parameters, autonomous processing, piece-wise delete, and others will be talked about. This is for everyone on either Db2 platform.

  • Start Here: Db2 Basics for Developers and Administrators
    Ember Crooks, Xtivia
    Michael Krafick, Sherwin-Williams

    You're at a Db2 conference so obviously you at least know how to spell Db2. Db2 education can be hard to come by. Once you have worked with Db2 for a few years, there is no better place for education than an IDUG Conference. However, IDUG conferences can be overwhelming for someone new to Db2. If you have just started working with Db2, this seminar is the place for you. This session is designed for any technicians who have been working with Db2 for less than two years. In addition to an introduction to Db2, this session serves to fill in the knowledge gaps that are inevitable in a self-taught world.