Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2012
    Posts
    120

    Unanswered: question on bufferpools

    Hi,
    I'm looking into a problem of a DB2 ESE 10.1 on Linux.
    I'd like to know which size is the default bufferpool which I know was changed with the command
    alter bufferpool ibmdefaultbp immediate size xxx automatic

    How can I know which xxx this DB is using?

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by Robert1973 View Post
    Hi,
    I'm looking into a problem of a DB2 ESE 10.1 on Linux.
    I'd like to know which size is the default bufferpool which I know was changed with the command
    alter bufferpool ibmdefaultbp immediate size xxx automatic

    How can I know which xxx this DB is using?

    Thanks
    If you want to know the current size of the bufferpool, use

    Code:
    select bp_name,BP_CUR_BUFFSZ FROM TABLE(MON_GET_BUFFERPOOL('',-2)) as bp

    MON_GET_BUFFERPOOL table function - Get buffer pool metrics
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2012
    Posts
    120
    thanks for the quick reply!

    I guess that is the current size, which may be different from the size that was set some weeks ago with the alter bufferpool statement (since it's automatic).

    Would it be possible to know the size that was originally set ?

    Thanks again

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Sorry, misunderstood your question .. It is logged in db2diag.log


    2013-03-15-07.22.00.681012+000 I2063E559 LEVEL: Info
    PID : 5097 TID : 140027149412096 PROC : db2sysc 0
    INSTANCE: opm NODE : 000 DB : OPM00
    APPHDL : 0-16596 APPID: *LOCAL.topmi01.130315071540
    AUTHID : OPM HOSTNAME: ip-10-35-71-37
    EDUID : 3509 EDUNAME: db2agent (OPM00) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
    MESSAGE : Altering bufferpool "CONTROL" From: "3604" <automatic> To: "5000"
    <automatic>


    If you want to capture such changes in the future, in DB2 10.1 , you can consider creating change history event monitors.

    Change history event monitoring
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    db2top -d sample
    press "b" and you'll see all the bufferpools with the actual value in pages
    press "m" and you'll see the total size of all bufferpools in Mb/Gb's
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    db2top -d sample
    press "b" and you'll see all the bufferpools with the actual value in pages
    press "m" and you'll see the total size of all bufferpools in Mb/Gb's
    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
  •