Use the database snapshot to determine whether the LOGBUFSZ parameter is optimal or not by looking at the lines shown in the following example:
Log pages read = 0
Log pages written = 12644
In general, the ratio between "log pages read" and "log pages written" should be as small as possible. An ideal value would be zero log pages read while seeing a good number of log pages written. When there are too many log pages read, it means a bigger LOGBUFSZ is needed.
Originally posted by mcdb2
When I took snapshot on db2 database, I got ,
log pages read =20. Could you please explain what does this mean &
How to rectify it?
Visit the new-look IDUG Website , register to gain access to the excellent content.
I have suspected that we should increase the logbufsz for our database, so this article is of special interest to me. I am a little curious, because the sytem monitor guide does not mention that this conclusion can be drawn in conjunction with the log pages written element. Can you please paste the link to the db2dd article?