Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    7

    Arrow Unanswered: Tool for finding slow SQLs

    Hi all,

    Is there any tool that finds slow running SQLs (or all the SQLs) running in given period of time?

    Regards,
    Bala

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you are on DB2 for Linux, UNIX, Windows, I would recommend the following command:
    db2 get snapshot for dynamic sql on db-name

    You will need to look in the Command Reference manual for details on this, and what monitor switches need to be set on before you run this command.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2008
    Posts
    7
    Hi, Thanks.

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    when you post it helps to know what your OS and db2 level is.

    If you are on 9 you can utilize new views that are in the schema SYSIBMADM
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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