Learning Visually with Examples [Electronic resources]

Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow

نسخه متنی -صفحه : 312/ 187
نمايش فراداده

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