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?
|
12: | Under which of the following conditions will application group memory not be used?
|
13: | Which of the following is not part of the database shared memory?
|
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?
|
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?
|
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?
|
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?
|
18: | Which of the following is not part of the database manager shared memory?
|
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?
|
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?
|