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.