TSM monitoring queries...

[DevNull]

Greetings,



I've been tasked to design and implement a UNIX-based monitoring program that will periodically issues several queries to the server through dsmadmc and alert the necessary folks in the event of an issue or problem. Writing the interface, logic, and all that isn't a problem but the question I have for all of you is:



What queries should I include that will have information or results that a TSM admin would like to be notified of?



For Example:

1) "select LIBRARY_NAME as "Library", count(*) as "SCRATCH" from

libvolumes where UPPER(status) = 'SCRATCH' group by LIBRARY_NAME" - Shows individual scratch counts for multiple library TSM environments.



I appreciate any help! Thanks in advance.

 

[tdp_ora]

Hi,

Perodically the TSM admin should Monitor ,

1) the No of Scratch TApes,

2) The DB Size

3) the recovery log

4) the cache hit ratio

5) the client sched

5) track the drives online/offline

6) track the DRM Status

7) check for the DB backup . :-o