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------------------------------
Original Message:
Sent: Mon November 15, 2021 10:13 AM
From: John Smith
Subject: buffers count is always the same
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