monitoring backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

krx - 29 May 2008 20:24 GMT

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.

Reply to this Message

Hardy - 30 May 2008 02:57 GMT

> Hello,
>
[quoted text clipped - 12 lines]
>
> Thanks in advance.

Never heard about that kind of tools. "list utilities" works well for
my need.

Reply to this Message

Pierre StJ - 30 May 2008 03:08 GMT

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.

> > Hello,
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Reply to this Message