A DBA issues the command:-DIS DB(DSNDB06) SPACE(*) LOCKS. In the LOCKINFO field the following data is reported: H-IS,S,C. When Will the lock first be released by DB2?

Where is the output of EXPLAIN stored?

Which cannot be done with the ALTER TABLE statement?

How do you perform the EXPLAIN of a dynamic SQL statement?

Can you use LOCK TABLE on a view?

What are segmented table spaces?

What is the primary focus of performance tuning, and how should performance tuning should take place?

If you wish to update your statistics after a change in your database, what utility can be executed?

What is an example of an environmental consideration in DB2 administration?

Which of the following are fields from SQLCA

When would phantom read phenomenon occur?