Results 1 to 2 of 2

Thread: Bufferpool

  1. #1
    Join Date
    Mar 2003

    Unanswered: Bufferpool

    hai all,
    When i tried to take the snapshot of bufferpools of my databases i got a result showing that it was not collected.While the same command worked on another server perfectly.

    Can anyone help me.

    Thanks in advance


  2. #2
    Join Date
    Mar 2003

    Re: Bufferpool

    By default, all monitor switches at the database manager and application level are turned off.
    You can check the status of monitor switches by:

    get database manager monitor switches

    If buffer pool activity information = off then you can issue following command from db2 comman line to turn on the bufferpool monitor swich:

    update dbm cfg using DFT_MON_BUFPOOL on

Posting Permissions

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