Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  buffers count is always the same

    Posted 11/15/21 10:13 AM
    Hello to All

    using statement below on sysmaster, the number of buffers is always equal to those configured 'BUFFERPOOL', does it mean that i have to increase buffers ?

    SELECT COUNT(*) AS pages_used
    FROM sysbufhdr
    WHERE bufsize = 4096
    AND bflags != 4;

    found here : https://www.ibm.com/support/pages/how-do-i-know-if-my-buffers-are-overallocated


    thanks

    ------------------------------
    John Smith
    ------------------------------

    #Informix


  • 2.  RE: buffers count is always the same

    Posted 11/15/21 12:07 PM
    John:

    No, it just means that you don't have too many buffers. Whether you have enough is a different question and doesn't depend on there being unused buffers. You can have no unused buffers and be doing just fine.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



Related Content