Section 14.10. Review Questions


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



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net