Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2007
    Posts
    35

    Unanswered: Restoring from large database backup into small database .

    Hi All,
    I am working with db2v8.2.6 and aix5.3

    I want to restore from a production backup image (it has large bufferpool) into UAT area that does not enough memory to be replaced the bufferpool from backup image, how can I manage to do restore with small bufferpool ?

    Thank you in advance for your help.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Tips

    What you need to do is write a redirected restore script to restore the database on to the server you have. You can modify the tablespace sizings to suit your environment if you have less hard disk space.

    For the Bufferpools once you have restored the database you can connect and issue the ALTER BUFFERPOOL command to set them to the desired sizes.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Mar 2007
    Posts
    35
    Quote Originally Posted by nitingm
    What you need to do is write a redirected restore script to restore the database on to the server you have. You can modify the tablespace sizings to suit your environment if you have less hard disk space.

    For the Bufferpools once you have restored the database you can connect and issue the ALTER BUFFERPOOL command to set them to the desired sizes.

    Actuly for bufferpool case, I can not connect because UAT environment does not have enough memory to alocate to buffepool so system will be hanged.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You can use the DB2_OVERRIDE_BPF registry variable to temporarily specify smaller bufferpool size(s).
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by jsmit
    Actuly for bufferpool case, I can not connect because UAT environment does not have enough memory to alocate to buffepool so system will be hanged.
    That's not correct. If there is not enough memory, DB2 won't allocate those bufferpools and use really small buffer pool instead. So you can connect to the database and change the other buffer pool sizes to your liking.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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