with Tags: runstats X
SergeRielau Tags: once conservative reopt bind binding runstats option run validate static dynamic featured always 4 Comments 3,303 Visits
Motivation Recently one of our major business partners submitted the following feature request: " Please make all the SQL in my SQL Routines dynamic! " Why, I asked, would you want to do that? If you make the SQL dynamic at lot of bad things would...
from Blog: SQL Tips for DB2 LUW
Does runstats seem to be running longer than usual? There could be a few explinations for this. First you should consider if there is a significant amount of data than before, this could just be normal. If you are in a situation where you will be working...
from Blog: Thoughts from Information Management Support
Did you know….. you can reduce the CPU consumption of RUNSTATS by using the Statistics Advisor of InfoSphere Optim Query Workload Tuner for DB2 for z/OS
IBM_Optim Tags: optimization_expert workload statistics query_tuner runstats willoughby cpu 1 Comment 2,019 Visits
…and at the same time maintain or improve query performance. Note from the editor: This blog entry has been updated to reflect the current product name, InfoSphere Optim Query Workload Tuner for DB2 for z/OS . Previously I have blogged about how InfoSphere...
from Blog: Managing the data lifecycle