Return
-
Title
Auto Optimizer, Setup to perform the testing one SQL at a time to reserve resources -
Description
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?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.