Overview of leaked/unclosed cursors/statements on DB2 LUW server?
SELECT 
  application_handle
, uow_id, activity_id, activity_type, activity_state
, timestampdiff(2, char(current timestamp - entry_time)) elapsed_sec
, stmt_text
FROM TABLE(MON_GET_ACTIVITY(null, -2))
order by elapsed_sec desc;


MON_GET_ACTIVITY table function - Return a list of activities