Informix

  • 1.  buffers count is always the same

    Posted 18 days ago
    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
    ------------------------------


  • 2.  RE: buffers count is always the same

    Posted 18 days ago
    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
    ------------------------------