Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Monitor Regular Sql

    Team,

    We have about to monitor daily running sql's (SAME 60 sql's) -AUTOMATED
    And store the Starting time, End time, Rows read, Timerons in a table.

    What approach is the best one?
    Is there any third party utility solve this idea.
    Unix shell scripting will solve this?

    Any idea is appreciated.

    Thanks,
    R

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    you can start a statement event monitor and write the output to table

    CREATE EVENT MONITOR abc FOR STATEMENTS WRITE TO TABLE BUFFERSIZE 4 BLOCKED MANUALSTART ;

    this will cause stmt_abc table which will have all the details for the period for which event monitor is on

    --Rahul Singh

  3. #3
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    BY this approach I am not getting

    END EXECUTION TIME.

    Sql statement is LOB and fills up the table quickly.

    Is there any way I tell event monitor to monitor only few queries?

    thanks,
    -R

  4. #4
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    Team..

    Any takers...

    Any guidelines appreciated.

    Thanks,
    R

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You may 'filter' the event monitor capture by specifying authid, applname etc.
    Have a look at the create event monitor stmt ..

    I would recommend capturing the information to a file and using awk or perl to parse them ... Write to table is a big overhead (beware - the overhead will not be captured by snapshot or event monitors - except the TABLE ones) especially for a OLTP system

    HTH
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    IIRC, last year there was an article in developerworks by someone in IBM canada who provided scripts for analysis ... Can't seem to find it now ..

    Sathyaram
    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
  •