Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: Online backup with compression - calculate rows read so far?

    Is there a way to get and calculate the number of rows currently ready by an online backup with compression?

    I realize you can look at "db2top" and see the % (which isn't a true % when running with compression) and it has the Rows/Read in GB. I want a summary count of the rows read on the database if possible. Maybe db2pd could be used somehow or an SQL to calculate this?

    Thank you.

    CC

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    the backup does not care about Rows. It just copies the pages. So you can't calculate the number of Rows backuped. "db2 list utilities show detail" gives an overview about the progress. The percentage for compressed backups are ... well ... inaccurate.

    Cheers

  3. #3
    Join Date
    Feb 2007
    Posts
    84
    Well db2top has the Delta RowsRead value for the backup, so somehow it calculates it by rows. So that is why I thought of "db2pd" command...

Posting Permissions

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