It is my understanding that the self-tuning only occurs after an expiration
process and that it uses BUFPOOLSIZE in the options file as a starting
point. Try doubling the BUFPOOLSIZE parameter and then stopping and
restating the server.

     Al

Alan Davenport
Senior Storage Administrator
Selective Insurance
alan.davenport AT selective DOT com
(973)948-1306


+ -----Original Message-----
+ From: Prather, Wanda [mailto:Wanda.Prather AT JHUAPL DOT EDU]
+ Sent: Monday, November 05, 2001 4:45 PM
+ To: ADSM-L AT VM.MARIST DOT EDU
+ Subject: SELFTUNEBUF & ANR0380W
+
+
+ I've seen this message several times today:
+
+ ANR0380W The database buffer pool recovered from an
+ overcommit of number of
+ pages pages. Consider increasing your buffer pool size by
+ kilobytes needed
+ kilobytes under current server load.
+
+ However we have SELFTUNEBUFPOOLSIZE set to YES.
+ Shouldn't SELFTUNEBUFPOOLSIZE take care of increasing the
+ buffer pool size?
+