Last week I blogged about the Best Practice Papers that were available for DB2 Linux, UNIX, and Windows: DB2 Best Practices – New or Updated for 2011. As a result of that entry, I found out that there are also Best Practices resources for DB2 for z/OS as well. Not only articles though, but lectures, podcasts, and publications. Thanks to Janet Ikemiya and David Salinero for providing me with this information!
The DB2 for z/OS best practices developerWorks webpage contains many of the recommendations and guidance of DB2 for z/OS subject matter experts. Material from frequent conference speakers such as John Campbell, Roger Miller, Bonnie Baker, Willie Favero and several others is located on this site. Over 25 web lectures (slides with audio), articles, and publications are organized into categories such as administering, security, and tuning.
The most recent additions are:
John Campbell's two part series of recommendations regarding optimizing DB2 insert performance. This web lecture includes a video with slides and audio by John. The slides and transcript are also available separately:
Optimizing insert performance, Part 1 (February 2011)
by John Campbell
This webcast presents trade-offs made between optimizing DB2 insert for better throughput versus space reuse. It explores questions regarding inserting rows sequentially or randomly, whether to sort into clustering order and the effects of indexes on insert performance. Learn best practices for the different types of DB2 table spaces and get the details on DB2 parameters and recommended values.
Optimizing insert performance, Part 2 (March 2011)
by John Campbell
This second webcast on optimizing insert performance reviews additional techniques for speeding up the process of inserting rows into DB2. Learn about methods such as using a large index pagesize, random index keys, removing unused indexes, logging, and efficiently creating unique identifiers. The webcast covers enhancements specific to DB2 10 (such as index I/O parallelism, unique index with INCLUDE, and in-line LOBs) that impact insert performance. Finally, the presenter summarizes the best practices from both part 1 and part 2.
Also added in 2011:
DB2 Statistics Data Collection, DB2 System Address Space CPU Time and WLM Settings, Data Set Open/Close Activity (January 2011)
by Florence Dubois
There are many choices when collecting statistics about the DB2 system environment. This webcast will give guidelines on which statistics to gather and how to analyze your system's health. The data collected from IFCIDs, CPU time from monitoring tools, WLM metrics, and data set open and close activity will all be explored. The recommendations given will lead to improved DB2 performance.
Hard Lessons Leaned From Customer Health Check Studies (January 2011)
by John Campbell
This webcast presents practical advice from DB2 health checks at customer installations. It describes problems encountered when dealing with WLM, disaster recovery, continuous availability, data sharing, DB2 restart, and storage tuning. It discusses the most common issues and proven methods to prevent problems.
Additional material is posted throughout the year so bookmark this page!
If you have a suggestion for additional best practice content, please send an email to the contact firstname.lastname@example.org.