Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    38

    Unanswered: Event Monitor Problem

    All,
    I have created 2 seperate event monitors one for Database and other for tables

    So Database event monitor should capture all events related to database namely connection to it and Table event monitor should capture all event related to table activity namely table creation, table population.( Please correct me if I'm wrong )

    Database Event Monitor Progress
    db2 => create event monitor vij_evemon2 for database write to file 'c:\vij_mon'
    DB20000I The SQL command completed successfully.

    db2 => set event monitor vij_evemon2 state =1
    DB20000I The SQL command completed successfully.

    C:\Documents and Settings\Administrator>db2evmon -db vijdb -evm vij_evemon2

    Reading c:\vij_mon\00000000.EVT ...
    --------------------------------------------------------------------------
    EVENT LOG HEADER
    Event Monitor name: VIJ_EVEMON2
    Server Product ID: SQL08010
    Version of event monitor data: 7
    Byte order: LITTLE ENDIAN
    Number of nodes in db2 instance: 1
    Codepage of database: 1252
    Territory code of database: 1
    Server instance name: DB2
    --------------------------------------------------------------------------

    --------------------------------------------------------------------------
    Database Name: VIJDB
    Database Path: C:\DB2\NODE0000\SQL00004\
    First connection timestamp: 06-03-2004 20:29:30.036634
    Event Monitor Start time: 06-03-2004 20:58:39.126844
    --------------------------------------------------------------------------


    Table Event Monitor Progress

    db2 => create event monitor vij_tabmon for tables write to file 'c:\vij_tabmon'
    DB20000I The SQL command completed successfully.

    db2 => set event monitor vij_tabmon state = 1
    DB20000I The SQL command completed successfully.

    C:\Documents and Settings\Administrator>db2evmon -db vijdb -evm vij_tabmon

    Reading c:\vij_tabmon\00000000.EVT ...
    --------------------------------------------------------------------------
    EVENT LOG HEADER
    Event Monitor name: VIJ_TABMON
    Server Product ID: SQL08010
    Version of event monitor data: 7
    Byte order: LITTLE ENDIAN
    Number of nodes in db2 instance: 1
    Codepage of database: 1252
    Territory code of database: 1
    Server instance name: DB2
    --------------------------------------------------------------------------

    --------------------------------------------------------------------------
    Database Name: VIJDB
    Database Path: C:\DB2\NODE0000\SQL00004\
    First connection timestamp: 06-03-2004 21:50:28.499426
    Event Monitor Start time: 06-03-2004 21:50:46.527572
    --------------------------------------------------------------------------


    But both event monitors (database & table ) are capturing the same data or Do I need to use any other tool ?

    Please help me in this regard to progress further. Thanks.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you want to capture info about connections, then you must use a connection event monitor ...

    I think you may need db2 auditing ..

    Can you tell us what you would like to achive ? So, we can give better suggestions .. .

    Cheers
    Sathyaram
    PS:
    If you are interested in knowing more about event monitors, PM me your email id ... I'll send you a copy of the presentation I did recently at the UK DB2 User Group meeting... (It is about half-meg in size ... too big to upload here!)
    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
  •