1.
When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?
2.
Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?
3.
Which command would be used to obtain the name of the first active log file for a database with log retain enabled?
4.
Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?
5.
What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?
6.
Given the following output from the GET DATABASE CONFIGURATION command: Which of the following DB configurations listed below will enable circular logging?
7.
If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?
8.
A database recovery operation (RECOVER DATABASE) failed during the roll forward phase. The DBA wants to force the RECOVER DATABASE to redo the restore phase. What must occur to accomplish this?
9.
Which tool or command will display only the automatic storage paths in an existing backup image?
10.
A primary and standby database are enabled for HADR and are in peer state. The HADR_SYNCMODE configuration parameter is set to SYNC. An application connects to the primary database, issues a COMMIT and receives a successful return code in response. How were the log buffers for this unit of work processed?