TDP Oracle Reports - Are there any?

[beansontoast]

Hi Everyone,

Bit of a noob question here.

I am trying to look at our TDPO backups in greater detail as I have the need to size up for moving to a new STG, specifically for TDPO.

In the overnight report I see the nodename and filesize, and thats about it.

Is there is report available anywhere, which can provide any database-specific backup information, such as instance name, nature of backup (can we\ do we do fulls for Oracle?).

The more information the better.
Having looked in the Operational Reports section, I can't see any available reports.

Can you please recommend how I can find the information that I am looking for.

Running TSM 6.3.3.

Thanks in advance ...

 

[marclant]

Not sure how TDPO backups are stored, but some of these commands may help you:
query nodedata {nodename}
query occupancy {nodename}
select * from summary where entity='NODENAME'
** the node name in the select must be in uppercase

Maybe this can help you too: http://thobias.org/tsm/sql/#toc68 You could add a "where entity='NODENAME'" to the queries to get just from one node too.