adilsonrapozojr
1/24/2018 - 9:21 PM

Get utilities app-handle

SELECT MEMBER
    ,UTILITY_ID
    ,APPLICATION_HANDLE
    ,timestampdiff ( 4, varchar(timestamp(current timestamp) - timestamp(UTILITY_START_TIME)) ) as DURATION
    ,UTILITY_TYPE
    ,utility_operation_type
    ,OBJECT_TYPE
    ,substr(rtrim(OBJECT_SCHEMA) || '.' || OBJECT_NAME,1,65) as OBJECT
    FROM TABLE(mon_get_utility(-2))