var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need script to send email if application is in waiting more than 10 hours
As per our current requirement we need to implement a script which will send eamil alert about the applications which are in UOW waiting state for around 10 hours.
Currenlty ia m trying to use
db2 list applications show detail command and from the output we have to compare the status change time stamp to the current timestamp.
But i am unable to compare it.
Does anybody has better idea about it ?
What DB2 version and OS are you using?
You could use the administrative views to calculate the result set:
select * from sysibmadm.applications where appl_status = 'UOWWAIT' and snapshot_timestamp - status_change_time >= 100000
Thanks for quick reply...
Just one more query :
Is 100000 is difference in seconds ?
If yes then for 10 hour it should be 10X60X60=36000 .
Please correct me if i am wrong.
Subtracting Date and time values result in a "time duration". Look it up in the manual.