var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Database Clone reduced !
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
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.
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;
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...
that means I need to reduce size of BPTEMP2.
Reducing Pagesize may not be desireable as some objects may need that pagesize .