Online Registration is Now Available
Register for the IDUG DB2 Tech Conference in Berlin, Germany, the premiere European event for DB2 professionals, taking place 4-9 November 2012, at the Estrel Berlin Hotel Berlin, Germany. This event will feature the latest in DB2 technologies, networking opportunities and the technical content you need to be efficient in your day-to-day activities.
Plan to attend 4 November and enjoy a day devoted to IBM certification training, DB2 migration workshops and sessions for CA customers. These optional events are free to conference attendees, and are a great way to prepare for the full conference opening on the 5 November.
Cost Saving Opportunities
- Early Bird Discount
Register on or before 8 October 2012 and receive the early bird discount on your conference registration.
- Multiple Delegate Discount
For every three individuals who register from the same organisation, a fourth may attend at the discounted rate of EUR 868.70. To take advantage of this discount, all individual registration forms and payment(s) must be submitted together.
- Mentor Program
If you have attended three previous IDUG DB2 Conferences, you are eligible to bring a first-time colleague to Prague for an 80% discount off the full registration fee. More details are available in the Mentor page.
These seminars will be held Friday, 9 November 2012. This full day experience includes breakfast, lunch and course materials. Registration for paid full conference delegates is EUR 535.50 and the one-day seminar only cost is EUR 589.05. Select from the following session topics:
- [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.