We are on 13.10.07.10 and have been experiencing Database restarts (13) for the past month. All indications from support is it has to do with Viewpoint and they have requested we upgrade. We WILL Upgrade but it can't happen IMMEDIATELY. Until then to attempt to isolate the issue we have decided to turn off our Viewpoint services. With these not running is there a way (SQL or utility) to determine which sessions are Idle and how long they have been idle? I have tried using QRYSESSN, but it simple tells me the session is IDLE, not how long it has been in that state. ANY HELP at all will be greatly appreciated.
Hi SandyRumble, i think that is not posible without viewpoint, because viewpoint save the information for do this statistics, but there is a file where viewpoint have its queries that it use.
One way for do this is create a script where you save this information for realize this function.
sorry for not being able to help more.