This entry was originally published on 2018-12-27.

Perhaps you've read previous blog posts in our series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS. Now you have a chance to hear the latest updated for 2019, directly from John! "JC's Greatest Hits, War Stories, and Best Practices 2019"

Register for Part 1: http://ibm.biz/JCGreatestHitsPART1

January 29, 2019 11am - 12:30pm EST

Register for Part 2: http://ibm.biz/JCWebcastPart2

January 30, 2019 11am - 12:30pm EST

This double session introduces and discusses some of most common 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:

• 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);
• System parameter REALSTORAGE_MANAGEMENT;
• Transaction level workload balancing for DRDA traffic;
• Use of High-Performance DBATs;
• Overuse of UTS PBG tablespaces and MAXPARTS;
• Cleaning up after STATCLUS = STANDARD;
• “MBA lock”;
• IRLM query requests for package break-in;
• Db2 maintenance issues with batch utilities;
• Running CHECK utilities with SHRLEVEL CHANGE;
• Local buffer pool allocation – virtual and real memory.