IBM.DB2.9.7.Advanced.Administration.Cookbook

sneng

thanks

sneng

thanks!!!

raizer

最近正在学习DB2呢~~~
感谢分享，帮我大忙了！

hanjsj

Thank you!

bupbechanh

nice, thanks !

boblin1

谢分享

dbsarva

Thanks

informixca

好东西！谢谢楼主！

zhangzongjun

SELECT
    M.EVMONNAME,
    CASE
       WHEN EVENT_MON_STATE(M.EVMONNAME) = 0 THEN 'Inactive'
       WHEN EVENT_MON_STATE(M.EVMONNAME) = 1 THEN 'Active'
    END AS STATUS,
    CASE M.TARGET_TYPE
        WHEN 'F' THEN 'File'
        WHEN 'T' THEN 'Table'
        WHEN 'P' THEN 'Piple'
        WHEN 'U' THEN 'Unformatted Event Table'
    END AS TARGET_TYPE,
    M.AUTOSTART,
    M.EVMON_ACTIVATES
FROM
    SYSCAT.EVENTMONITORS M , SYSCAT.EVENTS E
WHERE M.EVMONNAME = E.EVMONNAME
ORDER BY M.EVMONNAME;

zgdiyy

不错！！！！！！