| A1: | The Task Center lets you schedule scripts containing SQL statements and/or DB2 commands to be run at specific times. |
| A2: | There is no equivalent DB2 tool in the Linux/UNIX platforms. The Linux/UNIX shell would be equivalent to the DB2 Command Window. |
| A3: | The registry variable is DB2OPTIONS. |
| A4: | When you plan to copy a command or statement that has carriage returns and then paste it into the CLP, it is best to use this method. |
| A5: | The terminate command. |
| A6: | You can invoke Visual Explain from the Command Editor. Type a query, and then choose either the Execute and Access plan or Access Plan button. |
| A7: | The Development Center tool. |
| A8: | No. The Control Center can be used to administer DB2 for Linux, UNIX, and Windows databases as well as DB2 for OS/390 and z/OS databases. |
| A9: | The Journal keeps track of DB2 messages; therefore, review the Journal messages tab. |
| A10: | Access the Information Center from the Internet at http://publib.boulder.ibm.com/infocenter/db2help. |
| A11: | B and C. You can enter SQL statements and DB2 CLP commands in the Command Line Processor (CLP) or in the Command Editor. |
| A12: | B. The default termination character is a semi-colon (;). |
| A13: | E. By default the CLP has autocommit enabled, and this causes the CLP to issue a commit statement automatically after every statement. Therefore, in this case, the CLP will issue a commit four timesafter each entry in the input file. |
| A14: | C. The Health Center will alert you when actions in the database exceed thresholds for performance-related characteristics that you have defined. |
| A15: | B and E. The Memory Visualizer will track the memory used by DB2 on your system and will plot/graph this memory usage for you automatically if you desire. The db2mtrk tool is the command line interface to the same information, and it will provide the same information in a text-based report. |
| A16: | A. By default the CLP has autocommit enabled, which causes the CLP to issue a commit automatically after every statement. However, the +c flag tells the CLP to disable autocommit; therefore, in this case, the CLP will not issue a commit. Since there is no explicit commit statement, there will be no commits during the processing of this file. |
| A17: | B. To set a termination character you need to use the -TD option, and to set the input file you need to use the -f option. However, if you specify a value for an option, you cannot string the options together. Therefore the correct answer is B. |
| A18: | C and D. db2 ? SQL-911 is not commonly used, but it works. db2 ? SQL911N is most often used. Note that the N after the 911 is optional. |
| A19: | D. Repeat is not a DB2 CLP command and can't be run in interactive mode. |
| A20: | C and D are allowed from the CLP in interactive mode. A is not allowed since you cannot prefix the command with db2 when in interactive mode. B is a DB2 system command, and it can only be executed from the Command Window or the Linux/UNIX shell. |
