| 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
|
