Workshops Sunday, 4 November

Pre-certification class for Db2 11.1 DBA for Linux, UNIX, and Windows Database Administration Exam (Exam C2090-600)

Guy Przytula

Infocura

When:Sunday, Nov 4, 2018 09:15 to 17:00
Where: Neptune 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 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 C2090-600). The material for this course is aligned with the C2090-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 C2090-616 will also be covered during this class.

Objectives:

  • Introduction to 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

This will be the last opportunity for customers to have chance to take this certification test on IBM sponsored laptops at IDUG! To increase your passing chance for C2090-600/616 participate in this workshop and take the exam!

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

Migration Planning for Db2 12 and Continuous Delivery

Gareth Copplestone-Jones  &  Anthony Ciabattoni

Db2 for z/OS SWAT Team IBM

When:Sunday, Nov 4, 2018 09:15 to 17:00
Where: Venus (8th Floor)
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 & Continuous Delivery Workshop focuses on how you can quickly upgrade to Db2 Migration and Continuous Delivery and take advantage of new functions and 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
  • Take advantage of new function levels that are shipped continuously e.g components like APPLCOMPAT will now become vitally important and operate at the subsystem level, application/package level, as well as the driver level (IBM Data Server Driver)

The presenters 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 exploit new functions there-in, and how to prepare for the march towards continuous delivery.

Places are limited and will be offered on first come basis, this is a MUST ATTEND workshop for any Db2 for z/OS User!

Speaker Bio:

Gareth has many years of Systems Programming and DBA experience on the MVS (OS/390, z/OS) platform, with over 20 years with Db2.
He has worked with many customers around the world to help them succeed in their use of Db2.
In 2007 he joined the EMEA Db2 for z/OS SWAT Team at IBM, funded by Db2 Development, to work on customer critical situations, perform Db2 Health Checks, provide consultancy to Business Partners and customers.
Past presenter at IDUG and Db2 Technical Conferences
Specialties: Systems Programming, Assembler Programming, Rexx Programming, IMS, Db2, DBA, SQL.

Anthony has over 25 years of professional Db2 experience with expertise in high available 24/7 high transaction rate data sharing environments. Strong knowledge base in Db2 data sharing, Db2 system performance as well as high available sytems. Experience in all aspects of Db2, DBA experience, Db2 system experience and experience in architecting a well tuned Db2 environment.  He works for the Db2 for z/OS SWAT Team at IBM , led by John Campbell.
Past presenter at IDUG and Db2 Technical Conferences.
Specialties: Db2 for z/OS Backup & Recovery , High available Db2 Data Sharing Systems , Db2 Performance , Db2 Architect

Register

Introduction to Cognitive Class Data Science

Ivan Didur

CTO of Data Roots Lab

When:Sunday, Nov 4, 2018 09:00 to 17:00
Where: Neptune III
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 is an introduction, where you can learn the fundamentals of data science from data scientists at IBM.

Prerequisite course requirements:

You are either already comfortable programming in Python, or you have successfully completed the following online course Python 101
This free Python course provides a beginner-friendly introduction to Python. Practice through lab exercises, and you'll be ready to start data analysis in the bootcamp!

Agenda (Data Science)

  • Introduction to Data Science (09:00-11:00)
    • Cognitive Class Data Science course
    • Training environment
    • Online courses
  • Introduction to Machine Learning (11:00-12:00)
  • Break (12:00-13:00)
  • Introduction to Machine Learning (13:00-14:00)
  • Introduction to AI (14:00-16:00)
  • Introduction to IBM’s Cloud Financial Services (or Hands-on exercise session)
    – optional (laptop & internet connection required)

Places are limited and will be offered on first come basis!

Speaker Bio:

Alex Aklson, Ph.D., is a data scientist in the Digital Business Group at IBM Canada.

Alex has been intensively involved in many exciting data science projects such as designing a smart system that could detect the onset of dementia in older adults using longitudinal trajectories of walking speed and home activity. Before joining IBM, Alex worked as a data scientist at Datascope Analytics, a data science consulting firm in Chicago, IL, where he designed solutions and products using a human-centred, data-driven approach.

Register

Hands on creating and integrating Developer Services for your organization!

Patrick Bossman
Db2 z DevOps and Cloud Provisioning lead architect
Saghi Amirsoleymani
Director - World Wide Analytics, Rocket Software

