How to calculate success rate from TSM where every backup is run through TWS

vivek.saini

ADSM.ORG Member
Joined
Jul 2, 2007
Messages
10
Reaction score
0
Points
0
PREDATAR Control23

I have TWS in my environment for scheduling and TSM for backup. Every backup is run by TWS. Now how can i calculate the backup success rate from TSM. Because q eve * * doesn't give the output as there is no schedule on TSM. Also how can i check whether the backup of particular node is successful or not.
 
PREDATAR Control23

The best method is to setup the Operation Center and set the "At-risk" policy to match your requirements. In the Operation Center Summary page, you will get the percentage of clients at-risk. At risks means they have not had a successful backup within the At-Risk criteria regardless how the backup is invoked.
https://www.ibm.com/support/knowled...srv.solutions/r_ssdisk_chklist_mon_daily.html

Then you can go a step further and get a report emailed daily that includes that too.
https://www.ibm.com/support/knowled...tions/t_msdisk_mon_oc_email_report_setup.html
 
PREDATAR Control23

I don't have access to Operation Center, can anything from command line to check miss/fail ?
 
PREDATAR Control23

The Operation Center is free with Spectrum Protect, you just need to install it, configure it, and start using it.

You can check the summary table and do some filtering. You can start with:
SQL:
select * from summary where activity in ('BACKUP','ARCHIVE')

You can add a WHERE clause and filter using START_TIME/END_TIME, also SUCCESSFUL (YES=successeful, NO=FAILED).

There's examples here: https://thobias.org/tsm/sql/ of not what you need to do, but the examples will help you with filtering on START_TIME and END_TIME.
 
PREDATAR Control23

The Operation Center is free with Spectrum Protect, you just need to install it, configure it, and start using it.

You can check the summary table and do some filtering. You can start with:
SQL:
select * from summary where activity in ('BACKUP','ARCHIVE')

You can add a WHERE clause and filter using START_TIME/END_TIME, also SUCCESSFUL (YES=successeful, NO=FAILED).

There's examples here: https://thobias.org/tsm/sql/ of not what you need to do, but the examples will help you with filtering on START_TIME and END_TIME.
Hello,
I don't know how to create teh sql statement, can you please provide me the sql statement adding WHERE.....
 
Top