Patrick Bossman

Technology surrounding business is changing rapidly. Businesses need to deliver faster and more frequently than ever before. In response to these competitive pressures, development organizations are adopting DevOps practices - Agile software development, Continuous Integration and Continuous Delivery. These practices focus on delivering smaller, more frequent changes, more rapidly. A key foundation to achieve successful implementation is automating the application deployment process, and reducing the overhead and bottlenecks in the application deployment process itself.
This presentation will discuss Db2 z developer services, designed to enable companies to deliver developer self-services and automated deployments, radically improving developer efficiency, while retaining expected mainframe qualities of service through efficient design, review, and approval processes for database schema changes.

This presentation is a deep dive into analyzing query performance situations. The best practices approach utilized by Db2 for z/OS query performance diagnosis team. This presentation walks through what information is used, how information is layered onto the query, explain information, and optimizer choices information - and how to use it to evaluate a chosen access path versus alternates. While this presentation is targeted to Db2 for z/OS, the principles apply to evaluating query performance for any relational database.