buffers count is always the same
Posted in 2021
Topics: High Availability & Replication
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
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 ------------------------------