What tables need to be set up to support SQL Optimizer for DB2 and Toad for DB2? The table SYSTOOLS.EXPLAIN_GET_MSGS is not installed and the error message was given:
"[IBM][CLI Driver][DB2/LINUXX8664] SQL0551N "BVEASEY" does not have the required authorization or privilege to perform operation "EXECUTE" on object "SYSTOOLS.EXPLAIN_GET_MSGS". SQLSTATE=42501"
Checking the 'use plan table from "SYSTools"' means all users loging into the database will share a plan table created in "SYSTools" tablespace.
For example, user A login to database and create a plan table in "SYSTools". User B login to the database and based off the Toad settings, try to use this plan table too. That user would then also need execute, select, and delete privilege on that table. The plan table owner is user A, so user B may get a error message if the needed privs haven't been granted.
Privileges depend on the option being enabled and what table is set up.
In general, for this issue, you'll need insert/update/delete on this tables ADVICE_WORKLOAD ADVICE_INDEX EXPLAIN_OPERATOR EXPLAIN_OBJECT EXPLAIN_ARGUMENT EXPLAIN_PREDICATE EXPLAIN_STREAM EXPLAIN_INSTANCE EXPLAIN_STATEMENT and also execute on table function EXPLAIN_GET_MSGS.
If the option 'use plan table from "SYSTools" ' is unchecked, then all plan table will be created under current login user.
