Managing, Monitoring, Tuning and Architecting a Db2 for z/OS DDF Workload
Robert Catterall, IBM
At a great many Db2 for z/OS sites, applications that utilize the distributed data facility (DDF) comprise the fastest-growing segment of the overall Db2 workload, and such applications are increasingly found to be the very largest workload component - bigger than CICS-Db2, bigger than IMS-Db2, bigger than batch-Db2. These trends make it ever more important to "do DDF right." How can a Db2 DDF workload be effectively managed? How can DDF activity be monitored and tuned? What does DDF application architecture have to do with efficiency? These and other pertinent questions will be answered in this session.
Tablespace Evolvement – PBR2 is the New Kid on the Block
Steen Rasmussen, Broadcom
The tablespace design has been through many changes and enhancements. This presentation will cover each of the tablespace types including pro’s and con’s and limitations as well as best practices. The emphasis will be on the new tablespace type (Relative Addressing) introduced in Db2 12 using a live Db2 12 system to illustrate the details.
Tablespace design has evolved a lot over the past +3 decades and the new Relative Byte Addressing will solve most if not all the nightmares from the DBA perspective.
- Tablespace types since the early days of Db2 and their pro’s and con’s.
- Table Controlled Partitioning
- Partition By Growth
- Relative Byte Addressing
- Live walk through of all the new DDL attributes, utility processing, and enhancements to schema changes
Modern Db2 for z/OS Physical Database Design
Robert Catterall, IBM
Db2 for z/OS physical database design has changed with the introduction, via recent Db2 releases, of new options that DBAs can exploit to improve performance, availability, and security - without requiring application code changes. This session will provide information on leveraging features related to data partitioning, table space type, LOB management, data protection, index design, data archiving, insert throughput maximization, and more.
The Most Important Stuff You Should Know About Db2 12 for z/OS, in 75 Minutes
Robert Catterall, IBM
Db2 12 for z/OS is packed with new features and functions, and the scope of that new functionality expands several times per year with the delivery of successive function levels - Db2 12 continuous delivery in action. It's easy to talk all day about Db2 12, and I do that on a regular basis. For this session, I've boiled down what I personally consider to be the most important Db2 12-related information into a 75-minute presentation. Z hardware and z/OS exploitation, performance enhancements, package bind possibilities, utility goodies, SQL capabilities, smarter data sharing, and more. Tthis is my take on the best of the best of the Db2 12 story.