1: | What command should you use to display the actual names of DB2 processes on Solaris (i.e., not just db2sysc)? |
2: | What is the db2fmp process, and why is it executed outside of the address space of the DB2 engine? |
3: | What DB2 process flushes the data in the buffer pool to disk? |
4: | What kind of environment do DB2 subagents exist in? |
5: | What happens to a subagent when it completes its work? |
6: | If MAXAGENTS is set to 100, does this mean there is a maximum of 100 agents per instance, or per database? |
7: | What are the four types of DB2 agents? |
8: | What tool can you use to monitor the DB2 agent usage? |
9: | If NUM_INITAGENTS=3 and NUM_POOLAGENTS=5, how many db2agntp processes will be created when an instance is started?
|
10: | With the following settings, how many applications can execute concurrently?
MAXCONNECTIONS = 200 MAXCAGENTS = 100 MAX_COORDAGENTS = 200
|
11: | In a partitioned environment with four partitions, how many DB2 system controller processes are started when the instance starts?
|
12: | Which of the following parameters controls the number of idle agents?
|
13: | With the connection concentrator disabled, how many db2agent processes are assigned to service an application that is connected to a database with four partitions?
|
14: | Which of the following database configuration parameters controls the number of prefetchers?
|
15: | Which of the following is the DB2 system controller process?
|
16: | Which of the following is responsible for handling local client connections?
|
17: | Given the following Database Manager Configuration information:
Max number of existing agents (MAXAGENTS) = 100 Agent pool size (NUM_POOLAGENTS) = 20 Initial number of agents in pool (NUM_INITAGENTS) = 10 Max number of coordinating agents (MAX_COORDAGENTS) = 100 Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS what is the maximum number of concurrent connections possible to all databases in this instance?
|
18: | Which of the following is not a DB2 agent process?
|
19: | In which of the following cases will the connection concentrator be enabled?
|
20: | Which of the following processes will be seen when you enable the DB2 governor?
|