Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Statement event monitoring.

    Hi,

    Not able to figure out why Statement level event monitring is not working.

    Any idea ?

    Here are the steps I am following .

    Update monitor switches using statement on
    create event monitor test for statements where auth_id='xxx' write to file 'c:\test\'
    set event monitor test state=1
    connect to xxx user xxx using 'xxx'
    bunch of sqls ...
    connect reset.

    db2evmon -path c:\test > xxx.txt
    But I don't see any SQL statements in that file...

    Thanks
    Anil

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Statement event monitoring.

    First thing you need to do is check whether your monitor is active

    SELECT EVMONNAME,
    CASE
    WHEN EVENT_MON_STATE(EVMONNAME) = 0 THEN 'Inactive'
    WHEN EVENT_MON_STATE(EVMONNAME) = 1 THEN 'Active'
    END
    FROM SYSCAT.EVENTMONITORS

    Before you do a db2evmon try

    FLUSH EVENT MONITOR TEST BUFFER

    Tell us if you are successful in seeing the db2evmon output

    Sathyaram

    Originally posted by anilsahoo
    Hi,

    Not able to figure out why Statement level event monitring is not working.

    Any idea ?

    Here are the steps I am following .

    Update monitor switches using statement on
    create event monitor test for statements where auth_id='xxx' write to file 'c:\test\'
    set event monitor test state=1
    connect to xxx user xxx using 'xxx'
    bunch of sqls ...
    connect reset.

    db2evmon -path c:\test > xxx.txt
    But I don't see any SQL statements in that file...

    Thanks
    Anil
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •