The purpose of this page is to provide attendees with detailled information about the 2012 IDUG DB2 Tech Conference in Berlin, Germany.

To learn more, download the interactive brochure. Topics covered include technical highlights, keynote information, free workshops and more!

To view the full session schedule grid, download the Pocket Programme. Hard copies will be available at the Conference.


When: Thursday 8 November 2012 - 09:030 AM

Learn about administrating DB2 in an SAP environment through detail discussion on various DB2/SAP specific topics. 

Objective: After completing this course, you will be able to:

  • Understand DB2 fundamentals
  • Administer DB2 in SAP by using various SAP and DB2 tools to perform database monitoring, performance tuning, database layout, backup and recovery, etc.
  • Understand unique DB2 strengths and features, and the deep integration with SAP, such as DPF, MDC and deep compression
  • Understand various setup for high available system
  • Be able to perform basic problem analysis, 

Target Audience:

  • Database Administrator for SAP environment. This class will benefit most for attendees that have some SAP background on DB2 or other DBMSs. 
  • DB2 DBAs that do not have SAP skills will be taught specific areas in SAP where management of the database can be performed. 


  • DB2 & SAP Product Overview
  • Accessing DB2 - SAP DBA Cockpit
  • Database Objects
  • DB2 Configuration
  • Database StorageIntroduction to Logging, Backup & Recovery
  • DB2 SAP Performance Monitoring 

Please register here



COMPLIMENTARY: DB2 10 for z/OS DBA Administration Certification Crammer Course - CLASS IS FULL

When: Sunday 4 November 2012 - 09:30 AM

This course is a certification preparation course intended to help you take the DB2 10 Family Fundamentals exam (610) and the DB2 10 for z/OS Database Administration exam (612).

Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 10 z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 9 for z/OS and basic knowledge of DB2 10 features.

This will be a lecture-only class with no labs.This session offers an intense, overall review of all areas that will be on the certification exams (both the 730 – DB2 9 Family Fundamentals and the 612 – DB2 10 for z/OS), providing a comprehensive review for those planning on taking the certification exams to become an IBM Certified Solutions Expert - DB2 10 for z/OS Database Administration.

This course provides details about the exams and was written by an exam author and the co-author of the corresponding DB2 10 for z/OS Database Administration Certification Guide published by IBM Press. The course will include 610 and 612 Exam Details, 610 Exam DB2 10 Fundamentals including DB2 Products, 612 Exam DB2 10 for z/OS Database Administration including the topics of Environment, Controlling Access, Data Structures, Manipulating Database Objects, Advanced SQL, Maintaining Data, Database Recovery, Data Sharing, Performance Monitoring and Tuning, Application Development, Development Considerations, Advanced Functions as well as Locking and Concurrency

Please register here

COMPLIMENTARY: DB2 10 for LUW - DB2 for LUW Version 10 Certification Test Prep Seminar - CLASS IS FULL

When: Sunday 4 November 2012 - 09:30 AM

