Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Database Clone reduced !

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks,

    that means I need to reduce size of BPTEMP2.

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

    DBFinder

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •