Articles & Content

Archives

H02 - The 2013 DB2 for z/OS Database Diet

Topic: 2013 NA

Subtopic: DB2 for z/OS



In 2003, I delivered a presentation at IDUG conferences titled, "Put Your Database on a Diet," which described various techniques to reduce the CPU and disk space consumption of a DB2 for z/OS workload. In the 10 years since, new DB2 for z/OS efficiency-boosting techniques have emerged. I will be highlighting several of these in this presentation, including methods of index trimming and upgrading, buffer pool configuration optimization, thread management, memory management, and SQL statement tuning.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.