Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    33

    Unanswered: db2 -log pages read

    Hi all,

    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?


    Thanks,
    mc

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2 -log pages read

    From a db2dd article :

    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.


    Cheers

    Sathyaram

    Originally posted by mcdb2
    Hi all,

    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?


    Thanks,
    mc
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    Satyaram,

    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?

    Thanks in advance.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2 -log pages read

    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Aug 2003
    Posts
    33
    Thanks a lot for sharing information

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •