monitoring backup

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • krx
    #1

    monitoring backup

    Hello,

    Is there a way in DB2 or maybe a separate tool that will let us see
    how many pages DB2 has currently read while a backup operation is in
    progress.

    I understand "db2 list utilities show detail" shows the amount of work
    that is being done. But what exactly does "work" refer to over here -
    is that the number of pages that DB2 has to read?

    I'm trying to understand if the total pages read by DB2 is higher than
    the total pages it writes into the backup image (assuming that DB2
    reads up to the high watermark in the tablespace but only writes the
    pages that are non-free)

    Thanks in advance.
    Tags: None
    • Hardy
      #2
      Re: monitoring backup

      On 5ÔÂ30ÈÕ, ÉÏÎç3ʱ24·Ö, krx <kedar.she...@g mail.comwrote:
      Hello,
      >
      Is there a way in DB2 or maybe a separate tool that will let us see
      how many pages DB2 has currently read while a backup operation is in
      progress.
      >
      I understand "db2 list utilities show detail" shows the amount of work
      that is being done. But what exactly does "work" refer to over here -
      is that the number of pages that DB2 has to read?
      >
      I'm trying to understand if the total pages read by DB2 is higher than
      the total pages it writes into the backup image (assuming that DB2
      reads up to the high watermark in the tablespace but only writes the
      pages that are non-free)
      >
      Thanks in advance.
      Never heard about that kind of tools. "list utilities" works well for
      my need.

        Comment

        • Pierre StJ
          #3
          Re: monitoring backup

          There is more to the backup than pages of tablespaces. Most of the
          files in the database directory path are copied first to the image.
          Also, at the end, the SQLOGCTL.LFH file is copied.
          If you look in the System Monitor and Reference Guide you'll find what
          you need.
          You have to take a snapshot during the backup. Go to the DB2 Info.
          Center and search on "direct reads" monitor element for add'l info.
          I would think that the db2pd command also has info generated on this.
          I didn't search.
          Regards, Pierre.

          On May 29, 9:57 pm, Hardy <wyh...@gmail.c omwrote:
          On 5ÔÂ30ÈÕ, ÉÏÎç3ʱ24·Ö, krx <kedar.she...@g mail.comwrote:
          >
          >
          >
          >
          >
          Hello,
          >
          Is there a way in DB2 or maybe a separate tool that will let us see
          how many pages DB2 has currently read while a backup operation is in
          progress.
          >
          I understand "db2 list utilities show detail" shows the amount of work
          that is being done. But what exactly does "work" refer to over here -
          is that the number of pages that DB2 has to read?
          >
          I'm trying to understand if the total pages read by DB2 is higher than
          the total pages it writes into the backup image (assuming that DB2
          reads up to the high watermark in the tablespace but only writes the
          pages that are non-free)
          >
          Thanks in advance.
          >
          Never heard about that kind of tools. "list utilities" works well for
          my need.- Hide quoted text -
          >
          - Show quoted text -

            Comment

            Previous template Next
            Working...