JC Greatest Hits, War Stories and Best Practices 2021

Download PDF

Watch recording (logged in Tridex members only)

Session title: JC Greatest Hits, War Stories and Best Practices 2021

Session abstract: Opportunity to learn recommended best practice, earn from the good, bad and ugly experiences from other installations, and provide answers to important, frequent or difficult questions.

The following topics will be covered:

  • Fast Index Traversal (FTB) Latest News
  • IMS/TM Thread Connection Pooling
  • SMF Compression and/or zEDC compression of SMF records
  • Setting Special Registers and Global Variables
  • Contiguous Buffer Pool Considerations
  • “Running Pedal To The Metal”
  • Cost management using CPU capping
  • Tutorial on HiperDispatch and Efficiency differences between VH, VM, VLs
  • Configuring zIIP processors for Db2
  • 2-part fixes for Data Sharing
  • Data Sharing: False Contention before and after APAR OA59122
  • Implementing Huffman Compression
  • Using GETPAGES in RTS
  • REBIND Phase-In
  • Changed Behaviours after Migration to UTS
  • War Story with Insert and MEMBER CLUSTER
  • Investigating Lock Suspensions
  • IRLM Triggering Dynamic Structure Rebuild
  • Column Frequency Statistics (FREQVAL)

Speaker biography: John Campbell is an IBM Distinguished Engineer reporting to the VP of IBM zAnalytics Development at the IBM Silicon Valley Lab and is the technical leader of the world wide Db2 for z/OS Development SWAT Team. He has extensive experience of DB2 for z/OS in terms of systems, database and applications design. He specializes in design for high performance and data sharing. He is one of IBM’s foremost authorities for implementing high end database / transaction processing applications.