Complimentary Workshops (Sponsored by IBM)

 
IDUG is pleased to offer these Complimentary Workshops for FREE to squeeze the most educational value out of your conference.
 

Sunday, Nov 15th

Certification Preparation Courses:

Pre-Certification Workshop: IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals (Exam 610 & Exam 312)  
Pre-Certification Workshop: DB2 10.1 DBA for LUW (exam 611) and DB2 10.5 DBA for LUW Upgrade (exam 311)

Thursday, Nov 19th

 


COMPLIMENTARY: DB2 11 Migration Planning Workshop
 Gareth Jones and Michael Dewert [IBM]
 
When: Sunday Nov 15th, 2015 - 9:30-16:30
Where: Munster
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.

Presenter: Gareth Jones and Michael Dewert IBM]
Bio: Gareth Jones has worked in IT since 1985, when he worked for an IBM customer in the UK retail sector. His first real contact with DB2 was when, working as an IMS Systems Programmer and DBA, he took on the job of migrating DB2 from V1.3 to V2.1, and he hasn't looked back since. In the 1990s, he spent eight years as a contractor, in France, the Netherlands and the UK, before joining IBM as a permanent employee in 2000. Gareth worked for several years in IBM's Strategic Outsourcing division, and then in BetaWorks, before joining the DB2 for z/OS SWAT Team, under the leadership of John Campbell. He has worked with many customers around the world with the SWAT Team. He has written a number of technical papers as well as presenting at several conferences including Insight, and many user group meetings.
 
Michael Dewert 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.
 
 


COMPLIMENTARY: Fast Start! DB2 for z/OS Application Development Topics
 Gareth Jones [IBM]
 
When: Thursday Nov 19th, 2015 - 13:00-17:00
Where: Meeting Room 18
Price: FREE
 
Triggers, Instead Of Triggers and Multi-row operations
This session examines the use of triggers and instead of triggers, and looks at the benefits and coding techniques for exploiting multi-row operations.
Archive Transparency and TIMESTAMP with TIMEZONE
This session explores the DB2 11 feature which allows applications to transparently access data in an archive table, and optionally to move non-active data into an archive table. It also looks at the use of time zone information with TIMESTAMP columns.
SQL Features including Intersect/Except/Merge and other SQL coding techniques
This session looks at a variety of SQL features introduced over several DB2 releases, and how they can be used to provide improved functionality, performance, and to provide alternative coding techniques for your applications.
Dynamic SQL best practices
This session discusses dynamic SQL best practices in terms of exploiting and managing the Dynamic Statement Cache (DSC). Guidance is given on analysing dynamic query performance using performance data available in the DSC and the session concludes with a brief look at protecting the production environment by using production modelling to ensure consistent access path selection across development, test and production..
Managing Query Performance
This session briefly introduces the EXPLAIN tables , which are used to assist in access path analysis. It then looks at some typical access path problems, how they are affected by filter factors and the statistics in the DB2 catalog, how to identify them and some strategies for handling them. Once access path problems have been addressed, PLAN_TABLE and the DB2 Access Path Repository can be used to provide optimisation hints, to stabilise access paths, and ultimately to ensure that preferred access paths are used for critical queries.
Presenter: Gareth Jones
 
Bio: Gareth Jones has worked in IT since 1985, when he worked for an IBM customer in the UK retail sector. His first real contact with DB2 was when, working as an IMS Systems Programmer and DBA, he took on the job of migrating DB2 from V1.3 to V2.1, and he hasn't looked back since. In the 1990s, he spent eight years as a contractor, in France, the Netherlands and the UK, before joining IBM as a permanent employee in 2000. Gareth worked for several years in IBM's Strategic Outsourcing division, and then in BetaWorks, before joining the DB2 for z/OS SWAT Team, under the leadership of John Campbell. He has worked with many customers around the world with the SWAT Team. He has written a number of technical papers as well as presenting at several conferences including Insight, and many user group meetings.
 
 
 


COMPLIMENTARY: DB2 for z/OS and Cloud Computing
 Maryela Weihrauch and Kewei Wei [IBM]
 
When: Thursday Nov 19th, 2015 - 13:00-17:00
Where: Meeting Room 2
Price: FREE
 
DB2 for z/OS and Cloud Computing - Part 1:  Installation/Migration with z/OSMF
Being ready for Cloud computing is important for any software product. Maryela and Ke Wei will position DB2 for z/OS role in cloud computing, introduce z/OSMF workflows. They than will share how  DB2 exploits them for automated  DB2 migration and installation to simplify DB2 system programmers as well as infrastructure for cloud provisioning use cases.

DB2 for z/OS and Cloud Computing - Part 2: Self-Service Database Provisioning in Private Cloud
With the distributed databases making big steps in cloud support, it is critical for DB2 for z/OS to provide similar capabilities for easy database consumption.
 
Maryela and Ke Wei will show how DB2 database provisioning and de-provisioning can be offered as self-service to consumers within the company, e.g. application developers, test organisations and business units, They will discuss critical cloud criteria as capacity control, metering, security etc. in a System z computing environment.

Presenters: Maryela Weihrauch and Kewei Wei [IBM]
 
Bio: Maryela Weihrauch is an IBM Distinguish Engineer with DB2 z/OS Development. She has been working with customers around the world to design their DB2 systems and applications for optimum performance and availability. Currently, she drives the Business Analytic strategy with DB2 for z/OS. Maryela is frequently sharing her experience at conferences.
 
