How to Query Backed up files on TSM database

[ryanbsc]

HI guys


I want to be able to find what files where backed up and their sizes .
I've been told the TSM database will store these kind of details.


As the other night I seen TSM trying to back up 7, and 10 GIG files, and I'd like to know what they were, so I can figure out where they came from.


Can someone explain to me how I query the database and how I find the relavent informaiton that I need?


Thanks

 

[toxy13]

you can do something like:

select * from contents
or
select FILE_NAME,FILE_SIZE from contents

but it will generate a big big output, be carefull

 

[ryanbsc]

Thank y ou

Thank you very much.

How do I access the TSM database, do I log into tsm first.

I forgot ot mention , its running on AIX 5.3


Thanks..

 

[toxy13]

you can access the tsm database via dsmadmc (tsm admin console)

(or webinterface like isc/admin center)

 

[ryanbsc]

time specific

Ahh I found it, I had to log into TSM , and it accepts SQL commands..whoo hoo


also is there a command that would produce the details I need

I.e file name, file size, between a specific time range?

I.e yesterday between 5pm and 10pm?



Thank you

 

[ryanbsc]

thanks toxy

thanks toxy, found how to run that command, ......a bit scare to run that sql incase it bombs TSM

 

[toxy13]

no sorry, in the content table there is now specific time range to select!

 

[ryanbsc]

Thank you

Thank you toxy , really appreciate that.


Is there a way then to have it query only the last say 2000 records?So That I don't have to go through ALLL of the records?.


Thanks

 

[ryanbsc]

this the only wya?

I take it this is the only way to find out what files where backed up and the sizes?


Thanks

 

[toxy13]

select FILE_NAME,FILE_SIZE from contents order by FILE_SIZE DESC

ASC
Specifies that the columns are sorted in ascending order.
DESC
Specifies that the columns are sorted in descending order. -> you see the biggest files at first

 

[ryanbsc]

fantastic

Great Toxy

Thank you, I shall give that a bash and hopefully won't kill my TSM server.

Thank y oua gain for all your help.

 

[ryanbsc]

How to stop it

Sorry forgot to ask


How do I stop it doing the query ? if it starts to take to long and take up to much resource?

 

[ryanbsc]

to a file

Oh and last thing sorry, is there a way to make it out put to a file ? so I can then read through that file?

 

[toxy13]

if you start the query, you'll get the ouput on your screen, at the end of your screen you see:

(<ENTER> to continue, 'C' to cancel)

Press "C" + Enter

the output will stop, this will take a short while (ca. 1 minute) for a very large oupt

 

[toxy13]

for example:

 

[ryanbsc]

this is what I have

Hi Toxy

Thanks for tha tip

I ran that query and this is what it done :-

tsm: NODEA_TSM>select FILE_NAME,FILE_SIZE from contents order by FILE_SIZE DESC
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) Y


And now its just blank after that....I assume that it has to do the query firsttttt which can take a while before out putting?
Is there a way to kill this process in the event it takes too long with no out put yet happening?

 

[toxy13]

Oh and last thing sorry, is there a way to make it out put to a file ? so I can then read through that file?

yeah you can redirect it:

select FILE_NAME,FILE_SIZE from contents order by FILE_SIZE DESC > {your path}

BUT: you can not cancel, the redirection!

 

[toxy13]

Hi Toxy

Thanks for tha tip

I ran that query and this is what it done :-

tsm: NODEA_TSM>select FILE_NAME,FILE_SIZE from contents order by FILE_SIZE DESC
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) Y


And now its just blank after that....I assume that it has to do the query firsttttt which can take a while before out putting?
Is there a way to kill this process in the event it takes too long with no out put yet happening?

yes you can, in the "worst case" you need to press ctrl + c to stop/break your commanline

 

[ryanbsc]

:d

Thanks again toxy....really appreciate all your help.

I hope it produces some output soon

 

[toxy13]

I hope it produces some output soon

I hope so