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:
- SQLADM authority
- EXECUTE privilege on the DB2 -supplied stored procedures SYSPROC.SET_PLAN_HINT and
SYSPROC.ADMIN_COMMAND_DSN, and the BIND QUERY privilege
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.