Given that there are two containers in table space Smart1 and the following statement: ALTER TABLESPACE Smart1 REDUCE (ALL 100 M) Which of the following will happen?

If you have a poorly clustered index with random synchronous I/Ss, what clause would you use to prevent an impending delay?

An audit trace shows that TSO user TSOID1 with DBADM authority, is continually attempting to update a table in DB2 subsystem DSN1 that is not supposed to be updated. Which of the following will prevent access to the DB2 subsystem?

Which explicit system privileges allows the user to create new plans and packages without being able to also execute them?

What parameter and option must be set before using a DB2 DBMS?

Which of the following RACF profiles would be used to allow IMS to access DB2 DSN1?

What is intra-partition parallelism?

Which table space allows LOBs to use the filesystem cache?

Which is correct about the EXPLAIN statement

A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?

What type of parameter is “dbheap”?