Every database has some kind of database privileges. These privileges are directly reflected in SQL Optimizer to limit the access and authority of each user. When logging on to SQL Optimizer, if you do not satisfy the logon privileges below, you will be presented with a Connection Information window. The Connection Information window details reason and the workaround.
To create or modify temporary tables in User-Defined Temp Table, Scanner Temp Table, Trigger Conversion and temporary table generation while optimizing the original SQL statement, the logon user needs the following privileges:
Connection to DB2 LUW 7 or above.
USE privilege on the USER TEMPORARY table space or SYSADM or DBADM authority.
The Index Expert function requires DB2 LUW version 7 or later to retrieve the indexes recommended by DB2 LUW functions. It requires DB2 LUW version 8 or later to use the Generate Indexes function with the Index Expert’s unique Artificial Intelligence engine. It also requires that the statistics be run in order to be able to estimate the size of the index.
On the Access Plan tab in the SQL Optimizer window, you can update the table and index statistics. In order to update statistics, you must have one of these privileges:
CONTROL privilege on the table
