.254.8904
Internet
richard.che...@santos.com
Sent by: ADSM-L@VM.MARIST.EDU
12/04/2008 11:13 PM
Please respond to
ADSM-L@VM.MARIST.EDU
To
ADSM-L
cc
Subject
[ADSM-L] SQL command to query Sessions with MediaWait or Idle
Hello all
I am trying to figure out an effective way to get alerted if
>>select avg(wait_seconds) from sessions where state='MediaW'<<
Is there a join that would give an average per library or devclass or domain?
David
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 determ
Try
select * from sessions
and see if that gives you what you need
Steven Harris
Tivoli Storage Manager SME
Backup & Recovery Team
Storage Services Group
Cumberland Forest
Phone:
IBM Internal :70-75130 External:02 9407 5130
Mobile: 0422 932 065
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
