< Select Another Room
Db2 for z/OS
John Lyle, IBM
The purpose of this presentation is to introduce the new migration process for the new Db2 13 for z/OS release. The Db2 13 release migration process is significantly different from any previous Db2 release migration. The changes are, in fact, revolutionary. We will detail the Db2 12 to Db2 13 migration process, the Db2 13 Installation process, and go into details regarding application compatibility and the Continuous Delivery process as it relates to Db2 13. Each release brings new migration processes and challenges we will detail the nuts and bolts of the significant Db2 13 process and procedure changes.
Adrian Collett, Expertise4IT s.r.l.IBM Gold Consultant & Champion
Have you ever had a performance problem with unexplained long elapsed times? If so, the chances are that your monitor or performance data will show that it was due to elongated ACCUMULATED WAIT TIME BECAUSE OF PAGE LATCH CONTENTION(QWACAWTP). When this occurs during the peak period it can have a devastating effect on your system with threads queuing and CPU consumption going through the roof, leading to a general slow-down of the whole system. Unfortunately, this is one of the least documented, and least understood, reasons for wait-time in Db2 processing. This presentation will reveal the mysteries behind this “black hole” of Db2 processing and examine the main causes of Page Latch Contention and explain why and how it can have such a disastrous impact on your environment. Through the use of real-life examples, the presentation will provide guidelines on how to eliminate, or at least reduce, these causes of Page Latch Contention thus making your systems more reliable and efficient.
Steen Rasmussen, Broadcom
Emil Kotrc, BroadcomIBM Champion
Todd Mollenhauer, BMC Software
SMike ToppinsIBM Champion
Tom Glaser, MasterCardIBM Champion
Db2 for z/OS Back To Basics
Toine Michielse, BroadcomIBM Champion
Understanding what Db2 explain tells us can be intimidating to less experienced application developers and Dba's. Breaking down complex access paths to the basic components helps finding the pain points in an SQL statement.
SQL is a very powerful language. To support it the Db2 optimizer has many ways to get to the data and combine partial results into the final result set. even though many tools are available to visualize the access path Db2 plans to execute, the output can be complex to understand. Breaking it down to the the basic elements and understanding the way data is accessed by those elements will enable less experienced developers and DBA's to find performance problems quickly.
Ken Shaffer, Aerodata Inc.IBM Gold Consultant & Champion
Michal Bialecki, IBM Silicon Valley Lab
Vasudevan Natarajan, Walmart
Db2 for z/OSBack To Basics
Steve Solomon, BMC
Gayathiri Chandran, IBM
Robert Tilkes, IBM
Tammie Dang, IBM
Db2 for z/OS NEW Back To Basics
Robert Andresen, Broadcom
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403Phone: (910) 660-8649Fax: (910) 523-5504