14.10. Review Questions

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?

  1. 3

  2. 5

  3. 0

  4. 8

10:With the following settings, how many applications can execute concurrently? 
MAXCONNECTIONS = 200
MAXCAGENTS = 100
MAX_COORDAGENTS = 200

  1. 100

  2. 200

  3. 300

  4. 500

11:In a partitioned environment with four partitions, how many DB2 system controller processes are started when the instance starts?

  1. 1

  2. 2

  3. 3

  4. 4

12:Which of the following parameters controls the number of idle agents?

  1. MAXAGENTS

  2. NUM_POOLAGENTS

  3. NUM_INIAGENTS

  4. 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. 1

  2. 2

  3. 3

  4. 4

14:Which of the following database configuration parameters controls the number of prefetchers?

  1. NUM_IOCLEANERS

  2. NUM_IOSERVERS

  3. NUM_INITAGENTS

  4. NUM_PREFETCHERS

15:Which of the following is the DB2 system controller process?

  1. db2wdog

  2. db2gds

  3. db2sys

  4. db2sysc

16:Which of the following is responsible for handling local client connections?

  1. db2ipccm

  2. db2tcpdm

  3. db2tcpcm

  4. 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?

  1. 10

  2. 20

  3. 100

  4. 200

18:Which of the following is not a DB2 agent process?

  1. db2agent

  2. db2agntp

  3. db2agnta

  4. db2agnti

19:In which of the following cases will the connection concentrator be enabled?

  1. MAX_CONNECTIONS = 10 and MAX_COORDAGENTS = 10

  2. MAX_CONNECTIONS = 10 and MAX_COORDAGENTS = 100

  3. MAX_CONNECTIONS = 100 and MAX_COORDAGENTS = 10

  4. MAX_CONNECTIONS = MAX_COORDAGENTS and MAX_COORDAGENTS = 1000

20:Which of the following processes will be seen when you enable the DB2 governor?

  1. db2gov

  2. db2govd

  3. Governor

  4. db2governor

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.103.154