SQL statements with the most execution times of basic queries optimized by db2

SQL statements with the most execution times of basic queries optimized by db2

Use the following statement to find the maximum number of SQL statements executed

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.txt

The output file is displayed as follows:

Determine whether there is a problem based on the number of executions. If you find that the execution frequency is significantly higher, you should check whether there is any problem in the program. Generally, the basic data tables are frequently queried. If not, check the program to see if the corresponding SQL statements are called in some cycles.