When:Sunday, Nov 4, 2018 09:00 to 11:00
Where: Neptune IV
Price: FREE

Requirements: Participants need to bring their own laptop! And don't forget your power cord and an UK-Adaptor for the Maltese power sockets. ;-)

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:

Application Architects, Administrators and Release Engineers - get up to speed on how to turbo boost your developer productivity and expand the developer pool willing and able to create applications using Db2 z!

Objectives:

Attendees will get hands on experience implementing database as a service. In the administrator role, attendees will configure developer self-services to permit developers to provision/deprovision application environments. This configuration will include defining the target environment naming conventions, environment parameters, and provisioning limits such as number of instances. Attendees will learn how developers will be able to self-service provision a schema and perform changes in their sandbox environments. Administrators and developers will learn how application change deployments can be automated through the rest of the environments.

Speaker Bio:

Patrick's current role is lead architect for DevOps and Cloud Provisioning for Db2 for z/OS. Patrick's primary objective is helping Db2 z customers to improve their development organization efficiency by enabling developer self-services and extending continuous integration / continuous delivery practices to mainframe applications using Db2 z. In addition, Patrick spends a lot of time listening to developers new to System z to identify what sorts of interfaces are most critical to enabling those developers to be more productive and develop software with better quality using Db2 for z/OS.

Saghi is a WW Director at Rocket Software, where she evangelizes solutions for customers and partners on IBM technologies. Prior to joining this team, Saghi was part of the IBM DB2 z/OS technical support team and worked onsite premier support for almost 20 years. She began her career at IBM as an intern while earning her degree at the University of Southern California, and therefore is a diehard Trojans fan. Although she’s a SF Bay Area native,
raised in Mountain View, Saghi has earned her nickname from friends and colleagues as Ms. Worldwide. She travels throughout the world presenting on various topics related to Data Studio, Data Server Manager, Analytics and Performance at conferences, users groups, webcasts and events.

Register

Workshops Thursday, 8 November

IBM Db2 Analytics Accelerator Architecture Workshop

Eberhard Hechler & Ute Baumbach

Db2 for z/OS Team IBM

When: Thursday, Nov 8, 2018 14:00 to 17:00
Where: Neptune I/II
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS

Abstract:

Take advantage of a complimentary architecture workshop with IBM – to help you better understand how this game-changing technology enables analytics on Db2 for z/OS. The accelerator is continuously enhanced 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 2017 and 2018
  • Obtain latest news from IBM DB2 Analytics Accelerator development
  • Customer experiences of latest enhancements
  • Understand use cases and technical details
  • Deployment on Z
  • Migration considerations

You will leave with:

  • Presentation materials
  • Networking and Contacts

Speaker Bio:

Eberhard is an Executive Architect from the IBM Germany R&D Lab. He is a member of DB2 Analytics Accelerator development. After 2.5 years at the IBM Kingston Lab in New York, he worked in SW development, performance optimization, IT/solution architecture & design, Hadoop and Spark integration and MDM.

He began to work with DB2 for MVS, focusing on testing and performance measurements. He has worked worldwide with IBM clients from various industries on a vast number of topics, such as DWH and BI solutions, information architectures, and industry solutions.

From 2011-2014, he was at IBM Singapore, working as the Lead Big Data Architect in the Communications Sector of IBM’s Software Group.

He is a member of the IBM Academy of Technology Leadership Team, and co-authored the following books:

  • Enterprise MDM, Pearson, 2008, ISBN: 0132366258
  • The Art of Enterprise Information Architecture, Pearson, 2010, ISBN: 0137035713
  • Beyond Big Data, Pearson, 2014, ISBN: 013350980X

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

Developing RESTful apps for Db2 on Cloud

George Baklarz

Digital Technical Engagement Team

When: Thursday, Nov 8, 2018 14:00 to 17:00
Where: Neptune IV
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS

Abstract:

In addition to the traditional access methods available for use with Db2 on Cloud (JDBC, CLI, ODBC), Db2 on Cloud also allows the use of RESTful calls to access data from the database. The advantage of using RESTful calls is that the client does not require any Db2 libraries or drivers – only the RESTful API library is required.

Objectives:

