TSM Database Backup Rate

From Wikistix
Jump to: navigation, search

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

Misinformation found herein copyright Paul Ripke (aka “stix”) stixpjr@gmail.com.