Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    Unanswered: Performace review tool in DB2


    I am running DB2 v9.7 on AIX.

    1) I would like to review all SQL statements that are generated by Hibernate and also native SQL statements in my application and check whether there are any non-optimal SQL statements. I understand that data studio, db2explain, db2advisor can help me to get these figures. However, are there any handy tools, open source or IBM tools, that can help me perform this task efficiently, i.e., analyze the sql statements (preferably read my java application), and then produce the execution cost figure, and also cpu time, elaped time (any relevant attributes), etc. in a table (or similar structure) for further analysis?

    2) I would also like to review the healthiness of my DB2 database. Are there any db2 detailed performance report that can be produced so that I can review whether the configurations setting are good enough, e.g., bufferpool?

    Any suggestions.

    Thanks in advance.
    Last edited by db2213; 12-10-12 at 02:11.

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1

Posting Permissions

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