Learning Visually with Examples [Electronic resources]

Which tools can be used to display the memory used by DB2, and how it is associated with the DB2 configuration parameters?

What database configuration parameter can reserve shared memory in a 32-bit environment to allow dynamic increases to the amount of shared memory used?

Which parameter can be increased in a dynamic SQL environment to allow applications to reuse the compiled statements of other applications?

Which of the sort heap thresholds is a hard limit?

What is the maximum amount of time that can elapse between one flush of the log buffer to disk and the next one?

How can you tell the current total amount of shared memory used by a database?

What is the largest client I/O block allowed by DB2?

What memory is allocated when you start your DB2 instance?

When is the database-level shared memory allocated?

For what purpose are the FCM buffers used?

How many buffer pools will a database have by default immediately after it is created?

1. 1

2. 2

3. 3

4. 4

5. 5

Under which of the following conditions will application group memory not be used?

1. DB2MEMDISCLAIM=ON

2. INTRA_PARALLEL=ON

3. Connection concentrator is enabled

4. The database has multiple partitions

Which of the following is not part of the database shared memory?

1. Lock list

2. Shared sort heap threshold

3. Package cache

4. Statistics heap

Given the following configuration information:

Max size of appl. group mem set (4KB)   (APPGROUP_MEM_SZ) = 10000
Max appl. control heap size (4KB)       (APP_CTL_HEAP_SZ) = 512
Percent of mem for appl. group heap     (GROUPHEAP_RATIO) = 30

how large will the application group shared heap be?

1. 3,000 pages

2. 30,000 pages

3. 300,000 pages

4. 15,360 pages

Given the following configuration information:

Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000
Max appl. control heap size (4KB)         (APP_CTL_HEAP_SZ) = 512
Percent of mem for appl. group heap      (GROUPHEAP_RATIO) = 60

if there are 300 applications, how many application groups will be needed?

1. 1

2. 5

3. 6

4. 10

Given the following configuration information:

Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 2000
Sort list heap (4KB)                         (SORTHEAP) = 256

how many concurrent shared sorts can occur within memory for this database?

1. 1

2. 5

3. 7

4. 8

5. Unlimited

Given the following configuration information:

Sort heap threshold (4KB)          (SHEAPTHRES) = 2000
Sort list heap (4KB)                         (SORTHEAP) = 256

how many concurrent private sorts can occur within memory for this database?

1. 1

2. 5

3. 7

4. 8

5. Unlimited

Which of the following is not part of the database manager shared memory?

1. DB2 trace

2. Event Monitors

3. DB2 audit facility

4. Buffer pools

Given the following output of the

get db cfg command on a 32-bit DB2 instance:

Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(75264)

how large would the DATABASE MEMORY need to be to allocate a new 16K page size buffer pool, with a size of 10,000 pages?

1. 75264

2. 85264

3. 100000

4. 125000

Given the following output of the memory tracker tool:

db2mtrk -i -p -v 
Tracking Memory on: 2005/03/28 at 13:47:43 
Memory for instance 
Backup/Restore/Util Heap is of size 16384 bytes 
Package Cache is of size 81920 bytes 
Catalog Cache Heap is of size 65536 bytes 
Buffer Pool Heap is of size 1179648 bytes 
Buffer Pool Heap is of size 655360 bytes 
Buffer Pool Heap is of size 393216 bytes 
Buffer Pool Heap is of size 262144 bytes 
Buffer Pool Heap is of size 196608 bytes 
Lock Manager Heap is of size 278528 bytes 
Database Heap is of size 3637248 bytes 
Database Monitor Heap is of size 180224 bytes 
Other Memory is of size 7733248 bytes 
Total: 14680064 bytes 

which of the following is definitely not true for this database?

1. There is at least one application connected to the database.

2. A backup or restore is occurring.

3. The database has five user-created table spaces.

4. The instance has been started.