| 1: | Which tools can be used to display the memory used by DB2, and how it is associated with the DB2 configuration parameters? |
| 2: | What database configuration parameter can reserve shared memory in a 32-bit environment to allow dynamic increases to the amount of shared memory used? |
| 3: | Which parameter can be increased in a dynamic SQL environment to allow applications to reuse the compiled statements of other applications? |
| 4: | Which of the sort heap thresholds is a hard limit? |
| 5: | What is the maximum amount of time that can elapse between one flush of the log buffer to disk and the next one? |
| 6: | How can you tell the current total amount of shared memory used by a database? |
| 7: | What is the largest client I/O block allowed by DB2? |
| 8: | What memory is allocated when you start your DB2 instance? |
| 9: | When is the database-level shared memory allocated? |
| 10: | For what purpose are the FCM buffers used? |
| 11: | How many buffer pools will a database have by default immediately after it is created? 1 2 3 4 5
|
| 12: | Under which of the following conditions will application group memory not be used? DB2MEMDISCLAIM=ON INTRA_PARALLEL=ON Connection concentrator is enabled The database has multiple partitions
|
| 13: | Which of the following is not part of the database shared memory? Lock list Shared sort heap threshold Package cache Statistics heap
|
| 14: | 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? 3,000 pages 30,000 pages 300,000 pages 15,360 pages
|
| 15: | 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 5 6 10
|
| 16: | 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 5 7 8 Unlimited
|
| 17: | 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 5 7 8 Unlimited
|
| 18: | Which of the following is not part of the database manager shared memory? DB2 trace Event Monitors DB2 audit facility Buffer pools
|
| 19: | 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? 75264 85264 100000 125000
|
| 20: | 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? There is at least one application connected to the database. A backup or restore is occurring. The database has five user-created table spaces. The instance has been started.
|
