A database named FINANCE resides on an IBM System Storage DS8000 and a
database administrator would like to use Flash Copy to back up the database.
Which two actions must be performed before a backup image can be created in
this manner? (Choose two.)

Due to an application error, some data was deleted from a very large table
residing in table space TS1. The table space was then renamed TS2 before the
error was detected. Rather than try and rebuild this table, it was decided
that database OBI would be restored and then rolled forward to a point-in-time
(PiT) before the delete operation took place- Unfortunately the PiT roll
forward was done to a time that was too early and some critical transactions
were missing when the database was brought back on-line.
Which steps must be taken to ensure that the critical transactions which are
currently missing from the database are correctly applied to the database
and that table space TS1 is renamed TS2?

A database named PAYROLL resides on an IBM System Storage DS8000 and a
database administrator would like to use Flash Copy to back up the database.
Which command can be used to accomplish this?

Refer to the Exhibit.

Given the TCP/IP configuration shown in the exhibit, to what must the alternate
server be set on the Primary, to allow Automatic Client Reroute to connect
to the Standby after a HADR takeover?

Refer to the Exhibit.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active
log files, what will happen if there are currently 100 active log files and
DB2 needs to create active log file 101?

A database administrator created a new database from an existing full
database backup image.
If the original database resided on a 64-bit AIX server and the new database
was created on a different 64-bit AIX server, which two statements are correct?
(Choose two.)

Which set of procedures will be required to perform a rolling upgrade in
a HADR environment?

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?