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? 3 5 0 8
|
10: | With the following settings, how many applications can execute concurrently? MAXCONNECTIONS = 200 MAXCAGENTS = 100 MAX_COORDAGENTS = 200 100 200 300 500
|
11: | In a partitioned environment with four partitions, how many DB2 system controller processes are started when the instance starts? 1 2 3 4
|
12: | Which of the following parameters controls the number of idle agents? MAXAGENTS NUM_POOLAGENTS NUM_INIAGENTS MAXCAGENTS
|
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? 1 2 3 4
|
14: | Which of the following database configuration parameters controls the number of prefetchers? NUM_IOCLEANERS NUM_IOSERVERS NUM_INITAGENTS NUM_PREFETCHERS
|
15: | Which of the following is the DB2 system controller process? db2wdog db2gds db2sys db2sysc
|
16: | Which of the following is responsible for handling local client connections? db2ipccm db2tcpdm db2tcpcm db2local
|
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? 10 20 100 200
|
18: | Which of the following is not a DB2 agent process? db2agent db2agntp db2agnta db2agnti
|
19: | In which of the following cases will the connection concentrator be enabled? MAX_CONNECTIONS = 10 and MAX_COORDAGENTS = 10 MAX_CONNECTIONS = 10 and MAX_COORDAGENTS = 100 MAX_CONNECTIONS = 100 and MAX_COORDAGENTS = 10 MAX_CONNECTIONS = MAX_COORDAGENTS and MAX_COORDAGENTS = 1000
|
20: | Which of the following processes will be seen when you enable the DB2 governor? db2gov db2govd Governor db2governor
|