What do you need to do before you perform EXPLAIN?

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

The various locking levels available are: 

What happens during a DB2 Checkpoint?

Can you update a view which is based on more than one table?

What is dynamic SQL?

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

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

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

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?

What is the benefit of prefetching data?