Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2011
    Posts
    85

    Question Unanswered: How to monitor and track the db2 resource usage

    Hi All

    I need to Monitor and track db resource utilization only on a specif interval and extract the data to a report

    I want to extract a report which contains

    1) Locks
    a) object (table/row) being locked
    b) How long each given lock was held
    c) And other connections blocking on it
    2) Rows changed/queried

    With every release we migrate db changes to PROD. at the time when this process taking place i want to enable the method im using to capture above mention data, and after the process i want to disable the method again.

    Can you guide me a way of doing this..??
    Links, suggestions would be help massively

    Thanx

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

  3. #3
    Join Date
    Sep 2011
    Posts
    85
    Sorry Andy for not posting the data that required

    DB2 Version - "DB2 v9.7.0.5", "s111017", "IP23292", and Fix Pack
    "5".

    DB2 Type - "DB2 Advanced Enterprise Server Edition"

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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