How can I see the backup amount of one db2 schedule backup?

[jackyzhang]

The db2 schedule backup can be successfully finished.

And I also know the schedule start and end time.

But how can I know the backup amout of the db2 backup?

 

[rmazzon]

You can query the summary table using a select similar to this

select cast(sum(bytes)/1024/1024/1024 as decimal(9,3)) as "GB" from summary where entity='NODE_NAME' and start_time>'2012-07-25 18:00' and start_time<'2012-07-26 18:00'

Just insert the node name plus start and end dates and times. Depending on amount of data you may also want to adjust the cast function.

 

[moon-buddy]

You can query the summary table using a select similar to this

select cast(sum(bytes)/1024/1024/1024 as decimal(9,3)) as "GB" from summary where entity='NODE_NAME' and start_time>'2012-07-25 18:00' and start_time<'2012-07-26 18:00'

Just insert the node name plus start and end dates and times. Depending on amount of data you may also want to adjust the cast function.

I believe the post was for the delta of the DB2 backup done one the TSM DB2 database.