This workshop will take you through the steps of registering for a Db2 on Cloud service, setting up connection credentials, and then using a pre-configured system to access Db2 on Cloud using RESTful calls – without having to use any Db2 libraries. Some knowledge of Jupyter notebooks, Python programming, and of course, Db2, would be an asset, but not necessary.

Additional Requirements:

Students should have their laptop but if not, they will get instructions on what to do afterwards.

Speaker Bio:

George Baklarz, B. Math, M. Sc, Ph.D. Eng., has spent many years in IBM working on various aspects of database technology. In 1991, George was part of the team that introduced the Db2 distributed product to the market. Since this time he has worked on vendor enablement, competitive analysis, product marketing, product planning, and technical sales support for the Db2 product. George currently works in the Worldwide Digital Technical Engagement Team.

Register

Db2 Architecture Deep Dive

Keri Romanufa

Chief Architect for Db2

When:Thusday, Nov 8, 2018 14:00 to 17:00
Where: Neptune III
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS

Abstract:

An interactive presentation (i.e. questions welcomed!), aimed at taking a peak "under the hood" into Db2 (LUW) architecture.

A wide range of Db2 architecture topics will be covered, in addition some best practices will be included.

  • Db2's overall architecture and process model – how it is the same and/or varies between
    single node, MPP and pureScale
  • Look into the on disk layout for table spaces and for objects (row, columnar, indexes, etc)
  • Logging and crash recovery – how we keep your data safe, and at the same time support
    backup and restore, HADR and replication
  • Memory management, IO, and caching (aka buffering)

Speaker Bio:

Keri is an STSM and the Chief Architect for Db2. She has been a member of the Db2 team since 1992 and has had a variety of roles in the System Test and Performance Teams, but as spend the majority of her career in Kernel Development. She has contributed to many of Db2's advances including being the Chief Engineer for the initial release of DB2 pureScale, and driving technologies such as async IO, space reclaim and storage (DMS and later automatic) and focusing on performance especially in the buffer pool area, In doing so Keri has achieved 23 patents. Her current focus area is HTAP.

Register

Get more out of Hadoop using IBM's Db2 Big SQL

Jim Wankowski

IBM's Digital Technical Engagement

When: Thursday, Nov 8, 2018  14:00 to 17:00
Where: Jupiter
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS

Abstract:

More and more customers are building virtual data lakes which consist of multiple data sources. It is quite common to have a mix of Hadoop, Db2, Oracle, Neteeza, etc. This hands-on lab will teach students how to use IBM's Db2 Big SQL to easily build analytical SQL queries against Hadoop using Big SQL as well as Spark. It will also highlight Big SQL’s federated capabilities by building queries that join unstructured Hadoop data with relational Db2 data. This lab is great for Db2 professionals looking to learn how to leverage their Db2 SQL skills to explore Hadoop.

Speaker Bio:

Jim is currently part of IBM’s Digital Technical Engagement team specializing in Big Data. Jim’s main focus is supporting Hortonworks HDP, and Db2 Big SQL. Jim has 4+ years of experience with Big Data and more than 30+ years of development and database administration experience with Db2 for both z/OS and LUW starting with participation in the ESP program at one of the original beta sites for Db2 z/OS in 1984. Prior to joining IBM, Jim spent 5 years at CA supporting their Db2 z/OS tools, 10 years as the Db2 product manager for Quest Software, and nine years as a Db2 product specialist at Platinum Technology. Jim is a well-known international speaker who has written articles for Db2 Magazine, and Z/Journal, and regularly presents at IDUG, regional Db2 user groups.

Register

Db2 and SQL Optimization for Developers

Tony Andrews

Themis Inc

When: Thursday, Nov 8, 2018 14:00 to 17:00
Where: Cettina De Cesare III
Price: FREE

LIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASIS

Abstract:

This educational seminar is for those attendees to learn more about Db2 optimization and to get stronger in the SQL language. Get ready for a deep dive into Db2 for z/OS Optimization and advanced SQL. This is for the Db2 development professional who desires to understand the fundamental issues associated with performance in SQL applications. Emphasis is placed on new considerations for the latest releases of Db2 on both platforms and the use of IBM Data Studio as an optimization tool. Optimization and Db2 explains will be performed on both platforms, along with many SQL and Explain examples to review.

Speaker Bio:

Tony has more than 25 years experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDBMS application design, development and SQL programming – always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.

Register