This presentation/learning session will assist in preparation for the DB2 for LUW V10: Database Administration certification test (#000-611).

The session is organized according to the test sections and will include coverage of

  • DB2 Server Management (Install and config, the DB2 installation-instances)
  • Physical Design (Physical objects)
  • Business Rules Implementation (view-triggers and there specific settings)
  • Monitoring DB2 Activity (Monitoring tools like db2pd, dyn.adm.views,etc.)
  • Utilities (Details on utilities)
  • High Availability (HADR-backup-restore-logging)
  • Security, (DB2 V10 new security areas) and Connectivity and Networking (CS Connections and trouble shooting).  

Please register here


 COMPLIMENTARY: DB2 10 for z/OS New Functions and Migration Planning Workshop - CLASS IS FULL

When: Sunday 4 November 2012 - 09:30 AM

This offering enables users to understand the breadth of features delivered in DB2 for z/OS versions.

Many resources are brought together in a single offering.The migration process is explained.Leave the session with materials that you can use to start your installation / migration immediately, or in the future.

Your questions are given attention, typically in a small group setting.While most MPWs are small, multi-company events, they can be delivered for individual they can be delivered for individual companies or even user groups.

Who should attend?

  • Application Developers
  • Database Administrators
  • System Administrators
  • Architects, IT decision makers, and Project Managers.

What you can expect?

  • An understanding of the features delivered with DB2 10 and how they can benefit your enterprise.
  • Clarity of the migration process.
  • References for many subjects, including:Migration.Fallback.Prerequisites & preparations.
  • You will leave with:Presentation materials.Checklists.Project plan framework.
  • Networking and Contacts

Please register here



COMPLIMENTARY: Data Warehousing with DB2 for z/OS: IBM DB2 Analytics Accelerator Deep Dive Workshop - CLASS IS FULL

When: Sunday 4 November 2012 - 09:030 AM

Length of workshop: 3-4 hours, depending on questions and discussion

Take advantage of a complimentary architecture workshop with IBM - to help you understand how this game-changing technology can be used in DB2 for z/OS Data Warehousing and BI environments. Conducted at IDUG EMEA 2012 Conference, the DB2 Analytics Accelerator Architecture Workshop is a half-day, interactive session that will help you understand this new technology and how this can help you in improving your cost and performance of your DB2 for z/OS based Data Warehouse and related analytical business processes. 

What you can expect?

  • Technical deep dive into IBM DB2 Analytics AcceleratorDemonstration of data life cycles with IBM DB2 Analytics Accelerator
  • Data maintenance options (load, incremental update)
  • Example performance numbers for query acceleration, load and CPU savings
  • System prerequisites of IBM DB2 Analytics AcceleratorCustomer experiences

 You will leave with:

  • Presentation materials
  • Networking and Contacts

Please register here

Additional fee required: Educational Seminars

When: Friday 9 November 2012

Visit the Registration page to reserve


[ODS1] John Campbell: Recommended Best Practices from Customer DB2 Health Check Studies 

This one day seminar will introduce and discuss the major lessons to be learned from customer DB2 Health Check Studies carried out by DB2 for z/OS Development and provide recommended best practices in each area. The objectives are to: introduce and discuss the most common issues, share the experience gained from customer health check studies, share the experience from live customer production incidents, provide proven recommended best practice, and to encourage proactive behavior. The following topics will be covered: WLM Policy Setup, Balanced Design across CICS and DB2 Disaster Recovery, use of Flashcopy, Continuous Availability vs. Fast Failover, Preventative Software Maintenance, Multiple Data Sharing Groups., Running Multiple DB2 Subsystems on same LPAR, Normal DB2 Warm Restart vs. Restart Light, Storage Tuning.

[ODS2] Cristian Molaro: Practical guide to DB2 for z/OS Performance 

DB2 Performance is key in application success, user satisfaction and cost savings. This session is a pragmatic guide to DB2 for z/OS Performance. It focuses on providing the understanding required to allow you to get Performance results. It is the result of hands-on experiences, teaching and writing about DB2 for z/OS performance for many years. 

[ODS3] Martin Hubel & Scott Hayes: DB2 for LUW Top Gun Performance Workshop 

This course will teach how to configure and tune DB2 LUW databases for maximum performance and availability. Included arestrategies for memory and CPU optimization, techniques for speeding up I/O, and what and how to monitor and measure for mosteffective results, trend analysis, and capacity planning.
Attendees will learn dozens of key metrics that must be regularly monitored, and what corrective action to take if metrics showsubstandard performance. Upon completion of this seminar, DBAs and Application Developers will have a template to follow toensure that they have top performing databases and applications. SQL commands, scripts, and other electronic materials will beprovided to attendees to enhance learning and productivity. 

[ODS4] Daniel Luksetich: Advanced SQL Coding and Performance 

DB2 brings focus to the fact that SQL syntax is easy but writing good SQL is not, even with query rewrite. Examples are shown of how SQL can solve very difficult business problems, and why this type of SQL never gets written. Examples of complex SQL in different formulations are shown to demonstrate those that they perform efficiently versus those that perform in the worst possible manner. DB2 brought a whole new world to relational with advancements in SQL processing and object relational support. Presented here are the more advanced examples of joins, table expressions, CASE expressions, UDFs, table functions, SQL recursive processing, relational division, OLAP expressions, PureXML, and many other features of the DB2 family. There are many examples taken from real systems. An emphasis is made on the proper use of each technique for performance. 

[ODS5] Bart STEEGMANS: Understanding DB2 accounting information - "The full monty" 

Almost everybody gathers DB2 accounting information, but do you also use, understand and exploit all the information that is in those records ?This on day seminar will explain what information is tracked by DB2 and stored in its accounting records, and what all (or at least most of) the fields mean, including the data sharing related sections.We will discuss how to analyze transaction response time as seen by DB2, and transaction performance in general, as well as how to exploit this great source of information to analyze and solve performance problems.We will also explore what additional trace data you can collect in case the DB2 accounting information does not provide enough information to determine the root cause of a problem.And last but not least, the latest and greatest instrumentation enhancements in this area that come with DB2 10 for z/OS will also explained during this presentation.