Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Lightbulb Unanswered: Bufferpool - Real memory

    Hi Friends,

    Is bufferpool created only in Real memory or can it be also created in virtual memory ?

    Thanks,
    panditt

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    DB2 is the real thing, and therefore only uses real memory. If you don't have enough real memory (or are allocating too much memory for DB2), you are likely to encounter some very serious problems with DB2, including possible instance crash.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    To be precise, in any modern operating system all memory is virtual. In theory you could create a bufferpool that exceeds the amount of available real memory, but that would be like shooting yourself in the foot with a Gatling gun, as Marcus mentioned.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Jul 2009
    Location
    USA
    Posts
    53
    Is bufferpool pinned in real memory or can it be paged out?

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    As far as I know, db shared memory (including bufferpools) is only pinned on Solaris. There is a registry variable that will allow you to pin it on other Unix/Linux platforms. Please take a look at db2_pinned_bp if you're interested. Note that this registry variable will not just pin the bufferpools but the entire db shared memory set.

  6. #6
    Join Date
    Aug 2008
    Posts
    76

    Thanks a lot..

    Thanks a lot friends !!! Thanks for all the explanation. My question is answered.


    Thanks
    Panditt

Posting Permissions

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