| A1: | They are classified in two categories: DB2 system commands and DB2 CLP commands. |
| A2: | For DB2 system commands use command -h. For DB2 CLP commands use db2 ? command. |
| A3: | The Information Center provides a fast search engine that lets you search all the manuals based on a keyword. |
| A4: | The db2icrt command creates a DB2 instance on the server where the command is run. |
| A5: | Every database has three default table spaces created automatically by DB2. These table spaces are: SYSCATSPACE TEMPSPACE1 USERSPACE1
|
| A6: | The db2ilist command lists all instances that exist on a server, whether they are active or not. |
| A7: | When you install DB2 on a Windows server, the installation program will automatically create an instance named DB2 on the server. |
| A8: | No. The DAS is required only to allow the use of graphical tools for remote administration. |
| A9: | The DB2 environment can be configured by changing values of parameters in different areas: |
| A10: | Both the local database directory and system database directory are populated with the CREATE DATABASE command (not with the catalog command). |
| A11: | C. The db2start command starts the current DB2 instance. |
| A12: | B. The db2set all command lists all of the currently configured registry variables. |
| A13: | D. The command list db directory on C: will examine the local database directory, which is not removed when the instance is dropped, and list all of the databases on that drive/filesystem. |
| A14: | D. You must catalog the database before you can connect to it. To catalog the database in this situation, you must specify the drive or directory where the local database directory exists. In this case it is C:, so use the command catalog db sample on C:. |
| A15: | C. You must set the DB2INSTANCE environment variable to the instance you want to work with, in this case inst2, so the command is export db2instance=inst2. |
| A16: | D. The DB2_FORCE_FCM_BP registry variable tells DB2 to use shared memory for inter-partition communication (FCM) and not to use the network. |
| A17: | B. The db2_all command runs the specified command on all database partitions in the database. |
| A18: | B. Federated support is turned on using the dbm cfg parameter FEDERATED. |
| A19: | C. DB2NODE. |
| A20: | A. The CURRENT DBPARTITIONNUM special register provides this information. |
