TSM Database Backup Rate

From Wikistix

IBM recommends that the TSM database backup rate be greater than 5000000 pages per hour. The following TSM SQL query to display the database backup rate from recent database backups:

select activity, -
  cast ((end_time) as date) as "Date", -
  (examined/cast ((end_time-start_time) seconds as decimal (18,13))*3600) "Pages/Hr" -
from summary -
where activity='FULL_DBBACKUP' and days (end_time) - days (start_time) = 0