JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 2

Download PDF

Session title: JC Greatest Hits, War Stories, & Best Practices, 2019 – Part 2

Session abstract: Two part session introduces and discusses some of most common and/or most important issues based on worldwide customer engagements. There are two main objectives. Firstly, learn recommended best practice. Secondly, learn from the positive and negative experiences from other customer installations.The following topics will be discussed: Real Memory Map and planning LFAREA;,PGSTEAL(NONE) bufferpool and 2G size frames; System parameter REALSTORAGE_MANAGEMENT; Running out of basic 6-byte log RBA addressing range; Diagnosing resolving slow-downs and hangs; Hung Db2 threads; New ZSA keyword on HIPER and PE APARs; Insert free space search algorithm; Insert with APPEND; Fast un-clustered insert (Db2 12); Hidden ROWID support to partition; Cost management using CPU capping; Fast REORG with SORTDATA NO RECLUSTER NO; Requirement for increased RID Pool size (Db2 12); Setting initial STATISTICS PROFILE (Db2 12); Dynamic Prefetch avoidance with Db2 12, Transaction level workload balancing for DRDA traffic; Use of High-Performance DBATs; Overuse of UTS PBG tablespaces and MAXPARTS; Cleaning up after STATCLUS = STANDARD; IRLM query requests for package break-in; Running CHECK utilities with SHRLEVEL CHANGE;

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.