Results 1 to 4 of 4
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1

    Unanswered: Tips for DBA: Analysing Dynamic SQLs.

    As a DBA we have to make sure the running queries are optimized or identify bad queries and action them.

    Generally we take dynamic snapshots but i'm wondering if anyone has any scripts/ tool which comes handy in such analysis which can analyse the snapshots an point out bad queries and possibly give recommendations?

    Stella

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

  3. #3
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1
    Thanks, Is this a free tool?
    Any other alternative?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No it is not free, but it is easy to use and helps a lot. If you want free, then use the Monitor routines that come with DB2 and write your own.

    Andy

Posting Permissions

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