No Victim Buffers Available

Mark Horrocks

No Victim Buffers Available
Hi,







Over a period of 11 days I have seen the snapshot monitor database element
'No Victim Buffers Available' clock up to 900 million.











I am using UDB V8 on Aix.











My view is that the NUM_IOCLEANERS need increasing and the bufferpools
increasing.







Anybody else got ideas.







Thanks.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mark Horrocks

No Victim Buffers Available
(in response to Mark Horrocks)
Hi,







Over a period of 11 days I have seen the snapshot monitor database element
'No Victim Buffers Available' clock up to 900 million.











I am using UDB V8 on Aix.











My view is that the NUM_IOCLEANERS need increasing and the bufferpools
increasing.







Anybody else got ideas.







Thanks.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Gunning

Re: No Victim Buffers Available
(in response to Mark Horrocks)
Bufferpool increase would be my first move, num_iocleaners second, but not
more than number of cpus. Also, look at

Buffer pool data writes = 14250

Asynchronous pool data page writes = 14250



They should be close, if buffer pool data writes is much higher, you should
increase num_iocleaners. Another possibility is using alternate page
cleaning.





Phil



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of [login to unmask email]
Sent: Tuesday, December 18, 2007 11:36 AM
To: [login to unmask email]
Subject: [DB2-L] No Victim Buffers Available



Hi,







Over a period of 11 days I have seen the snapshot monitor database element
'No Victim Buffers Available' clock up to 900 million.











I am using UDB V8 on Aix.











My view is that the NUM_IOCLEANERS need increasing and the bufferpools
increasing.







Anybody else got ideas.







Thanks.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at
< http://www.idug.org/lsidug > www.idug.org under the Listserv tab. While at
the site, you can also access the IDUG Online Learning Center, Tech Library
and Code Place, see the latest < http://www.idug.org/lsconf > IDUG conference
information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on < http://www.idug.org/lsms > Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

David G Stritzinger

Re: No Victim Buffers Available
(in response to Philip Gunning)
How many page cleaners do you currently have? What size is your buffer
pools? Also you may want to check out the CHNGPGS_THRESH in your db cfg
and not sure what version of DB2 8 you are on, you may want to check out
the "Proactive Page Cleaning" by setting the
DB2_USE_ALTERNATE_PAGE_CLEANING instance variable.

Your mileage can and will vary.


David Stritzinger

(804) 965-7166 (Office Number)

(804) 334-3629 (Cell Number)





________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Tuesday, December 18, 2007 11:36 AM
To: [login to unmask email]
Subject: [DB2-L] No Victim Buffers Available



Hi,







Over a period of 11 days I have seen the snapshot monitor database
element 'No Victim Buffers Available' clock up to 900 million.











I am using UDB V8 on Aix.











My view is that the NUM_IOCLEANERS need increasing and the bufferpools
increasing.







Anybody else got ideas.







Thanks.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms