What type of parameter is “dbheap”?

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?

Which is correct about the EXPLAIN statement

Which table space allows LOBs to use the filesystem cache?

What is intra-partition parallelism?

What is a technique to access non-contiguous data pages more efficiently?

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

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

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?

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

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?