User is using Auto Optimize function to perform the optimization and testing processes simultaneously. The function is generating alternatives and starts testing several alternatives SQL at the same time. Due to several SQL being run at the same time, it is putting burden on DB2 resources.
Is there a way to setup the Auto Optimizer to perform the testing one SQL at a time?
That way it does not deplete DB2 resources.
If this is not possible then what is the best way of testing all alternate SQL one at a time?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center