I have 5 SQL Select statements connected by a Union/Union All. How many times should I have to specificy union to eliminate duplicate rows?

Why would you need to execute RUNSTATS regularly when using the SQL compiler?

In a UNIX-based environment, where would the database manager configuration file be found?

Which must be set to restrict clients from being able to discover any DB2 instances on a server?

After entering a query, what is the first step the SQL compiler takes?

Under what context is pushdown analysis utilized?

What happens during a DB2 Checkpoint?

The various locking levels available are: 

Which statement will gather only the index statistics for the table john.table1?

What do you need to do before you perform EXPLAIN?

The various locks available are _____________.