When working with concurrency controls, what happens when the number of locks held on rows and tables is equal to the percentage of the locklist specified by maxlocks?

Which DB2 object allows multiple users to access data in a table with each user only being able to access certain portions of the data?

What is a DB2 IMAGECOPY

What is the benefit of prefetching data?

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?

How does DB2 determine which lock-size to use?

What is a DB2 access path?

What is dynamic SQL?

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

What happens during a DB2 Checkpoint?