We're encountering a "too many open cursors issue" on DB2/LUW.
Is there any way to get a (database-server-side) list of the corresponding SELECT statements related to these open cursors?
We're doing that on Oracle all the time.
I know we could review the application logic but that is an awful lot harder in our particular case. So I wanted to get this question out first. Thanks.