JC’s Greatest Hits, War Stories and Best Practices 2020

Download PDF (Part 1) (Part 2)

Watch recording (logged in Tridex members only)

Session title: JC’s Greatest Hits, War Stories and Best Practices 2020

Session abstract: This session will introduce and discuss: recommended best practice; lessons to be learned from the good, bad and ugly experiences from other installations; answers to important, frequent or difficult questions. Specific topics to be included:

  • Considerations when migrating from segmented to multi-part PBG UTS
  • Dos and Don’ts around Continuous Delivery
  • Software Maintenance
  • Point-In-Time (PIT) Recovery in Db2 12 with SCOPE UPDATED
  • Point-In-Time (PIT) Recovery before Function Level (FL) activation and/or CATMAINT
  • Fast Index Traversal  (FTB memory)
  • Dynamic prefetch avoidance
  • Transfer Ownership and SECADM / SYSADM
  • Hang conditions in data sharing group
  • Increase in transaction timeouts caused by Online REORG
  • Misuse of High Performance DBATs (HP-DBATs)
  • Local Buffer Pools and Real Memory allocation
  • A single local buffer pool can be spread across different size real memory frames
  • XXXL Size Local Buffer Pool
  • Restrictions with Buffer Pool Simulation
  • Using DSNJU999 service aid
  • Using Large Frame Size (LFAREA) for Local Buffer Pools
  • Growth in CPU time/transaction as CPU busy increases
  • Tutorial on HiperDispatch and Efficiency differences between VH, VM, VLs
  • REBIND very old plans and packages to avoid Autobind
  • REBIND Phase-in and thread reuse with RELEASE(DEALLOCATE)
  • Data Sharing – GBP Asynchronous cross-invalidation (XI)
  • Data sharing – GBP deallocation
  • Data Sharing – Peer recovery
  • Database Housekeeping Rules
  • Turning off CICS-Db2 thread protection

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.