Re: [ADSM-L] SQL command to query Sessions with MediaWait or Idle

Hi,

the sql query I'd use would be something along the lines of:

select count(*) from sessions where state='MediaW' and WAIT_SECONDS>1800

(no spaces round the > to avoid output redirection).

Now, if you use a dsmadmc -tab -dataonly=y you'll get a nice piece of
output that you can use to determine whether or not to send e-mail ;-)
(or if you can, manually generate an snmp trap. You could even do nice
things like:

select avg(wait_seconds) from sessions where state='MediaW'

and feed that into whatever nice graphing tool you are using and
trigger when the average waiting time goes over some value. Of course,
what will you do when this happens. Both queries could be put in
graphs to see long-term development and aid in your buying decisions.

On 5 dec 2008, at 05:13, Cheung, Richard wrote:

Hello all

I am trying to figure out an effective way to get alerted if a backup
job is idle or not proceeding due to a MediaWait state.....  I want it
to have the smarts to maybe only alert me if it finds the same
successive node has been in the same MediaWait state for a
predetermined
period (eg an hour) - given that I am aware at different times an
occasional  'mediawait' warning is just part of normal function....

What is the best way of doing this?   I am thinking either running a
SQL
query of some sort to do this, then fire an email or netsend to
someone
- OR use SNMP..

Would welcome any suggestions or hints?



<html>
<body>
<font face="arial" color=#808080 size="-2"><img
alt="Santos Logo" src="http://www.santos.com/library/logo.gif";>
<br>Santos Ltd A.B.N. 80 007 550 923<br>
Disclaimer: The information contained in this email is intended only
for the use of the person(s) to whom it is addressed and may be
confidential or contain privileged information.
If you are not the intended recipient you are hereby notified that
any perusal, use, distribution, copying or disclosure is strictly
prohibited.
If you have received this email in error please immediately advise
us by return email and delete the email without making a copy.</font>
<font face="arial" color=#008000 size="-2">Please consider the
environment before printing this email</font>
</body>
</html>


--

Remco Post
r.post AT plcs DOT nl
+31 6 24821 622