Resources

Script to find the High Impact SQL's in the database which are CPU Bound and IO Bound

Topic: Code Place

Subtopic: DB2 for LUW



Description : The script will detect the High Impact SQL's in the database which are IO Intensive and CPU intensive bound. This will project the SQLS with the CPU time and IO time for each SQL's

a) It finds the top five sqls with high statement execution time in the database
 b) It finds the top five SQL's with high CPU Intensive queries in the database
c) It finds the top five SQL's with high IO Intensive queries 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.