Hi all,

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

Regards,
Bala

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.

Hi, Thanks.

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