Daily Tape usage query

[hmanegold]

Does anyone have a SQL query i can use to tell how much tape I am using per 24 hours

 

[PJ]

I'm afraid you'll have to be more specific than that.

PJ

 

[hmanegold]

Daily Tape Usage

well I am trying to come up with a query that will tell me how much tape is being used daily per node I have lots of good queries and I have made a visio of all the TSM tables and columns but I was wondering if someone has already made a select statement that shows tape usage per night per node

 

[PJ]

I wonder what you mean when you say "Tape Usage". Number of tapes? Number of Bytes stored in a Pool on tape?

PJ

 

[hmanegold]

Number of Bytes stored in a Pool on tape per 24 hour cycle

 

[nabildz]

can you share the visio file you created please

Many Thanks

 

[hmanegold]

TSM tables Visio

Yes I don't have it right here now I will have it tomorrow

 

[nabildz]

Much appreciated

 

[raj2618]

Hi Hmanegold,
Can you share the Visio diagram to me also? Thank you so much

Raj.

 

[THE_WIPET]

Hmanegold

i think this visio diagram will be very popular if you post it..

Thank you!

 

[hmanegold]

TSM Table Schema

Here are the tables in visio format if anyones interested

 

[THE_WIPET]

WOW!!!! thanks

 

[hmanegold]

Sorry about getting it posted so late but glad to help

I had some deadlines to meet before I could finish the diagram and post it

 

[[email protected]]

Thanks for the great Visio document.

What version of TSM server is documented?

Matt

 

[hmanegold]

the version of TSM is 5.5.0.3

 

[nabildz]

Good effort, well done and thanks for sharing

 

[luisvidal]

thanks for sharing the visio, hmanegold

 

[hmanegold]

sure what do you need help with

 

[MCharland]

Wee!!! thanks that a great chart. Now i need to do some exploring.

 

[meirf]

Thanks looked for this long time...