Hi,

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 ?

Thanks

What DB2 version and OS are you using?

Andy

We are at db2 9.1 FP4 .

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


Andy

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.

Thanks

Subtracting Date and time values result in a "time duration". Look it up in the manual.

Andy