Kewei Wei is the technical leader of DB2 for z/OS development and CE team in IBM China Development Lab. He has been working on the development of DB2 for z/OS query optimization technology for more than 10 years. He also provided consulting service of DB2 for z/OS application performance tuning to China and worldwide DB2 customers. Currently he is leading the development of DB2 Cloud provisioning services.
 

Register Now!


COMPLIMENTARY: DB2 in the Cloud Hands on Workshop
 Chris Eaton [IBM]
 
When: Thursday Nov 19th, 2015 - 13:00-17:00
Where: Meeting Room 1
Price: FREE
 

As you may be aware, IBM has a huge investment in Cloud Data Services with several billion dollars invested in acquiring and growing the IBM Cloud.  At the core of cloud data services are the database management systems you know and love ... namely DB2.  For the cloud we have renamed it dashDB as it is really more than just DB2. It's DB2 BLU Acceleration infused with Netezza in database analytics and offered in a pay as you go cloud model which provides a very low starting point (free) and allows you to grow and shrink with changing business demands.  In this 2 hour hands on workshop we will take you through provisioning and working with dashDB (the working part you will be familiar with since it's DB2).  We will also work on getting your data into the cloud and show you how we can integrate data from mobile applications that leverage a NoSQL JSON data store (like Cloudant) to provide analytics on top of these new data sources.  We will also work through moving data into, out of and around the cloud using the dataWorks service on IBM Bluemix (another free service). We will then wrap up with an exploration of Watson Analytics which allows you to perform predictive analytics on your DB2 data in the cloud without having to have a PhD in statistical analysis.

All you need to bring to the workshop is a network connected device (laptop, iPad, etc) to work with DB2 in the Cloud and the IBM Cloud provides the rest.

  Objectives:

  • Understand bluemix and creating data services
  • Provisioning and working with a dashDB instance
  • Working with JSON data in Cloudant and doing analytics on that data with dashDB
  • Moving data around the cloud and getting data in using dataWorks 
  • Watson Analytics - exploration and prediction for your business users
Presenter: Chris Eaton [IBM]
 
Bio: Chris Eaton is a Worldwide Technical Leader for IBM’s Cloud Data Services organization. Chris has been working with DB2 on the Linux, UNIX, Windows platform for over 23 years. From customer support to development manager, to Externals Architect and Product Manager for DB2, Chris has spent his career listening to customers and working to make DB2 a better product. Chris is the author of IBM DB2 9 New Features, DB2 9.7 New Features, Understanding Big Data and The High Availability Guide for DB2 and has one of the most popular blogs about DB2 on IT Toolbox at http://it.toolbox.com/blogs/db2luw. In his current role, Chris leads a worldwide team of technical specialists delivering IBM’s Analytics portfolio of products in the cloud. Chris is also a proud member of the IDUG Speaker Hall of Fame.
 

Register Now!

 


COMPLIMENTARY: DB2 LUW Basic Administration
 Saeid Mohseni [ Folksam Insurance Co.]
 
When: Thursday Nov 19th, 2015 - 13:00-17:00
Where: Meeting Room 9
Price: FREE
 
This session provides a basic knowledge of DB2 LUW from the DBA perspective, the session is useful for the new DB2 LUW DBAs and those who are not working as DBA daily basis. In this session, the following concepts will be explained:
  • The concept of the Database Manager (Instance)
  • Database tpyes: Single database, Database partitioning Features (DPF) and PureScale
  • Database and its physical components such as Storage Group and Transaction log
  • Table space definition and types of tablespaces
  • Table definition, types of tables and other database objects such as Index, Viewes and Alias.
  • The concept of IBM DB2 with BLU Acceleration • Data propagation such as Load, Import, Ingest
  • The Transaction log processing in DB2 LUW
  • Types of Backup and Recovery
  • Existing utilities in DB2
  • Database Shared Memory Review and retated parameters
  • Monitoring Tools
  • Security

Presenter: Saeid Mohseni [Folksam Insurance Co. ]

Bio: Saeid is IBM Information Champion and lead database team at Folksam Insurance Co. in Sweden. Saeid has over 35 years of experience in the Information Technology field, and 27 years of experience with the DB2 family of products. His area of expertise include database administration / database architect with focus on performance tuning in OLTP and BI from SQL and DB2 LUW engine point of view, database recovery and system development using DB2. Saeid is former IBM employee and DB2 LUW specialist. He is DB2 LUW instructor - has been teaching IBM DB2 LUW public classes for more than 15 years in Sweden and other Nordic countries. Saeid is co-author of IBM redbook (DB2 UDB V8 non-DPF Performance Guide for High Performance OLTP and BI). He was speaker at IDUG EMEA – 2011 and he is frequently speaker at swedish RUG.
 

Register Now!

 


COMPLIMENTARY: IBM DB2 Analytics Accelerator Architecture Workshop
 Patric Becker and Peter Bendel [IBM]
 
When: Thursday Nov 19th, 2015 - 13:00-17:00
Where: Meeting Room 6
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 and can now help you with additional use cases such as in-database-transformations. 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.
Conducted at IDUG 2013 and 2014 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 in 2015
    • Obtain latest news from IBM DB2 Analytics Accelerator development
    • Customer experiences of latest enhancements
    • Understand use cases and technical details of in-database-transformation (IDT) with an accelerator
    • Incremental update enhancements
    • Gain insight into more efficient ways to feed data to IBM DB2 Analytics Accelerator
      You will leave with:
      • Presentation materials
      • Networking and Contacts
      Target Audience: Business / LOB Titles Marketing Analyst, Application Architect
       
      Presenters: Patric Becker and Peter Bendel [IBM]
       
      Bio: 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.