Altering the DSSIZE is allowed for what type of table space?

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is
true?

When these two commands are issued in sequence, one after the other: STOP FUNCTION
SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What
will occur?

What is the purpose of the following query? SELECT DBNAME, NAME FROM

SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME
FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME =
TS.NAME);

Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spaces each
night. You create FULL image copies once a week and INCREMENTAL copies during the rest of
the days. After migrating to DB2 10, you plan to create the FULL image copies using
FLASHCOPY YES and COPYDDN, that is you create a flash copy image copy (FCIC) and
additionally a sequential copy. What happens to the incremental copies that you continue to create
on all other days?

What is the appropriate action to maintain data consistency if your page set is in REFP restrictive
state?

DB2 workfiles are critical to performance of applications. Which of the following will NOT assist
with achieving best performance for workfile usage?

Unnecessary REORGs of indexes may be avoided by which of the following?

Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or
directory in new function mode?

The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE
with utilid REORGON. Which statement is NOT true?