DB2 for z/OS

A DB2 Workload Tuning Methodology 

Nov 30, 2016 03:03 PM

nstead 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

Attachment(s)
pdf file
M02 - A DB2 Workload Tuning Methodology - Grainger - DRAF...pdf   2.73 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.