Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: Alert for no database activity

    Hi guys,

    On a V8 database I want to put an alert if there is no DML activity i.e. insert/update/delete for a specified period of time; let's say 10 minutes.Any idea what can be done to achieve this?

    Thanks in advance.

    Paul

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by dollar489
    Hi guys,

    On a V8 database I want to put an alert if there is no DML activity i.e. insert/update/delete for a specified period of time; let's say 10 minutes.Any idea what can be done to achieve this?

    Thanks in advance.

    Paul
    You could probably use a statement event monitor, see the System Monitor Guide.

    Would slow things down a bit, though.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Sep 2002
    Posts
    456
    Thanks Jonathan.

    I made use of the Rows deleted/Rows inserted and Rows updated to track the activity within the database. Thanks.

    Paul

Posting Permissions

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