Script to find out the Long Running SQL's in the database

Topic: Code Place

Subtopic: DB2 for LUW

The Long Running SQL's script will identify the Long Running SQL's that are running in the database currently. This data will be very useful to trap all the SQL's that are running for long time with the
elapsed time running more than 1 min. These Long Running SQL's may cause the Logspace Utilization to get filled up which inturn may lead for the database to go down which leads to sev-1 issue.
With the above script we can proactively monitor are there any long running sqls in the database.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.