Session Evaluation

The objectives of this double session are to learn recommended best practice, learn from the good, bad and ugly experiences from other installations and to provide answers to important, frequent or difficult questions. Part 1 will cover the following topics: Online removal of active log dataset, Online migration from PBG UTS to PBR UTS table spaces, ALTER TABLE DATA CAPTURE concurrency enhancement, User controls to improve the ability for SQL DDL operations to succeed and/or reduce application service, RUNSTATS and Page-level Sampling, WLM and DDF High Performance DBATs, DDF system parameters MAXCONQN and MAXCONQW, Misunderstanding about DDF sysplex workload balancing. Part 2 will cover the following topics: Enhancements to Fast Traversal Block (FTB) feature, Considerations using Contiguous Buffer Pool, Use of large index page size, Changes in behavior after migrating to UTS, War story about insert processing with MEMBER CLUSTER, Considerations when collecting column frequency statistics, Increase in false lock contention when using data sharing.