Articles & Content

Archives

A DB2 Workload Tuning Methodology (D11)

Topic: DB2 for z/OS

Subtopic: 2011



Instead of tuning your SQL one statement at a time, why not look to the advantages of tuning an entire workload of SQL instead? Workload SQL tuning can not only provide faster returns on the investment in tuning time and effort but will usually provide bigger savings of cpu and other resources. Workload tuning can also avoid the unfortunate “Silly Putty” situation where improving the performance of one SQL statement can have unexpected detrimental effects elsewhere! Apart from tactical emergency corrections to individual SQL statements, workload SQL tuning should be the preferred mechanism to ensure that application SQL and the underlying database design work together in the most efficient way possible This presentation walks through a typical workload tuning methodology



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.