星期五, 9月 03, 2010

Buffer pools in DB2 UDB

1. When you configure a buffer pool from the Control Center, what must you do to configure the Create Buffer Pool dialog box so that the buffer pool is only created when all connections to the database are closed?

Configure the dialog box to create the buffer pool immediately
Configure the dialog box to create the buffer pool when the database restarts
Configure the dialog box to store pages in extended memory



2. Suppose you want to change the page size of a buffer pool called CLIENT_BP to 550. Which command do you execute to change the page size of the buffer pool?

ALTER BUFFERPOOL CLIENT_BP 550;
ALTER BUFFERPOOL CLIENT_BP PAGESIZE 550;
ALTER BUFFERPOOL CLIENT_BP SIZE 550;




3. Suppose you want to create a buffer pool - SALES_BP - that contains 350 pages and services tablespaces that use a page size of 8192 bytes.
Which code do you need to execute to create this buffer pool?

CREATE BUFFERPOOL SALES_BP SIZE 8 PAGESIZE 350K;
CREATE BUFFERPOOL SALES_BP SIZE 350 PAGESIZE 8192K;
CREATE BUFFERPOOL SALES_BP SIZE 350 PAGESIZE 8K;
CREATE BUFFERPOOL SALES_BP SIZE 8192 PAGESIZE 350K;




4. What is the function of the buffer pool?

Cache data pages
Free up memory space
Improve database system performance
Write dirty pages to the hard drive