Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    118

    Unanswered: performance details

    I am analyzing the causes for the poor performance of the execution of a stored procedure. I would like to analyze it at the database level and at the application level.
    In order to do so, I am looking for information (both at db level and application level) which would lead me to the cause of poor response.
    I am using db2 udb ver 7.2 on NT.
    Could someone tell me where should I dig for performance tuning indicators ?

    thanks.

    Anil

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You should probably cut and paste the major SQL statements (the ones that execute against data) and do a visual explain on them.

    DB2 7.2 on NT is no longer supported by IBM. If you can upgrade to Windows 2000 (even with DB2 7.2 ), things will run quite a bit faster.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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