Database Clone reduced !

DBFinder · #1 (**permalink**) 02-23-09, 11:59

Hi,

Creating similar database fails because of bufferpool mapping:

Yesterday I created a test database on my test machine.
Smaller server and smaller memory hence smaller data.

I did 1/10 the of data selectively and then decreased the tablespaces accordingly.

I need help to bring bufferpool down according to the memory on target server.

So basically I am cloning database with 1/10 reduction.

Following is a bufferpool def extract from

Code:

CREATE BUFFERPOOL "BPTEMPORARY"  SIZE 25000 PAGESIZE 4096 NOT EXTENDED STORAGE;

CREATE BUFFERPOOL "BPSYSCATALOG"  SIZE 20000 PAGESIZE 4096 NOT EXTENDED STORAGE;

CREATE BUFFERPOOL "BPTEMP2"  SIZE 200000 PAGESIZE 16384 NOT EXTENDED STORAGE;

CREATE BUFFERPOOL "BP32K"  SIZE 4000 PAGESIZE 32768 NOT EXTENDED STORAGE;

Please advise me to change a parameter so that it can fit in 1.5G physical memory as opposed to 16G physical memory on production server.

Thank
DBFinder

ARWinner · #2 (**permalink**) 02-23-09, 12:56

Let see...

BPTEMPORARY = 25000 @ 4096 = 102.4 MB
BPSYSCATALOG = 20000 @ 4096 = 81.92 MB
BPTEMP2 = 200000 @ 16384 = 3.277 GB
BP32K = 4000 @ 32768 = 131 MB

Look at BPTEMP2...

Andy

DBFinder · #3 (**permalink**) 02-23-09, 13:03

Thanks,

that means I need to reduce size of BPTEMP2.

Reducing Pagesize may not be desireable as some objects may need that pagesize .

DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech