Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: DB2 Event Monitor for select statements only

    Guys,

    Is it possible to monitor select statements only - to reduce impact on data warehouse env ?

    I believe we have have a subset of monitoring by workload, can someone help me with simple guide or list of steps to do so.


    DB2 v9.7.6 on AIX 6.1

    DBFinder

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by DBFinder View Post
    monitor select statements only - to reduce impact on data warehouse
    And how many DML ("non-select") statements do you expect to be executed in a DW environment?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Yes, I understand what you mean. But it is what it is.
    Once again, question is "is it possible to monitor select statements only ??"

    Here I do not have time to advise my database manager, as a dba they want me to create it for select. I want your opinion.

    Thanks for your time.

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by n_i View Post
    And how many DML ("non-select") statements do you expect to be executed in a DW environment?
    And to be specific, we have more DML than 60% of an average warehouse.
    Warehouse size is about 55 TB and there are 50 partitions having 564 schemas

    Code:
    $ db2 "select count(distinct tabschema ) from syscat.tables"
    
    1
    -----------
            564
    
      1 record(s) selected.
    If I understand my warehouse completely, dividing by 10 it tells me about 52 small warehouses in one big warehouse (plz don't test my math).

    Coming to the point, there are lot more DML that you initially might have supposed. I am level two support DBA.

    DBFinder

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Well, what you want is not possible, you cannot filter statement by type. You could do something along these lines for an ACTIVITIES event monitor by defining a work class for READ activities and a corresponding work action to collect monitor data, but I guess it's not what you want.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thank you Nick.

    Your 2 lines have helped me a lot. I was expecting exactly same response.
    Well, I will go to any length to serve my employer, will define the class and work action. or maybe seperate auth-id for DMLs.


    Thanks again.
    DBFinder

Posting Permissions

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