JC Greatest Hits, War Stories, and Best Practices 2019 for Db2 for z/OS


This session will share lessons learned from good and bad customer experiences, and share recommended best practice. The presentation is a mash up of the following topics:
•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
•Requirement for increased RID Pool size (Db2 12)
•Setting initial STATISTICS PROFILE (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
•“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

Languages :  Polski Session Category :  Warszawa 2019 

By continuing to use the site, you agree to the use of cookies. więcej informacji

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.