Richard,
This is what I made to let me know what session is holding up what process
because it's waiting for media.. Maybe this is what you are looking for?
select sessions.SESSION_ID, sessions.CLIENT_NAME,
sessions.OUTPUT_VOL_ACCESS,processes.process_num as
PROCESS_NUM,processes.process,
Hi,
the sql query I'd use would be something along the lines of:
select count(*) from sessions where state='MediaW' and WAIT_SECONDS1800
(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
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
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
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