Best Practice Resources for DB2 z/OS
svisser1 2700018UK9 Visits (4910)
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)
Optimizing insert performance, Part 2 (March 2011)
Also added in 2011:
DB2 Statistics Data Collection, DB2 System Address Space CPU Time and WLM Settings, Data Set Open/Close Activity (January 2011)
Hard Lessons Leaned From Customer Health Check Studies (January 2011)
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 db2z