Authority and privileges that are required for overriding the selectivity of predicates

This authority and these privileges are required to override predicate selectivity by having InfoSphere Optim Query Workload Tuner calculate new filter factors or by specifying them manually. You can use this feature only when you are connected to DB2 11 for z/OS new-function mode or later.
Your authorization ID must have either the following authority or the following privileges: InfoSphere Optim Query Workload Tuner creates the two collection IDs OPTCOLL0 and OPTCOLL1. These collection IDs are for internal use only and users are not required to have any privileges on them.

Feedback