Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    Unanswered: Adding Memory and testing if new memory will be used

    We are are on DB2 9.7 LUW with AIX 6.1. We would like to add 1 GB of memory and would like to test in our TEST environment to see if it will use this new memory. We don't have much running on our Test environment.

    I realize if we only run one or two SQLs or processes it will just pick up memory in the bufferpools and not much will share this memory with many other processes, and probably won't tell us much if this new memory will be used.

    Is there anything that could be used or run on db2 to tell us if this new memory will be used and run faster? Have any of you done this before and what did you use and do?

    Thank you so much for your DB2 expert help!


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    If we add memory, I usually give a significant amount to the bufferpools.


  3. #3
    Join Date
    Jan 2009
    Zoetermeer, Holland
    db2top option "m" gives a nice overview
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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