monitoring backup

[krx]

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.

[Hardy]

On 5ÔÂ30ÈÕ, ÉÏÎç3ʱ24·Ö, krx <[e-mail]:

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.

[Pierre StJ]

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 <[e-mail]:

On 5ÔÂ30ÈÕ, ÉÏÎç3ʱ24·Ö, krx <[e-mail]:

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 -