DB2 Optimization base query execution most times SQL

Use the following statement to find the most frequently executed SQL

DB2 SELECT * FROM Sysibmadm. Snapdyn_sql ORDER BY Num_executions Desc,total_sys_cpu_time_ms desc FETCH first 205 rows only >>D:\NUM_EXECUTIONS.T Xt

The file that opens the output appears as follows:

Determine if there is a problem based on the number of executions. If you find that the number of executions is significantly higher, you should see if there is a problem in the program. In general, the basic data will be more than the number of table queries, if not, it is recommended to review the program to see if the corresponding SQL is called in some loops.

DB2 Optimization base query execution most times SQL