For which two events is it recommended to execute RUNSTATS? (Choose two.)

You are running an IMPORT utility and have specified the option COMMITCOUNT
AUTOMATIC
Which two reasons will cause the IMPORT utility to COMMIT? (Choose two.)

Tables TABLE_A and TABLE_B in database TESTDB have the same data structure
(same columns with the same definitions). You wish to unload the data from
the two tables into a single file in PC/IXF format.
Which command(s) can be used to do this?

For which two purposes would you run the db2look tool? (Choose two.)

A file named db2advise.in contains the text shown below:

-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname=’HAAS’;
What does the line -#SET FREQUENCY 100 convey when this file is used as input
for the Design Advisor?

If this command is executed:
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?

When using Optim Database Administrator to generate a change script, users
are given which two EXPORT utility output formats to preserve their data when
they drop a table then create a new table with the data? (Choose two.)

Visual Explain uses which explain facility to capture information?

Which method may be used to collect deadlock information in DB2 97?

Which three authorizations allow you to execute db2pd? (Choose three.)